基于大数据技术的照明灯具及用户体验可视化分析

Visualization Analysis of Lighting Fixtures and User Experience Based on Big Data Technology

摘要: 基于2022年京东照明灯具相关数据，采用搭建数据仓库，分析用户体验及灯具属性。初始表有商品搜索表、商品详细表、最近商品评论表，通过Python技术对数据就行去除空格，剔除脏数据及重复数据，运用Hadoop及Hive技术对数据解析，得到好评排行、用户评价关键词、用户体验反馈，并与网评进行比对，运用ECharts技术将数据以可视化的方式进行展示。论文从大数据技术角度，更加直观清晰地获取用户对灯具使用的满意度，进而判断灯具是否满足了提高生活质量的需求。

Abstract: Based on the relevant data of JD lighting fixtures in 2022, a data warehouse is established to analyze the user experience and the attributes of lighting. Initial tables include the product search table, the product detail table, the recent product review table. Using Python technology to remove spaces, dirty data and duplicate data on the data line. After the data is uploaded to the server and analyzed using Hadoop and Hive technology, positive reviews, user evaluation key- words, and user experience feedback are obtained. Compare with online reviews and use ECharts technology to visualize the data. From the perspective of big data technology, this paper more intuitively and clearly captures users’ satisfaction with the use of lighting fixtures, and then evaluates whether it meets the needs of improving quality of life.