Hi,
I have a file with 3 columns in it that are comma separated and it has about 5000 lines. What I want to do is find the most common value in column 3 using awk or a shell script or whatever works! I'm totally stuck on how to do this.
e.g.
value1,value2,bob
value1,value2,bob... (12 Replies)
Hello,
I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2
SDF4 -0.211654
SDF4 0.978068
... (1 Reply)
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (1 Reply)
Hi friends,
My file is like:
Second file is :
I need to print the rows present in file one, but in order present in second file....I used
while read gh;do
awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile
done < secondfile
but the output I am... (14 Replies)
Hi all, looking for some help here. I'm what you'd call a dirty programmer. my shell scripts might be ugly, but they (usually) function...
Say I have a single column text file with a list of dates (yyyymmdd) that represent the elevation of a point on that date (I work with land subsidence, so... (2 Replies)
Hi All ,
I am having an input file as stated below
Input file
6 ddk/djhdj/djhdj/Q 10 0.5
dhd/jdjd.djd.nd/QB 01 0.5
hdhd/jd/jd/jdj/Q 10 0.5
512 hd/hdh/gdh/Q 01 0.5
jdjd/jd/ud/j/QB 10 0.5
HD/jsj/djd/Q 01 0.5
71 hdh/jjd/dj/jd/Q 10 0.5
... (5 Replies)
Discussion started by: kshitij
5 Replies
LEARN ABOUT CENTOS
spline
spline(1) User Commands spline(1)NAME
spline - interpolate smooth curve
SYNOPSIS
spline [-aknpx] ...
DESCRIPTION
spline takes pairs of numbers from the standard input as abcissas and ordinates of a function. It produces a similar set, which is approxi-
mately equally spaced and includes the input set, on the standard output. The cubic spline output (R. W. Hamming, Numerical Methods for
Scientists and Engineers,2nd ed., 349ff) has two continuous derivatives, and sufficiently many points to look smooth when plotted, for
example by graph(1).
OPTIONS -a Supply abscissas automatically (they are missing from the input); spacing is given by the next argument, or is assumed to be 1 if
next argument is not a number.
-k The constant k used in the boundary value computation
(2nd deriv. at end) = k*(2nd deriv. next to end)
is set by the next argument. By default k = 0.
-n Space output points so that approximately n intervals occur between the lower and upper x limits. (Default n = 100.)
-p Make output periodic, that is, match derivatives at ends. First and last input values should normally agree.
-x Next 1 (or 2) arguments are lower (and upper) x limits. Normally these limits are calculated from the data. Automatic abcissas
start at lower limit (default 0).
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWesu |
+-----------------------------+-----------------------------+
SEE ALSO graph(1), attributes(5)
R. W. Hamming, Numerical Methods for Scientists and Engineers, 2nd ed.
DIAGNOSTICS
When data is not strictly monotonic in x, spline reproduces the input without interpolating extra points.
BUGS
A limit of 1000 input points is enforced silently.
SunOS 5.10 14 Sep 1992 spline(1)