Export numpy array to excel in Python

It is always easy to manipulate data on numpy array rather than dataframe. If the data you generated in array has to be exported to excel??? How to do this?

7.png

Fig1: Array of data

Python offers lot of excel libraries, but xlxswriter is good among them

Step 1)

Import xlsxwriter, Create new workbook, in this case my workbook name is “Expenses01”.

Initiate row and column

Worksheet.write function, writes or copying data cell by cell, column by column and then row by row

5.png

Check your directory for the new excel file, open it and check whether its copied or not.

6

Advertisements

About YANAMALA VIJAY RAJ

Mtech in Clinical Eng Jointly offered by Indian institute of technology Madras& Christian medical college Vellore& Sree chitra tirunal institute for medical sciences and technology Trivandrum.
This entry was posted in Programming, Uncategorized and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s