Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replicate merging and frequency calculation
Top Forums Shell Programming and Scripting Replicate merging and frequency calculation Post 302889642 by Akshay Hegde on Saturday 22nd of February 2014 02:39:30 PM
Old 02-22-2014
Code:
$ cat file
ID String
EN03 typehellobyedogcatcatdog
EN09 typehellobye
EN08 dogcatcatdog
EN09 catcattypehello
EN10 typehellobyedogcatcatdog
EN10 typehellobyedogcatcatdogdog

Code:
awk '
        NR==1{
		print "ID", "dog_frequency", "ID_frequency"
		next
	     }
      FNR==NR{
		A[$1]++
		B[$1]+=gsub(/dog/,x,$2)
		next
	     } 
    ($1 in A){ 
		print $1,B[$1],A[$1]
		delete A[$1]
		delete B[$1]
	     }
    ' OFS='\t' file{,}

Resulting
Code:
ID	dog_frequency	ID_frequency
EN03	2	1
EN09	0	2
EN08	2	1
EN10	5	2

This User Gave Thanks to Akshay Hegde For This Post:
verse123
 

10 More Discussions You Might Find Interesting

1. Linux

how replicate linux server

hai the point I want one server and additional backup server just like winnt pdc , bdc concept . anybody know any solutions for this. the thing is i don't have that much amount to spend for additional hardwares. Is any software or anything ????? rgds sun (5 Replies)
Discussion started by: sun
5 Replies

2. Shell Programming and Scripting

How to replicate data using Uniq or awk

Hi, I have this scenario; where there are two classes:- apple and orange. 1,2,3,4,5,6,apple 1,1,0,4,2,3,apple 1,3,3,3,3,4,apple 1,1,1,1,1,1,orange 1,2,3,1,1,1,orange Basically for apple, i have 3 entries in the file, and for orange, I have 2 entries. Im trying to edit the file and find... (5 Replies)
Discussion started by: ahjiefreak
5 Replies

3. UNIX for Advanced & Expert Users

Replicate CPU load to other processors in server

Hi Folks, We have 6 processors in our sun server. I do see that CPU usage by one of the processor is always more than 70-80% and for remaining 5 processors, its only 20%. Is there a way to delegate the excess CPU load on one of the processors in server to other processors in same server? Is... (3 Replies)
Discussion started by: vaibhav.kanchan
3 Replies

4. Shell Programming and Scripting

Replicate one directory with another

I have a dir as /library/utility/apache-tomcat/tbase-6001/repositories which has many huge directories and files. I am planning to replicate it to another folder /library/utility/apache-tomcat/tbase2008-6001/repositories Normal copy command is taking a hell lot of time and getting hung in... (1 Reply)
Discussion started by: Tuxidow
1 Replies

5. Shell Programming and Scripting

Replicate history commands in multiple terminal

Hi, I am using putty client to connect to my remote Linux server box, and I am connecting through ssh. That system runs bash shell. So, if I use multiple putty terminal, how can I replicate those commands that I ran in other terminals to be available/shared in the current terminal window (i.e)... (1 Reply)
Discussion started by: royalibrahim
1 Replies

6. Shell Programming and Scripting

replicate lines - awk

Is it possible to replicate the lines based on 4th column of the input like the below ? input ar1 10 100 -1 ar1 20 200 -2 arX 34 140 +1 arY 7 1 +4 output ar1 10 100 - ar1 20 200 - ar1 20 200 - arX 34 140 + arY ... (1 Reply)
Discussion started by: quincyjones
1 Replies

7. Shell Programming and Scripting

Find the replicate record using awk

We usually use the following awk code to delete of find out the replicate record. awk -F, '{a++} END {for (i in a) if (a>=2) print i a}' file My question is how can I print the whole record. The following code doesn't work. awk -F, '{a++} END {for (i in a) if (a>=2) print $0}' file ... (8 Replies)
Discussion started by: xshang
8 Replies

8. Shell Programming and Scripting

Merging strings which have deviation in frequency

Dear all, I need a little help. I am working on a frequency driven database in which the structure is as under: headword=gloss<space>Frequency The data which I am working with has dupes i.e. the Headword is repeated more than once with a different gloss variant on the right hand side and... (8 Replies)
Discussion started by: gimley
8 Replies

9. AIX

AIX install and replicate to 5 server

Hi, I have to install 5 servers with same OS level and same packs, i wonder if there is an way to install 1 and then copy or clone the instalattion to the other 4? any suggetions? Rgs, (1 Reply)
Discussion started by: prpkrk
1 Replies

10. Programming

How to replicate Ruby´s binary file reading with Java?

Hello to all guys, Maybe some expert could help me. I have a working ruby script shown below that reads a big binary file (more than 2GB). The chunks of data I want to analyze is separated by the sequence FF47 withing the binary. So, in the ruby script is defined as "line separator" =... (10 Replies)
Discussion started by: Ophiuchus
10 Replies

LEARN ABOUT CENTOS

git-column

GIT-COLUMN(1)							    Git Manual							     GIT-COLUMN(1)

NAME

       git-column - Display data in columns

SYNOPSIS

       git column [--command=<name>] [--[raw-]mode=<mode>] [--width=<width>]
		    [--indent=<string>] [--nl=<string>] [--padding=<n>]

DESCRIPTION

       This command formats its input into multiple columns.

OPTIONS

       --command=<name>
	   Look up layout mode using configuration variable column.<name> and column.ui.

       --mode=<mode>
	   Specify layout mode. See configuration variable column.ui for option syntax.

       --raw-mode=<n>
	   Same as --mode but take mode encoded as a number. This is mainly used by other commands that have already parsed layout mode.

       --width=<width>
	   Specify the terminal width. By default git column will detect the terminal width, or fall back to 80 if it is unable to do so.

       --indent=<string>
	   String to be printed at the beginning of each line.

       --nl=<N>
	   String to be printed at the end of each line, including newline character.

       --padding=<N>
	   The number of spaces between columns. One space by default.

AUTHOR

       Written by Nguyen Thai Ngoc Duy <pclouds@gmail.com[1]>

GIT

       Part of the git(1) suite

NOTES

	1. pclouds@gmail.com
	   mailto:pclouds@gmail.com

Git 1.8.3.1							    06/10/2014							     GIT-COLUMN(1)
All times are GMT -4. The time now is 12:11 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy