Hi,
I have 20 files which have respective 50 lines with different values.
I would like to process each line of the 50 lines in these 20 files one at a time and do an average of 3rd field ($3) of these 20 files. This will be output to an output file.
Instead of using join to generate whole... (8 Replies)
Hey all,
I ran some simulations, of which the output is 100s of files. I've used grep to extract the vital information needed from the files. This has made my task somewhat easier. But I still need to perform some mathematical calculations (average and geometrical average) on the results of the... (9 Replies)
Hi,
I have a space delimited text file that looks like the following:
Aa 100 200
Bb 300 100
Cc X 500
Dd 600 X
Basically, I want to take the average of columns 2 and 3 and print it in column 4. However if there is an X in either column 2 or 3, I want to print the non-X value. Therefore... (11 Replies)
Hi,
I would like to calculate the average of column 'y' based on the value of column 'pos'.
For example, here is file1
id pos y c
11 1 220 aa
11 4333 207 f
11 5333 112 ee
11 11116 305 e
11 11117 310 r
11 22228 781 gg
11 ... (2 Replies)
Hi,
I have 3 to 4 different files, from that i need to take a Average of numbers from a particular column. here i have to take 4th column,
that should present in diff. file.
File 1:
Col1 col2 col3 col4
1 11 sa 12.00
2 22 sb 134.59
3 33 sc 11.99
4 44 sd 12.44
Col1 col2 col3... (8 Replies)
Hi all,
I think so I’m getting the result is wrong, while using following awk commend,
colval=$(awk 'FNR>1 && NR==FNR{a=$4;next;} FNR>1 {a+=$4; print $2"\t"a/3}'
filename_f.tsv filename_f2.tsv filename_f3.tsv)
echo $colval >> Result.tsv
it’s doing the condition 2 times, first result... (5 Replies)
Hi All,
I have two files in the following format, with numbers being defined under columns(described by a set of headers) and rows(again defined by a set of identifiers)
2013 2013
Make200 Make201
Merc BMW
Jpur Del
... (9 Replies)
Hi,
My input file
Gene1 1
Gene1 2
Gene1 3
Gene1 0
Gene2 0
Gene2 0
Gene2 4
Gene2 8
Gene3 9
Gene3 9
Gene4 0
Condition:
If the first column matches, then look in the second column. If there is a value of zero in the second column, then don't consider that record while averaging.
... (5 Replies)
Hello All,
What is load average and how is it computed in Solaris 10?
What are the different ranges for normal, warning and danger signs?
Kindly clarify.
Thank you,
Sunil Kumar (3 Replies)
Hello Members,
Need your expert opinion how to tackle below.
I have an input file that looks like below:
USS|AWCC|AFGAW|93|70
USSAA|Roshan TDCA|AFGTD|93|72,79
ALB|Vodafone|ALBVF|355|69
ALGEE|Wataniya (Nedjma)|DZAWT|213|50,550
I like output file in below format:
... (7 Replies)
Discussion started by: umarsatti
7 Replies
LEARN ABOUT DEBIAN
plotit
plotit(1) General Commands Manual plotit(1)NAME
plotit - experiment data visualization
SYNOPSIS
plotit -w FILE
plotit [-lp] -q FILE [FILE]...
plotit [-lp] Y FILE [FILE...]
plotit [-lp] X Y FILE [FILE...]
DESCRIPTION
The plotit program is a simple plotting program which can draw line plots and stripcharts using a command language similar to that of gnu-
plot. It can also make quick plots of multiple data files from the command-line. Wildcards may be used in the file names.
The program takes optional expressions which can be used to manipulate data columns before plotting. Expressions may be as simple as the
designation of a column to be plotted or may contain arithmetic expressions and functions. In the latter case the espression must be
enclosed in 'single' or "double" quotation marks. Column numbers are designated by the at-sign character (@). A single expression is used
for the Y axis of the plot.
OPTIONS -h, --help
Print the usage and exit.
--version
Print the version number and exit.
-w Watch the input file for commands to stripchart, or wait to read all of stdin before plotting. Only one file or - for stdin may be
specified with this option. No other options may be used in conjuction with this option.
-q Plot the first and second columns of each file.
-l Plot with lines.
-p Plot with points.
EXAMPLES
Plot the second column versus the first of all three files with lines only.
plotit -lq file1.dat file2.dat file3.dat
Plot the quotient of the third column and the second column versus the first column of all files matching the pattern using points only.
plotit -p '@3/@2' file??.dat
Plot the natural log of the second column divided by the third column versus the fourth column. By default these data are plotted with
both lines and points.
plotit @4 'log(@2/@3)' file.dat
AUTHOR
This manual page was written by Carlo Segre <segre@iit.edu>.
February 21, 2009 plotit(1)