jeudi 21 juillet 2016

Extract date from excel

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

Screenshot of the table

Aucun commentaire:

Enregistrer un commentaire