Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mean Value over 10 min and transform time col

Status
Not open for further replies.

lecojon

MIS
Apr 30, 2010
2
DE
Hi, what´s up?

I need a little help, i´m dying with my files, there are over 40 MB and my RAMmemory is too low for this amount of data. I´ve got many files like in the attachment (only as an example)
The first column is "date"...i don´t need that....
What i wanna do is, i would like to transform the time column (2nd col) in seconds and calculate the mean value of the rest of columns over 10 minutes...then write results in new file with "time(scale:10 min in sec), u,v,w,T (mean values)....

I wrote a program that would work, but because of memory size it only reads a part of that big files...so what i must do is, tell the program to read files for 10 min--->calculate---->write in file....now read next 10 min---->calculate--->append in same file... and so on, till eof

Here are two programs,"schreibe 2 files" writes the time with "," seperation, i didn´t know how to do that with ":"

here the files:
can anyone help?

greetings, lecojon

PS: i wrote 2 progs, the first one is to tranform time into seconds....but maybe someone knows how to do that all in one prog?
 
OK, i´ve done it...with this it works....
i build the mean values over same times with this:

if(Timesec(i)==timestart)then
end if
but now i want to build mean value over 10 min...so it should be:
if(Timesec(i)<=timestart+600)then
end if

and nothing happens....

time is in seconds now....
here´s my script:
greetings
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top