Skip to content

Instantly share code, notes, and snippets.

@pimlock

pimlock/reading-sql.py

Created May 12, 2021 17:44
Show Gist options
  • Save pimlock/05beabb53cf5c8065090f2c981488f3e to your computer and use it in GitHub Desktop.
Save pimlock/05beabb53cf5c8065090f2c981488f3e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
reading-sql.py
import sqlite3
con = sqlite3.connect("2016-olympics-medals.db")
try:
df_sql = pd.read_sql_query("SELECT * FROM medals", con)
df_sql.info()
finally:
con.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment