Save Data To Excel File In Python

In this tutorial, we'll learn how to save data from Python pandas into Excel files. Test version of the tutorial: pythoninoffice.com/save-multi...
We often need to present data/results to non-technical people that might not know Python, so Excel is the standard choice for that purpose. We'll cover two different ways to save pandas dataframe into Excel files.

[@pranabmishra2609]

how to save a plot image in the same excel sheet

[@mahdiarepicgame6889]

thanks you saved my life

[@pythoninoffice6568]

Happy to help!

[@zamokuhle1992]

Hi, I have generated a CAPM OLS regression and got my summary results. How can I export the summary statistics to excel as it is

[@pythoninoffice6568]

Hi, It depends what the results look like, sometimes they are stored inside a nicely formatted table (dataframe), sometimes it's just text. Depending on the data type you might want to do things differently... what does the result look like?

[@anshamma.m3692]

How to save console output in text files

[@tigreonice2339]

i want to do something like this. the data was taken with webscrapping, so i have 3 lists. I have a column of 1 type of fruit, another column of price and another of price per kg. I would like it to only write or save to a new array, list or dictionary if the fruit (with its price1 and price per kg) includes a specific word, for example fruit in 'box' or 'bulk'. do you know how i can do it? But if its fruit shampoo dont be write or save in excel column (it has not the word box or bulk).... or at least be written and the deleted that row

[@pythoninoffice6568]

You can filter the data by the keywords you want first, then save to Excel. To filter data you can do something like this, assuming the data is inside a dataframe (df), with a column named "fruit" df['fruit'].str.contains('box|bulk') This will filter on the "fruit" column and keep only records contain either 'box' or 'bulk' in the fruit column. Note this will return a boolean index with True/False values. To select the actual data rows, you just need to pass the above boolean index into the dataframe using the .loc[] property: df.loc[df['fruit'].str.contains('box|bulk')]

[@tigreonice2339]

@@pythoninoffice6568 thank you. I will try it

[@tigreonice2339]

@@pythoninoffice6568 It worked! Thank you :D

[@ahteshamshakeel5879]

Hii sir this working but other sheets on file is missing how can i solve this issue

[@mahaveerprajapat7094]

Hi, your video is as i want ,still i have a question. My Question: How can I paste the array in a specific range of an excel sheet as we can do in vba?

[@pythoninoffice6568]

You can do that with several other libraries such as openpyxl or xlxswriter. I have a few videos on those libraries that should help you do that.

[@jennyleow3855]

hi, how can I generate python coding file either in Excel or Word ? thank you

[@pythoninoffice6568]

Sorry I might not understand your question correctly. You want to create .py files using Excel or Word? Why would you want to do that?

[@FarzamAhmed-wg7pf]

Hi . The method you are using is for a single run will it works if I re run my code will the previous record be there or it will be removed?

[@bl4ckang3l48]

Good

[@riyapandey1008]

Hi sir I want to send my python output to the excel automatically..

[@pythoninoffice6568]

Can you elaborate what are you trying to achieve?

[@07harjas]

Can i write to excel file while it is open ?

[@pythoninoffice6568]

No - with this particular library (pandas), you'll get a permission denied error message if you try to save while having the file open. Need to make sure file is closed before saving.

[@Supercharged_Mindset]

Trying to scrape twitter for some info and export to excel but can't seem to get it to work. I tried moving the excel file to where Atom exports and saves files, desktop, and where Python is installed but nothing seemed to help. Even tried to follow your tutorial step by step but it didn't work. Here's a sample of my code: data = pd.DataFrame(tweets_list1, columns=['Datetime', 'Tweet Id', 'Text', 'Username']) with pd.ExcelWriter(r'C:\Users\User\Desktop\Python\test.xlsx') as writer: data.to_excel(writer,sheet_name ='Sheet1') Any dea what's going wrong and how to fix it?

[@Supercharged_Mindset]

Alternatively, I've tried this method and it didn't work as well data = pd.DataFrame(tweets_list1, columns=['Datetime', 'Tweet Id', 'Text', 'Username']) datatoexcel = pd.ExcelWriter("test.xlsx",engine='xlsxwriter') data.to_excel(datatoexcel, sheet_name='Sheet1') datatoexcel.save()

[@Supercharged_Mindset]

found a solution def insert_data(listdata): wb = xlsxwriter.Workbook("test.xlsx") ws = wb.add_worksheet() row = 0 col = 0 for line in listdata: for item in line: ws.write(row, col, item) col += 1 row += 1 col = 0 wb.close() insert_data(data) os.system("test.xlsx") still can't figure out why the first two didn't work though

[@pythoninoffice6568]

Have you tried just simply data.to_excel(file_path) ? What kind of error messages did you get by running the first two methods?

[@Supercharged_Mindset]

@@pythoninoffice6568 Thanks for the swift response, much appreciated! Your solution works like a charm. Was unsure about the exact error msg so I tried to write it up again and strangely enough, both solutions worked as well. Must've been a typo or wrong attribute. Thanks for your time! Aside; Your videos are easy to follow, concise, and very informative. Would love to see you put up more content!! Especially regarding DS. Best regards!

[@pythoninoffice6568]

@@Supercharged_Mindset Really appreciate your kind words, means a lot to me! I took a break from video to focus more on my blog, but I plan to come back to making more videos soon!