dfr query
for dataframe
Query dataframe using SQL. Note: The dataframe is always named 'df' in your query's from clause.
Signature
> dfr query (sql)
Parameters
sql
: sql query
Input/output types:
input | output |
---|---|
any | any |
Examples
Query dataframe using SQL
> [[a b]; [1 2] [3 4]] | dfr into-df | dfr query 'select a from df'
╭───┬───╮
│ # │ a │
├───┼───┤
│ 0 │ 1 │
│ 1 │ 3 │
╰───┴───╯
Tips: Dataframe commands were not shipped in the official binaries by default, you have to build it with --features=dataframe
flag