dfr for dataframe

Operate with data in a dataframe format.


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


> dfr {flags}

Input/output types:



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


dfr aggBuiltinPerforms a series of aggregations from a group-by.
dfr agg-groupsBuiltinCreates an agg_groups expression.
dfr all-falseBuiltinReturns true if all values are false.
dfr all-trueBuiltinReturns true if all values are true.
dfr appendBuiltinAppends a new dataframe.
dfr arg-maxBuiltinReturn index for max value in series.
dfr arg-minBuiltinReturn index for min value in series.
dfr arg-sortBuiltinReturns indexes for a sorted series.
dfr arg-trueBuiltinReturns indexes where values are true.
dfr arg-uniqueBuiltinReturns indexes for unique values.
dfr arg-whereBuiltinCreates an expression that returns the arguments where expression is true.
dfr asBuiltinCreates an alias expression.
dfr as-dateBuiltinConverts string to date.
dfr as-datetimeBuiltinConverts string to datetime.
dfr cacheBuiltinCaches operations in a new LazyFrame.
dfr castBuiltinCast a column to a different dtype.
dfr colBuiltinCreates a named column expression.
dfr collectBuiltinCollect lazy dataframe into eager dataframe.
dfr columnsBuiltinShow dataframe columns.
dfr concat-strBuiltinCreates a concat string expression.
dfr concatenateBuiltinConcatenates strings with other array.
dfr containsBuiltinChecks if a pattern is contained in a string.
dfr countBuiltinCreates a count expression.
dfr count-nullBuiltinCounts null values.
dfr cumulativeBuiltinCumulative calculation for a series.
dfr datepartBuiltinCreates an expression for capturing the specified datepart in a column.
dfr dropBuiltinCreates a new dataframe by dropping the selected columns.
dfr drop-duplicatesBuiltinDrops duplicate values in dataframe.
dfr drop-nullsBuiltinDrops null values in dataframe.
dfr dtypesBuiltinShow dataframe data types.
dfr dummiesBuiltinCreates a new dataframe with dummy variables.
dfr explodeBuiltinExplodes a dataframe or creates a explode expression.
dfr expr-notBuiltinCreates a not expression.
dfr fetchBuiltinCollects the lazyframe to the selected rows.
dfr fill-nanBuiltinReplaces NaN values with the given expression.
dfr fill-nullBuiltinReplaces NULL values with the given expression.
dfr filterBuiltinFilter dataframe based in expression.
dfr filter-withBuiltinFilters dataframe using a mask or expression as reference.
dfr firstBuiltinShow only the first number of rows or create a first expression
dfr flattenBuiltinAn alias for dfr explode.
dfr getBuiltinCreates dataframe with the selected columns.
dfr get-dayBuiltinGets day from date.
dfr get-hourBuiltinGets hour from date.
dfr get-minuteBuiltinGets minute from date.
dfr get-monthBuiltinGets month from date.
dfr get-nanosecondBuiltinGets nanosecond from date.
dfr get-ordinalBuiltinGets ordinal from date.
dfr get-secondBuiltinGets second from date.
dfr get-weekBuiltinGets week from date.
dfr get-weekdayBuiltinGets weekday from date.
dfr get-yearBuiltinGets year from date.
dfr group-byBuiltinCreates a group-by object that can be used for other aggregations.
dfr implodeBuiltinAggregates a group to a Series.
dfr into-dfBuiltinConverts a list, table or record into a dataframe.
dfr into-lazyBuiltinConverts a dataframe into a lazy dataframe.
dfr into-nuBuiltinConverts a dataframe or an expression into into nushell value for access and exploration.
dfr is-duplicatedBuiltinCreates mask indicating duplicated values.
dfr is-inBuiltinCreates an is-in expression.
dfr is-not-nullBuiltinCreates mask where value is not null.
dfr is-nullBuiltinCreates mask where value is null.
dfr is-uniqueBuiltinCreates mask indicating unique values.
dfr joinBuiltinJoins a lazy frame with other lazy frame.
dfr lastBuiltinCreates new dataframe with tail rows or creates a last expression.
dfr litBuiltinCreates a literal expression.
dfr lowercaseBuiltinLowercase the strings in the column.
dfr lsBuiltinLists stored dataframes.
dfr maxBuiltinCreates a max expression or aggregates columns to their max value.
dfr meanBuiltinCreates a mean expression for an aggregation or aggregates columns to their mean value.
dfr medianBuiltinAggregates columns to their median value
dfr meltBuiltinUnpivot a DataFrame from wide to long format.
dfr minBuiltinCreates a min expression or aggregates columns to their min value.
dfr n-uniqueBuiltinCounts unique values.
dfr notBuiltinInverts boolean mask.
dfr openBuiltinOpens CSV, JSON, JSON lines, arrow, avro, or parquet file to create dataframe.
dfr otherwiseBuiltinCompletes a when expression.
dfr quantileBuiltinAggregates the columns to the selected quantile.
dfr queryBuiltinQuery dataframe using SQL. Note: The dataframe is always named 'df' in your query's from clause.
dfr renameBuiltinRename a dataframe column.
dfr replaceBuiltinReplace the leftmost (sub)string by a regex pattern.
dfr replace-allBuiltinReplace all (sub)strings by a regex pattern.
dfr reverseBuiltinReverses the LazyFrame
dfr rollingBuiltinRolling calculation for a series.
dfr sampleBuiltinCreate sample dataframe.
dfr schemaBuiltinShow schema for a dataframe.
dfr selectBuiltinSelects columns from lazyframe.
dfr setBuiltinSets value where given mask is true.
dfr set-with-idxBuiltinSets value in the given index.
dfr shapeBuiltinShows column and row size for a dataframe.
dfr shiftBuiltinShifts the values by a given period.
dfr sliceBuiltinCreates new dataframe from a slice of rows.
dfr sort-byBuiltinSorts a lazy dataframe based on expression(s).
dfr stdBuiltinCreates a std expression for an aggregation of std value from columns in a dataframe.
dfr str-lengthsBuiltinGet lengths of all strings.
dfr str-sliceBuiltinSlices the string from the start position until the selected length.
dfr strftimeBuiltinFormats date based on string rule.
dfr sumBuiltinCreates a sum expression for an aggregation or aggregates columns to their sum value.
dfr summaryBuiltinFor a dataframe, produces descriptive statistics (summary statistics) for its numeric columns.
dfr takeBuiltinCreates new dataframe using the given indices.
dfr to-arrowBuiltinSaves dataframe to arrow file.
dfr to-avroBuiltinSaves dataframe to avro file.
dfr to-csvBuiltinSaves dataframe to CSV file.
dfr to-jsonlBuiltinSaves dataframe to a JSON lines file.
dfr to-parquetBuiltinSaves dataframe to parquet file.
dfr uniqueBuiltinReturns unique values from a dataframe.
dfr uppercaseBuiltinUppercase the strings in the column.
dfr value-countsBuiltinReturns a dataframe with the counts for unique values in series.
dfr varBuiltinCreate a var expression for an aggregation.
dfr whenBuiltinCreates and modifies a when expression.
dfr with-columnBuiltinAdds a series to the dataframe.