text_plain_output_1.png
import pandas as pd

df = pd.read_csv('../input/all_energy_statistics.csv')
df.columns = ['country', 'commodity', 'year', 'unit', 'quantity', 'footnotes', 'category']

df_solar = df[df.commodity.str.contains('Electricity - total net installed capacity of electric power plants, solar')]
df_max = df_solar.groupby(pd.Grouper(key='country'))['quantity'].max()
df_max = df_max.sort_values(ascending=False)
df_max = df_max[:6]
df_max.index.values