Dataframe

Command	Description
dfr	Operate with data in a dataframe format.
dfr all-false	Returns true if all values are false.
dfr all-true	Returns true if all values are true.
dfr append	Appends a new dataframe.
dfr arg-max	Return index for max value in series.
dfr arg-min	Return index for min value in series.
dfr arg-sort	Returns indexes for a sorted series.
dfr arg-true	Returns indexes where values are true.
dfr arg-unique	Returns indexes for unique values.
dfr as-date	Converts string to date.
dfr as-datetime	Converts string to datetime.
dfr cast	Cast a column to a different dtype.
dfr columns	Show dataframe columns.
dfr concatenate	Concatenates strings with other array.
dfr contains	Checks if a pattern is contained in a string.
dfr count-null	Counts null values.
dfr cumulative	Cumulative calculation for a series.
dfr drop	Creates a new dataframe by dropping the selected columns.
dfr drop-duplicates	Drops duplicate values in dataframe.
dfr drop-nulls	Drops null values in dataframe.
dfr dtypes	Show dataframe data types.
dfr dummies	Creates a new dataframe with dummy variables.
dfr filter-with	Filters dataframe using a mask or expression as reference.
dfr first	Show only the first number of rows or create a first expression
dfr get	Creates dataframe with the selected columns.
dfr get-day	Gets day from date.
dfr get-hour	Gets hour from date.
dfr get-minute	Gets minute from date.
dfr get-month	Gets month from date.
dfr get-nanosecond	Gets nanosecond from date.
dfr get-ordinal	Gets ordinal from date.
dfr get-second	Gets second from date.
dfr get-week	Gets week from date.
dfr get-weekday	Gets weekday from date.
dfr get-year	Gets year from date.
dfr into-df	Converts a list, table or record into a dataframe.
dfr into-nu	Converts a dataframe or an expression into into nushell value for access and exploration.
dfr is-duplicated	Creates mask indicating duplicated values.
dfr is-not-null	Creates mask where value is not null.
dfr is-null	Creates mask where value is null.
dfr is-unique	Creates mask indicating unique values.
dfr last	Creates new dataframe with tail rows or creates a last expression.
dfr lowercase	Lowercase the strings in the column.
dfr ls	Lists stored dataframes.
dfr melt	Unpivot a DataFrame from wide to long format.
dfr n-unique	Counts unique values.
dfr not	Inverts boolean mask.
dfr open	Opens CSV, JSON, JSON lines, arrow, avro, or parquet file to create dataframe.
dfr query	Query dataframe using SQL. Note: The dataframe is always named 'df' in your query's from clause.
dfr rename	Rename a dataframe column.
dfr replace	Replace the leftmost (sub)string by a regex pattern.
dfr replace-all	Replace all (sub)strings by a regex pattern.
dfr rolling	Rolling calculation for a series.
dfr sample	Create sample dataframe.
dfr schema	Show schema for a dataframe.
dfr set	Sets value where given mask is true.
dfr set-with-idx	Sets value in the given index.
dfr shape	Shows column and row size for a dataframe.
dfr shift	Shifts the values by a given period.
dfr slice	Creates new dataframe from a slice of rows.
dfr str-lengths	Get lengths of all strings.
dfr str-slice	Slices the string from the start position until the selected length.
dfr strftime	Formats date based on string rule.
dfr summary	For a dataframe, produces descriptive statistics (summary statistics) for its numeric columns.
dfr take	Creates new dataframe using the given indices.
dfr to-arrow	Saves dataframe to arrow file.
dfr to-avro	Saves dataframe to avro file.
dfr to-csv	Saves dataframe to CSV file.
dfr to-jsonl	Saves dataframe to a JSON lines file.
dfr to-parquet	Saves dataframe to parquet file.
dfr unique	Returns unique values from a dataframe.
dfr uppercase	Uppercase the strings in the column.
dfr value-counts	Returns a dataframe with the counts for unique values in series.
dfr with-column	Adds a series to the dataframe.