Question

At the end you should have left with 7 rows not counting the header.

import pandas_datareader.data as wb

import datetime as date

#Step 1(10 points): Remotely Download "Treasury Constant Maturity Rate" from FRED

#(https://fred.stlouisfed.org/categories/115) from 02/01/2014 to 02/01/2016:

#6-Month

#1-Year

#5-Year

#10-Year

#Step 2( 5 points ): Determine the average and standard deviation for each of the

maturities( maturity is 6-month, 1 year, etc.)

#Step 3( 5 points ): Select only those rows that have value more or less than avg

+/- 1 std

#Step 4( 10 points ): Create a dataframe which has only those rows for which all of

the maturities

#has value outside of avg +/- 1 std. Hint: think about joins for frames in step 3

#Step 5( 5 points): Save the generated dataframe as sigma.xlsx

Answer 1

code:- read data file

2.Convert file data into a data frame

3)Determine standard deviation and average value

4)value greater or less