Question: I need help with this code, I am getting the error message listed below the code. Step 2: Scatterplot and Correlation for the Total Number

I need help with this code, I am getting the error message listed below the code.

Step 2: Scatterplot and Correlation for the Total Number of Wins and Average Points Scored

Your coach expects teams to win more games in a regular season if they have a high average number of points compared to their opponents. This is because the chances of winning are higher if a team scores high in its games. Therefore, it is expected that the total number of wins and the average points scored are correlated. Calculate the Pearson correlation coefficient and its P-value. Make the following edits to the code block below:

  1. Replace ??DATAFRAME_NAME?? with the name of the dataframe used in this project. See Step 1 for the name of dataframe used in this project.
  1. Replace ??POINTS?? with the name of the variable for average points scored in a regular season. See the table included in the Project Three instructions above to pick the variable name. Enclose this variable in single quotes. For example, if the variable name is var1 then replace ??POINTS?? with 'var1'.
  1. Replace ??WINS?? with the name of the variable for the total number of wins in a regular season. Remember to enclose the variable in single quotes. See the table included in the Project Three instructions above to pick the variable name. Enclose this variable in single quotes. For example, if the variable name is var2 then replace ??WINS?? with 'var2'.

The code block below will print a scatterplot of the total number of wins against the average points scored in a regular season.

After you are done with your edits, click the block of code below and hit the Run button above.

In [8]:

import scipy.stats as st
 
# ---- TODO: make your edits here ----
plt.plot('nba_wins_data.csv'['avg_pts'], 'nba_wins_data.csv'['total_wins'], 'o')
 
plt.title('Total Number of Wins by Average Points Scored', fontsize=20)
plt.xlabel('Average Points Scored')
plt.ylabel('Total Number of Wins')
plt.show()
 
 
# ---- TODO: make your edits here ----
correlation_coefficient, p_value = st.pearsonr('nba_wins_data.csv'['avg_pts'], 'nba_wins_data.csv'['total_wins'])
 
print("Correlation between Average Points Scored and the Total Number of Wins ")
print("Pearson Correlation Coefficient =", round(correlation_coefficient,4))
print("P-value =", round(p_value,4))
--------------------------------------------------------------------------- TypeError Traceback (most recent call last) in  2  3 # ---- TODO: make your edits here ---- ----> 4 plt.plot('nba_wins_data.csv'['avg_pts'], 'nba_wins_data.csv'['total_wins'], 'o')  5  6 plt.title('Total Number of Wins by Average Points Scored', fontsize=20) TypeError: string indices must be integers 

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!