pandas

I have the following dataframe: Year Country medal no of medals 1896 Afghanistan Gold 5 1896 Afghanistan Silver 4 1896 Afghanistan Bronze 3 1896 Algeria Gold 1 1896 Algeria Silver 2 1896 Algeria Bronze 3 I want it this way. Year Country Gold Silver Bronze 1896 Afghanistan 5 4 3 1896 Algeria 1 2 3 … Read more

The question Given a Series s and DataFrame df, how do I operate on each column of df with s? df = pd.DataFrame( [[1, 2, 3], [4, 5, 6]], index=[0, 1], columns=['a', 'b', 'c'] ) s = pd.Series([3, 14], index=[0, 1]) When I attempt to add them, I get all np.nan df + s a … Read more

I have a DataFrame object similar to this one:

i have a small sample data:

I’m working with the following df:

I am using .size() on a groupby result in order to count how many items are in each group.