利用pandas将numpy数组导出生成excel的实例
程序员文章站
2023-11-26 15:41:28
上图
代码
# -*- coding: utf-8 -*-
"""
created on sun jun 18 20:57:34 2017
@au...
上图
代码
# -*- coding: utf-8 -*- """ created on sun jun 18 20:57:34 2017 @author: bruce lau """ import numpy as np import pandas as pd # prepare for data data = np.arange(1,101).reshape((10,10)) data_df = pd.dataframe(data) # change the index and column name 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'] # create and writer pd.dataframe to excel writer = pd.excelwriter('save_excel.xlsx') data_df.to_excel(writer,'page_1',float_format='%.5f') # float_format 控制精度 writer.save()
how to move one row to the first in pandas?
create a new dataframe object use .reindex([...]) attribute/method
以上这篇利用pandas将numpy数组导出生成excel的实例就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持。
上一篇: vue中slot(插槽)的介绍与使用