Sponsored Content
Full Discussion: Awk to count occurences
Top Forums Shell Programming and Scripting Awk to count occurences Post 302483376 by saint2006 on Sunday 26th of December 2010 04:16:14 PM
Old 12-26-2010
Awk to count occurences

Hi,

i am in need of an awk script to accomplish the following:

Input table looks like:

Student1 arts
Student2 science
Student3 arts
Student4 science
Student5 science
Student6 science
Student7 science
Student8 science
Student9 science
Student10 science
Student11 science
Student12 arts
Student13 arts
Student14 arts
Student15 arts
Student16 science
Student17 science
Student18 science
Student19 science
Student20 science

Problem:

I want to count how many 'science' occurs continuously and how many 'arts' occurs continuously and how many times each occur continuously without a break in this table.

Expected Result:

'science' occurs twice continuously with 8 and 5 counts respectively and 'arts' occurs once continuously with 4 counts.


I greatly appreciate your help.
Thanks.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl - Count occurences

I have enclosed the script. I am able to find the files that contain my search string but when I try to count the occurences within the file I get zero always. Any help on this. #!/usr/bin/perl my $find = $ARGV; my $replace = $ARGV; my $glob = $ARGV; @filelist = <*$glob>; # process each... (22 Replies)
Discussion started by: TimHortons
22 Replies

2. Shell Programming and Scripting

to count the number of occurences of a column value

im trying to count the number of occurences of column 2 value(starting from KKK*) of the below file, file.txt using the code cat file.txt | awk ' BEGIN { print "Category Counts"} {FS=","} {NR > 2} { cats = cats + 1} END { for(c in cats) { print c, "=", cats} } ' but its returning as ... (6 Replies)
Discussion started by: michaelrozar17
6 Replies

3. Shell Programming and Scripting

Count occurences of string

Hi, Please help me in finding the number of occurences of the string. Example: Apple, green, blue, Apple, Orange, green, blue are the strings can be even in the next line. The o/p should look as: Word Count ----- ----- Apple 2 green 2 Orange 1 blue 2 Thanks (2 Replies)
Discussion started by: acc888
2 Replies

4. UNIX for Dummies Questions & Answers

Count pattern occurences

hi, I have a text..and i need to find a pattern in the text and count to the no of times the pattern occured. i have used grep command ..but the problem is , it shows the occurrences of the pattern but doesn't count no of times the pattern occuries. (5 Replies)
Discussion started by: nvnni
5 Replies

5. Shell Programming and Scripting

Count occurences based on interval

Hi, I have a file which has 4500 entries 10000 9880 9800 8700 8200 ... ..... ... ... ... ... ... ... ... 50 (1 Reply)
Discussion started by: Diya123
1 Replies

6. Shell Programming and Scripting

Count number of occurences using awk

Hi Guys, I have 2 files like below file1 xx yy file2 b yy b2 xx c1 yy xx yy Now I want an idea which can count occurences of text from file1 and file2 so outbout would be kind of (9 Replies)
Discussion started by: prashant2507198
9 Replies

7. Shell Programming and Scripting

awk count occurences

line number:status, market, keystation 1,SENT,EBS,1 : 1 2,DONE,REU,1 : 1 3,SENT,EBS,2 : 1 4,DONE,EBS,1 : 0 5,SENT,EBS,2 : 0 6,SENT,EBS,2 : 0 7,SENT,EBS,2 : 0 8,SENT,EBS,1 : 1 for each status, market combination I want to keep a tally of active orders. i.e if an order is SENT, then +1, if... (8 Replies)
Discussion started by: Calypso
8 Replies

8. Shell Programming and Scripting

[solved]awk count occurences in time window

Input File Time, KeyStation 00:00:00,000;KS_1 00:00:01,000;KS_1 00:00:02,000;KS_1 00:00:03,000;KS_1 00:00:04,000;KS_1 00:00:05,000;KS_1 00:00:06,000;KS_1 00:01:01,000;KS_1 00:01:02,000;KS_1 00:01:03,000;KS_1 00:01:04,000;KS_1 00:01:05,000;KS_1 00:01:06,000;KS_1 01:00:01,000;KS_1... (0 Replies)
Discussion started by: Calypso
0 Replies

9. Shell Programming and Scripting

Count the occurences of strings

I have some text files in a folder f1 with 10 columns. The first five columns of a file are shown below. aab abb 263-455 263 455 aab abb 263-455 263 455 aab abb 263-455 263 455 bbb abb 26-455 26 455 bbb abb 26-455 26 455 bbb aka 264-266 264 266 bga bga 230-232 230 ... (10 Replies)
Discussion started by: gomez
10 Replies

10. UNIX for Beginners Questions & Answers

Count occurences of the word without it repeating

Hi, I would like to count the number of ALA occurences without having them to be repeated. In the script I have written now it has 40 repetitions of ALA but it has to be 8. ALA is chosen as one of the 20 values it can have when the script asks for the input of AAA, which for this example is chosen... (7 Replies)
Discussion started by: Aurimas
7 Replies
Number::RecordLocator(3pm)				User Contributed Perl Documentation				Number::RecordLocator(3pm)

NAME
Number::RecordLocator - Encodes integers into a short and easy to read and pronounce "locator string" SYNOPSIS
use Number::RecordLocator; my $generator = Number::RecordLocator->new(); my $string = $generator->encode("123456"); # $string = "5RL2"; my $number = $generator->decode($string); # $number = "123456"; DESCRIPTION
"Number::RecordLocator" encodes integers into a 32 character "alphabet" designed to be short and easy to read and pronounce. The encoding maps: 0 to O 1 to I S to F B to P With a 32 bit encoding, you can map 33.5 million unique ids into a 5 character code. This certainly isn't an exact science and I'm not yet 100% sure of the encoding. Feedback is much appreciated. new Instantiate a new "Number::RecordLocator" object. Right now, we don't actually store any object-specific data, but in the future, we might. init Initializes our integer to character and character to integer mapping tables. encode INTEGER Takes an integer. Returns a Record Locator string. decode STRING Takes a record locator string and returns an integer. If you pass in a string containing an invalid character, it returns undef. canonicalize STRING To compare a Record Locator string with another you can do: print "ALWAYS TRUE " if $generator->decode("B0") == $generator->decode("PO"); However, this method provides an alternative: my $rl_string = $generator->encode(725); print "ALWAYS TRUE " if $generator->canonicalize("b0") eq $rl_string; print "ALWAYS TRUE " if $generator->canonicalize("BO") eq $rl_string; print "ALWAYS TRUE " if $generator->canonicalize("P0") eq $rl_string; print "ALWAYS TRUE " if $generator->canonicalize("po") eq $rl_string; This is primarily useful if you store the record locator rather than just the original integer and don't want to have to decode your strings to do comparisons. Takes a general Record Locator string and returns one with character mappings listed in "DESCRIPTION" applied to it. This allows string comparisons to work. This returns "undef" if a non-alphanumeric character is found in the string. BUGS AND LIMITATIONS
No bugs have been reported. Please report any bugs or feature requests to "bug-number-recordlocator@rt.cpan.org", or through the web interface at <http://rt.cpan.org>. AUTHOR
Jesse Vincent "<jesse@bestpractical.com>" LICENCE AND COPYRIGHT
Copyright (c) 2006, Best Practical Solutions, LLC. All rights reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic. perl v5.10.0 2009-08-13 Number::RecordLocator(3pm)
All times are GMT -4. The time now is 11:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy