JuniorTheoryCommon

What does this program print?

Python

import pandas as pd

df = pd.DataFrame({
    "team": ["a", "a", "a", "b", "b"],
    "salary": [100, 110, 600, 120, 130],
})
med = df.groupby("team")["salary"].median()
print(med.to_dict())

{'a': 110.0, 'b': 125.0}

Expecting 270.0 for team a: that is the mean, which the outlier 600 drags up; the median is the middle of 100, 110, 600, so it is 110.0.
Expecting 130.0 for team b: with an even number of values the median is the mean of the two central ones, (120 + 130) / 2, so 125.0.

Which salary figure would you report for team a as typical, and why?
What would the median of team a become if 600 were replaced by 6000?

Back to questions Open topic in roadmap →Answer it yourself — Quiz

Back to questions

JuniorTheoryCommon

What does this program print?

Python

import pandas as pd

df = pd.DataFrame({
    "team": ["a", "a", "a", "b", "b"],
    "salary": [100, 110, 600, 120, 130],
})
med = df.groupby("team")["salary"].median()
print(med.to_dict())

{'a': 110.0, 'b': 125.0}

Expecting 270.0 for team a: that is the mean, which the outlier 600 drags up; the median is the middle of 100, 110, 600, so it is 110.0.
Expecting 130.0 for team b: with an even number of values the median is the mean of the two central ones, (120 + 130) / 2, so 125.0.

Which salary figure would you report for team a as typical, and why?
What would the median of team a become if 600 were replaced by 6000?

Back to questions Open topic in roadmap →Answer it yourself — Quiz