6 TP Final Integrador

print(my_df.head())

   order_id  week  article_id  quantity  seller_id country_name  \
0     15024     1       20039        10         10         Peru   
1     15025     1       20029        15          5         Peru   
2     15026     1       20024         5         14      Bolivia   
3     15027     1       20018         9         14       Brazil   
4     15028     1       20035         6         15       Mexico   

    article_name  total_amount      seller_name  
0  Water Cooling         675.0  Cirilo Grandham  
1          Mouse         454.5      Ewell Peres  
2        Netbook         725.0   Janel O'Curran  
3         Tablet        1170.0   Janel O'Curran  
4           Case         227.4  Daisie Slograve

# RESOLUCIÓN GRÁFICA sns.barplot(x=df2.index,y=df2['quantity'],data=df2,order=df2.sort_values('quantity', ascending=False).index) plt.xticks(rotation=90) plt.show()

# RESOLUCIÓN GRÁFICA plt.pie(x=df3['total_amount'],labels=df3.index) plt.show()

# RESOLUCIÓN GRÁFICA plt.bar(df4.index, df4['total_amount']) plt.xticks(rotation=60) plt.show()

# RESOLUCIÓN GRÁFICA plt.bar(df5.index,df5['total_amount']) plt.show()

# BY CECILIA plt.plot(df5.index, df5["total_amount"]) plt.show()

# RESOLUCIÓN df6=(my_df.groupby('country_name').sum()).sort_values('total_amount', ascending=False).head(1) print(df6['total_amount'])

country_name
Brazil    441271.85
Name: total_amount, dtype: float64

# RESOLUCIÓN df8=(my_df.groupby('article_name').sum()).sort_values('total_amount', ascending=True).head(1) print(df8['total_amount'])

article_name
Sata Cable    564.96
Name: total_amount, dtype: float64

# RESOLUCIÓN df9 = my_df[(my_df['country_name']=='Brazil')&(my_df['article_name']=='Full Pc')] sns.scatterplot(y='seller_name', x='total_amount', data=df9)