A package that integrates pandas and sqlaclhemy.
Project description
pandalchemy: an intuitive combination of pandas and sqlalchemy to manipulate databases with pandas
What is it?
pandalchemy is a Python package that lets Data Scientists create and manipulte databases with the pandas package that they know and love without needing to learn the ins and outs of sqlalchemy.
Main Features
Here are just a few of the things that pandaclehmy does:
- Pulls down any sql table with sqlalchemy and maintains all data types, keys, and indexes when you make your changes.
- Adds a primary key to a new table, something pandas to_sql method does not do.
- Add or delete columns in a database table thanks to sqlalchemy-migrate.
Where to get it
The source code is currently hosted on GitHub at: https://github.com/eddiethedean/pandalchemy
# PyPI
pip install pandalchemy
Dependencies
Example code
from sqlalchemy import create_engine
import pandalchemy as ba
# Use sqlalchemy to create an engine to connect to existing database
engine = create_engine('postgresql://scott:tiger@localhost:5432/mydatabase')
# Initialize a pandalchemy DataBase object
db = ba.DataBase(engine)
# Accessing a table by name gives you a DataFrame like Table object
tbl = db['test_table']
# Make changes to the Table just like you would a pandas DataFrame
tbl['age'] = [11, 12, 13, 14, 15]
# Use the push method to push all your changes to your database
db.push()
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
Close
Hashes for pandalchemy-0.0.7-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 963ff7e0e7035bf5eeb57f1853af2fb1f4a28cf00cb5539bb914e3709fd3c098 |
|
MD5 | df93cac0e21b1296a9f6fc2bf4c83af6 |
|
BLAKE2b-256 | fcd26c4d5a23272a005021f6debac6bbae7599f581a0dac79fd7e103d785814f |