How to save data to an excel spreadsheet with Python
• 1 minPython 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 :
Pandas - The Python You Need
We gathered the only Python essentials that you will probably ever need.