A data scientist is building a forecasting model for a retail company by using the most recent 5 years of sales records that are stored in a data warehouse. The dataset contains sales records for each of the company's stores across five commercial regions The data scientist creates a working dataset with StorelD. Region. Date, and Sales Amount as columns. The data scientist wants to analyze yearly average sales for each region. The scientist also wants to compare how each region performed compared to average sales across all commercial regions.
Which visualization will help the data scientist better understand the data trend?
The best visualization for this task is to create a bar plot, faceted by year, of average sales for each region and add a horizontal line in each facet to represent average sales. This way, the data scientist can easily compare the yearly average sales for each region with the overall average sales and see the trends over time. The bar plot also allows the data scientist to see the relative performance of each region within each year and across years. The other options are less effective because they either do not show the yearly trends, do not show the overall average sales, or do not group the data by region.
References:
pandas.DataFrame.groupby --- pandas 2.1.4 documentation
pandas.DataFrame.plot.bar --- pandas 2.1.4 documentation
Matplotlib - Bar Plot - Online Tutorials Library
Xuan
10 days agoDevora
17 days agoDean
8 days agoTenesha
25 days agoLuis
6 days agoBerry
7 days agoCassi
8 days agoMarvel
30 days agoPhuong
1 months agoAmira
3 days agoStefany
5 days agoLauran
6 days agoSarina
14 days agoJoseph
1 months agoDorthy
19 days agoClorinda
30 days agoBarney
1 months agoTruman
1 months agoMargery
1 months ago