How to save data to an excel spreadsheet with Python
Land Your First Data Science Job
A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.
Python can work with excel spreadsheets quite easily.
Using the Pandas library the task is even easier.
Let's take the example of Apple share prices here.
We create an example DataFrame to save as an excel file.
df = pd.DataFrame(index=["2020-10-09","2020-10-12","2020-10-13"],
data={
"Open" : [115.27999877929688,
120.05999755859375,
125.2699966430664],
"High" : [117.0,
125.18000030517578,
125.38999938964844],
"Low" : [114.91999816894531,
119.27999877929688,
119.6500015258789],
"Close" : [116.97000122070312,
124.4000015258789,
121.0999984741211]
})
# We save the dataframe as an excel file
df.to_excel("apple_prices.xlsx")Here you are! You now know how to save data as an excel file.
More on DataFrames
If you want to know more about DataFrame and Pandas. Check out the other articles I wrote on the topic, just here :
Land Your First Data Science Job
A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.
Related Articles
Continue your learning journey with these related topics
Master Data Science in Days, Not Months 🚀
Skip the theoretical rabbit holes. Get practical data science skills delivered in bite-sized lessons – Approach used by real data scientist. Not bookworms. 📚