Lowest salary players

For this exercise, we'll read the salaries.csv dataset, that contains salaries of NBA Players (original can be found here).

Your task: Get a list of those players making less than the mean salary (average salary).

Test Cases

test players less mean 1 - Run Test

def test_players_less_mean_1():
    assert round(players_less_mean.sum()) == 703889045.0

test players less mean 2 - Run Test

def test_players_less_mean_2():
    assert round(players_less_mean[23]) == 4736050.0

Solution 1

import numpy as np
import pandas as pd

salaries = pd.read_csv('salaries.csv', squeeze=True, index_col=0)

players_less_mean = salaries[salaries < salaries.mean()]
Files associated with this lesson:

salaries.csv

import numpy as np import pandas as pd salaries = pd.read_csv('salaries.csv', squeeze=True, index_col=0) players_less_mean = ?