Count the lines with the same values in a column and write the output to a file

10 More Discussions You Might Find Interesting

1. 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,,,,,,,,,,,,,,,,,,,,,,,,, ...

2. Shell Programming and Scripting

Read first column and count lines in second column using awk

Hello all, I would like to ask your help here: I've a huge file that has 2 columns. A part of it is: sorted.txt: kss23 rml.67lkj kss23 zhh.6gf kss23 nhd.09.fdd kss23 hp.767.88.89 fl67 nmdsfs.56.df.67 fl67 kk.fgf.98.56.n fl67 bgdgdfg.hjj.879.d fl66 kl..hfh.76.ghg fl66...

3. Shell Programming and Scripting

Count frequency of unique values in specific column

Hi, I have tab-deliminated data similar to the following: dot is-big 2 dot is-round 3 dot is-gray 4 cat is-big 3 hot in-summer 5 I want to count the frequency of each individual "unique" value in the 1st column. Thus, the desired output would be as follows: dot 3 cat 1 hot 1 is...

4. Shell Programming and Scripting

Count specific column values

Hi all: quick question! I have the following data that resembles some thing like this: i am tired tired am i what is up hello people cool I want to count (or at least isolate) all of the unique elements in the 2nd column. I have tried this: cut -f 2 | uniq 'input' which does...

5. 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 ...

6. Shell Programming and Scripting

Word count of values in a column

Hi friends, I have an input file of the following format a b c 1.11112 d e f 4.5767 g h i 19.098 k i l 87.9999 I am looking for an awk one liners that would help me in giving the following output output.txt Range of the column: 1.11112 to 87.9999 Total records between 1 and 10 - 2...

7. Shell Programming and Scripting

How to compare the values of a column in awk in a same file and consecutive lines..

I would like to compare the values of 2nd column of consecutive lines of same file in such a way so that if the difference between first value and second value is more than 100 it should print complete line else ignore line. Input File ========== PDB 2500 RTDB 123 RTDB-EAGLE 122 VSCCP 2565...

8. UNIX for Dummies Questions & Answers

Count Number Of lines in text files and append values to beginning of file

Hello, I have 50 text files in a directory called "AllFiles" I want to make a program that will go inside of the "AllFiles" Directory and count the number of lines in each individual text file. Then, the program will calculate how many more lines there are over 400 in each text file and...

9. Shell Programming and Scripting

Help with script to read lines from file and count values

Hi, I need some help with a script I'm trying to write. I have a log file containing references to a number of different webservices. I wish to write a script that will list the webservices with a count as to how many times they appear in the log. An example of the log file content: ...

10. 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...

LEARN ABOUT POSIX

total

TOTAL(1)						      General Commands Manual							  TOTAL(1)

NAME

       total - sum up columns

SYNOPSIS

       total [ -m ][ -sE | -p | -u | -l ][ -i{f|d}[N] ][ -o{f|d} ][ -tC ][ -N [ -r ]] [ file ..  ]

DESCRIPTION

       Total sums up columns of real numbers from one or more files and prints out the result on its standard output.

       By default, total computes the straigt sum of each input column, but multiplication can be specified instead with the -p option.  Likewise,
       the -u option means find the upper limit (maximum), and -l means find the lower limit (minimum).

       Sums of powers can be computed by giving an exponent with the -s option.  (Note that there is no space between the -s  and  the	exponent.)
       This  exponent  can be any real number, positive or negative.  The absolute value of the input is always taken before the power is computed
       in order to avoid complex results.  Thus, -s1 will produce a sum of absolute values.  The default power (zero) is interpreted as a straight
       sum without taking absolute values.

       The -m option can be used to compute the mean rather than the total.  For sums, the arithmetic mean is computed.  For products, the geomet-
       ric mean is computed.  (A logarithmic sum of absolute values is used to avoid overflow, and zero values are silently ignored.)

       If the input data is binary, the -id or -if option may be given for 64-bit double or 32-bit float values, respectively.	Either option  may
       be  followed  immediately  by  an  optional  count, which defaults to 1, indicating the number of double or float binary values to read per
       record on the input file.  (There can be no space between the option and this count.)  Similarly, the -od and -of  options  specify  binary
       double or float output, respectively.  These options do not need a count, as this will be determined by the number of input channels.

       A count can be given as the number of lines to read before computing a result.  Normally, total reads each file to its end before producing
       its result, but this behavior may be overridden by inserting blank lines in the input.  For each blank input line, total produces a  result
       as  if  the end-of-file had been reached.  If two blank lines immediately follow each other, total closes the file and proceeds to the next
       one (after reporting the result).  The -N option (where N is a decimal integer) tells total to produce a result and reset  the  calculation
       after  every N input lines.  In addition, the -r option can be specified to override reinitialization and thus give a running total every N
       lines (or every blank line).  If the end of file is reached, the current total is printed and the calculation is reset before the next file
       (with or without the -r option).

       The -tC option can be used to specify the input and output tab character.  The default tab character is TAB.

       If no files are given, the standard input is read.

EXAMPLE

       To compute the RMS value of colon-separated columns in a file:

	 total -t: -m -s2 input

       To produce a running product of values from a file:

	 total -p -1 -r input

BUGS

       If the input files have varying numbers of columns, mean values will certainly be off.  Total will ignore missing column entries if the tab
       separator is a non-white character, but cannot tell where a missing column should have been if the tab character is white.

AUTHOR

       Greg Ward

SEE ALSO

       cnt(1), neaten(1), rcalc(1), rlam(1), tabfunc(1)

RADIANCE
							      2/3/95								  TOTAL(1)

UNIX for Dummies Questions & Answers