Today we bring to your attention the analytics (research) of alcoholic beverages of the Lenta chain of stores (hereinafter - Lenta), which is in the catalog on the official website of the company.
Planning, preparation, sampling
Why did you choose alcoholic beverages and this company? Yes, everything is very simple - the first thing that came to mind (yes, it happens) and a large assortment of this segment. I think in the future there will be an analysis of the products of other companies. But back to our bottle research elements. Having previously studied the structure of the company's website itself, we come to the conclusion that the product catalog is dynamic depending on the location of the sales object and the change in the assortment. It was decided to take a sample in Moscow, in hypermarkets. Of course, without having accurate data on the assortment of the company's alcoholic products, one cannot say that it is representative, but we still believe that everything is ok. Having studied the number of units of products in the catalogs on the site by points of sale, we get that, on average, the same, here.
Analytics tools
senior data analyst - python 3+, pandas , BeautifulSoup, request, csv, lxml , seaborn, matplotlib, plotly , Anaconda, JupyterLab Jupyternotebook, google sheets( ) brain.
( !) - (). (python). - , - , - «» ( ). .
, , () . , 101 . Jupyter .
.csv , , .
, () . , ( ) “ ” , , , , . “” python . , strip() replace(), , ₽.
price \xa0 - , ( ). replace() astype(float) float .
describe() . 986.78 . , 631.59 .
c matplotlib , . 2400 , .
For an in-depth analysis, let's build a boxplot from the plotly library. Now we see that the overwhelming value of emissions starts from 2420 rubles. And the biggest release was Hennessy XO cognac for 16209 rubles. Using the sort_value () method, we find out the top five most expensive alcohol in the Ribbon.
Let me remind you that prices and assortment are dynamic, so everything can change every day.
Thank you for your attention, all the best, your konstatic.