Skip to content

sql.rst

Latest commit

 

History

History
39 lines (29 loc) · 1.31 KB

sql.rst

File metadata and controls

39 lines (29 loc) · 1.31 KB

SQL

DataFusion also offers a SQL API, read the full reference here

.. ipython:: python

    import datafusion
    from datafusion import col
    import pyarrow

    # create a context
    ctx = datafusion.SessionContext()

    # register a CSV
    ctx.register_csv('pokemon', 'pokemon.csv')

    # create a new statement via SQL
    df = ctx.sql('SELECT "Attack"+"Defense", "Attack"-"Defense" FROM pokemon')

    # collect and convert to pandas DataFrame
    df.to_pandas()