3 ms·
Great write up, thanks - wish I'd had this when I got started with pandas because the thing I found tricky was converting the SQL I knew into its pandas equival
by RobinL 13y ago
Great write up, thanks - wish I'd had this when I got started with pandas because the thing I found tricky was converting the SQL I knew into its pandas equivalent.
One thing I would point out for new users is the .loc and .iloc functions which I think make selecting data more intuitive because they are a bit more explicit.
- cdavid 13y agoyou may want to look at pandasql, where you can do something like from pandasql import sqldf, load_meat, load_births pysqldf = lambda q: sqldf(q, globals()) meat = load_meat() births = load_births() print pysqldf("SELECT * FROM meat LIMIT 10;").head()
- grej 13y agoAll credit on the writeup goes to Greg Reda. I just found this while working with Pandas and thought it was a great intro resource!