|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
python写的
- def gen_data(da):
- nianji=[]
- banji=[]
- jiaoshi=[]
- nianji=list(str(da['年级'])*da['班级数'])
- banji=[str(i) for i in range(da['班级数']+1)[1:]]
- jiaoshi=[str(da['楼层'])+'0'+str(i) for i in range(da['班级数']+1)[1:]]
- temp_df=pd.DataFrame({'年级':nianji,'班级':banji,'教室':jiaoshi})
- return temp_df
- df1=pd.DataFrame([],columns=['年级','班级','教室'])
- for i in df.index:
- da=(df.iloc[i]).to_dict()
- temp_da=gen_data(da)
- df1=df1.append(temp_da,ignore_index=True)
复制代码 |
|