SQL Queries For Pandas DataFrames

[@OhItsAnthony]

Have you used the ibis library? It's kind of the opposite to pandasql in that it enables you to write SQL queries in Python. Might make for an interesting companion video to this one.

[@OmarGhani-z4u]

Thanks for the video, what is the purpose of the locals() method within the ps.sqldf query?

[@РодионСоловьев-к1ч]

it seems a better video title would be "SQL Queries Between Multiple Pandas DataFrames" because pandas already supports SQL queries using sqlalchemy or sqlite connections

[@Ubhi-tp7qz]

Hi!, i have question, i have stored xlxs file to blob sql, how to read that with pandas? Thank You :)

[@Ultrajamz]

I’ve had issues with pandasql and had to limit the version of sqlachemy to get it to work

[@ragnarocking]

This is a great tutorial. Is there any way to increase performance? It seems like it can only query the dataframe once per second. In my scenario, I've loaded a ~400MB database of stock data into a pandas dataframe and need to run about 28k queries (one for each stock symbol). In total, it takes about 8hrs. Thanks!

[@donnillorussia]

Oh, please, just use classic relational database and do some corellated subqueries or something... Learn some old-school basics, not only top-level fancy code. No library can "optimize" your lack of knowledge

[@ragnarocking]

@@donnillorussia gee, abrasive much? Nice personality you have there. It's a 3rd party host. I obviously know SQL otherwise I wouldn't be entertaining the idea of using this python package to begin with. A relational database is overkill for my needs and would cost me a small amount extra in hosting fees every month. I thought I'd explore alternatives.

[@j.k.priyadharshini9753]

@@ragnarocking Hi, Iam going through same issue. Did you find out any solution to this?

[@assavinkengkart9141]

This is great library. Thank for sharing.

[@flyingspaghettimonster2925]

What does locals() do

[@tomliao6667]

prevent you from using global variable to do SQL query

[@8irsan8]

just what I need. Awesome.

[@sawekb8102]

How ithis sql querry is connected to the data? I cant understand it.

[@phsopher]

why tho?

[@adnanqudsi9604]

hii, thnx for the video but can anyone here help mw out with, why do we actually need to use sql queries in our python pandas based program provided we can do the same thing without it?? i mean what is the purpose of it?? if anyone can give clarification over this matter, it would be really helpful. thank you.

[@calvingadson7863]

Thank you!

[@rohamhadidchi1196]

Thank you so much for this

[@chriskeo392]

SQL queries to Vaex next?!?!

[@PedroAnacletoOficial]

awesome stuff

[@tomkmb4120]

Seems like Pandas Query is simpler/cleaner imo

[@Dr.AhmedQusaySabri]

Thanks a lot

[@guilherme5094]

👍

[@hasindusithmin1074]

👀👌