
from datascience import *
import numpy as np

%matplotlib inline
import matplotlib.pyplot as plots
plots.style.use('fivethirtyeight')


nba = Table.read_table('nba_salaries.csv')
nba


point_guards = nba.where('position', 'PG')


point_guards


point_guards.drop('position')


point_guards


point_guards = point_guards.drop('position')


point_guards.sort('salary', descending=True).show()


point_guards.sort('salary', descending=True).show(15)


# Errors!
nba.where('Position', 'PG')

---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
Cell In [10], line 2
      1 # Errors!
----> 2 nba.where('Position', 'PG')

File /opt/homebrew/Caskroom/miniforge/base/lib/python3.10/site-packages/datascience/tables.py:1424, in Table.where(self, column_or_label, value_or_predicate, other)
   1342 def where(self, column_or_label, value_or_predicate=None, other=None):
   1343     """
   1344     Return a new ``Table`` containing rows where ``value_or_predicate``
   1345     returns True for values in ``column_or_label``.
   (...)
   1422     Color | Shape | Amount | Price
   1423     """
-> 1424     column = self._get_column(column_or_label)
   1425     if other is not None:
   1426         assert callable(value_or_predicate), "Predicate required for 3-arg where"

File /opt/homebrew/Caskroom/miniforge/base/lib/python3.10/site-packages/datascience/tables.py:2229, in Table._get_column(self, column_or_label)
   2227     return self[c]
   2228 elif isinstance(c, str):
-> 2229     raise ValueError('label "{}" not in labels {}'.format(c, self.labels))
   2230 else:
   2231     assert len(c) == self.num_rows, 'column length mismatch'

ValueError: label "Position" not in labels ('rank', 'name', 'position', 'team', 'salary', 'season')


nba.drop('position').where('position', 'PG')

30


10 * 3    # int


10 / 3    # float


10 / 2


10 ** 3


10 ** 0.5


1234567 ** 890


10 / 3


75892745.215489247589274985712


75892745.215489247589274985712 - 75892745.21548925


(13 ** 0.5) ** 2


int(10 / 5)


int(10 / 4)


float(3)


6 / 4


6 / 4000


6 / 400000000000000000000000000000000000000000000000000000000


400000000000000000000000000000000000000000000000000000000 * 1.5e-56


1.5e-56


x = 5

2x


2 * x


'Flavor'


Flavor


"Flavor"


'Don't always use single quotes'


"Don't always use single quotes"


'ha' * 100


'lo' * 5.5


'ha' + 10


'ha' + str(10)


int('3')


int('3.0')


int(float('3.0'))


type(10)


a = 10


type(a)


type(4.5)


type('abc')


type(nba)


type(True)


abs(-5)


type(abs)


my_array = make_array(1, 2, 3, 4)


my_array


my_array * 2


my_array ** 2


my_array + 1


my_array # array is unchanged, just like when we call show/select/drop on Table


another = make_array(5, 6, 7, 8)


my_array + another


yet_another = make_array(5, 6, 7)


my_array + yet_another


sum(my_array)


np.average(my_array)


len(my_array)


tunas = make_array('bluefin', 'albacore', 'jim')
tunas


tunas * 4


tunas.item(0) # NOTE: indexing starts at 0!


tunas.item(1)


tunas.item(2)


warriors = nba.where('team', 'Golden State Warriors')


warriors


warriors.select('salary')


type(warriors.select('salary'))


warriors.column('salary')


np.average(warriors.column('salary'))


celtics = nba.where('team', 'Boston Celtics')


np.average(warriors.column('salary')) - np.average(celtics.column('salary'))

rank	name	position	team	salary	season
1	Shaquille O'Neal	C	Los Angeles Lakers	17142000	2000
2	Kevin Garnett	PF	Minnesota Timberwolves	16806000	2000
3	Alonzo Mourning	C	Miami Heat	15004000	2000
4	Juwan Howard	PF	Washington Wizards	15000000	2000
5	Scottie Pippen	SF	Portland Trail Blazers	14795000	2000
6	Karl Malone	PF	Utah Jazz	14000000	2000
7	Larry Johnson	F	New York Knicks	11910000	2000
8	Gary Payton	PG	Seattle SuperSonics	11020000	2000
9	Rasheed Wallace	PF	Portland Trail Blazers	10800000	2000
10	Shawn Kemp	C	Cleveland Cavaliers	10780000	2000

rank	name	position	team	salary	season
8	Gary Payton	PG	Seattle SuperSonics	11020000	2000
11	Damon Stoudamire	PG	Portland Trail Blazers	10125000	2000
20	Stephon Marbury	PG	New Jersey Nets	9000000	2000
24	Nick Van Exel	PG	Denver Nuggets	8354000	2000
26	Terrell Brandon	PG	Minnesota Timberwolves	7400000	2000
34	Jason Kidd	PG	Phoenix Suns	6858000	2000
35	Kenny Anderson	PG	Boston Celtics	6680000	2000
39	Steve Nash	PG	Dallas Mavericks	5500000	2000
55	Charlie Ward	PG	New York Knicks	4540000	2000
61	Darrel Armstrong	PG	Orlando Magic	4125000	2000

rank	name	team	salary	season
8	Gary Payton	Seattle SuperSonics	11020000	2000
11	Damon Stoudamire	Portland Trail Blazers	10125000	2000
20	Stephon Marbury	New Jersey Nets	9000000	2000
24	Nick Van Exel	Denver Nuggets	8354000	2000
26	Terrell Brandon	Minnesota Timberwolves	7400000	2000
34	Jason Kidd	Phoenix Suns	6858000	2000
35	Kenny Anderson	Boston Celtics	6680000	2000
39	Steve Nash	Dallas Mavericks	5500000	2000
55	Charlie Ward	New York Knicks	4540000	2000
61	Darrel Armstrong	Orlando Magic	4125000	2000

rank	name	position	team	salary	season
8	Gary Payton	PG	Seattle SuperSonics	11020000	2000
11	Damon Stoudamire	PG	Portland Trail Blazers	10125000	2000
20	Stephon Marbury	PG	New Jersey Nets	9000000	2000
24	Nick Van Exel	PG	Denver Nuggets	8354000	2000
26	Terrell Brandon	PG	Minnesota Timberwolves	7400000	2000
34	Jason Kidd	PG	Phoenix Suns	6858000	2000
35	Kenny Anderson	PG	Boston Celtics	6680000	2000
39	Steve Nash	PG	Dallas Mavericks	5500000	2000
55	Charlie Ward	PG	New York Knicks	4540000	2000
61	Darrel Armstrong	PG	Orlando Magic	4125000	2000

rank	name	team	salary	season
1	Stephen Curry	Golden State Warriors	40231758	2020
2	Chris Paul	Oklahoma City Thunder	38506482	2020
3	Russell Westbrook	Houston Rockets	38506482	2020
4	John Wall	Washington Wizards	38199000	2020
1	Stephen Curry	Golden State Warriors	37457154	2018
1	Stephen Curry	Golden State Warriors	37457154	2019
2	Chris Paul	Houston Rockets	35654150	2019
4	Russell Westbrook	Oklahoma City Thunder	35654150	2019
8	Kyle Lowry	Toronto Raptors	34996296	2020
14	Kemba Walker	Boston Celtics	32742000	2020
16	Mike Conley	Utah Jazz	32511624	2020
17	Kyrie Irving	Brooklyn Nets	31742000	2020
4	Kyle Lowry	Toronto Raptors	31200000	2018
7	Kyle Lowry	Toronto Raptors	31200000	2019
9	Mike Conley	Memphis Grizzlies	30521115	2019

Review of Tables¶

Numbers¶

Strings¶

Types¶

Arrays¶

Columns of Tables are Arrays¶

rank	name	team	salary	season
1	Stephen Curry	Golden State Warriors	40231758	2020
2	Chris Paul	Oklahoma City Thunder	38506482	2020
3	Russell Westbrook	Houston Rockets	38506482	2020
4	John Wall	Washington Wizards	38199000	2020
1	Stephen Curry	Golden State Warriors	37457154	2018
1	Stephen Curry	Golden State Warriors	37457154	2019
2	Chris Paul	Houston Rockets	35654150	2019
4	Russell Westbrook	Oklahoma City Thunder	35654150	2019
8	Kyle Lowry	Toronto Raptors	34996296	2020
14	Kemba Walker	Boston Celtics	32742000	2020
16	Mike Conley	Utah Jazz	32511624	2020
17	Kyrie Irving	Brooklyn Nets	31742000	2020
4	Kyle Lowry	Toronto Raptors	31200000	2018
7	Kyle Lowry	Toronto Raptors	31200000	2019
9	Mike Conley	Memphis Grizzlies	30521115	2019
21	Damian Lillard	Portland Trail Blazers	29802321	2020
6	Mike Conley	Memphis Grizzlies	28530608	2018
7	Russell Westbrook	Oklahoma City Thunder	28530608	2018
14	Damian Lillard	Portland Trail Blazers	27977689	2019
2	Mike Conley	Memphis Grizzlies	26540100	2017
7	Russell Westbrook	Oklahoma City Thunder	26540100	2017
12	Damian Lillard	Portland Trail Blazers	26153057	2018
19	Chris Paul	Houston Rockets	24599495	2018
10	Damian Lillard	Portland Trail Blazers	24328425	2017
14	Chris Paul	LA Clippers	22868827	2017
6	Chris Paul	LA Clippers	21468695	2016
2	Jason Kidd	Dallas Mavericks	21372000	2009
21	Derrick Rose	New York Knicks	21323252	2017
7	Stephon Marbury	Boston Celtics	20840625	2009
43	Kyrie Irving	Boston Celtics	20099189	2019
8	Derrick Rose	Chicago Bulls	20093064	2016
7	Chris Paul	LA Clippers	20068563	2015
52	Malcolm Brogdon	Indiana Pacers	20000000	2020
53	Terry Rozier	Charlotte Hornets	19894737	2020
8	Deron Williams	Brooklyn Nets	19754465	2015
3	Jason Kidd	New Jersey Nets	19728000	2008
45	Zach LaVine	Chicago Bulls	19500000	2019
55	Zach LaVine	Chicago Bulls	19500000	2020
57	Goran Dragic	Miami Heat	19217900	2020
41	John Wall	Washington Wizards	19169800	2018