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

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • 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. UNIX / Linux : How to delete root equivalent user (Non-Root User with UID 0)
  2. CentOS / RHEL : How to delete LVM volume
  3. rm: cannot remove ‘doc/by-app’: Function not implemented (CentOS/RHEL 7)
  4. flashrom Command Examples in Linux
  5. How to delete a non-root use with UID 0 in Linux
  6. lvextend command examples in Linux
  7. blastp: command not found
  8. CentOS / RHEL : How to create and host yum repository over httpd
  9. e2undo: command not found
  10. How to configure iSCSI Initiator (client) in CentOS / RHEL 7

You May Also Like

Primary Sidebar

Recent Posts

  • powertop Command Examples in Linux
  • powertop: command not found
  • powerstat: command not found
  • powerstat Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright