I am having rain gauge data of daily time series of 15 minute interval and each sheet contains 30days data. How can i extract data for each day in different variables?
my code:
import pandas as pd
Rgdata = pd.read_excel(filexl,skiprows = 6) #skip first 6 rows
fdata = Rgda[rgda['Date'] >0] # It gives index only where date date changes in Data column.please see bellow data format
Date Time Today's Rain Total Rain
01/11/2014 08:45 0 1425
04:15 5 1430
11:00 0 1430
09:15 0 1430
09:30 0 1430
09:45 10 1440
10:00 0 1440
10:15 0 1440
10:30 0 1440
10:45 0 1440
11:15 0 1440
13:15 0 1440
Aucun commentaire:
Enregistrer un commentaire