[4]: returns_new = pd. read_csv('ce3_Returns.csv', index_col='Ticker') returns_new.head() [4]: [5]: Again, the file ce3_Returns.csv contains data on...

 

Transcribed Image Text:

[4]: returns_new = pd. read_csv('ce3_Returns.csv', index_col='Ticker') returns_new.head() [4]: [5]: Again, the file ce3_Returns.csv contains data on the return over the first half of 2022 for US companies together with a numerical sector code. Load its content into a DataFrame called returns_new. Choose the appropriate index for this DataFrame. [ ]: [ ]: Ticker A AA 33.0 0.236646 AAA 52.0 -0.050213 AAAU 52.0 -0.003000 AAC 52.0 0.008459 [5]: USmarkets = pd. read_csv('ce3_USMarkets.csv', index_col='Ticker') USmarkets.head() The file ce3_USMarkets.csv contains the name of the stock exchange where each company is listed. Load its content into a DataFrame called USmarkets. Choose the appropriate index for this DataFrame (Point 4: 1 Mark). Ticker A AA Sector Return AAA 33.0 0.002133 AAAU AAC Exchange NYSE NYSE ARCA ARCA NYSE Produce a DataFrame called size having as index the names of the stock markets and as a single column the number of companies listed in each market (Point 5: 1 Mark). Calculate the average return of all the companies listed on the NASDAQ. Assign this result to a numeric variable (a number) called average_nasdaq (Point 6: 1 Mark). [4]: returns_new = pd. read_csv('ce3_Returns.csv', index_col='Ticker') returns_new.head() [4]: [5]: Again, the file ce3_Returns.csv contains data on the return over the first half of 2022 for US companies together with a numerical sector code. Load its content into a DataFrame called returns_new. Choose the appropriate index for this DataFrame. [ ]: [ ]: Ticker A AA 33.0 0.236646 AAA 52.0 -0.050213 AAAU 52.0 -0.003000 AAC 52.0 0.008459 [5]: USmarkets = pd. read_csv('ce3_USMarkets.csv', index_col='Ticker') USmarkets.head() The file ce3_USMarkets.csv contains the name of the stock exchange where each company is listed. Load its content into a DataFrame called USmarkets. Choose the appropriate index for this DataFrame (Point 4: 1 Mark). Ticker A AA Sector Return AAA 33.0 0.002133 AAAU AAC Exchange NYSE NYSE ARCA ARCA NYSE Produce a DataFrame called size having as index the names of the stock markets and as a single column the number of companies listed in each market (Point 5: 1 Mark). Calculate the average return of all the companies listed on the NASDAQ. Assign this result to a numeric variable (a number) called average_nasdaq (Point 6: 1 Mark).

Answer rating: 100% (QA)

Given G is a group a If G has an element of order G then ... View the full answer