1、多索引数据 删除某一索引
fund = get_factor(stocks, factor=['basic_earnings_per_share'], start_date='20170103', end_date='20170103')
fund.head()
原始数据
删除date index
fund = fund.reset_index(1, drop=True)
fund.head()
2、多索引数据 交换索引
fund = get_factor(stocks, factor=['basic_earnings_per_share'], start_date='20170103', end_date='20170103')
fund.head()
索引date与order_book_id 交换
fund.index = fund.index.swaplevel(0, 1)
fund.head()
3、多索引 行数据转换列
fund = get_factor(stocks, factor=['basic_earnings_per_share'], start_date='20170103', end_date='20170103')
fund.head()
order_book_id内容成为列
fund.index = fund.index.swaplevel(0, 1)
fund = fund.unstack(level=1) # 索引转换成列
# 丢弃basic_earnings_per_share列
fund.columns = fund.columns.droplevel()
# 修改名字
fund.index.set_names(['date'], inplace=True)
# 修改列的说明
fund.columns.set_names([''], inplace=True)
fund.head()
