pandas中to

pandas中调用to_excel方法把数据保存到Excel中，并且保存多个不同的sheet中。

import pandas as pd
import numpy as np


def run():
    # 构造Dataframe数据
    dict_obj = {'key1': ['a', 'b', 'a', 'b',
                         'a', 'b', 'a', 'a'],
                'key2': ['one', 'one', 'two', 'three',
                         'two', 'two', 'one', 'three'],
                'data1': np.random.randint(1, 10, 8),
                'data2': np.random.randint(1, 10, 8)}
    df_obj1 = pd.Dataframe(dict_obj)
    df_obj2 = df_obj1.copy()
    df_obj2['key3'] = 'shanghai'

    # 把数据保存到Excel中
    res_file = './123.xlsx'
    writer = pd.ExcelWriter(res_file)
    df_obj1.to_excel(writer, index=False, sheet_name='参数信息1')
    df_obj2.to_excel(writer, index=False, sheet_name='参数信息2')
    writer.save()


if __name__ == '__main__':
    run()