dfrOperate with data in a dataframe format.
dfr all-falseReturns true if all values are false.
dfr all-trueReturns true if all values are true.
dfr appendAppends a new dataframe.
dfr arg-maxReturn index for max value in series.
dfr arg-minReturn index for min value in series.
dfr arg-sortReturns indexes for a sorted series.
dfr arg-trueReturns indexes where values are true.
dfr arg-uniqueReturns indexes for unique values.
dfr as-dateConverts string to date.
dfr as-datetimeConverts string to datetime.
dfr castCast a column to a different dtype.
dfr columnsShow dataframe columns.
dfr concatenateConcatenates strings with other array.
dfr containsChecks if a pattern is contained in a string.
dfr count-nullCounts null values.
dfr cumulativeCumulative calculation for a series.
dfr dropCreates a new dataframe by dropping the selected columns.
dfr drop-duplicatesDrops duplicate values in dataframe.
dfr drop-nullsDrops null values in dataframe.
dfr dtypesShow dataframe data types.
dfr dummiesCreates a new dataframe with dummy variables.
dfr filter-withFilters dataframe using a mask or expression as reference.
dfr firstShow only the first number of rows or create a first expression
dfr getCreates dataframe with the selected columns.
dfr get-dayGets day from date.
dfr get-hourGets hour from date.
dfr get-minuteGets minute from date.
dfr get-monthGets month from date.
dfr get-nanosecondGets nanosecond from date.
dfr get-ordinalGets ordinal from date.
dfr get-secondGets second from date.
dfr get-weekGets week from date.
dfr get-weekdayGets weekday from date.
dfr get-yearGets year from date.
dfr into-dfConverts a list, table or record into a dataframe.
dfr into-nuConverts a dataframe or an expression into into nushell value for access and exploration.
dfr is-duplicatedCreates mask indicating duplicated values.
dfr is-not-nullCreates mask where value is not null.
dfr is-nullCreates mask where value is null.
dfr is-uniqueCreates mask indicating unique values.
dfr lastCreates new dataframe with tail rows or creates a last expression.
dfr lowercaseLowercase the strings in the column.
dfr lsLists stored dataframes.
dfr meltUnpivot a DataFrame from wide to long format.
dfr n-uniqueCounts unique values.
dfr notInverts boolean mask.
dfr openOpens CSV, JSON, JSON lines, arrow, avro, or parquet file to create dataframe.
dfr queryQuery dataframe using SQL. Note: The dataframe is always named 'df' in your query's from clause.
dfr renameRename a dataframe column.
dfr replaceReplace the leftmost (sub)string by a regex pattern.
dfr replace-allReplace all (sub)strings by a regex pattern.
dfr rollingRolling calculation for a series.
dfr sampleCreate sample dataframe.
dfr schemaShow schema for a dataframe.
dfr setSets value where given mask is true.
dfr set-with-idxSets value in the given index.
dfr shapeShows column and row size for a dataframe.
dfr shiftShifts the values by a given period.
dfr sliceCreates new dataframe from a slice of rows.
dfr str-lengthsGet lengths of all strings.
dfr str-sliceSlices the string from the start position until the selected length.
dfr strftimeFormats date based on string rule.
dfr summaryFor a dataframe, produces descriptive statistics (summary statistics) for its numeric columns.
dfr takeCreates new dataframe using the given indices.
dfr to-arrowSaves dataframe to arrow file.
dfr to-avroSaves dataframe to avro file.
dfr to-csvSaves dataframe to CSV file.
dfr to-jsonlSaves dataframe to a JSON lines file.
dfr to-parquetSaves dataframe to parquet file.
dfr uniqueReturns unique values from a dataframe.
dfr uppercaseUppercase the strings in the column.
dfr value-countsReturns a dataframe with the counts for unique values in series.
dfr with-columnAdds a series to the dataframe.