Advanced-Data Analysis of Air Conditioner Distribution through E-Commerce Platform
Khushit Mehta1, Dr. Sunil Maggu2, Bhaskar Kapoor3
1 Student, Department of IT, Maharaja Agrasen Institute of Technology, Delhi INDIA
2Assistant Professor, Department of IT, Maharaja Agrasen Institute of Technology, Delhi INDIA
3Assistant Professor, Department of IT, Maharaja Agrasen Institute of Technology, Delhi INDIA
---------------------------------------------------------------------***---------------------------------------------------------------------
Abstract - Due to the rising temperatures and humidity along with a rise in income levels throughout the world as well as the growing acceptance of air conditioners as a utility and necessity rather than a luxury product, the air conditioning (AC) sector is predicted to see enormous development. A deeper Analysis of AC distribution over the E-Commerce platform is the main idea of this study. Platforms like Flipkart, and Amazon have shown tremendous growth. Various high-selling brands like Voltas Hitachi have shown top-level sales in both offline channels as well as online sales. Bluestar and Samsung have been giving fierce competition in online channels. The study started with gathering data from an E-Commerce platform by using web scraping tools. Once the data was collected it was cleaned using data cleaning tools of checking nan values and removing unnecessary data rows. The data visualisation of the case study of the Air Conditioner data on the Flipkart platform till December 2022 was performed and various plots like Bar-graph, Pie-chart, Histogram, Heatmap, etc. were plotted. Many parameters were taken into consideration like the number of reviews, star rating, and number of products of a particular brand, and results were obtained. Some key results are like in offline sales Voltas and Hitachi are market leaders with Bluestar and Samsung close behind. The number of products offered by number is provided by Voltas and Hitachi as well as giving customers a wide range of products to choose from. Overall, the customer seems satisfied because most of them have given 3.8 – 4.8 star ratings to the products. As technology advances, we’ll see an increase in the sales of products online grow many folds.
Key Words: AC, star rating, Voltas, Hitachi, E-Commerce, Flipkart