# RESOLUCIÓN
df6 = (my_df.groupby(by='country_name').sum()).sort_values('total_amount', ascending=False)
pd.options.display.float_format='$ {:,.2f}'.format
print(df6[['total_amount']].head(5))
# RESOLUCIÓN GRÁFICA
plt.bar(df6.index, df6['total_amount'], color='tab:pink')
plt.xticks(rotation=90)
plt.show()
total_amount
country_name
Brazil $ 441,271.85
Argentina $ 205,832.78
Colombia $ 177,514.29
Peru $ 161,421.12
Mexico $ 138,619.99
# RESOLUCIÓN
df7 = (my_df.groupby(by='country_name').sum()).sort_values('quantity', ascending=False)
pd.options.display.float_format='$ {:,.2f}'.format
print(df7[['quantity']])
# RESOLUCIÓN GRÁFICA
plt.plot(df7.index,df7['quantity'],'#00FF00')
plt.xticks(rotation=90)
plt.show()
quantity
country_name
Brazil 2515
Peru 1027
Argentina 947
Colombia 881
Mexico 846
Venezuela 320
Honduras 303
Chile 231
Guatemala 202
Bolivia 181
Costa Rica 145
Ecuador 129
Paraguay 123
El Salvador 111
Uruguay 92
Puerto Rico 12
# RESOLUCIÓN
df8 = my_df.loc[(my_df['seller_name'] == 'Janel O\'Curran') & (my_df['country_name'] == 'Brazil')].head() # | == OR
print (df8)
# RESOLUCIÓN GRÁFICA
plt.pie(x=df8['quantity'],labels=df8['article_name'],startangle=90, autopct='%1.2f%%')
plt.show()
week quantity country_name article_name total_amount seller_name
3 1 9 Brazil Tablet $ 1,170.00 Janel O'Curran
28 1 5 Brazil Power Supply $ 219.75 Janel O'Curran
112 1 9 Brazil Full Pc $ 19,150.29 Janel O'Curran
151 1 12 Brazil Range Extender $ 245.40 Janel O'Curran
156 1 2 Brazil Sata Cable $ 4.28 Janel O'Curran