Command Reference

Command	Beschreibung
agg	Performs a series of aggregations from a group by
agg-groups	creates an agg_groups expression
alias	Alias a command (with optional flags) to a new name
all-false	Returns true if all values are false
all-true	Returns true if all values are true
all?	Test if every element of the input matches a predicate.
ansi	Output ANSI codes to change color.
ansi gradient	Draw text with a provided start and end code making a gradient
ansi strip	Strip ANSI escape sequences from a string
any?	Tests if any element of the input matches a predicate.
append	Appends a new dataframe
append	Append any number of rows to a table.
arg-max	Return index for max value in series
arg-min	Return index for min value in series
arg-sort	Returns indexes for a sorted series
arg-true	Returns indexes where values are true
arg-unique	Returns indexes for unique values
as	Creates an alias expression
as-date	Converts string to date.
as-datetime	Converts string to datetime.
benchmark	Time the running time of a block
build-string	Create a string from the arguments.
cache	Caches operations in a new LazyFrame
cal	Display a calendar.
cd	Change directory.
char	Output special characters (e.g., 'newline').
clear	Clear the terminal.
col	Creates a named column expression
collect	Collect lazy dataframe into eager dataframe
collect	Collect the stream and pass it to a block.
columns	Show the columns in the input.
compact	Creates a table with non-empty rows.
complete	Complete the external piped in, collecting outputs and exit code
concatenate	Concatenates strings with other array
config	Edit nushell configuration files
config env	Edit nu environment configurations
config nu	Edit nu configurations
contains	Checks if a pattern is contained in a string
count	creates a count expression
count-null	Counts null values
cp	Copy files.
cumulative	Cumulative calculation for a series
date	Date-related commands
date format	Format a given date using a format string.
date humanize	Print a 'humanized' format for the date, relative to now.
date list-timezone	List supported time zones.
date now	Get the current date.
date to-record	Convert the date into a structured table.
date to-table	Convert the date into a structured table.
date to-timezone	Convert a date to a given time zone.
db	Database commands
db and	Includes an AND clause for a query or expression
db as	Creates an alias for a column selection
db col	Creates column expression for database
db collect	Query a database using SQL.
db describe	Describes connection and query of the DB object
db fn	Creates function expression for a select operation
db from	Select section from query statement for a DB
db group-by	Group by query
db join	Joins with another table or derived table. Default join type is inner
db limit	Limit result from query
db open	Open a database
db or	Includes an OR clause for a query or expression
db order-by	Orders by query
db over	Adds a partition to an expression function
db query	Query a database using SQL.
db schema	Show database information, including its schema.
db select	Creates a select statement for a DB
db testing	Create query object
db where	Includes a where statement for a query
debug	Debug print the value(s) piped in.
decode	Decode bytes as a string.
def	Define a custom command
def-env	Define a custom command, which participates in the caller environment
default	Sets a default row's column if missing.
describe	Describes dataframes numeric columns
describe	Describe the type and structure of the value(s) piped in.
detect columns	Attempt to automatically split text into multiple columns
df-not	Inverts boolean mask
do	Run a block
drop	Creates a new dataframe by dropping the selected columns
drop	Remove the last number of rows or columns.
drop column	Remove the last number of columns. If you want to remove columns by name, try 'reject'.
drop nth	Drop the selected rows.
drop-duplicates	Drops duplicate values in dataframe
drop-nulls	Drops null values in dataframe
dtypes	Show dataframe data types
du	Find disk usage sizes of specified items.
each	Run a block on each element of input
each while	Run a block on each element of input until a $nothing is found
echo	Echo the arguments back to the user.
empty?	Check for empty values.
enter	Enters a new shell at the given path.
env	Display current environment variables
error make	Create an error.
every	Show (or skip) every n-th row, starting from the first one.
exec	Execute a command, replacing the current process.
exit	Exit a Nu shell or exit Nu entirely.
explode	creates an explode expression
export	Export custom commands or environment variables from a module.
export alias	Define an alias and export it from a module
export def	Define a custom command and export it from a module
export def-env	Define a custom command that participates in the environment and export it from a module
export env	Export a block from a module that will be evaluated as an environment variable when imported.
export extern	Define an extern and export it from a module
expr-not	creates a not expression
extern	Define a signature for an external command
fetch	collects the lazyframe to the selected rows
fetch	Fetch the contents from a URL.
fill-na	Replaces NA values with the given expression
fill-null	Replaces NULL values with the given expression
filter-with	Filters dataframe using a mask or expression as reference
find	Searches terms in the input or for elements of the input that satisfies the predicate.
first	Creates new dataframe with first rows
first	Show only the first number of rows.
flatten	Flatten the table.
fmt	Format a number
for	Loop over a range
format	Format columns into a string using a simple pattern.
format filesize	Converts a column of filesizes to some specified format
from	Parse a string or binary data into structured data
from csv	Parse text as .csv and create table.
from eml	Parse text as .eml and create table.
from ics	Parse text as .ics and create table.
from ini	Parse text as .ini and create table
from json	Convert from json to structured data
from nuon	Convert from nuon to structured data
from ods	Parse OpenDocument Spreadsheet(.ods) data and create table.
from ssv	Parse text as space-separated values and create a table. The default minimum number of spaces counted as a separator is 2.
from toml	Parse text as .toml and create table.
from tsv	Parse text as .tsv and create table.
from url	Parse url-encoded string as a table.
from vcf	Parse text as .vcf and create table.
from xlsx	Parse binary Excel(.xlsx) data and create table.
from xml	Parse text as .xml and create table.
from yaml	Parse text as .yaml/.yml and create table.
from yml	Parse text as .yaml/.yml and create table.
g	Switch to a given shell.
get	Creates dataframe with the selected columns
get	Extract data using a cell path.
get-day	Gets day from date
get-hour	Gets hour from date
get-minute	Gets minute from date
get-month	Gets month from date
get-nanosecond	Gets nanosecond from date
get-ordinal	Gets ordinal from date
get-second	Gets second from date
get-week	Gets week from date
get-weekday	Gets weekday from date
get-year	Gets year from date
glob	Creates a list of files and/or folders based on the glob pattern provided.
grid	Renders the output to a textual terminal grid.
group	Groups input into groups of `group_size`.
group-by	Creates a groupby object that can be used for other aggregations
group-by	Create a new table grouped.
gstat	Get the git status of a repo
hash	Apply hash function.
hash base64	base64 encode or decode a value
hash md5	Hash a value using the md5 hash algorithm
hash sha256	Hash a value using the sha256 hash algorithm
headers	Use the first row of the table as column names.
help	Display help information about commands.
hide	Hide symbols in the current scope
histogram	Creates a new table with a histogram based on the column name passed in.
history	Get the command history
if	Conditionally run a block.
ignore	Ignore the output of the previous command in the pipeline
inc	Increment a value or version. Optionally use the column of a table.
input	Get input from the user.
insert	Insert a new column.
into	Commands to convert data from one type to another.
into binary	Convert value to a binary primitive
into bool	Convert value to boolean
into datetime	Convert text into a datetime
into decimal	Convert text into a decimal
into duration	Convert value to duration
into filesize	Convert value to filesize
into int	Convert value to integer
into string	Convert value to string
is-admin	Check if nushell is running with administrator or root privileges
is-duplicated	Creates mask indicating duplicated values
is-in	Checks if elements from a series are contained in right series
is-not-null	Creates mask where value is not null
is-not-null	creates a is not null expression
is-null	Creates mask where value is null
is-null	creates a is null expression
is-unique	Creates mask indicating unique values
join	Joins a lazy frame with other lazy frame
keep	Deprecated command
keep until	Deprecated command
keep while	Deprecated command
keybindings	Keybindings related commands
keybindings default	List default keybindings
keybindings list	List available options that can be used to create keybindings
keybindings listen	Get input from the user.
kill	Kill a process using the process id.
last	Creates new dataframe with tail rows or creates a last expression
last	Show only the last number of rows.
length	Count the number of elements in the input.
let	Create a variable and give it a value.
let-env	Create an environment variable and give it a value.
lines	Converts input to lines
list	Aggregates a group to a Series
lit	Creates a literal expression
load-env	Loads an environment update from a record.
ls	List the files in a directory.
ls-df	Lists stored dataframes
match	Deprecated command
math	Use mathematical functions as aggregate functions on a list of numbers or tables.
math abs	Returns absolute values of a list of numbers
math avg	Finds the average of a list of numbers or tables
math ceil	Applies the ceil function to a list of numbers
math eval	Evaluate a math expression into a number
math floor	Applies the floor function to a list of numbers
math max	Finds the maximum within a list of numbers or tables
math median	Gets the median of a list of numbers
math min	Finds the minimum within a list of numbers or tables
math mode	Gets the most frequent element(s) from a list of numbers or tables
math product	Finds the product of a list of numbers or tables
math round	Applies the round function to a list of numbers
math sqrt	Applies the square root function to a list of numbers
math stddev	Finds the stddev of a list of numbers or tables
math sum	Finds the sum of a list of numbers or tables
math variance	Finds the variance of a list of numbers or tables
max	Aggregates columns to their max value
max	Creates a max expression
mean	Aggregates columns to their mean value
mean	Creates a mean expression for an aggregation
median	Aggregates columns to their median value
median	Creates a median expression for an aggregation
melt	Unpivot a DataFrame from wide to long format
merge	Merge a table into an input table
metadata	Get the metadata for items in the stream
min	Aggregates columns to their min value
min	Creates a min expression
mkdir	Make directories, creates intermediary directories as required.
module	Define a custom module
move	Move columns before or after other columns
mv	Move files or directories.
n	Switch to the next shell.
n-unique	Counts unique values
n-unique	creates a n-unique expression
nth	Deprecated command
nu-highlight	Syntax highlight the input string.
open	Load a file into a cell, converting to table if possible (avoid by appending '--raw').
open-df	Opens csv, json or parquet file to create dataframe
otherwise	completes a when expression
overlay	Commands for manipulating overlays.
overlay add	Add definitions from a module as an overlay
overlay list	List all active overlays
overlay new	Create an empty overlay
overlay remove	Remove an active overlay
p	Switch to the previous shell.
par-each	Run a block on each element of input in parallel
parse	Parse columns from string data using a simple pattern.
path	Explore and manipulate paths.
path basename	Get the final component of a path
path dirname	Get the parent directory of a path
path exists	Check whether a path exists
path expand	Try to expand a path to its absolute form
path join	Join a structured path or a list of path parts.
path parse	Convert a path into structured data.
path relative-to	Get a path as relative to another path.
path split	Split a path into parts by a separator.
path type	Get the type of the object a path refers to (e.g., file, dir, symlink)
pivot	Deprecated command
post	Post a body to a URL.
prepend	Prepend any number of rows to a table.
print	Prints the values given
ps	View information about system processes.
quantile	Aggregates the columns to the selected quantile
quantile	Aggregates the columns to the selected quantile
query	Show all the query commands
query json	execute json query on json file (open --raw <file> | query json 'query string')
query web	execute selector query on html/web
query xml	execute xpath query on xml
random	Generate a random value.
random bool	Generate a random boolean value
random chars	Generate random chars
random decimal	Generate a random decimal within a range [min..max]
random dice	Generate a random dice roll
random integer	Generate a random integer [min..max]
random uuid	Generate a random uuid4 string
range	Return only the selected rows.
reduce	Aggregate a list table to a single value using an accumulator block.
register	Register a plugin
reject	Remove the given columns from the table. If you want to remove rows, try 'drop'.
rename	Rename a dataframe column
rename	Creates a new table with columns renamed.
replace	Replace the leftmost (sub)string by a regex pattern
replace-all	Replace all (sub)strings by a regex pattern
reverse	Reverses the LazyFrame
reverse	Reverses the table.
rm	Remove file(s).
roll	Rolling commands for tables
roll down	Roll table rows down
roll left	Roll table columns left
roll right	Roll table columns right
roll up	Roll table rows up
rolling	Rolling calculation for a series
rotate	Rotates a table clockwise (default) or counter-clockwise (use --ccw flag).
run-external	Runs external command
sample	Create sample dataframe
save	Save a file.
select	Selects columns from lazyframe
select	Down-select table to only these columns.
seq	Print sequences of numbers.
seq char	Print sequence of chars
seq date	Print sequences of dates
set	Sets value where given mask is true
set-with-idx	Sets value in the given index
shape	Shows column and row size for a dataframe
shells	Lists all open shells.
shift	Shifts the values by a given period
shuffle	Shuffle rows randomly.
size	Gather word count statistics on the text.
skip	Skip the first n elements of the input.
skip until	Skip elements of the input until a predicate is true.
skip while	Skip elements of the input while a predicate is true.
sleep	Delay for a specified amount of time.
slice	Creates new dataframe from a slice of rows
sort	Sort in increasing order.
sort-by	sorts a lazy dataframe based on expression(s)
sort-by	Sort by the given columns, in increasing order.
source	Runs a script file in the current context.
split	Split contents across desired subcommand (like row, column) via the separator.
split chars	Split a string's characters into separate rows
split column	Split a string into multiple columns using a separator
split row	Split a string into multiple rows using a separator
split-by	Create a new table splitted.
std	Aggregates columns to their std value
std	Creates a std expression for an aggregation
str	Various commands for working with string data
str camel-case	Convert a string to camelCase
str capitalize	Capitalize first letter of text
str collect	Concatenate multiple strings into a single string, with an optional separator between each
str contains	Checks if string contains pattern
str downcase	Make text lowercase
str ends-with	Check if a string ends with a pattern
str find-replace	Deprecated command
str index-of	Returns start index of first occurrence of pattern in string, or -1 if no match
str kebab-case	Convert a string to kebab-case
str length	Output the length of any strings in the pipeline
str lpad	Left-pad a string to a specific length
str pascal-case	Convert a string to PascalCase
str replace	Find and replace text
str reverse	Reverse every string in the pipeline
str rpad	Right-pad a string to a specific length
str screaming-snake-case	Convert a string to SCREAMING_SNAKE_CASE
str snake-case	Convert a string to snake_case
str starts-with	Check if string starts with a pattern
str substring	Get part of a string. Note that the start is included but the end is excluded, and that the first character of a string is index 0.
str title-case	Convert a string to Title Case
str to-datetime	Deprecated command
str to-decimal	Deprecated command
str to-int	Deprecated command
str trim	Trim whitespace or specific character
str upcase	Make text uppercase
str-lengths	Get lengths of all strings
str-slice	Slices the string from the start position until the selected length
strftime	Formats date based on string rule
sum	Aggregates columns to their sum value
sum	Creates a sum expression for an aggregation
sys	View information about the system.
table	Render the table.
take	Creates new dataframe using the given indices
take	Take the first n elements of the input.
take until	Take elements of the input until a predicate is true.
take while	Take elements of the input while a predicate is true.
term size	Returns the terminal size
to	Translate structured data to a format
to csv	Convert table into .csv text
to html	Convert table into simple HTML
to json	Converts table data into JSON text.
to md	Convert table into simple Markdown
to nuon	Converts table data into Nuon (Nushell Object Notation) text.
to text	Converts data into simple text.
to toml	Convert table into .toml text
to tsv	Convert table into .tsv text
to url	Convert table into url-encoded text
to xml	Convert table into .xml text
to yaml	Convert table into .yaml/.yml text
to-csv	Saves dataframe to csv file
to-df	Converts a List, Table or Dictionary into a dataframe
to-dummies	Creates a new dataframe with dummy variables
to-lazy	Converts a dataframe into a lazy dataframe
to-lowercase	Lowercase the strings in the column
to-nu	Converts a section of the dataframe to Nushell Table
to-nu	Convert expression to a nu value for access and exploration
to-parquet	Saves dataframe to parquet file
to-uppercase	Uppercase the strings in the column
touch	Creates one or more files.
transpose	Transposes the table contents so rows become columns and columns become rows.
tutor	Run the tutorial. To begin, run: tutor
unalias	Deprecated command
uniq	Return the unique rows.
unique	Returns unique values from a dataframe
update	Update an existing column to have a new value.
update cells	Update the table cells.
upsert	Update an existing column to have a new value, or insert a new column.
url	Apply url function.
url host	Get the host of a URL
url path	Get the path of a URL
url query	Get the query string of a URL
url scheme	Get the scheme (e.g. http, file) of a URL
use	Use definitions from a module
value-counts	Returns a dataframe with the counts for unique values in series
var	Aggregates columns to their var value
var	Create a var expression for an aggregation
version	Display Nu version.
view-source	View a block, module, or a definition
watch	Watch for file changes and execute Nu code when they happen.
when	Creates and modifies a when expression
where	Filter values based on a condition.
which	Finds a program file, alias or custom command.
window	Creates a sliding window of `window_size` that slide by n rows/elements across input.
with-column	Adds a series to the dataframe
with-env	Runs a block with an environment variable set.
wrap	Wrap the value into a column.
zip	Combine a stream with the input