Hi everyone,
I'm just wondering how could I using awk language merge two files by comparison of one their row.
I mean, I have one file like this:
file#1:
21/07/2009 11:45:00 100.0000000 27.2727280
21/07/2009 11:50:00 75.9856644 25.2492676
21/07/2009 11:55:00 51.9713287 23.2258072... (4 Replies)
Hi,
How to enumerate duplicate values, without sorting the file.
example
1 1
2 1
3 1
1 2
2 2
3 2
1 3
2 3
3 3
Where the first column have the repetead values without sorting,
I would like to get the value of the times that the value is repetead , as I show... (2 Replies)
I have two questions that are related, so it would be great if you can help me with both!
Question1:
I have a file A that looks like this:
a x
b y
b z
c w
I want to get something like:
a x
b y; z
c w
Given that a,b,c has no spaces. But the other letters might contain spaces.
... (2 Replies)
My input file is:
LOC_Os01g01870 GO:0006139
LOC_Os01g01870 GO:0009058
LOC_Os01g02570 GO:0006464
LOC_Os01g02570 GO:0009987
LOC_Os01g02570 GO:0008152
LOC_Os01g04380 GO:0006950
LOC_Os01g04380 GO:0009628
I want to append the duplicate values in a tab/space... (2 Replies)
Hi Gents,
Please can you help me to get the desired output .
In the first column I have some duplicate records, The condition is that all need to reject the duplicate record keeping the last occurrence. But the condition is. If the last occurrence is equal to value 14 or 98 in column 3 and... (2 Replies)
Dear folks
I have a map file of around 54K lines and some of the values in the second column have the same value and I want to find them and delete all of the same values. I looked over duplicate commands but my case is not to keep one of the duplicate values. I want to remove all of the same... (4 Replies)
Join and merge multiple files with duplicate key and fill void columns
Hi guys,
I have many files that I want to merge:
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv: (5 Replies)
Discussion started by: yjacknewton
5 Replies
LEARN ABOUT PHP
histo
HISTO(1) General Commands Manual HISTO(1)NAME
histo - compute 1-dimensional histogram of N data columns
SYNOPSIS
histo [-c][-p] xmin xmax nbins
histo [-c][-p] imin imax
DESCRIPTION
Histo bins columnular data on the standard input between the given minimum and maximum values. If three command line arguments are given,
the third is taken as the number of data bins between the first two real numbers. If only two arguments are given, they are both assumed
to be integers, and the number of data bins will be equal to their difference plus one. The bins are always of equal size.
The output is N+1 columns of data (for N columns input), where the first column is the centroid of each division, and each row corresponds
to the frequencies for each column around that value.
If the -c option is present, then histo computes the cumulative histogram for each column instead of the straight frequencies. The upper
value of each bin is printed also instead of the centroid. This may be useful in computing percentiles, for example. Values below the
minimum specified are still counted in the cumulative total.
The -p option tells histo to report the percentage of the total number of input lines rather than the absolute counts. In the case of a
cumulative total, this yields the percentile values directly. Values above the maximum are counted as well as values below in this case.
All input data is interpreted as real values, and columns must be white-space separated. If any value is less than the minimum or greater
than the maximum, it will be ignored unless the -c option is specified.
EXAMPLE
To count data values between -1 and 1 in 50 bins:
histo -1 1 50 < input.dat
To count frequencies of integers between 0 and 255:
histo 0 255 < input.dat
AUTHOR
Greg Ward
SEE ALSO cnt(1), neaten(1), rcalc(1), rlam(1), tabfunc(1), total(1)RADIANCE 9/6/96 HISTO(1)