devbox
知新_RL
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Python采集电商平台商品数据进行可视化分析_电商数据可视化

作者：知新_RL | 2024-04-24 22:27:02

赞

踩

电商数据可视化

环境使用:
python 3.8 解释器

pycharm 编辑器

模块使用:
第三方模块 需要安装

requests —> 发送 HTTP请求
内置模块 不需要安装

csv —> 数据处理中经常会用到的一种文件格式
第三方模块安装:

win + R 输入cmd 输入安装命令 pip install 模块名 (如果你觉得安装速度比较慢, 你可以切换国内镜像源)

基本流程思路:
一. 数据来源分析

明确需求

明确采集网站以及数据

数据: 商品信息

抓包分析 --> 通过浏览器自带工具: 开发者工具

打开开发者工具: F12 / 右键点击检查选择network

刷新网页: 让网页数据重新加载一遍

搜索关键字: 搜索数据在哪里

找到数据包: 50条商品数据信息

整页数据内容: 120条 --> 分成三个数据包

前50条数据 --> 前50个商品ID

中50条数据 --> 中50个商品ID

后20条数据 --> 后20个商品ID

已知: 数据分为三组 --> 对比三组数据包请求参数变化规律

请求参数变化规律: 商品ID

分析找一下 是否存在一个数据包, 包含所有商品ID

如果想要获取商品信息 --> 先获取所有商品ID --> ID存在数据包

二. 代码实现步骤: 发送请求 -> 获取数据 -> 解析数据 -> 保存数据

第一次请求 --> 获取商品ID

发送请求, 模拟浏览器对于url地址发送请求

请求链接: 商品ID数据

获取数据, 获取服务器返回响应数据

开发者工具: response

解析数据, 提取我们想要的数据内容

商品ID

第二次请求 --> 获取商品信息

发送请求, 模拟浏览器对于url地址发送请求

请求链接: 商品信息数据包

获取数据, 获取服务器返回响应数据

开发者工具: response

解析数据, 提取我们想要的数据内容

商品信息

保存数据, 把信息保存本地文件 csv表格

多页数据采集

数据展示：  点击此处跳转获取测试链接

  1. {
  2. 	"item": {
  3. 		"num_iid": "652874751412",
  4. 		"title": "奶油风布艺沙发现代简约轻奢小户型客厅直排可拆洗沙发原木可定制",
  5. 		"desc_short": "",
  6. 		"price": 480,
  7. 		"total_price": "",
  8. 		"suggestive_price": "",
  9. 		"orginal_price": 480,
  10. 		"nick": "惜情yqq1127",
  11. 		"num": 1600,
  12. 		"detail_url": "https://item.taobao.com/item.htm?id=652874751412",
  13. 		"pic_url": "//gd1.alicdn.com/imgextra/i4/2568161054/O1CN01aYBriY1Jem9UDtt9e_!!2568161054.jpg",
  14. 		"brand": "#0 工厂",
  15. 		"brandId": "",
  16. 		"rootCatId": "",
  17. 		"cid": 50020632,
  18. 		"desc": "<div > \n   <div >\n    <img src=\"http://img.alicdn.com/imgextra/i3/2568161054/O1CN01LFmSOU1Jem9QOjMPb_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i3/2568161054/O1CN014vyOOT1Jem9DpHz3Y_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01B3PpsA1Jem9N8V7uf_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i2/2568161054/O1CN015JbyeY1Jem9MZshUt_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01HXSoxx1Jem9RvgzHN_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i3/2568161054/O1CN01IEultA1Jem9MdEx8R_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i3/2568161054/O1CN0176K98O1Jem9QOjE69_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i4/2568161054/O1CN013Pxp1O1Jem9RvgeTv_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01SfyZ8M1Jem9QOi1Gx_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i4/2568161054/O1CN01bb1POa1Jem9Sdgve2_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i3/2568161054/O1CN018Eo9dV1Jem9KV0y79_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01vuEofr1Jem9Nzy9xY_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i4/2568161054/O1CN01qw9sAi1Jem8wkNKpy_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01HeFhFw1Jem8rLnjBY_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i2/2568161054/O1CN01SNgjoi1Jem9QOil15_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i2/2568161054/O1CN01RXf3RA1Jem9DpHVwj_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i4/2568161054/O1CN01gZmZjt1Jem9ISThgm_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i2/2568161054/O1CN01YL0FHM1Jem9PQTjX9_!!2568161054.jpg\"  />\n    <img src=\"http://img.alicdn.com/imgextra/i4/2568161054/O1CN01UhsEhZ1Jem8yvJIhZ_!!2568161054.jpg\"  />\n   </div> \n  </div><img src=\"https://www.o0b.cn/i.php?t.png&rid=gw-1.65dec45204283&p=1778787400&k=81159&t=1709098066\" style=\"display:none\" />",
  19. 		"item_imgs": [
  20. 			{
  21. 				"url": "//gd1.alicdn.com/imgextra/i4/2568161054/O1CN01aYBriY1Jem9UDtt9e_!!2568161054.jpg"
  22. 			},
  23. 			{
  24. 				"url": "//gd3.alicdn.com/imgextra/i3/2568161054/O1CN01kjOfNb1Jem9DmWn8Y_!!2568161054.jpg"
  25. 			},
  26. 			{
  27. 				"url": "//gd1.alicdn.com/imgextra/i1/2568161054/O1CN01HoB9ha1Jem9DmWn8r_!!2568161054.jpg"
  28. 			},
  29. 			{
  30. 				"url": "//gd4.alicdn.com/imgextra/i4/2568161054/O1CN011PjP2P1Jem9MXEUFT_!!2568161054.jpg"
  31. 			},
  32. 			{
  33. 				"url": "//gd3.alicdn.com/imgextra/i3/2568161054/O1CN01KUfBFL1Jem9KTTMn1_!!2568161054.jpg"
  34. 			}
  35. 		],
  36. 		"item_weight": "",
  37. 		"post_fee": "",
  38. 		"freight": "",
  39. 		"express_fee": "",
  40. 		"ems_fee": "",
  41. 		"shipping_to": "",
  42. 		"video": {
  43. 			"url": "http://cloud.video.taobao.com/play/u/p/1/e/6/t/1/428224913062.mp4"
  44. 		},
  45. 		"sample_id": "",
  46. 		"props_name": "31480:14306495906:几人坐:脚踏90*60*48cm;31480:14306495907:几人坐:双人165*95*67cm;31480:14306495908:几人坐:三人210*95*67cm;31480:14306495909:几人坐:单人100*95*67cm;31480:21480914361:几人坐:四人位240*95*67cm;31480:21480914362:几人坐:大四人320*95*76cm;31480:1387571900:几人坐:3米贵妃沙发;31480:32527954:几人坐:定制尺寸;1627207:28321:颜色分类:乳白色 尺寸颜色可定制;1627207:28321:颜色分类:乳白色 尺寸颜色可定制;1627207:28321:颜色分类:乳白色 尺寸颜色可定制;1627207:28321:颜色分类:乳白色 尺寸颜色可定制;1627207:28321:颜色分类:乳白色 尺寸颜色可定制;1627207:28321:颜色分类:乳白色 尺寸颜色可定制;1627207:28321:颜色分类:乳白色 尺寸颜色可定制;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
  47. 		"prop_imgs": {
  48. 			"prop_img": [
  49. 				{
  50. 					"properties": "1627207:28321",
  51. 					"url": "//gd4.alicdn.com/imgextra/i1/2568161054/O1CN017GTZ4h1Jem9Qra1ap_!!2568161054.jpg"
  52. 				}
  53. 			]
  54. 		},
  55. 		"props_imgs": {
  56. 			"prop_img": [
  57. 				{
  58. 					"properties": "1627207:28321",
  59. 					"url": "//gd4.alicdn.com/imgextra/i1/2568161054/O1CN017GTZ4h1Jem9Qra1ap_!!2568161054.jpg"
  60. 				}
  61. 			]
  62. 		},
  63. 		"property_alias": "",
  64. 		"props": [
  65. 			{
  66. 				"name": "品牌",
  67. 				"value": "#0 工厂"
  68. 			},
  69. 			{
  70. 				"name": "型号",
  71. 				"value": "520"
  72. 			},
  73. 			{
  74. 				"name": "材质",
  75. 				"value": "木"
  76. 			},
  77. 			{
  78. 				"name": "木质材质",
  79. 				"value": "松木"
  80. 			},
  81. 			{
  82. 				"name": "面料",
  83. 				"value": "绒布"
  84. 			},
  85. 			{
  86. 				"name": "风格",
  87. 				"value": "北欧"
  88. 			},
  89. 			{
  90. 				"name": "几人坐",
  91. 				"value": "脚踏90*60*48cm 双人165*95*67cm 三人210*95*67cm 单人100*95*67cm 四人位240*95*67cm 大四人320*95*76cm 3米贵妃沙发 定制尺寸"
  92. 			},
  93. 			{
  94. 				"name": "颜色分类",
  95. 				"value": "乳白色"
  96. 			},
  97. 			{
  98. 				"name": "填充物",
  99. 				"value": "海绵"
  100. 			},
  101. 			{
  102. 				"name": "结构工艺",
  103. 				"value": "木质工艺"
  104. 			},
  105. 			{
  106. 				"name": "是否可定制",
  107. 				"value": "是"
  108. 			},
  109. 			{
  110. 				"name": "沙发组合形式",
  111. 				"value": "U形"
  112. 			},
  113. 			{
  114. 				"name": "是否可拆洗",
  115. 				"value": "是"
  116. 			},
  117. 			{
  118. 				"name": "适用对象",
  119. 				"value": "成年人"
  120. 			},
  121. 			{
  122. 				"name": "是否带储物空间",
  123. 				"value": "否"
  124. 			},
  125. 			{
  126. 				"name": "产地",
  127. 				"value": "上海"
  128. 			},
  129. 			{
  130. 				"name": "地市",
  131. 				"value": "上海市"
  132. 			},
  133. 			{
  134. 				"name": "区县",
  135. 				"value": "奉贤区"
  136. 			},
  137. 			{
  138. 				"name": "是否组装",
  139. 				"value": "否"
  140. 			},
  141. 			{
  142. 				"name": "出租车是否可运输",
  143. 				"value": "否"
  144. 			},
  145. 			{
  146. 				"name": "填充物硬度",
  147. 				"value": "软"
  148. 			},
  149. 			{
  150. 				"name": "款式定位",
  151. 				"value": "经济型"
  152. 			}
  153. 		],
  154. 		"total_sold": "-1",
  155. 		"skus": {
  156. 			"sku": [
  157. 				{
  158. 					"price": 480,
  159. 					"total_price": 0,
  160. 					"orginal_price": 480,
  161. 					"properties": "31480:14306495906;1627207:28321",
  162. 					"properties_name": "31480:14306495906:几人坐:脚踏90*60*48cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
  163. 					"quantity": 200,
  164. 					"sku_id": "4881047531343"
  165. 				},
  166. 				{
  167. 					"price": 1688,
  168. 					"total_price": 0,
  169. 					"orginal_price": 1688,
  170. 					"properties": "31480:14306495907;1627207:28321",
  171. 					"properties_name": "31480:14306495907:几人坐:双人165*95*67cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
  172. 					"quantity": 200,
  173. 					"sku_id": "4881047531344"
  174. 				},
  175. 				{
  176. 					"price": 2088,
  177. 					"total_price": 0,
  178. 					"orginal_price": 2088,
  179. 					"properties": "31480:14306495908;1627207:28321",
  180. 					"properties_name": "31480:14306495908:几人坐:三人210*95*67cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
  181. 					"quantity": 200,
  182. 					"sku_id": "4881047531345"
  183. 				},
  184. 				{
  185. 					"price": 968,
  186. 					"total_price": 0,
  187. 					"orginal_price": 968,
  188. 					"properties": "31480:14306495909;1627207:28321",
  189. 					"properties_name": "31480:14306495909:几人坐:单人100*95*67cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
  190. 					"quantity": 200,
  191. 					"sku_id": "4881047531346"
  192. 				},
  193. 				{
  194. 					"price": 2388,
  195. 					"total_price": 0,
  196. 					"orginal_price": 2388,
  197. 					"properties": "31480:21480914361;1627207:28321",
  198. 					"properties_name": "31480:21480914361:几人坐:四人位240*95*67cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
  199. 					"quantity": 200,
  200. 					"sku_id": "5039985183001"
  201. 				},
  202. 				{
  203. 					"price": 3188,
  204. 					"total_price": 0,
  205. 					"orginal_price": 3188,
  206. 					"properties": "31480:21480914362;1627207:28321",
  207. 					"properties_name": "31480:21480914362:几人坐:大四人320*95*76cm;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
  208. 					"quantity": 200,
  209. 					"sku_id": "5039985183002"
  210. 				},
  211. 				{
  212. 					"price": 3400,
  213. 					"total_price": 0,
  214. 					"orginal_price": 3400,
  215. 					"properties": "31480:1387571900;1627207:28321",
  216. 					"properties_name": "31480:1387571900:几人坐:3米贵妃沙发;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
  217. 					"quantity": 200,
  218. 					"sku_id": "5039984824000"
  219. 				},
  220. 				{
  221. 					"price": 3000,
  222. 					"total_price": 0,
  223. 					"orginal_price": 3000,
  224. 					"properties": "31480:32527954;1627207:28321",
  225. 					"properties_name": "31480:32527954:几人坐:定制尺寸;1627207:28321:颜色分类:乳白色 尺寸颜色可定制",
  226. 					"quantity": 200,
  227. 					"sku_id": "5039985183003"
  228. 				}
  229. 			]
  230. 		},
  231. 		"seller_id": "2568161054",
  232. 		"sales": 0,
  233. 		"shop_id": "567158267",
  234. 		"props_list": {
  235. 			"31480:14306495906": "几人坐:脚踏90*60*48cm",
  236. 			"31480:14306495907": "几人坐:双人165*95*67cm",
  237. 			"31480:14306495908": "几人坐:三人210*95*67cm",
  238. 			"31480:14306495909": "几人坐:单人100*95*67cm",
  239. 			"31480:21480914361": "几人坐:四人位240*95*67cm",
  240. 			"31480:21480914362": "几人坐:大四人320*95*76cm",
  241. 			"31480:1387571900": "几人坐:3米贵妃沙发",
  242. 			"31480:32527954": "几人坐:定制尺寸",
  243. 			"1627207:28321": "颜色分类:乳白色 尺寸颜色可定制"
  244. 		},
  245. 		"seller_info": {
  246. 			"nick": "惜情yqq1127",
  247. 			"item_score": 5,
  248. 			"score_p": 5,
  249. 			"delivery_score": 5,
  250. 			"shop_type": "",
  251. 			"user_num_id": "2568161054",
  252. 			"sid": null,
  253. 			"title": "",
  254. 			"zhuy": "https://shop567158267.taobao.com",
  255. 			"cert": null,
  256. 			"open_time": "",
  257. 			"credit_score": "tb-rank-blue:4",
  258. 			"shop_name": "现代布艺沙发"
  259. 		},
  260. 		"tmall": false,
  261. 		"error": "",
  262. 		"location": null,
  263. 		"data_from": "ha",
  264. 		"has_discount": "false",
  265. 		"is_promotion": "false",
  266. 		"promo_type": null,
  267. 		"props_img": {
  268. 			"1627207:28321": "//gd4.alicdn.com/imgextra/i1/2568161054/O1CN017GTZ4h1Jem9Qra1ap_!!2568161054.jpg"
  269. 		},
  270. 		"format_check": "ok",
  271. 		"desc_img": [
  272. 			"http://img.alicdn.com/imgextra/i3/2568161054/O1CN01LFmSOU1Jem9QOjMPb_!!2568161054.jpg",
  273. 			"http://img.alicdn.com/imgextra/i3/2568161054/O1CN014vyOOT1Jem9DpHz3Y_!!2568161054.jpg",
  274. 			"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01B3PpsA1Jem9N8V7uf_!!2568161054.jpg",
  275. 			"http://img.alicdn.com/imgextra/i2/2568161054/O1CN015JbyeY1Jem9MZshUt_!!2568161054.jpg",
  276. 			"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01HXSoxx1Jem9RvgzHN_!!2568161054.jpg",
  277. 			"http://img.alicdn.com/imgextra/i3/2568161054/O1CN01IEultA1Jem9MdEx8R_!!2568161054.jpg",
  278. 			"http://img.alicdn.com/imgextra/i3/2568161054/O1CN0176K98O1Jem9QOjE69_!!2568161054.jpg",
  279. 			"http://img.alicdn.com/imgextra/i4/2568161054/O1CN013Pxp1O1Jem9RvgeTv_!!2568161054.jpg",
  280. 			"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01SfyZ8M1Jem9QOi1Gx_!!2568161054.jpg",
  281. 			"http://img.alicdn.com/imgextra/i4/2568161054/O1CN01bb1POa1Jem9Sdgve2_!!2568161054.jpg",
  282. 			"http://img.alicdn.com/imgextra/i3/2568161054/O1CN018Eo9dV1Jem9KV0y79_!!2568161054.jpg",
  283. 			"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01vuEofr1Jem9Nzy9xY_!!2568161054.jpg",
  284. 			"http://img.alicdn.com/imgextra/i4/2568161054/O1CN01qw9sAi1Jem8wkNKpy_!!2568161054.jpg",
  285. 			"http://img.alicdn.com/imgextra/i1/2568161054/O1CN01HeFhFw1Jem8rLnjBY_!!2568161054.jpg",
  286. 			"http://img.alicdn.com/imgextra/i2/2568161054/O1CN01SNgjoi1Jem9QOil15_!!2568161054.jpg",
  287. 			"http://img.alicdn.com/imgextra/i2/2568161054/O1CN01RXf3RA1Jem9DpHVwj_!!2568161054.jpg",
  288. 			"http://img.alicdn.com/imgextra/i4/2568161054/O1CN01gZmZjt1Jem9ISThgm_!!2568161054.jpg",
  289. 			"http://img.alicdn.com/imgextra/i2/2568161054/O1CN01YL0FHM1Jem9PQTjX9_!!2568161054.jpg",
  290. 			"http://img.alicdn.com/imgextra/i4/2568161054/O1CN01UhsEhZ1Jem8yvJIhZ_!!2568161054.jpg"
  291. 		],
  292. 		"shop_item": [],
  293. 		"relate_items": []
  294. 	},
  295. 	"error": "",
  296. 	"secache": "4ad7ad2480af253fec9c2fd4daa266bb",
  297. 	"secache_time": 1709098066,
  298. 	"secache_date": "2024-02-28 13:27:46",
  299. 	"translate_status": "",
  300. 	"translate_time": 0,
  301. 	"language": {
  302. 		"default_lang": "cn",
  303. 		"current_lang": "cn"
  304. 	},

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/知新_RL/article/detail/481866
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号