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