W3cubDocs

/Nushell

dfr query for dataframe

Query dataframe using SQL. Note: The dataframe is always named 'df' in your query's from clause.

Signature

> dfr query {flags} (sql)

Parameters

  • sql: sql query

Input/output types:

input output
any any

Examples

Query dataframe using SQL

> [[ab]; [12] [34]] |dfr into-df|dfr query'select a from df'
╭───┬───╮
# │ a │
├───┼───┤
01
13
╰───┴───╯

Tips: Dataframe commands were not shipped in the official binaries by default, you have to build it with --features=dataframe flag

Copyright © 2019–2023 The Nushell Project DevelopersLicensed under the MIT License.
https://www.nushell.sh/commands/docs/dfr_query.html