Skip to content

Instantly share code, notes, and snippets.

@StuffbyYuki

StuffbyYuki/myPandasql.py

Last active March 5, 2022 18:50
Show Gist options
  • Save StuffbyYuki/2694dd02f5a03ca0cc52dcebb88926d4 to your computer and use it in GitHub Desktop.
Save StuffbyYuki/2694dd02f5a03ca0cc52dcebb88926d4 to your computer and use it in GitHub Desktop.
Download ZIP
Pandasql snipet - getting started
Raw
myPandasql.py
from pandasql import sqldf
from pandasql import load_meat, load_births # import data
mysql = lambda q: sqldf(q, globals())
meat = load_meat()
birth = load_births()
# start sql queries in pandas
mysql('select * from meat limit 5')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment