天猫商品评论区爬虫+词云分析

import re import json s = 'jsonp1615({"rateDetail":{"rateCount":{"total":94609,"shop":0,"picNum":17525,"used":9274},"rateDanceInfo":{"storeType":4,"currentMilles":1560969325750,"showChooseTopic":false,"intervalMilles":3570029000},"rateList":[{"auctionPicUrl":"","userInfo\ ":"","displayRatePic":"","dsr":0,"displayRateSum":0,"appendComment":{"commentId":0,"days":0,"reply":"","commentTime":"2019-06-18 15:40:07","pics":[],"content":"保温时间长，肚子很舒服"},"fromMemory":0,"picsSmall":[],"tmallSweetPic":"","rateDate"\ :"2019-06-18 15:37:53","rateContent":"宝贝收到了，加热无声音，样式也好，客服很有耐心。","fromMall":true,"userIdEncryption":"","sellerId":2386968451,"displayUserLink":"","id":1048536129286,"aliMallSeller":false,"reply":"","pics":["//img.alicdn.c\ om/bao/uploaded/i3/O1CN01ehkWod1wQowLtt2f7_!!0-rate.jpg","//img.alicdn.com/bao/uploaded/i1/O1CN01hH1smg1wQowMDGt3X_!!0-rate.jpg"],"buyCount":0,"userVipLevel":0,"auctionSku":"颜色分类:【细柔款】可拆洗 自动断电 静音充电 红色 三年换新","anony":fal\ se,"displayUserNumId":0,"goldUser":false,"attributesMap":null,"tradeEndTime":{"date":18,"hours":15,"seconds":26,"month":5,"timezoneOffset":-480,"year":119,"minutes":35,"time":1560843326000,"day":2},"headExtraPic":"","aucNumId":0,"displayUserNic\ k":"x***5","structuredRateList":[],"carServiceLocation":"","userVipPic":"","serviceRateContent":"","memberIcon":"","attributes":"","position":"","cmsSource":"天猫","tamllSweetLevel":0,"gmtCreateTime":{"date":18,"hours":15,"seconds":53,"month":5\ ,"timezoneOffset":-480,"year":119,"minutes":37,"time":1560843473000,"day":2},"useful":true,"displayUserRateLink":""},{"auctionPicUrl":"","userInfo":"","displayRatePic":"","dsr":0,"displayRateSum":0,"appendComment":null,"fromMemory":0,"picsSmall\ ":[],"tmallSweetPic":"","rateDate":"2019-06-18 15:37:01","rateContent":"暖水宝很好用","fromMall":true,"userIdEncryption":"","sellerId":2386968451,"displayUserLink":"","id":1048854783445,"aliMallSeller":false,"reply":"","pics":[],"buyCount":0,"u\ serVipLevel":0,"auctionSku":"颜色分类:【豪华长毛款】可拆洗 自动断电 静音充电 粉色 三年换新","anony":false,"displayUserNumId":0,"goldUser":false,"attributesMap":null,"tradeEndTime":{"date":18,"hours":15,"seconds":48,"month":5,"timezoneOffset":-4\ 80,"year":119,"minutes":36,"time":1560843408000,"day":2},"headExtraPic":"","aucNumId":0,"displayUserNick":"b***仔","structuredRateList":[],"carServiceLocation":"","userVipPic":"","serviceRateContent":"","memberIcon":"","attributes":"","position\ ":"","cmsSource":"天猫","tamllSweetLevel":0,"gmtCreateTime":{"date":18,"hours":15,"seconds":1,"month":5,"timezoneOffset":-480,"year":119,"minutes":37,"time":1560843421000,"day":2},"useful":true,"displayUserRateLink":""},{"auctionPicUrl":"","use\ rInfo":"","displayRatePic":"","dsr":0,"displayRateSum":0,"appendComment":null,"fromMemory":0,"picsSmall":[],"tmallSweetPic":"","rateDate":"2019-06-18 13:57:01","rateContent":"使用过一次，感觉还不错","fromMall":true,"userIdEncryption":"","seller\ Id":2386968451,"displayUserLink":"","id":1048370192787,"aliMallSeller":false,"reply":"","pics":[],"buyCount":0,"userVipLevel":0,"auctionSku":"颜色分类:【细柔款】可拆洗 自动断电 静音充电 红色 三年换新","anony":false,"displayUserNumId":0,"goldUse\ r":false,"attributesMap":null,"tradeEndTime":{"date":16,"hours":13,"seconds":37,"month":5,"timezoneOffset":-480,"year":119,"minutes":53,"time":1560664417000,"day":0},"headExtraPic":"","aucNumId":0,"displayUserNick":"玩***界","structuredRateList\ ":[],"carServiceLocation":"","userVipPic":"","serviceRateContent":"","memberIcon":"","attributes":"","position":"","cmsSource":"天猫","tamllSweetLevel":0,"gmtCreateTime":{"date":18,"hours":13,"seconds":1,"month":5,"timezoneOffset":-480,"year":1\ 19,"minutes":57,"time":1560837421000,"day":2},"useful":true,"displayUserRateLink":""},{"auctionPicUrl":"","userInfo":"","displayRatePic":"","dsr":0,"displayRateSum":0,"appendComment":null,"fromMemory":0,"picsSmall":[],"tmallSweetPic":"","rateDa\ te":"2019-06-18 13:09:23","rateContent":"电热宝非常好.并且质量也好.做工非常满意.客服有耐心.发货也快.","fromMall":true,"userIdEncryption":"","sellerId":2386968451,"displayUserLink":"","id":1048515501264,"aliMallSeller":false,"reply":"","pics":[]\ ,"buyCount":0,"userVipLevel":0,"auctionSku":"颜色分类:【豪华长毛款】可拆洗 自动断电 静音充电 粉色 三年换新","anony":false,"displayUserNumId":0,"goldUser":false,"attributesMap":null,"tradeEndTime":{"date":18,"hours":13,"seconds":13,"month":5,"ti\ mezoneOffset":-480,"year":119,"minutes":7,"time":1560834433000,"day":2},"headExtraPic":"","aucNumId":0,"displayUserNick":"g***0","structuredRateList":[],"carServiceLocation":"","userVipPic":"","serviceRateContent":"","memberIcon":"","attributes\ ":"","position":"","cmsSource":"天猫","tamllSweetLevel":0,"gmtCreateTime":{"date":18,"hours":13,"seconds":23,"month":5,"timezoneOffset":-480,"year":119,"minutes":9,"time":1560834563000,"day":2},"useful":true,"displayUserRateLink":""},{"auctionP\ icUrl":"","userInfo":"","displayRatePic":"","dsr":0,"displayRateSum":0,"appendComment":null,"fromMemory":0,"picsSmall":[],"tmallSweetPic":"","rateDate":"2019-06-18 11:55:11","rateContent":"质量一般般，与图片不符，这样的质量卖这样的价格偏贵了点\ ，要不是着急用，肯定会退货的！","fromMall":true,"userIdEncryption":"","sellerId":2386968451,"displayUserLink":"","id":1048676682095,"aliMallSeller":false,"reply":"","pics":[],"buyCount":0,"userVipLevel":0,"auctionSku":"颜色分类:【豪华长毛款】可\ 拆洗 自动断电 静音充电 粉色 三年换新","anony":true,"displayUserNumId":0,"goldUser":false,"attributesMap":null,"tradeEndTime":{"date":18,"hours":11,"seconds":31,"month":5,"timezoneOffset":-480,"year":119,"minutes":53,"time":1560830011000,"day":2\ },"headExtraPic":"","aucNumId":0,"displayUserNick":"蓝***纯","structuredRateList":[],"carServiceLocation":"","userVipPic":"","serviceRateContent":"","memberIcon":"","attributes":"","position":"","cmsSource":"天猫","tamllSweetLevel":0,"gmtCreate\ Time":{"date":18,"hours":11,"seconds":11,"month":5,"timezoneOffset":-480,"year":119,"minutes":55,"time":1560830111000,"day":2},"useful":true,"displayUserRateLink":""},{"auctionPicUrl":"","userInfo":"","displayRatePic":"","dsr":0,"displayRateSum\ ":0,"appendComment":null,"fromMemory":0,"picsSmall":[],"tmallSweetPic":"tmall-grade-t2-18.png","rateDate":"2019-06-18 11:14:32","rateContent":"****，垃圾物流。2、3年的老客户了，这次帮别人买了一个，结果东西放在目的地2天多了还没有收到货。售后、阳\ 光、后勤3个人轮番上阵，历史近24小时，除了废话，没有解决任何问题。缺乏培训，管理水平低下。快递把东西仍在菜鸟驿站，就不管了。我自己联系菜鸟驿站，结果那个菜鸟一开始就说没有那个包裹，废话了约5分钟，最后查了运单号，才说东西在他那里。浪费我的时间，还\ 态度恶劣。现在，东西还没有送到。先给差评。","fromMall":true,"userIdEncryption":"","sellerId":2386968451,"displayUserLink":"","id":1048349776509,"aliMallSeller":false,"reply":"","pics":[],"buyCount":0,"userVipLevel":0,"auctionSku":"颜色分类:【细\ 柔款】可拆洗 自动断电 静音充电 红色 三年换新","anony":true,"displayUserNumId":0,"goldUser":false,"attributesMap":null,"tradeEndTime":{"date":18,"hours":11,"seconds":19,"month":5,"timezoneOffset":-480,"year":119,"minutes":6,"time":1560827179000,\ "day":2},"headExtraPic":"","aucNumId":0,"displayUserNick":"h***3","structuredRateList":[],"carServiceLocation":"","userVipPic":"","serviceRateContent":"垃圾。","memberIcon":"","attributes":"","position":"","cmsSource":"天猫","tamllSweetLevel":2\ ,"gmtCreateTime":{"date":18,"hours":11,"seconds":32,"month":5,"timez