Question: Question 3 : Economic Data a ) Load econ _ data.xlsx excel file. Have the Date as the Index. b ) Calculate simple percentage changes

Question3: Economic Data
a) Load econ_data.xlsx excel file. Have the Date as the Index.
b) Calculate simple percentage changes for each column time series and save as a new DataFrame. Use a function. Print the tail.
c) Calculate descriptive statistics on the raw data and pct changes. (see econ_describe_raw and econ_describe_pct below)
d) Calculate correlation between all pct change columns. (see econ_corr below)
e) Calculate covariance between all pct columns (see econ_cov below)
f) Sort data on the index (dates) so they are descending (see sorted_data below)
g) Remove - values and FRED from columns to clean data columns and set these new column names for econ_data. Note this should be done at beginning of data processing. (See list and econ_data below)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!