• 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. Image optimization with webp
  2. “git credential” Command Examples
  3. archlinux-java Command Examples in Linux
  4. How to Change runlevels/targets using systemd in Ubuntu
  5. How To Force User/Group Ownership Of Files On A Samba Share
  6. module Command Examples in Linux
  7. How to disable NFS client caching in CentOS/RHEL
  8. CentOS / RHEL 6 : How to Disable / Enable direct root login via telnet
  9. CentOS / RHEL : How to delete LVM volume
  10. btrfs restore Command Examples in Linux

You May Also Like

Primary Sidebar

Recent Posts

  • gixy Command Examples
  • gitsome Command Examples
  • gitmoji Command Examples
  • gitlint Command Examples

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright