Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

use the command pd.read_excel to read in the excel file Class3_hisassetret.xlsx It contains the annual return data for S&P 500 (includes dividends), 3-month T.Bill, and

image text in transcribedimage text in transcribed

use the command "pd.read_excel" to read in the excel file Class3_hisassetret.xlsx It contains the annual return data for S&P 500 (includes dividends), 3-month T.Bill, and 10-year T. Bond

import pandas as pd mydata=pd.read_excel('Class3_hisassetret-1.xlsx') mydata

Python exercise We went through the file "Class 3_stock_stdcov" in class. Study the file "Class3_inputoutput" and use the command "pd.read_excel" to read in the excel file Class3_hisassetret.xlsx It contains the annual return data for S&P 500 (includes dividends), 3-month T.Bill, and 10-year T. Bond [3]: import pandas as pd -[3]: mydata=pd.read_excel ('Class3_hisassetret-1.xlsx') mydata Year S&P 500 (includes dividends) 3-month T.Bill Return on 10-year T. Bond 0 1928 0.438112 0.03080 0.008355 1 1929 -0.082979 0.03160 0.042038 2 1930 -0.251236 0.04550 0.045409 3 1931 -0.438375 0.02310 -0.025589 4 1932 -0.086424 0.01070 0.087903 85 2013 0.321451 0.00066 -0.091046 86 2014 0.135244 0.00053 0.107462 87 2015 0.013789 0.00210 0.012843 88 2016 0.117731 0.00510 0.006906 89 2017 0.216412 0.01390 0.028017 90 rows x 4 columns

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

Step: 3

blur-text-image

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

Foundations of Finance The Logic and Practice of Financial Management

Authors: Arthur J. Keown, John D. Martin, J. William Petty

8th edition

132994879, 978-0132994873

More Books

Students also viewed these Finance questions

Question

What is the MFD? UFD? How are they related?

Answered: 1 week ago