High scorers

For the following exercises, we'll read nba_data.csv CSV file, that contains data of NBA Players (original can be found here).

Your task: Get a list of all the players making more points than the double of the mean. That list should include just players name and points.

Test Cases

test high scorers - Run Test

def test_high_scorers():
    assert high_scorers.shape == (45,2) and high_scorers.iloc[37,1] == 18.3

Solution 1

import numpy as np
import pandas as pd

df = pd.read_csv('nba_data.csv')

high_scorers = df.loc[df['Points'] > 2 * df['Points'].mean(), ['Player', 'Points']]

Files associated with this lesson:

nba_data.csv

          
  
      
      Rk
      Player
      Position
      Age
      Mp
      Fg
      Fga
      Fg%
      3P
      3Pa
      3P%
      2P
      2Pa
      2P%
      Efg%
      Ft
      Fta
      Ft%
      Orb
      Drb
      Trb
      Ast
      Stl
      Blk
      Tov
      Pf
      Points
      Team
      Gp
      Mpg
      Orpm
      Drpm
      Rpm
      Wins_Rpm
      Pie
      Pace
      W
    

  
      0
      1
      Russell Westbrook
      PG
      28
6
2
0
425
5
2
343
7
8
459
476
8
4
845
7
0
7
4
6
4
4
3
6
      OKC
      81
6
74
      -0.47
27
34
0
31
      46
    

      1
      2
      James Harden
      PG
      27
4
3
9
440
2
3
347
1
6
530
525
2
9
847
2
0
1
2
5
5
7
7
1
      HOU
      81
4
38
      -1.57
81
54
0
98
      54
    

      2
      3
      Isaiah Thomas
      PG
      27
8
0
4
463
2
5
379
8
9
528
546
8
5
909
6
1
7
9
9
2
8
2
9
      BOS
      76
8
72
      -3.89
83
19
1
84
      51
    

      3
      4
      Anthony Davis
      C
      23
1
3
3
505
5
8
299
7
6
524
518
9
6
802
3
5
8
1
3
2
4
2
0
      NO
      75
1
45
90
35
81
2
19
      31
    

      4
      5
      DeMar DeRozan
      SG
      27
4
7
9
467
4
7
266
3
2
484
477
4
7
842
9
3
2
9
1
2
4
8
3
      TOR
      74
4
21
      -2.04
17
46
5
69
      47
    

      5
      6
      DeMarcus Cousins
      C
      26
2
0
9
452
8
0
361
2
8
483
498
2
3
772
1
9
0
6
4
3
7
9
0
      NO/SAC
      72
2
56
64
20
26
8
11
      30
    

      6
      7
      Damian Lillard
      PG
      26
9
8
8
444
9
7
370
0
1
492
516
5
3
895
6
3
9
9
9
3
6
0
0
      POR
      75
9
63
      -1.49
14
72
9
68
      38
    

      7
      8
      LeBron James
      SF
      32
8
9
2
548
7
6
363
3
5
611
594
8
2
674
3
3
6
7
2
6
1
8
4
      CLE
      74
8
49
93
42
43
3
38
      51
    

      8
      9
      Kawhi Leonard
      SF
      25
4
6
7
485
0
2
380
6
5
529
541
3
2
880
1
7
8
5
8
7
1
6
5
      SA
      74
4
83
25
08
53
4
79
      54
    

      9
      10
      Stephen Curry
      PG
      28
4
5
3
468
1
0
411
4
3
537
580
1
6
898
8
7
5
6
8
2
0
3
3
      GS
      79
4
27
14
41
80
1
08
      65
    


        

	Rk	Player	Position	Age	Mp	Fg	Fga	Fg%	3P	3Pa	3P%	2P	2Pa	2P%	Efg%	Ft	Fta	Ft%	Orb	Drb	Trb	Ast	Stl	Blk	Tov	Pf	Points	Team	Gp	Mpg	Orpm	Drpm	Rpm	Wins_Rpm	Pie	Pace	W
0	1	Russell Westbrook	PG	28	34.6	10.2	24.0	0.425	2.5	7.2	0.343	7.7	16.8	0.459	0.476	8.8	10.4	0.845	1.7	9.0	10.7	10.4	1.6	0.4	5.4	2.3	31.6	OKC	81	34.6	6.74	-0.47	6.27	17.34	23.0	102.31	46
1	2	James Harden	PG	27	36.4	8.3	18.9	0.440	3.2	9.3	0.347	5.1	9.6	0.530	0.525	9.2	10.9	0.847	1.2	7.0	8.1	11.2	1.5	0.5	5.7	2.7	29.1	HOU	81	36.4	6.38	-1.57	4.81	15.54	19.0	102.98	54
2	3	Isaiah Thomas	PG	27	33.8	9.0	19.4	0.463	3.2	8.5	0.379	5.8	10.9	0.528	0.546	7.8	8.5	0.909	0.6	2.1	2.7	5.9	0.9	0.2	2.8	2.2	28.9	BOS	76	33.8	5.72	-3.89	1.83	8.19	16.1	99.84	51
3	4	Anthony Davis	C	23	36.1	10.3	20.3	0.505	0.5	1.8	0.299	9.7	18.6	0.524	0.518	6.9	8.6	0.802	2.3	9.5	11.8	2.1	1.3	2.2	2.4	2.2	28.0	NO	75	36.1	0.45	3.90	4.35	12.81	19.2	100.19	31
4	5	DeMar DeRozan	SG	27	35.4	9.7	20.9	0.467	0.4	1.7	0.266	9.3	19.2	0.484	0.477	7.4	8.7	0.842	0.9	4.3	5.2	3.9	1.1	0.2	2.4	1.8	27.3	TOR	74	35.4	2.21	-2.04	0.17	5.46	15.5	97.69	47
5	6	DeMarcus Cousins	C	26	34.2	9.0	19.9	0.452	1.8	5.0	0.361	7.2	14.8	0.483	0.498	7.2	9.3	0.772	2.1	8.9	11.0	4.6	1.4	1.3	3.7	3.9	27.0	NO/SAC	72	34.2	3.56	0.64	4.20	11.26	17.8	97.11	30
6	7	Damian Lillard	PG	26	35.9	8.8	19.8	0.444	2.9	7.7	0.370	6.0	12.1	0.492	0.516	6.5	7.3	0.895	0.6	4.3	4.9	5.9	0.9	0.3	2.6	2.0	27.0	POR	75	35.9	4.63	-1.49	3.14	10.72	15.9	99.68	38
7	8	LeBron James	SF	32	37.8	9.9	18.2	0.548	1.7	4.6	0.363	8.3	13.5	0.611	0.594	4.8	7.2	0.674	1.3	7.3	8.6	8.7	1.2	0.6	4.1	1.8	26.4	CLE	74	37.8	6.49	1.93	8.42	20.43	18.3	98.38	51
8	9	Kawhi Leonard	SF	25	33.4	8.6	17.7	0.485	2.0	5.2	0.380	6.6	12.5	0.529	0.541	6.3	7.2	0.880	1.1	4.7	5.8	3.5	1.8	0.7	2.1	1.6	25.5	SA	74	33.4	5.83	1.25	7.08	15.53	17.4	95.79	54
9	10	Stephen Curry	PG	28	33.4	8.5	18.3	0.468	4.1	10.0	0.411	4.4	8.3	0.537	0.580	4.1	4.6	0.898	0.8	3.7	4.5	6.6	1.8	0.2	3.0	2.3	25.3	GS	79	33.4	7.27	0.14	7.41	18.80	15.1	105.08	65

High scorers

Test Cases

Files associated with this lesson:

😥 Please, login to continue

Previous attempt

Get in touch with us