Search Results

Hey Bartus,

for the averaging code you gave me I'm unsure as to what the code actually does, can you just breifly run through what the parts of the script do?



#!/bin/gawk -f

# this...

I have an output like this now


Site: Ridge Hill
yyyy mm dd hh mm ____CO2________SD_______CH4_______SD_______H20_______SD__
2011 06 09 15 38 4.65205e+02 71.0168 2.03040e+00 0.1782...

My love knows no boundaries for you my friend. Just one final quick thing, for file2, the standard deviation code you gave me before, how would I amend it so that all values were to 4 decimal places?

Bartus I do believe you're a magician. If I want to combine two files

File 1

Site: Ridge Hill
yyyy mm dd hh CO2 CH4 H20
2011 06 09 14 5.2977498477e+02...

Hi Roboticus,

I've tried combining the codes you've given me into


function std_dev(data, count) {
sum=0;
for( x=1; x <= count; x++) {
sum += data[x];
}

avg =...

Hi Roboticus,

Thanks for the help. Am I right in thinking this will give me the hourly SD's for column 7? How would I get the hourly SD's of say columns 17 19 and 20 and place them next to each...

Hi all,

I need to find the standard deviation of each column of a dataset below for each hour. The data is given in 5 second intervals as shown below


DATE TIME ...

I apologise if I've been ambiguous, I shall attempt to clarify the task.

I wish the output file to look like this

DATE TIME FRAC_DAYS_SINCE_JAN1 ...

I have written a script in awk that edits the raw data into a format that can be analysed by a pre written program. However with 5 second data, the quantity that is read into the program is huge (and...

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 ...

hey dude2cool, I meant sort it from the earliest date first to the most recent date. There's 10 years worth of data, the years themselves are together but are grouped randomly.

Hi yazu, I tried...

Hi,

I have a large data frame as shown below, where data is separated into years.


10 May 2011 Created: 10 May 11 15:05 GMT Scale: SIO-2005 and others
GC-MD, Cape Grim, Tasmania, Lat.:...

Using the same concept, I need to remove 6 lines of a data frame and those interspersed throughout.


10 May 2011 Created: 10 May 11 15:05 GMT Scale: SIO-2005 and others
GC-MD, Cape Grim,...

Hey Michael,

that code worked! I had to write the input file to a few one i.e.


sed '1!{/DATE/d}' inputfile1.dat > inputfile2.dat



Thanks a lot!

Heya there,

A small selection of my data is shown below.


DATE TIME FRAC_DAYS_SINCE_JAN1
2011-06-25 08:03:20.000 ...

@panyam this is the result the Shell gave me


09/06/2011 20:00:00 0
24/06/2011 13:00:00 0
21/06/2011 18:00:00 0
09/06/2011 21:00:00 0
24/06/2011 14:00:00 0
21/06/2011 19:00:00 0
09/06/2011...

hey,

The averages were printed out to the shell so that's great, is there anyway of replacing the existing data in the csv file so the output looks like


25/06/2011 08:03:20 386.034 ...

hey! This is my output



hour-> 17 average-> 0
hour-> 08 average-> 0
hour-> average-> 0
hour-> 18 average-> 0
hour-> 09 average-> 0
hour-> 19 average-> 0
hour-> 00 average-> 0
hour-> 01...

date,alarm,species,solenoid,mpv,outlet,cavp,cavt,warmbox,etalon,dastemp,co2sync,co2,ch4sync,ch4,h2osync$
25/06/2011 08:03:20...

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 ...

For some odd reason I'm still getting


CO2 CH4
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0


Did you say there was a way to edit the file itself,...

ok no worries, thanks for the help!

Oh my bad. It doesn't do that either, just prints 'CO2 CH4'. Is there anyway to change the file? As that is the hope in averaging to 30 minutes, that the .csv file gets edited.

I exported it to a csv and changed the delimiter, but still didn't change the file at all. Did it work for you?

I've attached just a snippet of the file. Hope it helps.