Calculating Daily Average From Irregular Time Series Using Pandas

I am trying to obtain daily averages from an irregular time series from a csv-file. The data in the csv-file start at 13:00 on 20 September 2013 and run till 10:57 on 14 January 20

Solution 1:

You want dayfirst=True, one of the many tweaks listed in the read_csv docs.