05-29-2011
Hi Mirni,
Thanks for the response.
Probably I was not very clear with my question.
I have 3 input files each with 339962 entries and I need to get top 10% counts from these 3 files.
For instance row 1 ,3,5 from file 1 are in top10% from file1 then those need to be picked for file2 and file3 irrespective of they being in the top 10% or not.
For file 2 suppose row 2,3,4 are in top 10% then they need to be picked for file 1 and file 3
For file 3 row 3,4,5 are in top 10% they need to be picked from file1 and file 2
So now the output file should have rows 1,2,3,4,5 from all the three files.
Also as I mentioned I need the rest 90% should be saved to a different file.
So I should have 2 outputs one with top10% counts from 3 files and rest 90% in other .
Thanks in advance,
Diya
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I've been working with an awk script and I'm wondeing id it's possible to count records in a file which DO NOT contain, in this instance fields 12 and 13.
With the one script I am wanting to display the count for the records WITH fields 12 and 13 and a seperate count of records WITHOUT fields... (2 Replies)
Discussion started by: Glyn_Mo
2 Replies
2. Shell Programming and Scripting
I need "awk solution" for simple counting!
File looks like:
STUDENT GRADE
student1 A
student2 A
student3 B
student4 A
student5 B
Desired Output:
GRADE No.of Students
A 3
B 2
Thanks for awking! (4 Replies)
Discussion started by: saint2006
4 Replies
3. Shell Programming and Scripting
Hi, I am having the following number in the file tmp
31013.004
20675.336
43318.190
30512.926
48992.559
277893.111
41831.330
8749.113
415980.576
28273.054
I want to add these numbers, I am using following script
awk 'END{print s}{s += $1}' tmp
its giving answer 947239 which is correct,... (3 Replies)
Discussion started by: chaitubek
3 Replies
4. Shell Programming and Scripting
Can awk count numbers until it reaches the end of the sequence after the slash?
input:
serv1a, 32, 41/47, 53, 89/100, 108/11, 113.
serv1b, 1/2, 114/18, 121/35, 139/40, 143/55, 159/64,
serv2, 255/56, 274/77, 763, 774/75, 777, 1434/35, 1444/50, 1715, 2025/31, 2048.
serv10b, 804, 808, 929/32,... (9 Replies)
Discussion started by: sdf
9 Replies
5. Shell Programming and Scripting
I have a list of URLs and I want to be able to count the number of instances of addresses ending in a certain TLD and output and sort it like so.
5 bdcc.com
48 zrtzr.com
49 rvo.com
Input is as so
ync.org
sduzj.edu
sduzj.edu
sduzj.edu
sduzj.edu
sduzj.edu
sduzj.edu
sduzj.edu... (1 Reply)
Discussion started by: Pjstaab
1 Replies
6. Shell Programming and Scripting
ok, so a user can specify options as is shown below:
ExA:
cpu.pl!23!25!-allow
or
ExB:
cpu.pl!23!25!-block!all
options are delimited by the exclamation mark.
now, in example A, there are 4 options provided by the user.
in example B, there are 5 options provided by the user.
... (3 Replies)
Discussion started by: SkySmart
3 Replies
7. Shell Programming and Scripting
Probably a simple to this, but unsure how to do it. I would prefer an AWK solution. Below is the data set.
1 2 3
2 5 7
4 6 9
1 5 4
8 5 7
1 1 10
15 3 12
3 7 9
9 8 10
4 5 2
9 1 10
4 7 9
7 12 6
9 13 8
For the second... (11 Replies)
Discussion started by: mollydog11
11 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have two text files (1.txt and 2.txt).
2.txt contains two columns which are extracted from 1.txt using a simple if(condition) print.
I want to:
- count how many times the values contained in 2.txt appear in 1.txt
-if they appear just one time, I have to delete the entire row in... (5 Replies)
Discussion started by: Pintug
5 Replies
9. Shell Programming and Scripting
I want to count lines of a file using AWK (only) and not in the END part like this awk 'END{print FNR}' because I want to use it.
Does anyone know of a way?
Thanks a lot. (7 Replies)
Discussion started by: guitarist684
7 Replies
10. UNIX for Dummies Questions & Answers
Hi!!
I am trying to write a program which allows me to count how many times I used the same word in a text:
{$0 = tolower ($0)
gsub (/_]/, "", $0)
for (i = 1; i <= NF; i++)
freq++
}
END {
for (word in freq)
printf "%s\t%d\n", word, freq
It seems work but... (3 Replies)
Discussion started by: ettore8888
3 Replies
MERGE(1) General Commands Manual MERGE(1)
NAME
merge - three-way file merge
SYNOPSIS
merge [ options ] file1 file2 file3
DESCRIPTION
merge incorporates all changes that lead from file2 to file3 into file1. The result ordinarily goes into file1. merge is useful for com-
bining separate changes to an original. Suppose file2 is the original, and both file1 and file3 are modifications of file2. Then merge
combines both changes.
A conflict occurs if both file1 and file3 have changes in a common segment of lines. If a conflict is found, merge normally outputs a
warning and brackets the conflict with <<<<<<< and >>>>>>> lines. A typical conflict will look like this:
<<<<<<< file A
lines in file A
=======
lines in file B
>>>>>>> file B
If there are conflicts, the user should edit the result and delete one of the alternatives.
OPTIONS
-A Output conflicts using the -A style of diff3(1), if supported by diff3. This merges all changes leading from file2 to file3 into
file1, and generates the most verbose output.
-E, -e These options specify conflict styles that generate less information than -A. See diff3(1) for details. The default is -E. With
-e, merge does not warn about conflicts.
-L label
This option may be given up to three times, and specifies labels to be used in place of the corresponding file names in conflict
reports. That is, merge -L x -L y -L z a b c generates output that looks like it came from files x, y and z instead of from files
a, b and c.
-p Send results to standard output instead of overwriting file1.
-q Quiet; do not warn about conflicts.
-V Print RCS's version number.
DIAGNOSTICS
Exit status is 0 for no conflicts, 1 for some conflicts, 2 for trouble.
IDENTIFICATION
Author: Walter F. Tichy.
Manual Page Revision: 5.8.1; Release Date: 2012-06-06.
Copyright (C) 2010-2012 Thien-Thi Nguyen.
Copyright (C) 1990, 1991, 1992, 1993, 1994, 1995 Paul Eggert.
Copyright (C) 1982, 1988, 1989 Walter F. Tichy.
SEE ALSO
diff3(1), diff(1), rcsmerge(1), co(1).
BUGS
It normally does not make sense to merge binary files as if they were text, but merge tries to do it anyway.
GNU RCS 5.8.1 2012-06-06 MERGE(1)