Skip to content

Instantly share code, notes, and snippets.

@marymlucas

marymlucas/connect_psycopg2_to_pandas.py

Forked from jakebrinkmann/connect_psycopg2_to_pandas.py
Created February 2, 2022 17:40
Show Gist options
  • Save marymlucas/8ac1b1466639edbb09eb5ad48b4c5fae to your computer and use it in GitHub Desktop.
Save marymlucas/8ac1b1466639edbb09eb5ad48b4c5fae to your computer and use it in GitHub Desktop.
Download ZIP
Read SQL query from psycopg2 into pandas dataframe
Raw
connect_psycopg2_to_pandas.py
import pandas as pd
import pandas.io.sql as sqlio
import psycopg2
conn = psycopg2.connect("host='{}' port={} dbname='{}' user={} password={}".format(host, port, dbname, username, pwd))
sql = "select count(*) from table;"
dat = sqlio.read_sql_query(sql, conn)
conn = None
@marymlucas
Copy link
Author

marymlucas commented Feb 2, 2022 •
edited
Loading 

import pandas as pd

conn = psycopg2.connect("host='{}' port={} dbname='{}' user={} password={}".format(host, port, dbname, username, pwd))
sql = "select count(*) from table;"
dat = pd.read_sql_query(sql, conn)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment