使用pandas生成excel表格

• 需要使用的python模块
• 安装模块
  • pip install pandas
  • pip install numpy
  • pip install openpyxl

import pandas as pd
import numpy as np

data = np.arange(1,101).reshape((10,10))
data_df = pd.DataFrame(data)
data_df.columns = ['A','B','C','D','E','F','G','H','I','J']
data_df.index = ['a','b','c','d','e','f','g','h','i','j']

writer = pd.ExcelWriter('my.xlsx')
data_df.to_excel(writer,float_format='%.5f')
writer.save()

my.xlsx 结果如下: