- import pandas as pd
- #长度
- yearlen = 3
- codelen = 3
- #年份
- year = [2010, 2011, 2012]*codelen
- #代码
- code = sorted(list(range(1,codelen+1))*yearlen)
- sheet2 = pd.DataFrame({'年份':year, '代码':code})
- data = [[2010,1,500],
- [2011,1,300],
- [2012,1,600],
- [2011,2,800],
- [2011,3,152],
- [2012,3,186]]
- sheet1 = pd.DataFrame(data, columns=['年份', '代码', '现金流量'])
- sheet = pd.merge(sheet1, sheet2, how='right', on=['年份', '代码'])
- sheet = sheet.fillna(0)
- sheet = sheet.sort_values(by=['年份', '代码'])
- sheet.index = range(len(sheet))