• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • VCS
  • Interview Questions
  • Database
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

datamash Command Examples in Linux

by Deepika

datamash is a command-line utility that allows you to perform basic numeric, textual, and statistical operations on input data files. It is a simple and lightweight tool that is useful for data manipulation and analysis tasks.

To use datamash, you will need to specify the operation that you want to perform, as well as the input data file and any necessary options or arguments. For example, to calculate the average of a column in a CSV file, you could use the following command:

# datamash -t, mean 1 < input.csv

This command will calculate the mean of the values in the first column of the input.csv file, using a comma as the field delimiter.

datamash Command Examples

1. Get max, min, mean and median of a single column of numbers:

# seq 3 | datamash max 1 min 1 mean 1 median 1

2. Get the mean of a single column of float numbers (floats must use "," and not "."):

# echo -e '1.0\n2.5\n3.1\n4.3\n5.6\n5.7' | tr '.' ',' | datamash mean 1

3. Get the mean of a single column of numbers with a given decimal precision:

# echo -e '1\n2\n3\n4\n5\n5' | datamash -R number_of_decimals_wanted mean 1

4. Get the mean of a single column of numbers ignoring "Na" and "NaN" (literal) strings:

# echo -e '1\n2\nNa\n3\nNaN' | datamash --narm mean 1

Filed Under: Linux

Some more articles you might also be interested in …

  1. How to Find Number of CPU Sockets on a CentOS/RHEL System
  2. chronyc : command not found
  3. killall Command Examples in Linux
  4. lpr Command Examples in Linux
  5. isisdl Command Examples
  6. nethogs: command not found
  7. CentOS / RHEL : Exclusion with Yum For Kernel Updates
  8. “az webapp” Command Examples (Manage Web Applications hosted in Azure Cloud Services)
  9. sudoedit: command not found
  10. How to uninstall cmake package from Ubuntu

You May Also Like

Primary Sidebar

Recent Posts

  • Vanilla OS 2 Released: A New Era for Linux Enthusiasts
  • mk Command Examples
  • mixxx Command Examples
  • mix Command Examples

© 2025 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright