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