Hello all,
I have a huge csv file with a few hundred thousand rows. I would like to perform statistical calculations on it and also obtain the first row value, for each time interval.
Example for every 300seconds, I would like to calculate the variance of the total number of rows within the 1st 300seconds, 2nd 300 seconds, 3rd 300 seconds and so on.... So the total number of rows would vary with each 300 seconds interval.
I would also like to get the value of a specific column in the First Row for each 300 second interval.
Example during the 1st 300 seconds, I would like to get the value of the 1st row during the time interval, for the next 300seconds I would like to get the value of the 1st row in the time interval again.
I have a time column T, which is all in seconds, so maybe I could calculate for every T=T+300?
Any suggestions on how and steps to do it??
Thanks a million!!!
I have a huge csv file with a few hundred thousand rows. I would like to perform statistical calculations on it and also obtain the first row value, for each time interval.
Example for every 300seconds, I would like to calculate the variance of the total number of rows within the 1st 300seconds, 2nd 300 seconds, 3rd 300 seconds and so on.... So the total number of rows would vary with each 300 seconds interval.
I would also like to get the value of a specific column in the First Row for each 300 second interval.
Example during the 1st 300 seconds, I would like to get the value of the 1st row during the time interval, for the next 300seconds I would like to get the value of the 1st row in the time interval again.
I have a time column T, which is all in seconds, so maybe I could calculate for every T=T+300?
Any suggestions on how and steps to do it??
Thanks a million!!!