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')新聞熱點
疑難解答
