Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Apache Cassandra Development

Authors: Vivek Mishra

1st Edition

1484201426, 9781484201428

More Books

Students also viewed these Databases questions

Question

How does systematic risk differ from unsystematic risk?

Answered: 1 week ago