I have several sequential files with name stat.1000, stat.1001....to stat.1020 with a format like this
I know I can find the average of the 9th column by using
But I would like to find the average of the 9th column in each file and put them in a new file (in that order). Can someone pls help with this problem?
Last edited by Scrutinizer; 09-21-2012 at 11:28 AM..
Reason: code tags instead of quote tags
Hi,
I got a lot of files looking like this:
1
0.5
6
All together there are ard 1'000'000 lines in each of the ard 100 files.
I want to build the average for every line, and write the result to a new file.
The averaging should start at a specific line, here for example at line... (10 Replies)
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)
Hi,
first, I have searched in the forum for this, but I could not find the right answer. (There were some similar threads, but I was not sure how to adapt the ideas.)
Anyway, I have a quite natural problem: Given are several text files. All files contain the same number of lines and the same... (3 Replies)
Hello there,
I found an elegant solution to computing average values from multiple text files
awk '{for (i=1;i<=NF;i++){if ($i!~"n/a"){a+=$i}else{b++}}}END{for (i=1;i<=FNR;i++){for (j=1;j<=NF;j++){printf (a/(3-b))((b>0)?"~"b" ":" ")};printf "\n"}}' file1 file2 file3
I tried to modify... (2 Replies)
I have roughly ~30 .txt files in a directory which all have unique names. These files all contain text arranged in columns separated by whitespace (example file:
[#YY MM DD hh mm WDIR WSPD GST WVHT DPD APD MWD PRES ATMP WTMP DEWP VIS TIDE
#yr mo dy hr mn degT m/s m/s m sec ... (5 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,
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)
I have the following format of input from multiple files
File 1
24.01 -81.01 1.0
24.02 -81.02 5.0
24.03 -81.03 0.0
File 2
24.01 -81.01 2.0
24.02 -81.02 -5.0
24.03 -81.03 10.0
I need to scan through the files and when the first 2 columns match I... (18 Replies)
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
LEARN ABOUT HPUX
cpio
cpio(4) Kernel Interfaces Manual cpio(4)NAME
cpio - format of cpio archive
DESCRIPTION
The header structure, when the option of is not used (see cpio(1)), is:
When the option is used, the header information is described by:
Longtime and Longfile are equivalent to and respectively. The contents of each file are recorded together with other items describing the
file. Every instance of contains the constant 070707 (octal). The items through have meanings explained in stat(2). The length of the
null-terminated path name including the null byte, is given by
The last record of the archive always contains the name Directories and the trailer are recorded with equal to zero.
It will not always be the case that and correspond to the results of but the values are always sufficient to tell whether two files in the
archive are linked to each other.
When a device special file is archived by HP-UX (using the option), contains a magic constant which is dependent upon the implementation
doing the writing. flags the device file as an HP-UX 32-bit device specifier, and contains the 32-bit device specifier (see stat(2)). If
the option is not present, special files are not archived or restored. Non-HPUX device special files are never restored.
SEE ALSO cpio(1), find(1), stat(2).
STANDARDS CONFORMANCE cpio(4)