how to count number of rows and sum of column using awk Post: 302422525

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to sum rows in e.g. column 1 by a category in e.g. column 2

Hi, I've shown an example of what I would like to achieve below. In the example file, I would like to sum the values in column 2 for each distinct category in column 3 (presumably making an array?) and print the sum as well as the category name and length (note:length always corresponds with...

2. Shell Programming and Scripting

awk count characters, sum, and divide by another column

Hi All, I am another biologist attempting to parse a large txt file containing several million lines like: tucosnp 56762 T Y 228 228 60 23 .CcCcc,,..c.c,cc,,.C... What I need to do is get the frequency of periods (.) plus commas (,) in column 9, and populate this number into another...

3. Shell Programming and Scripting

how to add the number of row and count number of rows

Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count The input file: 21 2341 A 21 2341 A 21 2341 A 21 2341 C 21 2341 C 21 2341 C 21 2341 C 21 4567 A 21 4567 A 21 4567 C ...

4. UNIX for Dummies Questions & Answers

count number of rows based on other column values

Could anybody help with this? I have input below ..... david,39 david,39 emelie,40 clarissa,22 bob,42 bob,42 tim,32 bob,39 david,38 emelie,47 what i want to do is count how many names there are with different ages, so output would be like this .... david,2 emelie,2 clarissa,1...

5. UNIX for Dummies Questions & Answers

Sum the rows number based on first field string value

Hi, I have a file like this one h1 4.70650E-04 4.70650E-04 4.70650E-04 h2 1.92912E-04 1.92912E-04 1.92912E-04 h3A 3.10160E-11 2.94562E-11 2.78458E-11 h4 0.00000E+00 0.00000E+00 0.00000E+00 h1 1.18164E-12 2.74150E-12 4.35187E-12 h1 7.60813E-01 7.60813E-01 7.60813E-01...

6. UNIX for Dummies Questions & Answers

count number of distinct values in each column with awk

Hi ! input: A|B|C|D A|F|C|E A|B|I|C A|T|I|B As the title of the thread says, I would need to get: 1|3|2|4 I tried different variants of this command, but I don't manage to obtain what I need: gawk 'BEGIN{FS=OFS="|"}{for(i=1; i<=NF; i++) a++} END {for (b in a) print b}' input ...

7. Shell Programming and Scripting

awk code to ignore the first occurence unknown number of rows in a data column

Hello experts, Shown below is the 2 column sample data(there are many data columns in actual input file), Key, Data A, 1 A, 2 A, 2 A, 3 A, 1 A, 1 A, 1 I need the below output. Key, Data A, 2 A, 2 A, 3 A, 1 A, 1 A, 1

8. UNIX for Dummies Questions & Answers

Script to count number of rows

Hi, I need a solaris shell script to read multiple files and count number of unique name rows(strings) from those files. The input and output should be like this Input: file 1 abc cde abc ...

9. UNIX for Beginners Questions & Answers

Copy columns from one file into another and get sum of column values and row count

I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv abc.csv- UTF-8,,,,,,,,,,,,,,,,,,,,,,,,, ...

10. Shell Programming and Scripting

Count Repetitive Number in a column and renumbering using awk

Unable to get the desired output. Need only the rows which has repeated values in column 5. Input File <tab separated file> chr1 3773797 3773797 CEP10 1 chr1 3773797 3773797 CEP104 2 chr1 3689350 3689350 SMIM1 2 chr1 3773797 3773797 CEP4 3 chr1 3773797 3773797 EP104 ...

LEARN ABOUT DEBIAN

free

FREE(1) 							   User Commands							   FREE(1)

NAME

       free - Display amount of free and used memory in the system

SYNOPSIS

       free [options]

DESCRIPTION

       free  displays  the  total  amount of free and used physical and swap memory in the system, as well as the buffers used by the kernel.  The
       shared memory column should be ignored; it is obsolete.

OPTIONS

       -b, --bytes
	      Display the amount of memory in bytes.

       -k, --kilo
	      Display the amount of memory in kilobytes.  This is the default.

       -m, --mega
	      Display the amount of memory in megabytes.

       -g, --giga
	      Display the amount of memory in gigabytes.

       --tera Display the amount of memory in terabytes.

       -h, --human
	      Show all output fields automatically scaled to shortest three digit unit and display the units of print out.   Following	units  are
	      used.

		B = bytes
		K = kilos
		M = megas
		G = gigas
		T = teras

	      If unit is missing, and you have petabyte of RAM or swap, the number is in terabytes and columns might not be aligned with header.

       -c, --count count
	      Display the result count times.  Requires the -s option.

       -l, --lohi
	      Show detailed low and high memory statistics.

       -o, --old
	      Display the output in old format, the only difference being this option will disable the display of the "buffer adjusted" line.

       -s, --seconds seconds
	      Continuously  display  the  result  delay seconds apart.	You may actually specify any floating point number for delay, usleep(3) is
	      used for microsecond resolution delay times.

       --si   Use power of 1000 not 1024.

       -t, --total
	      Display a line showing the column totals.

       --help Print help.

       -V, --version
	      Display version information.

FILES

       /proc/meminfo
	      memory information

SEE ALSO

       ps(1), slabtop(1), top(1), vmstat(8).

AUTHORS

       Written by Brian Edmonds.

REPORTING BUGS

       Please send bug reports to <procps@freelists.org>

procps-ng							  September 2011							   FREE(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to sum rows in e.g. column 1 by a category in e.g. column 2

Discussion started by: auburn

2. Shell Programming and Scripting

awk count characters, sum, and divide by another column

Discussion started by: peromhc

3. Shell Programming and Scripting

how to add the number of row and count number of rows

Discussion started by: juelillo

4. UNIX for Dummies Questions & Answers

count number of rows based on other column values

Discussion started by: itsme999