Screen Link: https://app.dataquest.io/m/381/exploring-data-with-pandas%3A-fundamentals/3/series-data-exploration-methods
rank_change = f500["previous_rank"] - f500["rank"]
rank_change_max = rank_change.max()
rank_change_min = rank_change.min()
print(rank_change.describe())
Output:
count 500.000000
mean -28.366000
std 108.602823
min -500.000000
25% -28.250000
50% -4.000000
75% 8.250000
max 226.000000
dtype: float64
I am trying to do a little extra for this mission out of curiosity.
Basically, I want to pull the max value of rank_change
and use it to pull back the company that had that rank change. I feel like I’m overthinking the syntax but still can’t figure it out.
I was trying to do this syntax originally:
print(rank_change[226])
But that did not work for me.
Any help would be appreciated!!