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

将numpy数组写入Excel文件import numpy as npimport pandas as pdA = 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(wri...

文章共411字 · 阅读需要大约2分钟

一键AI生成摘要，助你高效阅读

问答

卖萌的大米

79112人浏览 · 2019-02-21 19:42:42

卖萌的大米 · 2019-02-21 19:42:42 发布

将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()

运行后的结果为：
写入excel文件
其中，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