Python学习——将numpy数组写入Excel

将numpy数组写入Excel文件

import numpy as np
import pandas as pd

A = np.array([[1, 2], [3, 2], [1, 1], [3, 5], [5,2]])
data = pd.DataFrame(A)

writer = pd.ExcelWriter('A.xlsx')		# 写入Excel文件
data.to_excel(writer, 'page_1', float_format='%.5f')		# ‘page_1’是写入excel的sheet名
writer.save()

writer.close()

运行后的结果为：

其中，to_excel()的参数主要有：

to_excel(self, excel_writer, sheet_name='Sheet1', na_rep='', float_format=None,columns=None, 
header=True, index=True, index_label=None,startrow=0, startcol=0, engine=None, 
merge_cells=True, encoding=None,inf_rep='inf', verbose=True, freeze_panes=None)

各参数的类型：

Inferred type: (self: DataFrame, excel_writer: {write_cells}, sheet_name: str, na_rep: str, float_format: Any, columns: Any, 
header: bool, index: bool, index_label: Any, startrow: int, startcol: int, engine: Any, merge_cells: bool, encoding: Any, 
inf_rep: str, verbose: bool, freeze_panes: Any) -> None