Pass postgres data to pandas dataframe
Project description
DFTOPO
How to Install
pip install dftopo
Import into your code
from dftopo import dfps
Examples
Connection.
dbname='your_dbname'
user='your_user'
password='your_password'
host='your_host'
port='your_port'
schema='your_schema'
engine = dfps.connection(dbname,user,password,host,port,schema)
Pure SQL.
query = f"""
SELECT * FROM test
"""
list(dfps.query_execution(query, engine))
Read data from postgres in python.
query = f"""
SELECT * FROM test
"""
df = dfps.read(query, engine)
Load data from python to Postgres.
dfps.load(df,"test2", engine)
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 Distribution
dftopo-1.0.3.tar.gz
(2.7 kB
view hashes)
Built Distribution
dftopo-1.0.3-py3-none-any.whl
(3.0 kB
view hashes)