Skip to content

Latest commit

 

History

History
35 lines (25 loc) · 976 Bytes

README.md

File metadata and controls

35 lines (25 loc) · 976 Bytes
Raw

sqldf

Tests

Ever wish you could query pandas DataFrames with SQL like this?

df = pd.DataFrame(...)
sqldf.query_df(df, """
SELECT *, sum(b)
WHERE a > 5
GROUP BY b
""")

Well now you can with sqldf!

Currently Supported

  • SELECT
  • WHERE
    • =, !=, >, >=, <, <=, IN, NOT IN

Not (Yet) Supported

  • SELECT ... AS
  • FROM
  • GROUP BY
  • JOIN
  • WHERE ... LIKE
  • ORDER BY

How it Works

A PEG grammar is defined in sqldf/sql.gram that is passed through pegen to generate the parser in sqldf/parser.py that parses the SQL and generates objects (currently dictionaries). The generated objects are then processed to build up the relevant pandas calls to return the processed DataFrame.