How to export numpy array and generate excel in pandas

This article mainly introduces "how to export numpy array in pandas and generate excel". In daily operation, I believe many people have doubts about how to export numpy array and generate excel in pandas. Xiaobian consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to export numpy array and generate excel in pandas". Next, please follow the editor to study!

Code

#-*-coding: utf-8-*-import numpy as npimport pandas as pd# prepare for datadata = np.arange (1101). Reshape ((10Magazine 10)) data_df = pd.DataFrame (data) # change the index and column namedata_df.columns = ['Alaeagnus pedagogica' Bai Zi'C', 'Dai','FZ','G','] data_df.index = ['a', # create and writer pd.DataFrame to excelwriter = pd.ExcelWriter ('Save_Excel.xlsx') data_df.to_excel (writer,'page_1',float_format='%.5f') # float_format control precision writer.save ()

How to move one row to the first in pandas?

Create a new dataframe object use .reindex ([...]) Attribute/method at this point, on "how to export the numpy array in pandas and generate excel," the study is over, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!