10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I want to compute for the average of a file with null values (NaN) for each row. any help on how to do it. the sample file looks like this.
1.4 1.2 1.5 NaN 1.6
1.3 1.1 NaN 1.3 NaN
2.4 1.3 1.5 NaN 1.5
NaN 1.2 NaN 1.4 NaN
I need to do a row-wise averaging such that it will sum only... (14 Replies)
Discussion started by: ida1215
14 Replies
2. Shell Programming and Scripting
Hello all, I need to compute a row-wise average of files with a single column based on the pattern of the filenames. I really appreciate any help on this. it would just be very difficult to do them manually as the rows are mounting to 100,000 lines. the filenames are as below with convention as... (2 Replies)
Discussion started by: ida1215
2 Replies
3. Shell Programming and Scripting
Hi all,
I have a data file like below, where Time is in the second column
DATE TIME FRAC_DAYS_SINCE_JAN1
2011-06-25 08:03:20.000 175.33564815
2011-06-25 08:03:25.000 175.33570602... (10 Replies)
Discussion started by: gd9629
10 Replies
4. Shell Programming and Scripting
Hello
I have file that consist of 2 columns of millions of entries
timestamp and throughput
I want to find the average (throughput ) for each equal timestamp before change it to proper format
e.g : i want to average 2 coloumnd fot all 1308154800 values in column 1
and then
print... (4 Replies)
Discussion started by: aadel
4 Replies
5. Shell Programming and Scripting
Hey all,
I have a set of 5-second data as shown below. I need to find an hourly average of this data.
date co2
25/06/2011 08:04:00 8.30
25/06/2011 08:04:05 8.31
25/06/2011 08:04:10 8.32
25/06/2011 08:04:15 8.33
25/06/2011 08:04:20 ... (5 Replies)
Discussion started by: gd9629
5 Replies
6. Shell Programming and Scripting
A happy Monday to you all,
I have a .csv file which contains data taken every 5 seconds. I want to average these 5 second data points into 30 minute averages!
date co2
25/06/2011 08:04 8.31
25/06/2011 08:04 8.32
25/06/2011 08:04 8.33... (18 Replies)
Discussion started by: gd9629
18 Replies
7. Shell Programming and Scripting
Hi, I only have a very limited understanding and experience with writing code and I was hoping I could get some help.
I have a dataset of two columns (txt format, numbers in each row separated by a tab)
Eg.
1 5
2 5
3 6
4 7
5 6
6 6
7 ... (5 Replies)
Discussion started by: Emred_Skye
5 Replies
8. UNIX for Dummies Questions & Answers
Dear all,
I have the data in the following format. I want to do average of each NR= 5 (rows) for all the 3 ($1,$2, $3) columns and want to print average result in another file in the same format. I dont know how to write code for this in 'awk', can some one help me to write a code for this in... (1 Reply)
Discussion started by: arvindr
1 Replies
9. Shell Programming and Scripting
Hello. Im just starting to learn awk so hang in there with me...I have a large text file formatted as such everything is in a single column
ID001
value 1
value 2
value....n
ID002
value 1
value 2
value... n
I want to be able to calculate the average for values for each ID from the... (18 Replies)
Discussion started by: johnmillsbro
18 Replies
10. Shell Programming and Scripting
Hello,
I have three columns of data of the format below:
<name> <volume> <size>
a 2 1.2
a 2 1.1
b 3 1.7
c 0.7 1.9
c 0.7 1.9
c 0.7 1.8
What I... (3 Replies)
Discussion started by: itisthus
3 Replies