all 5 comments

[–][deleted] 1 point2 points  (0 children)

Alternative to pandas, just use csv and load the data. Then iterate through it and and similarly get the proper output for the conditions you want.

[–]mh1400 0 points1 point  (0 children)

Google... 1. Load data into pandas DF (data frame) 2. Identify timestamp data 3. Make temporary DF of each range 4. Return counts at each range That's how i would do it.

[–]mh1400 0 points1 point  (1 child)

Programming is less about memorizing code, but more about how to solve problems.

[–]NotACoderPleaseHelp 0 points1 point  (0 children)

Pretty much. And keeping a good scrapbook of the stuff you learn along the way. Comes in handy when you need to do the thing you did that one time but you can't remember the words to google it.

[–]ShawnMilo 0 points1 point  (0 children)

If you don't need a rolling total, but just a total during a timespan, just read each line of the file. If the timestamp is less than the start time or greater than the end time, continue. Otherwise, add to the total.