Awk: count unique elements in a field and sum their occurence across the entire file Post: 303016025

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Getting Sum, Count and Distinct Count of a file

Hi all this is a UNIX question. I have a large flat file with millions of records. col1|col2|col3 1|a|b 2|c|d 3|e|f 3|g|h footer**** I am supposed to calculate the sum of col1 1+2+3+3=9, count of col1 1,2,3,3=4, and distinct count of col1 1,2,3=c3 I would like it if you avoid...

2. UNIX for Dummies Questions & Answers

How to search unique occurence in a file?

Hi, I have to search and count unique occurence of DE numbers in bold below in a file which has content like below. Proc Tran F-BUY Item Tkey Q5JV Item Tsid JTIZ9 Item Tdat 20091001 Item Tset 20091001 Item Tbkr 5 Item Tshs 2 Item Tprc 897.0 Item Tcom 2000.0 Item Tcm1 20091001...

3. Shell Programming and Scripting

Printing entire field, if at least one row is matching by AWK

Dear all, I have been trying to print an entire field, if the first line of the field is matching. For example, my input looks something like this. aaa ddd zzz 123 987 126 24 0.650 985 354 9864 0.32 0.333 4324 000 I am looking for a pattern,...

4. Shell Programming and Scripting

awk and count sum ?

I have a input.txt file which have 3 fields separate by a comma place, os and timediff in seconds tampa,win7, 2575 tampa,win7, 157619 tampa,win7, 3352 dallas,vista,604799 greenbay,winxp, 14400 greenbay,win7 , 518400 san jose,winxp, 228121 san jose,winxp, 70853 san jose,winxp, 193514...

5. Shell Programming and Scripting

awk if statement not printing entire field

I have an input that looks like this: chr1 mm9_knownGene utr3 3204563 3206102 0 - . gene_id "Xkr4"; transcript_id "uc007aeu.1"; chr1 mm9_knownGene utr3 4280927 4283061 0 - . gene_id "Rp1"; transcript_id "uc007aew.1"; chr1 mm9_knownGene ...

6. Shell Programming and Scripting

awk sum entire string

Hi I am trying to carry out a sum on a file (totals.txt). The file looks like: So far i have this command this returns 20610 I however want it to return 000000206100 Any help would be great thanks!

7. Shell Programming and Scripting

Looping through entire directory and count unique values

Hello, I`m a complete newbie to coding, please help with this problem. I have multiple files in a directory, I have to loop through the contents of each file and extract number of unique isoforms in that file. Each file is tab delimited and only the line with the first parent (column 3)...

8. Shell Programming and Scripting

awk to count using each unique value

Im looking for an awk script that will take the unique values in column 5, then print and count the unique values in column 6. CA001011500 11111 11111 -9999 201301 AAA CA001012040 11111 11111 -9999 201301 AAA CA001012573 11111 11111 -9999 201301 BBB CA001012710 11111 11111 -9999 201301...

9. Shell Programming and Scripting

Count of unique lines in field 4

When I use the below awk to count the unique lines in $4 for the input it seems to work. The answer is 3 because $4 is only unique 3 times in all the entries. However, when I use the same on actual data I get 56,536 and I know the answer should be 56,548. My question is there a better way to...

10. UNIX for Beginners Questions & Answers

Use strings from nth field from one file to match strings in entire line in another file, awk

I cannot seem to get what should be a simple awk one-liner to work correctly and cannot figure out why. I would like to use patterns from a specific field in one file as regex to search for matching strings in the entire line ($0) of another file. I would like to output the lines of File2 which...

LEARN ABOUT OPENDARWIN

katalyzer

KATALYZER(1)							      libkate							      KATALYZER(1)

NAME

       katalyzer - analyzes Kate streams and displays various information about them.

SYNOPSIS

       katalyzer [-hV] [-l types] [-l!]  [ infile ]

DESCRIPTION

       katalyzer  analyzes  Kate streams and displays information about them. The type of information to select is selectable on the command line.
       Several multiplexed Kate streams may be analyzed at the same time.

OPTIONS

       -h     Show command line help.

       -V     Show version information.

       -l types
	      Select the types of information to log, from the list below. These characters may be concatenated in a single -l option, as, eg,	ls
	      does (eg, katalyzer -l Ttv).  Refer to the katalyzer command line help for a fully up to date list of types.
		  e: errors
		  p: packet
		  c: container specific information
		  T: Timing
		  t: text
		  v: event
		  d: dump page and packets
		  S: statistics
		  -: miscellaneous information that doesn't belong in any other type

       -l!    Shorthand to select all information to log.

EXAMPLES

       Analyzes any Kate stream in an Ogg file:

	   katalyzer input.ogg

       Analyzes any Kate stream in an Ogg file, displaying only errors:

	   katalyzer -l e input.ogg

SEE ALSO

       katedec(1), kateenc(1)

libkate 0.4.1							 03 december 2008						      KATALYZER(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Getting Sum, Count and Distinct Count of a file

Discussion started by: singhabhijit

2. UNIX for Dummies Questions & Answers

How to search unique occurence in a file?

Discussion started by: akash028

3. Shell Programming and Scripting

Printing entire field, if at least one row is matching by AWK

Discussion started by: Chulamakuri

4. Shell Programming and Scripting

awk and count sum ?

Discussion started by: sabercats