pandas将excel数据写入

以Excel表的一数列数为条件，将这数列的数据复制到另外一个竖列，复制后的数据每行数据不变，复制过后的原竖列数据换成-符号然后生成excel文件

需求有些奇怪，大概就是这样吧

img

import pandas as pd
data_lst = [ ['张三',21,89,'一']
             ,['李四',25,69,'一']
            ,['王五',22,82,'二']]
df1 = pd.DataFrame(data_lst)
df1.columns = ['姓名','年龄','成绩','年级']
print(df1)
df2 = df1.copy()
df2['年龄'] = df2['成绩']
df2['成绩'] = '-'
print(df2)
# df1.append(df2.copy(),ignore_index=True)
df3 = pd.concat([df1, df2],ignore_index=True)
print(df3)
df3.to_excel("data.xlsx",index=False)

这个意思?

df['fld_new']= df['fld_old']
df['fld_old'] = '-'
df.to_excel("data.xlsx")

img