2017/02/07 - Extract attributes from index

Step1: Group by [ ‘Number’, ‘Date’]

select = ['Number','Date','Fare']
pd.read_excel('data.xlsx'[select].groupby(['Number','Date']).sum()

Step2: Convert ‘Group by’ into ‘DataFrame’ dataset

# Extract Number, Date, Farel = []for i in Insurance.index:    l.append(i)InsuranceT = pd.DataFrame(l)InsuranceT['Fare'] = Insurance.valuesInsuranceT.columns = ['Number', 'Date', 'Fare']# Date --> datetime formatfor i in xrange(len(InsuranceT)):    temp = str(InsuranceT.iloc[i,1])    InsuranceT.iloc[i,1] = datetime.strptime(temp,'%Y%m%d')