sqldf
sqldf copied to clipboard
A simple wrapper to run SQL queries (SQLite3) on pandas.Dataframe objects (Python)
Hello, This is a proposal in order to make more efficient the joins, it could be great the run commnand accept the an otimization varibale which is a list of...
Does this package work for window functions? It seems like not working when I used such as ROW_NUMBER() OVER(PARTITION BY NULL) as such.
sqlite provides limited functions, hope a mysql version is developed. I will try to do this.