Issue
I have a csv file with measurements, and I want to create a new csv file with the hourly averages and standard deviations. But only for certain columns.
Example:
csv1:
YY-MO-DD HH-MI-SS_SSS | Acceleration | Lumx | Pressure
2015-12-07 20:51:06:608 | 22.7 | 32.3 | 10
2015-12-07 20:51:07:609 | 22.5 | 47.7 | 15
to csv 2 (only for the pressure and acceleration:
YY-MO-DD HH-MI-SS_SSS | Acceleration avg | Pressure avg
2015-12-07 20:00:00:000 | 22.6 | 12.5
2015-12-07 21:00:00:000 | .... | ....
Now I have an idea (thanks to the people on this site) on how to calculate the averages - but i'm having trouble on creating a new smaller dataframe that contains the calculations for a few columns.
Thanks !!!
Solution
You can make a smaller DataFrame like below:
csv2 = csv1[['Acceleration', 'Pressure']].copy()
Then you can handle csv2
, which only has the columns you want. (You said you have an idea about avg calculation.)
FYI, .copy()
could be omitted if you are sure about view versus copy.
Answered By - su79eu7k
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.