week quantity country_name article_name total_amount seller_name
0 1 10 Peru Water Cooling 675.0 Cirilo Grandham
1 1 15 Peru Mouse 454.5 Ewell Peres
2 1 5 Bolivia Netbook 725.0 Janel O'Curran
3 1 9 Brazil Tablet 1170.0 Janel O'Curran
4 1 6 Mexico Case 227.4 Daisie Slograve
article_name
HDD 413
Name: quantity, dtype: int64
# RESOLUCIÓN ANALÍTICA
df3=(my_df.groupby('article_name').sum()).sort_values('total_amount', ascending=False).head(5)
print(df3['total_amount'])
article_name
Full Pc 538335.93
Notebook 251000.00
Smartphone 152250.00
Chair 69477.48
Tablet 48620.00
Name: total_amount, dtype: float64
# RESOLUCIÓN GRÁFICA
plt.pie(x=df3['total_amount'], labels=df3.index)
plt.show()
Respuesta week quantity total_amount
seller_name
Janel O'Curran 174 703 192832.47
quantity total_amount
seller_name
Janel O'Curran 703 192832.47
Brockie Patience 441 142709.88
Oliviero Charkham 555 141329.76
Vasily Danilyuk 521 129157.55
Daisie Slograve 554 120520.11
Aveline Swanwick 629 118874.33
Arnold Kilkenny 583 94552.04
Kati Innot 512 83704.62
Jase Doy 582 80628.31
Ewell Peres 496 78144.32
Onida Cosely 535 77373.37
Milly Christoffe 442 61733.69
Tobin Roselli 519 56984.42
Cornie Wynrehame 523 52253.57
Cirilo Grandham 470 45009.40
quantity total_amount
week
1 2449 507458.81
2 2444 415364.44
3 2114 329140.03
4 1058 223844.56
week quantity total_amount
country_name
Brazil 717 2515 441271.85
Argentina 241 947 205832.78
Colombia 230 881 177514.29
Peru 266 1027 161421.12
Mexico 237 846 138619.99
Venezuela 84 320 77684.52
El Salvador 36 111 57391.26
Guatemala 62 202 52579.25
Honduras 78 303 36763.56
Costa Rica 41 145 34606.50
Chile 70 231 24660.98
Bolivia 45 181 22682.80
Uruguay 31 92 17843.09
Ecuador 44 129 17475.30
Paraguay 39 123 8195.12
Puerto Rico 3 12 1265.43
Respuesta week quantity total_amount
seller_name
Cirilo Grandham 131 470 45009.4
quantity total_amount
seller_name
Cirilo Grandham 470 45009.40
Cornie Wynrehame 523 52253.57
Tobin Roselli 519 56984.42
Milly Christoffe 442 61733.69
Onida Cosely 535 77373.37
Ewell Peres 496 78144.32
Jase Doy 582 80628.31
Kati Innot 512 83704.62
Arnold Kilkenny 583 94552.04
Aveline Swanwick 629 118874.33
Daisie Slograve 554 120520.11
Vasily Danilyuk 521 129157.55
Oliviero Charkham 555 141329.76
Brockie Patience 441 142709.88
Janel O'Curran 703 192832.47
week quantity total_amount
seller_name
Cirilo Grandham 131 470 45009.40
Cornie Wynrehame 159 523 52253.57
Tobin Roselli 126 519 56984.42
Milly Christoffe 112 442 61733.69
Onida Cosely 148 535 77373.37
# RESOLUCIÓN