pandas实现将矩阵导出到excel+对矩阵进行连接，参考博客<猿创征文｜pandas实现将矩阵导出到excel+对矩阵进行>

import pandas as pd # 先将Excel中原有的数据读取出来 original_data = pd.read_excel('excel追加.xlsx') city, year = [], [] for i in original_data.values: city.append(i[0]) year.append(i[1]) city += ['北京', '上海', '广州', '深圳'] year += ['a', 'b', 'c', 'd'] data2 = {'city': city, '2018': year} data2 = pd.DataFrame(data2) # 将新数据与旧数据合并起来 data2.to_excel('excel追加3.xlsx', index=False)