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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Match row sequence and average part of column elements
Thanks PHV that code seem to be working. I have one more question. In my real data, I have time stamps that increment by 0.002 (ie instead of day 1 to 366 incrementing by 1, I have time stamp that goes from 1.002 to 365.998 by step of 0.002. Any tips! Thanks a mill. -
Match row sequence and average part of column elements
Thanks feherke, the second part of the code works great but I have still a problem with my first problem. Sorry I should have put the problem more clearly. Here is a clarification again. My data is a time series and runs day 1 to day 366 say with one data point per day. But for some days, data... -
Match row sequence and average part of column elements
Thanks Feherke My main problem is just spacing the large data that I have collected every 3 minutes 366 days. I made the data increment step every day here to make it simpler. This is example of the input data with the first field being a time stamp 1 0.1 0.2 0.4 2 0.1 0.2 0.4 3 1.0 0.2... -
Match row sequence and average part of column elements
I have a large data that have the following format 1 0.1 0.2 0.4 2 0.1 0.2 0.4 3 1.0 0.2 0.4 10 4.1 0.2 0.4 20 3.1 0.2 0.4 50 2.1 0.2 0.4 31 5.1 0.2 0.4 . . . 366 11.1 0.2 0.4 The first column is a day stamp and i have many columns as a field. The data is not spaced 1 to 366 evenly as you see...
