0

Hello im trying to do a dataframe and get the min values of a column "electric consum"i have a counter for each hour of the day and by groupying into same date i want to get the minimum electric consum hour of each day

datas={'date': date,'year': year, 'season': season, 'day': day, 'month': month, 'hour': hour, 'electric consum':consum}

df = pd.DataFrame(data=datas, index=ind)
mini = datas.groupby(['date'])['electric consum'].min()

with this i get a data frame sorted by day and the minimum consum for each day but i cant see the hour how can i get that

date
2010-05-25    6.321167
2010-05-26    6.518963
2010-05-27    6.423513
Rancid
  • 21
  • 1

0 Answers0