It should include all the columns from playerdata and

This preview shows page 11 - 15 out of 26 pages.

It should include all the columns from player_dataand salary_data, except the "PlayerName"column.NameAgeTeamGamesReboundsAssistsStealsBlocksTurnoversPointsJames Harden25HOU81459565154603212217Chris Paul29LAC82376838156151901564Stephen Curry26GSW80341619163162491900... (489 rows omitted)PlayerNameSalaryKobe Bryant23500000Amar'e Stoudemire23410988Joe Johnson23180790... (489 rows omitted)player_data =Table.read_table('player_data.csv')salary_data =Table.read_table('salary_data.csv')player_data.show(3)salary_data.show(3)
In [103]:In [104]:Out[103]:NameAgeTeamGamesReboundsAssistsStealsBlocksTurnoversPointsSalaryA.J. Price28TOT263246701413362552AaronBrooks30CHI8216626154151579541145685AaronGordon19ORL47169332122382433992040AdreianPayne23TOT3216230199442131855320AlHorford28ATL765442446898100115612000000AlJefferson30CHO65548113478468108213666667Al-FarouqAminu24DAL74342597062554121100602AlanAnderson32BRK7420483565605451276061AlecBurks23UTA2711482175523743034356Alex Kirk23CLE5110004507336... (482 rows omitted)~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Running tests---------------------------------------------------------------------Test summaryPassed: 1Failed: 0[ooooooooook] 100.0% passedfull_data =player_data.join('Name',salary_data, 'PlayerName')full_data_ =ok.grade('q3_1')
.Question 2.Create a table called full_data_with_valuethat's a copy of full_data, with an extracolumn called "Value"containing each player's value (according to our crude measure). Then make ahistogram of players' values. Specify bins that make the histogram informative, and don't forget yourunits!Remember that hist()takes in an optional third argument that allows you to specify the units!Hint: Informative histograms contain a majority of the data and exclude outliers.)
Question 3.Make a histogram of the values of the players in sample_salary_data, using the samemethod for measuring value we used in question 2. Use the same bins, too.Hint:This will take several steps.In [118]:
)
)
)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture