I need to make a plot that shows the change of value in a specific date.

Question

I have a file (https://drive.google.com/file/d/136yL1tN5gc10IPQLdpIvJumD8wpl707M/view?usp=sharing) from which I have to find the highest number of measurements taken on a day (have to find that day) and generate a plot for it (to show how the value of PSU changed).

My code in full looks like this:

https://code.sololearn.com/cClDh7z7Z9Yl

The problem is that I got the max number, but that value is a sum and I don't know how to got a date out of it to generate a plot.

Answer 1

Try this (you have to add the path to your file in line 12):
https://code.sololearn.com/c9HyHxrtj99r/?ref=app
I'm assuming this is some kind of practice project, because it doesn't really make sense since measurements are taken in multiple locations. If you run the code you'll notice that on the day in question there are over 200 measurements, but they're taken at only three different times.
Two remarks about your code:
1. You're grouping by date and time instead of date.
2. You're making the assumption that the data is sorted by date and time. You should always make sure.