import pandas as pddf = pd.DataFrame({"学院":["电子学院","机电学院","大数据学院","软件学院","网络学院"],"2017年":[1320,1351,2251,3178,2151],"2018年":[1323,1402,2202,3180,2190],"2019年":[1466,1322,2222,3162,2122],"2020年":[1486,1388,2248,3218,3108]
})#index=False表示不写入索引
df.to_csv("学院.csv",index=False)

效果图如下所示：