Save your analysis to multiple excel worksheets
Now that you have completed your analysis, you may want to save all results into a single Excel workbook.
Let's practice exporting various DataFrame
to multiple Excel worksheets.
This exercise is part of the course
Manipulating Time Series Data in Python
Exercise instructions
We have already imported pandas
as pd
for you. We have also loaded both the historical price series of your index constituents into the variable stock_prices
, and the index as index
.
- Inspect both
index
andstock_prices
using.info()
. - Use
.join()
to combineindex
withstock_prices
, and assign todata
. - Apply
.pct_change()
todata
and assign toreturns
. - Create
pd.ExcelWriter
and usewith
to exportdata
andreturns
to excel withsheet_names
of the same name.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Inspect index and stock_prices
print(____)
print(____)
# Join index to stock_prices, and inspect the result
data = ____
print(____)
# Create index & stock price returns
returns = ____
# Export data and data as returns to excel
with pd.ExcelWriter('data.xls') as writer:
data.____
returns.____