dataframe

Operate with data in a dataframe format.

WARNING

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

Signature

> dfr {flags}

Input/output types:

input	output
nothing	string

Notes

You must use one of the following subcommands. Using this command as-is will only produce this help message.

Subcommands:

name	type	usage
dfr agg	Builtin	Performs a series of aggregations from a group-by.
dfr agg-groups	Builtin	Creates an agg_groups expression.
dfr all-false	Builtin	Returns true if all values are false.
dfr all-true	Builtin	Returns true if all values are true.
dfr append	Builtin	Appends a new dataframe.
dfr arg-max	Builtin	Return index for max value in series.
dfr arg-min	Builtin	Return index for min value in series.
dfr arg-sort	Builtin	Returns indexes for a sorted series.
dfr arg-true	Builtin	Returns indexes where values are true.
dfr arg-unique	Builtin	Returns indexes for unique values.
dfr arg-where	Builtin	Creates an expression that returns the arguments where expression is true.
dfr as	Builtin	Creates an alias expression.
dfr as-date	Builtin	Converts string to date.
dfr as-datetime	Builtin	Converts string to datetime.
dfr cache	Builtin	Caches operations in a new LazyFrame.
dfr cast	Builtin	Cast a column to a different dtype.
dfr col	Builtin	Creates a named column expression.
dfr collect	Builtin	Collect lazy dataframe into eager dataframe.
dfr columns	Builtin	Show dataframe columns.
dfr concat-str	Builtin	Creates a concat string expression.
dfr concatenate	Builtin	Concatenates strings with other array.
dfr contains	Builtin	Checks if a pattern is contained in a string.
dfr count	Builtin	Creates a count expression.
dfr count-null	Builtin	Counts null values.
dfr cumulative	Builtin	Cumulative calculation for a series.
dfr datepart	Builtin	Creates an expression for capturing the specified datepart in a column.
dfr drop	Builtin	Creates a new dataframe by dropping the selected columns.
dfr drop-duplicates	Builtin	Drops duplicate values in dataframe.
dfr drop-nulls	Builtin	Drops null values in dataframe.
dfr dtypes	Builtin	Show dataframe data types.
dfr dummies	Builtin	Creates a new dataframe with dummy variables.
dfr explode	Builtin	Explodes a dataframe or creates a explode expression.
dfr expr-not	Builtin	Creates a not expression.
dfr fetch	Builtin	Collects the lazyframe to the selected rows.
dfr fill-nan	Builtin	Replaces NaN values with the given expression.
dfr fill-null	Builtin	Replaces NULL values with the given expression.
dfr filter	Builtin	Filter dataframe based in expression.
dfr filter-with	Builtin	Filters dataframe using a mask or expression as reference.
dfr first	Builtin	Show only the first number of rows or create a first expression
dfr flatten	Builtin	An alias for dfr explode.
dfr get	Builtin	Creates dataframe with the selected columns.
dfr get-day	Builtin	Gets day from date.
dfr get-hour	Builtin	Gets hour from date.
dfr get-minute	Builtin	Gets minute from date.
dfr get-month	Builtin	Gets month from date.
dfr get-nanosecond	Builtin	Gets nanosecond from date.
dfr get-ordinal	Builtin	Gets ordinal from date.
dfr get-second	Builtin	Gets second from date.
dfr get-week	Builtin	Gets week from date.
dfr get-weekday	Builtin	Gets weekday from date.
dfr get-year	Builtin	Gets year from date.
dfr group-by	Builtin	Creates a group-by object that can be used for other aggregations.
dfr implode	Builtin	Aggregates a group to a Series.
dfr into-df	Builtin	Converts a list, table or record into a dataframe.
dfr into-lazy	Builtin	Converts a dataframe into a lazy dataframe.
dfr into-nu	Builtin	Converts a dataframe or an expression into into nushell value for access and exploration.
dfr is-duplicated	Builtin	Creates mask indicating duplicated values.
dfr is-in	Builtin	Creates an is-in expression.
dfr is-not-null	Builtin	Creates mask where value is not null.
dfr is-null	Builtin	Creates mask where value is null.
dfr is-unique	Builtin	Creates mask indicating unique values.
dfr join	Builtin	Joins a lazy frame with other lazy frame.
dfr last	Builtin	Creates new dataframe with tail rows or creates a last expression.
dfr lit	Builtin	Creates a literal expression.
dfr lowercase	Builtin	Lowercase the strings in the column.
dfr ls	Builtin	Lists stored dataframes.
dfr max	Builtin	Creates a max expression or aggregates columns to their max value.
dfr mean	Builtin	Creates a mean expression for an aggregation or aggregates columns to their mean value.
dfr median	Builtin	Aggregates columns to their median value
dfr melt	Builtin	Unpivot a DataFrame from wide to long format.
dfr min	Builtin	Creates a min expression or aggregates columns to their min value.
dfr n-unique	Builtin	Counts unique values.
dfr not	Builtin	Inverts boolean mask.
dfr open	Builtin	Opens CSV, JSON, JSON lines, arrow, avro, or parquet file to create dataframe.
dfr otherwise	Builtin	Completes a when expression.
dfr quantile	Builtin	Aggregates the columns to the selected quantile.
dfr query	Builtin	Query dataframe using SQL. Note: The dataframe is always named 'df' in your query's from clause.
dfr rename	Builtin	Rename a dataframe column.
dfr replace	Builtin	Replace the leftmost (sub)string by a regex pattern.
dfr replace-all	Builtin	Replace all (sub)strings by a regex pattern.
dfr reverse	Builtin	Reverses the LazyFrame
dfr rolling	Builtin	Rolling calculation for a series.
dfr sample	Builtin	Create sample dataframe.
dfr schema	Builtin	Show schema for a dataframe.
dfr select	Builtin	Selects columns from lazyframe.
dfr set	Builtin	Sets value where given mask is true.
dfr set-with-idx	Builtin	Sets value in the given index.
dfr shape	Builtin	Shows column and row size for a dataframe.
dfr shift	Builtin	Shifts the values by a given period.
dfr slice	Builtin	Creates new dataframe from a slice of rows.
dfr sort-by	Builtin	Sorts a lazy dataframe based on expression(s).
dfr std	Builtin	Creates a std expression for an aggregation of std value from columns in a dataframe.
dfr str-lengths	Builtin	Get lengths of all strings.
dfr str-slice	Builtin	Slices the string from the start position until the selected length.
dfr strftime	Builtin	Formats date based on string rule.
dfr sum	Builtin	Creates a sum expression for an aggregation or aggregates columns to their sum value.
dfr summary	Builtin	For a dataframe, produces descriptive statistics (summary statistics) for its numeric columns.
dfr take	Builtin	Creates new dataframe using the given indices.
dfr to-arrow	Builtin	Saves dataframe to arrow file.
dfr to-avro	Builtin	Saves dataframe to avro file.
dfr to-csv	Builtin	Saves dataframe to CSV file.
dfr to-jsonl	Builtin	Saves dataframe to a JSON lines file.
dfr to-parquet	Builtin	Saves dataframe to parquet file.
dfr unique	Builtin	Returns unique values from a dataframe.
dfr uppercase	Builtin	Uppercase the strings in the column.
dfr value-counts	Builtin	Returns a dataframe with the counts for unique values in series.
dfr var	Builtin	Create a var expression for an aggregation.
dfr when	Builtin	Creates and modifies a when expression.
dfr with-column	Builtin	Adds a series to the dataframe.