I have a pandas dataframe named 'brics' with columns names given by 'country', 'capital', 'area' and 'population' and indices given by 'FR', 'IT' and 'UK'. I want to construct a pandas dataframe with the only two columns 'country' and 'capital' and only for the indices 'FR' and 'IT'. Which command should I use?

Question

I have a  pandas  dataframe named 'brics' with columns names given by 'country', 'capital', 'area' and 'population' and indices given by 'FR', 'IT' and 'UK'. I want to construct a  pandas  dataframe with the only two columns 'country' and 'capital' and only for the indices 'FR' and 'IT'. Which command should I use?

Answer

brics.iloc[['FR', 'IT'], ['country', 'capital']]

Answer

brics[('FR', 'IT'), ('country':'capital')]

Answer

brics.loc[['FR', 'IT'], ['country', 'capital']]

Answer

brics[['FR', 'IT'], ['country':'capital']]

Crowdly

I have a pandas dataframe named 'brics' with columns names given by 'country',...

Want instant access to all verified answers on moodle.essec.fr?