Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk: count unique elements in a field and sum their occurence across the entire file
Top Forums UNIX for Beginners Questions & Answers Awk: count unique elements in a field and sum their occurence across the entire file Post 303016009 by RudiC on Wednesday 18th of April 2018 06:23:46 AM
Old 04-18-2018
For my convenience, I rearranged / -idented your code, and added the delete count statement:
Code:
awk -F"|" -vOFS="\t" '

        {a = split ($2, b, ",")
         for (i=1; i<=a; i++)   if (!count[b[i]]++)     total[b[i]]++
         delete count
        }

END     {for (k in total)       print k "\t" total[k]
        }
' file
A    3
B    2
C    1
D    1

Looks promising!
This User Gave Thanks to RudiC For This Post:
beca123456
 

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... (4 Replies)
Discussion started by: singhabhijit
4 Replies

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... (6 Replies)
Discussion started by: akash028
6 Replies

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,... (5 Replies)
Discussion started by: Chulamakuri
5 Replies

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 Replies)
Discussion started by: sabercats
5 Replies

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 ... (5 Replies)
Discussion started by: pbluescript
5 Replies

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! (6 Replies)
Discussion started by: nwalsh88
6 Replies

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)... (1 Reply)
Discussion started by: ritakadm
1 Replies

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... (4 Replies)
Discussion started by: ncwxpanther
4 Replies

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... (8 Replies)
Discussion started by: cmccabe
8 Replies

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... (1 Reply)
Discussion started by: jvoot
1 Replies

LEARN ABOUT DEBIAN

qrencode

QRENCODE(1)						      General Commands Manual						       QRENCODE(1)

NAME

       qrencode - Encode input data in a QR Code and save as a PNG or EPS image.

SYNOPSIS

       qrencode [OPTION]...  [STRING]

DESCRIPTION

       Libqrencode  is	a  library  for encoding data in a QR Code symbol, a kind of 2D symbology that can be scanned by handy terminals such as a
       mobile phone with CCD. The capacity of QR Code is up to 7000 digits or 4000 characters, and has high robustness.

       Qrencode is a utility software using libqrencode to encode string data in a QR Code and save as a PNG or EPS image.

OPTIONS

       -h, --help
	      display help message.

       -o FILENAME, --output=FILENAME
	      write image to FILENAME. If '-' is specified, the result will be output to standard output. If -S is given, structured  symbols  are
	      written to FILENAME-01.png, FILENAME-02.png, ... (suffix is removed from FILENAME, if specified)

       -s NUMBER, --size=NUMBER
	      specify the size of dot (pixel). (default=3)

       -l {LMQH}, --level={LMQH}
	      specify error collectin level from L (lowest) to H (highest). (default=L)

       -v NUMBER, --symversion=NUMBER
	      specify the version of the symbol. (default=auto)

       -m NUMBER, --margin=NUMBER
	      specify the width of margin. (default=4)

       -d NUMBER, --dpi=NUMBER
	      specify the DPI of the generated PNG. (default=72)

       -t {PNG,EPS,ANSI,ANSI256}, --type={PNG,EPS,ANSI,ANSI256}
	      specify the type of the generated image. (default=PNG)

       -S, --structured
	      make structured symbols. Version must be specified.

       -k, --kanji
	      assume that the input text contains kanji (shift-jis).

       -c, --casesensitive
	      encode lower-case alphabet characters in 8-bit mode. (default)

       -i, --ignorecase
	      ignore case distinctions and use only upper-case characters.

       -8, --8bit
	      encode entire data in 8-bit mode. -k, -c and -i will be ignored.

       -M, --micro
	      encode in a Micro QR Code. (experimental)

       -V, --version
	      display the version number and copyrights of the qrencode.

       [STRING]
	      input data. If it is not specified, data will be taken from standard input.

EXAMPLES

       qrencode -l L -v 1 -o output.png 'Hello, world!'
	      encode into a symbol version 1, level L.

       qrencode -iSv 1 --output=output.png
	      read standard input and encode it into a structured-appended symbols in case-insensitive mode.

AUTHOR

       Written by Kentaro Fukuchi.

RESOURCES

       Main Web Site: http://fukuchi.org/works/qrencode/

       Source code repository: https://github.com/fukuchi/libqrencode/

COPYRIGHT

       Copyright (C) 2006-2012 Kentaro Fukuchi.

qrencode 3.3.0							   Feb. 29, 2012						       QRENCODE(1)
All times are GMT -4. The time now is 09:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy