37,720
社区成员
发帖
与我相关
我的任务
分享
from pandas import DataFrame,Series,MultiIndex
import pandas as pd
from datetime import date
df=DataFrame([[1.1,2.1,3.1,4.1],
[1.2,2.5,3.3,4.4],
[1.3,2.9,3.5,4.7],
[1.4,3.3,3.7,5.0],
[1.5,3.7,3.9,5.3],
[1.6,4.1,4.1,5.6],
[1.7,4.5,4.3,5.9],
[1.8,4.9,4.5,6.2]],
columns=['A','B','C','D'],
index=[date(2018,1,1),date(2018,1,2),date(2018,1,3),
date(2018,2,1),date(2018,2,15),
date(2018,3,1),date(2018,3,8),date(2018,3,29)])
ix=MultiIndex.from_arrays([[date(i.year,i.month,1) for i in df.index.values],
df.index.values])
df.index=ix
print(df)