Five questions on transform against agg, what resample does to a day with no rows in it, which direction tz_localize converts, and which chart answers which question. The groupby question is the one worth running rather than reasoning about.