口红数据分析及pyecharts可视化

最新推荐文章于 2024-01-17 09:04:58 发布

slaythedragon

最新推荐文章于 2024-01-17 09:04:58 发布

阅读量6.2k

点赞数 1

分类专栏： Python数据分析

本文链接：https://blog.csdn.net/kkill_youokk_/article/details/117386366

版权

Python数据分析专栏收录该内容

19 篇文章 12 订阅

订阅专栏

口红.ipynb

import pandas as pd 
import json
import gc

with open("./taobao.json", encoding='utf-8') as f:
    data = f.read()
data[:1000]

'[{\n  "img_url": "http://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2379306225/O1CN01kN44fC1vr67mvZCNG_!!0-item_pic.jpg",\n  "price": "108.00",\n  "location": "浙江 宁波",\n  "shop": "\\n\\n\\n\\n\\n\\nclubclio海外旗舰店\\n",\n  "shop_type": "淘宝",\n  "pay_nums": "28",\n  "title": "CLIO珂莱欧丝绒唇彩哑光唇釉雾感丝绒小红管口红唇膏",\n  "svolume": 0,\n  "evaluate": 0,\n  "product_name": "CLIO 雾面唇彩",\n  "brand": "\xa0CLIO",\n  "place": "\xa0韩国",\n  "color": "\xa001经典暗红色\xa002魅惑砖红色\xa003娇艳樱桃红\xa004耀眼橘红色\xa005温暖摩卡棕\xa006温柔粉棕色\xa007清新珊瑚粉\xa008甜美珊瑚红\xa009优雅柔粉色\xa010复古蔷薇紫\xa011无敌粉红\xa012南瓜棕橙\xa013织物棕红\xa014自然豆沙色",\n  "detail_url": "https://detail.tmall.com/item.htm?id=589776975867&ad_id=&am_id=&cm_id=140105335569ed55e27b&pm_id=&abbucket=9"\n},\n{\n  "img_url": "http://g-search1.alicdn.com/img/bao/uploaded/i4/i3/3943518676/O1CN01uM7vBb2DxesoDbm8v_!!0-item_pic.jpg",\n  "price": "99.00",\n  "location": "上海",\n  "shop": "\\n\\n\\n\\n\\n\\nkiko海外旗舰店\\n",\n  "shop_type": "淘宝",\n  "pay_nums": "235",\n  "title": "KIKO滋养润唇蜜充盈丰满保湿补水镜面水光透明唇蜜口红打底",\n  "svolume": 0,\n  "evaluate": 0,\n  "product_name": "KIKO 清透滋养润唇蜜",\n  "b'

# 调整数据格式，将数据中的\n、\\n、\xa0都换成空
data = data.replace("\n","").replace("\\n","").replace("\xa0","")
# json数据转化python数据
data = json.loads(data)
# 转化成dataframe数据
data = pd.DataFrame(data)
# 删除无用的列
data = data.drop(["detail_url","img_url","color"],axis=1)
data.head()

	brand	location	pay_nums	place	price	product_name	shop	shop_type	svolume	title
0	CLIO	浙江宁波	28	韩国	108.00	CLIO 雾面唇彩	clubclio海外旗舰店	淘宝	0	CLIO珂莱欧丝绒唇彩哑光唇釉雾感丝绒小红管口红唇膏
1	KIKO	上海	235	意大利	99.00	KIKO 清透滋养润唇蜜	kiko海外旗舰店	淘宝	0	KIKO滋养润唇蜜充盈丰满保湿补水镜面水光透明唇蜜口红打底
2	YSL/圣罗兰	江苏苏州	1208	法国	1280.00	YSL/圣罗兰纯口红 2	ysl圣罗兰美妆官方旗舰店	天猫		YSL圣罗兰释爱4支口红套装限定包装方管新色110/120七夕礼盒
3	Givenchy/纪梵希	上海	6500+	法国	690.00	None	givenchy纪梵希官方旗舰店	天猫		【七夕礼盒】GIVENCHY纪梵希小羊皮红丝绒n37 口红套装散粉香水
4	Christian Louboutin	浙江杭州	1786	美国	1760.00	Christian Louboutin 双支...	christianlouboutin美妆官方旗舰店	天猫		【七夕礼盒】Christian Louboutin女王权杖双支礼盒 cl萝卜丁口红

# 看一下所有的列
data.columns

Index(['brand', 'evaluate', 'location', 'pay_nums', 'place', 'price',
       'product_name', 'shop', 'shop_type', 'svolume', 'title'],
      dtype='object')

# 将缺失值换为0
data = data.replace("-","0")
for col in data.columns:
    print("*"*90)
    # 对每一列进行遍历，并且进行去重
    print(col,":",data[col].unique())

******************************************************************************************
brand : ['CLIO' 'KIKO' 'YSL/圣罗兰' 'Givenchy/纪梵希' 'Christian Louboutin' 'Dior/迪奥'
 'GIORGIO ARMANI/阿玛尼' 'TF' 'Watsons/屈臣氏' 'ZEESEA/滋色' 'Dior' '萝卜丁'
 'Lancome/兰蔻' '香奈儿' "L'OREAL /欧莱雅" '花西子' 'Tom Ford/汤姆福特' 'MAC/魅可' '亲茉'
 '迪奥' 'CARSLAN/卡姿兰' 'NEELAM/尼蓝' 'Estee Lauder/雅诗兰黛' 'KISSKYLIE/绮诗凯莉' '曼诗丽'
 'Maybelline/美宝莲' 'Guerlain/娇兰' 'Jimmy Choo' 'qaqv' 'CHARLOTTE TILBURY'
 '迪香儿' 'Sckiquen' '3CE/三熹玉' '靓琳' 'PERFECT DIARY/完美日记' 'Nars/娜斯'
 'Shu-uemura/植村秀' 'Gucci/古驰' 'SIXPALACE/六宫粉黛' 'Hermes/爱马仕' 'COLOUR FEEL'
 'Sephora/丝芙兰' 'CHIOTURE 稚优泉' 'unny club' 'UKISS/悠珂思' '鹤禧觉色' '韩熙贞' '乐在其中'
 '艾嘉儿' 'Dike Dior/迪可迪奥' 'ROMAND' 'vnk' '色彩主义' 'Gucci/古奇'
 'BOBBI BROWN/芭比波朗' 'bourjois/妙巴黎' '' 'COLOR KEY' 'AMORTALS/尔木萄'
 'CPB/肌肤之钥' 'SUQQU' 'go go tales' 'HOLD LIVE' 'JudydoLL/橘朵' 'Catkin/卡婷'
 'MARIE DALGAR/玛丽黛佳' '毛戈平' '润百颜' 'Revlon/露华浓' 'HEDONE #FASHION SNOBS'
 'Joocyee' 'OMGA' 'red earth/红地球' 'KATO' 'MYG/魅颜堂' 'MERENGUE' 'TTX'
 'Mentholatum/曼秀雷敦' 'ROVANCHY/洛梵诗' 'BURBERRY/博柏利' 'Mamonde/梦妆' '美康粉黛'
 'Girlcult' 'INTO YOU' 'physicians formula' '爱礼一万年' '梦华美' 'bareMinerals'
 'Tonymoly/托尼魅力' 'FLORMAR' 'Hourglass' 'Stage Q' 'canmake/井田' '戈戈舞' '碧奥泉'
 'Christian Dior/克里斯汀·迪奥' "A'PIEU" 'The Saem/得鲜' 'Cezanne/倩诗丽' 'CROXX（美妆）'
 'Clarins/娇韵诗' 'CEZANNE/倩丽' 'moongate' 'MAKE BOON' 'msekko/米可儿' 'Moontea'
 'sora club' 'BBIA/碧娥' '中后' '健美创研' 'Y－CID Make UP/施蒂'
 'MAKE UP FOR EVER/玫珂菲' 'Sunnies Face' 'ZARA' '柏迪芬' 'Hera/赫妍' 'Mistine'
 "Peach's Secret/半桃" '兰奕' 'color fans/迷色粉丝' 'guicami' 'FOCALLURE/菲鹿儿'
 'PECHOIN/百雀羚' 'mc one' 'HUDAMOJI' '璃沫嫣' '韩格丽' '资莱皙' 'Fresh/馥蕾诗'
 'Opera/娥佩兰' 'Laneige/兰芝' 'IPSA/茵芙莎' '阿芙' '一束红妍' 'PRAMY/柏瑞美' 'Hince'
 'BAZAAR RED' 'TF（美妆用品）' 'G FANCY/花色小蛋糕' '贝雅思' 'Too Faced'
 'pat mcgrath labs' 'WETCODE/水密码' '唯尚美' '透真' 'leezi/莉兹' '季肤爽' '圣·博蜜思'
 'IT-MAC' 'Herborist/佰草集' 'Lipstick Queen' 'Aekyung/爱敬' 'Sisley/希思黎'
 'FESINSO/花川秀' '天使的诱惑' "Burt's Bees" 'Qdsuh/巧迪尚惠' 'CHANDO/自然堂'
 'cocosiliya' 'The history of whoo/后' '咪玥乐妮' 'ROMAND/闵赛伦' '淘宝心选' 'Kemelo'
 '清平调' 'GEL MAGIC' '思尚' '肽润' 'Milani' 'LANSUR/兰瑟' 'HANYUL/韩律'
 'Skin Menu/肌肤之食' 'Clio/珂莱欧' 'JOANNE MISS/迪奥亚菲' 'manukabee/小蜜坊' '彩即'
 '迪奥·曼尼' 'Leosotoo/莱索兔' 'stila' 'moonseem/极地之悦' 'Easamia/依圣美'
 'Elizabeth Arden/雅顿' 'KAREN MURRELL' '柏蕊诗' '资泊丽' 'PERIPERA/菲丽菲拉' '迪奥拉'
 'MacLeod' 'GIORGIO  ARMANI' '恋意' 'MaxFactor/蜜丝佛陀' '相宜本草' '桃の夭夭' 'wis'
 'LEGEND AGE/传奇今生' 'geoskincare/纽西之谜' 'Cosme Decorte/黛珂' 'Doyes/朵雅而姿'
 'RVB' 'BY TERRY/泰芮' 'caremille/珂曼' 'Colorina Pro-Artist' 'CINDLAND/千迪兰'
 'Nico' '植荟露' 'NOVO（彩妆）' 'VLONCA/薇罗尼卡' 'cuicu/库库' 'Lime Crime' 'NYX' '纪梵希'
 '韩奈儿' '8EO' '雅歌' '4U2' 'CETTE FILLE' 'Urban Decay' 'NUDE by Nature'
 'LEVERCIL' 'Y.N.M' '御泥坊' '吴掌柜（美妆）' 'RAREKIND' 'WETN/温莛' 'DHC' 'JILL LEEN'
 'LIVING NATURE' 'Clinique/倩碧' 'ATORS' 'SNR/时千寻' 'Flower Knows' '妮可叮叮'
 '启咖' '和玺' 'cisow' 'ISENO/伊丝诺' 'Colorfans' 'CT' 'mannings/万宁' 'lolis/萝莉诗'
 '黛港颜' '3CEYES' 'MAMEW/麻美' '伊特娜' 'CL女王权杖萝卜丁' '欧碧芙' '正宫御品' 'THERA' '有兮（美妆）'
 'Ms.Miss/美诗蜜斯' 'XNIKE/秀妮可' '100% Pure' 'Shiseido/资生堂' 'romand（美妆）'
 'Koh Gen Do/江原道' 'CYBER COLORS/尚智色彩' 'sasatinnie' '透蜜' 'DEAO-MANI/迪奥·曼尼'
 'SUM37°/苏秘37°' 'LCHEAR/蕾琪' 'ulnconve/谙洛伊' 'Anna sui/安娜苏' 'BOM BIDI BOM'
 '墨绿森林' '她素' 'Lavera' 'Antipodes' '柳丝木']
******************************************************************************************
evaluate : [0 '1070' '9' '638' '252' '818' '5622' '1775' '4' '1671' '6935' '511'
 '247' '575' '3236' '1081' '6737' '2' '5229' '3735' '5756' '11833' '909'
 '510' '1267' '136' '267' '143' '2197' '266' '4542' '93' '491' '1477'
 '238' '7465' '525' '220' '5425' '940' '233' '634' '9694' '2232' '1542'
 '927' '578' '99' '8186' '2372' '1157' '7469' '549' '3023' '3831' '4606'
 '488' '17106' '1893' '1512' '8099' '455' '1050' '461' '268' '1294' '198'
 '1237' '1298' '21' '2820' '487' '2300' '51' '769' '26790' '2907' '817'
 '776' '86' '7577' '918' '10988' '2268' '8575' '3736' '356' '1620' '679'
 '281' '754' '230' '84' '2021' '1251' '0' '160' '14472' '3690' '1926'
 '18177' '17524' '151' '200' '13' '371' '1558' '2779' '4108' '54' '8797'
 '3566' '375' '1038' '261' '11' '1394' '260' '1216' '204' '1742' '121'
 '76' '4211' '593' '15' '821' '26883' '184' '1092' '797' '17768' '2322'
 '1928' '5324' '6976' '12234' '1510' '61225' '618' '3021' '381' '333'
 '110' '85' '175' '370' '23' '1' '33' '90' '40' '92' '154' '1828' '9844'
 '83' '47' '112' '768' '218' '42' '52' '124' '3' '101' '314' '134' '1138'
 '1825' '4678' '8301' '96' '10367' '631' '555' '484' '5341' '536' '132'
 '149' '39' '35' '58' '17' '16' '78' '8' '74' '1623' '153' '765' '14'
 '1180' '18696' '1841' '3441' '7' '2742' '3392' '1222' '4087' '3917' '95'
 '1959' '4527' '10' '244' '829' '2498' '5254' '508' '413' '1992' '1478'
 '2625' '691' '2223' '311' '243' '2726' '26' '8476' '141' '502' '4215'
 '10757' '72' '513' '2621' '678' '3626' '137' '5875' '18628' '5738' '785'
 '5547' '82' '7142' '29' '66' '3429' '294' '463' '20' '25' '80' '87'
 '1357' '258' '5' '27' '48' '1951' '483' '225' '65' '13263' '462' '466'
 '2167' '5494' '135' '186703' '163' '612' '392' '144' '3047' '579' '1052'
 '1871' '2539' '1978' '7910' '361' '2645' '270' '193' '3419' '4997' '36'
 '173091' '313' '590' '2036' '44' '19' '17422' '2531' '1310' '7757' '801'
 '2718' '1762' '3178' '155' '130' '185' '869' '183' '1334' '1073' '277'
 '15234' '211' '4219' '131' '1263' '860' '68508' '77470' '6575' '6454'
 '2752' '6184' '32' '681' '943' '394' '105' '158' '625' '1076' '556'
 '6452' '888' '228' '780' '221' '123' '1899' '8886' '3777' '811' '1119'
 '7189' '398' '6512' '5187' '1158' '738' '219' '2087' '37358' '543' '216'
 '916' '89' '8434' '1720' '568' '162' '106' '38' '5147' '213' '1611'
 '1003' '30148' '5168' '6717' '1880' '33048' '53' '4960' '108' '734' '174'
 '433' '3652' '8376' '6245' '4158' '642' '12599' '120' '147' '3322' '401'
 '11906' '1480' '576' '1902' '222' '119' '237' '71' '391' '1219' '41'
 '3567' '861' '156' '18' '61' '37359' '24' '195' '7338' '4924' '283'
 '2201' '843' '2739' '2495' '4273' '276' '675' '486' '7262' '46' '2947'
 '180' '1371' '1057' '55' '291' '385' '68' '2349' '1322' '3624' '383'
 '441' '115' '2411' '1182' '215' '326' '617' '516' '4391' '19401' '4438'
 '2694' '125' '3298' '274' '475' '2218' '100' '472' '199' '1016' '3911'
 '269' '3869' '347' '702' '190' '449' '4204' '67' '534' '60' '128' '1958'
 '615' '1416' '324' '69' '1607' '386' '342' '5767' '1238' '2808' '1195'
 '359' '878' '456' '1011' '5630' '292' '1358' '1927' '1326' '8431' '1072'
 '236' '542' '241' '835' '2922' '453' '2006' '318' '50' '411' '500' '802'
 '633' '1932' '7550' '63' '5351' '49' '346' '476' '8285' '2643' '2330'
 '4911' '8430' '6379' '719' '649' '186' '766' '1412' '2436' '1341' '2251'
 '842' '34' '3231' '308' '58479' '187' '323' '77' '737' '1921' '1515'
 '485' '22' '6493' '229' '1116' '94' '1853' '5597' '665' '30' '1656'
 '2509' '505' '366' '1320' '109' '1576' '4748' '1423' '967' '4577' '4677'
 '15956' '37' '8816' '961' '142' '5829' '12' '732' '1917' '2700' '1226'
 '73' '514' '114' '1099' '4187' '17128' '883' '548' '864' '2222' '1605'
 '995' '97' '24877' '2680' '439' '438' '349' '146' '189' '1695' '1272'
 '974' '396' '8482' '384' '624' '127' '3489' '272' '264' '217' '1705'
 '1565' '1643' '5121' '140' '3691' '116' '1348' '1311' '928' '14331' '966'
 '1264' '362' '4860' '231' '88' '79' '4780' '4808' '2266' '2302' '2422'
 '152' '3417' '133' '8024' '2360' '1091' '2212' '1760' '373' '2848' '746'
 '844' '1185' '847' '22280' '28' '816' '1167' '31363' '1993' '159' '2189'
 '956' '537' '1113' '358' '2013' '1085' '13975' '910' '616' '4418' '2503'
 '3629' '4885' '9056' '1304' '138' '946' '15981' '434' '416' '2089' '339'
 '1602' '350' '338' '1206' '779' '748' '1325' '89120' '181' '2333' '212'
 '254' '227' '1029' '4568' '2469' '1428' '202' '718' '273' '282' '2993'
 '3150' '2195' '203' '479' '2755' '2750' '15157' '1442' '3212' '1997'
 '983' '1501' '920' '5878' '406' '3022' '4729' '758' '1375' '170' '161'
 '499' '25664' '1069' '12709' '9354' '328' '1039' '778' '756' '5618'
 '12745' '1301' '2016' '3659' '312' '335' '1094' '20781' '939' '11841'
 '567' '1088' '932' '1438' '8557' '2626' '81' '1008' '7525' '762' '2858'
 '713' '722' '637' '2635' '178' '1173' '1064' '4092' '1799' '1400' '1446'
 '426' '481' '2484' '31' '1502' '572' '531' '523' '1019' '761' '113' '594'
 '934' '275' '2953' '70' '1546' '9491' '3213' '325' '559' '747']
******************************************************************************************
location : ['浙江 宁波' '上海' '江苏 苏州' '浙江 杭州' '广东 深圳' '浙江 台州' '广东 广州' '福建 泉州' '江苏 南通' '北京'
 '广东 佛山' '广东 惠州' '浙江 金华' '山东 青岛' '广东 东莞' '浙江 温州' '浙江 嘉兴' '河南 郑州' '江苏 南京'
 '四川 成都' '福建 厦门' '韩国' '辽宁 沈阳' '湖南 长沙' '河北 石家庄' '河北 沧州' '天津' '安徽 合肥'
 '福建 福州' '浙江 丽水' '河北 衡水' '江苏 无锡' '江西 新余' '浙江 绍兴' '江苏 徐州' '辽宁 大连' '广东 汕头'
 '香港 香港岛' '广东 潮州' '黑龙江 牡丹江' '山东 济宁' '海南 三亚' '云南 西双版纳' '广东 珠海' '香港 新界'
 '福建 莆田' '广东 中山' '黑龙江 哈尔滨' '香港 九龙' '辽宁 营口' '四川 宜宾' '山东 淄博' '江西 抚州' '重庆'
 '湖北 武汉' '湖北 黄石' '美国' '福建 漳州' '安徽 安庆' '山东 威海' '山东 济南' '江苏 常州' '日本' '安徽 芜湖'
 '海南 海口' '新西兰' '澳大利亚' '湖南 株洲' '泰国' '辽宁 盘锦' '吉林' '广东 清远' '荷兰' '山东 烟台' '加拿大'
 '江西 上饶' '山东 聊城']
******************************************************************************************
pay_nums : ['28' '235' '1208' '6500+' '1786' '2.0万+' '9000+' '1.5万+' '669' '370' '33'
 '152' '158' '12' '5000+' '8500+' '1280' '345' '2384' '1.0万+' '3394' '150'
 '4.5万+' '1805' '4204' '' '703' '8.5万+' '3182' '1100' '3380' '9.0万+'
 '1706' '6000+' '5500+' '49' '1145' '1476' '2743' '3477' '755' '3756' '50'
 '441' '1556' '993' '34' '1005' '5.5万+' '2.5万+' '333' '1337' '431' '3069'
 '1412' '60' '1165' '280' '1060' '1032' '1143' '8.0万+' '463' '84' '4105'
 '127' '136' '389' '353' '3580' '835' '717' '10万+' '1170' '156' '1228'
 '3.0万+' '4894' '4208' '3848' '2463' '2080' '557' '1842' '1925' '1421'
 '9500+' '7500+' '7000+' '918' '3885' '513' '673' '788' '591' '1175' '186'
 '242' '961' '583' '211' '94' '72' '341' '108' '4.0万+' '834' '80' '187'
 '58' '2' '1736' '548' '4804' '2244' '2961' '683' '549' '873' '4515'
 '2262' '879' '445' '3.5万+' '423' '297' '3940' '2139' '1622' '674' '471'
 '574' '560' '243' '128' '378' '2540' '132' '90' '57' '20' '1167' '10'
 '15' '25' '363' '9' '607' '1367' '3504' '1792' '1010' '25万+' '4578'
 '1795' '151' '1749' '2933' '797' '205' '1588' '1543' '1927' '3701' '1931'
 '711' '2691' '1781' '2600' '1424' '349' '684' '1259' '190' '16' '680'
 '400' '176' '104' '188' '35' '208' '21' '14' '7' '714' '1403' '422'
 '2352' '871' '4250' '480' '1450' '4199' '406' '255' '1946' '1072' '2216'
 '1402' '3154' '409' '498' '4163' '4520' '1249' '3604' '4670' '65' '516'
 '93' '78' '335' '86' '307' '318' '100' '26' '40' '48' '18' '36' '6' '23'
 '63' '820' '64' '2012' '1183' '214' '47' '1725' '517' '32' '79' '122' '4'
 '8' '3' '24' '5' '322' '1654' '589' '1873' '845' '2269' '2353' '2001'
 '1493' '177' '355' '1013' '1463' '3662' '3338' '2377' '195' '221' '272'
 '71' '245' '22' '41' '1008' '418' '215' '183' '3651' '842' '994' '3826'
 '686' '533' '497' '3140' '650' '4817' '4255' '987' '925' '1926' '2666'
 '1241' '605' '2682' '1387' '504' '204' '405' '616' '2667' '2678' '346'
 '273' '1144' '106' '31' '259' '193' '241' '469' '148' '1999' '772' '1096'
 '1576' '1907' '1547' '1312' '2380' '218' '4431' '4486' '1454' '1257'
 '336' '320' '1600' '1724' '1054' '988' '2974' '4091' '945' '1607' '408'
 '140' '1663' '2590' '2056' '779' '833' '160' '2074' '52' '181' '416'
 '512' '74' '11' '38' '88' '17' '56' '1239' '1040' '521' '139' '443' '554'
 '1499' '617' '135' '1942' '129' '230' '302' '604' '351' '291' '645'
 '2588' '198' '303' '576' '175' '374' '732' '1773' '147' '1155' '590'
 '983' '1676' '425' '2166' '1046' '4631' '3024' '4178' '874' '585' '308'
 '1506' '1365' '661' '109' '191' '309' '55' '13' '69' '4789' '216' '1963'
 '42' '823' '2831' '613' '179' '1929' '142' '700' '1612' '2114' '865' '39'
 '266' '2247' '315' '73' '99' '1414' '144' '2241' '1044' '2188' '2469'
 '555' '854' '2198' '124' '716' '599' '1834' '164' '37' '523' '332' '2525'
 '30' '384' '185' '75' '2554' '340' '984' '795' '468' '414' '76' '760'
 '1509' '4087' '487' '1426' '4238' '385' '488' '1074' '377' '924' '609'
 '173' '220' '731' '223' '1092' '805' '1383' '499' '559' '1377' '799'
 '254' '558' '4155' '665' '1446' '317' '1204' '630' '4706' '101' '882'
 '70' '3280' '3941' '107' '46' '61' '2753' '240' '754' '438' '514' '0'
 '51' '278' '3877' '371' '3196' '43' '118' '121' '2539' '19' '3716' '651'
 '379' '2451' '219' '327' '453' '426' '45' '562' '321' '624' '979' '1238'
 '1051' '358' '515' '253' '312' '908' '769' '1441' '1091' '2213' '1475'
 '687' '102' '682' '689' '564' '350' '289' '3542' '228' '1844' '261'
 '2044' '976' '2091' '4147' '1056' '829' '436' '194' '2379' '114' '610'
 '87' '2392' '898' '110' '489' '786' '721' '1505' '105' '143' '98' '125'
 '577' '294' '134' '8000+' '741' '2515' '1085' '538' '759' '212' '111'
 '2834' '391' '551' '159' '646' '641' '950' '519' '528' '244' '926' '444'
 '957' '306' '1789' '522' '971' '4095' '419' '3461' '277' '933' '541'
 '1168' '4369' '123' '452' '654' '763' '163' '699' '1567' '268' '744'
 '685' '3311' '1965' '912' '27' '279' '146' '771' '457' '2077' '1133'
 '162' '1928' '1382' '116' '1342' '707' '77' '328' '229' '881' '199' '367'
 '866' '644' '305' '360' '209' '182' '410' '569' '601' '1681' '392' '2163'
 '1250' '1126' '424' '1438' '1733' '217' '2918' '252' '324' '456' '368'
 '790' '1119' '180' '660' '342' '97' '662' '1203' '653' '347' '561' '210'
 '178' '96' '447' '869' '83' '518' '167' '2632' '166' '1190' '314' '362'
 '1174' '1299' '921' '1185' '95' '891' '196' '29' '1730' '992' '910' '635'
 '92' '1678' '701' '112' '2186' '765' '1127' '203' '595' '1033' '2784'
 '395' '1069' '153' '168' '283' '796' '2643' '1804' '145' '292' '621' '1'
 '1716' '59' '131' '784' '663' '236' '3668' '1135' '344' '566' '720' '859'
 '4060' '895' '249' '54' '231' '53' '1379' '1529' '2661' '500' '2398'
 '596' '774' '1186' '1794' '2584' '1996' '417' '1949' '1311' '3072' '399'
 '1636' '1169' '542' '2200' '224' '664' '722' '2093' '225' '1189' '1225'
 '137' '1418' '1243' '952' '1471' '1583' '3027' '546' '3446' '311' '2585'
 '213' '130' '2257' '200' '2367' '828' '2041' '875' '103' '226' '1374'
 '1009' '1231' '67' '3158' '1608' '1333' '1522' '838' '1878' '2064' '2368'
 '1655' '1584' '1115' '119' '1627' '334' '943' '1319' '354' '381' '326'
 '149' '657' '44' '365' '251' '906' '509' '455' '433' '232' '745' '1240'
 '1968' '375' '1156' '1469' '369' '1347' '520' '1093' '1045' '1293' '296'
 '295' '2521' '930' '337' '1016' '91' '155' '343' '727' '85' '120' '3825'
 '1210' '82' '138' '352' '1411' '568' '1519' '454' '239' '1030' '2180'
 '1485' '348' '201' '506' '1267' '1043' '299' '165' '1487' '117' '2306'
 '154' '1626' '265' '2271' '1012' '767' '286' '62' '364' '1001' '556'
 '1709' '1160' '207' '275' '809' '1192' '126' '493' '383' '1615' '486'
 '636' '411' '695' '171' '503' '694' '647' '667' '270' '524' '1138' '3052'
 '531' '446' '1316' '459' '2070' '728' '1202' '449' '316' '1742' '113'
 '451' '2112' '285' '157']
******************************************************************************************
place : ['韩国' '意大利' '法国' '美国' '中国' '比利时' '加拿大' '爱尔兰' '日本' '德国' '其他/other' '' '英国'
 '香港特别行政区' '泰国' None '新西兰' '瑞士' '澳大利亚' '荷兰']
******************************************************************************************
price : ['108.00' '99.00' '1280.00' '690.00' '1760.00' '880.00' '138.00' '345.00'
 '155.00' '259.00' '310.00' '239.93' '236.22' '109.00' '640.00' '320.00'
 '788.00' '588.00' '39.90' '49.90' '175.00' '598.00' '270.00' '1438.00'
 '349.00' '330.00' '120.00' '129.00' '145.00' '450.00' '128.00' '180.00'
 '549.00' '235.00' '277.00' '298.00' '520.00' '208.00' '278.00' '908.00'
 '143.00' '308.00' '89.00' '2029.00' '95.00' '233.48' '170.00' '166.00'
 '136.00' '1000.00' '340.00' '218.00' '135.00' '335.00' '248.00' '238.00'
 '115.00' '198.00' '628.00' '848.00' '193.00' '210.00' '190.00' '148.00'
 '213.00' '159.00' '569.00' '359.00' '1138.00' '229.00' '785.00' '168.00'
 '129.90' '499.00' '288.00' '279.00' '139.00' '29.00' '240.00' '518.00'
 '86.00' '1498.00' '408.00' '260.00' '149.00' '324.00' '219.00' '69.00'
 '269.00' '669.00' '110.00' '840.00' '133.00' '165.00' '228.00' '496.00'
 '268.00' '300.00' '178.00' '285.00' '188.00' '59.90' '315.00' '59.00'
 '485.00' '158.00' '160.00' '478.00' '140.00' '1807.20' '318.00' '99.90'
 '618.00' '159.90' '249.00' '299.00' '150.00' '232.20' '589.00' '383.00'
 '398.00' '388.00' '396.00' '379.00' '211.00' '338.00' '488.00' '76.00'
 '90.00' '118.00' '258.00' '280.00' '599.00' '365.00' '65.00' '199.00'
 '245.00' '239.00' '319.00' '750.00' '49.00' '45.00' '457.20' '940.00'
 '265.00' '109.90' '250.20' '259.20' '44.90' '79.00' '1060.80' '69.90'
 '273.00' '156.00' '185.00' '125.00' '610.00' '179.00' '1079.00' '998.75'
 '215.05' '119.00' '289.00' '555.00' '558.00' '77.00' '205.00' '142.00'
 '126.00' '302.00' '64.00' '895.00' '88.00' '230.00' '648.00' '117.00'
 '98.00' '471.17' '195.00' '162.00' '96.00' '255.00' '39.00' '2048.00'
 '675.00' '209.00' '192.00' '197.00' '169.00' '111.00' '130.00' '58.00'
 '1388.00' '226.00' '545.00' '54.00' '19.80' '233.00' '400.00' '224.00'
 '348.00' '27.00' '48.00' '49.80' '79.90' '56.00' '563.00' '418.00'
 '290.00' '80.00' '1199.00' '69.80' '41.90' '685.00' '233.47' '68.00'
 '79.80' '87.00' '93.00' '513.84' '145.99' '223.20' '187.20' '34.90'
 '358.00' '785.40' '1288.00' '33.20' '487.20' '64.90' '539.00' '157.00'
 '228.42' '438.00' '39.80' '469.00' '106.00' '134.00' '368.00' '709.00'
 '232.00' '53.00' '173.00' '18.00' '25.65' '26.00' '366.00' '234.00'
 '35.00' '78.00' '35.90' '637.20' '52.00' '55.00' '997.20' '85.00'
 '225.00' '200.00' '42.00' '498.00' '19.90' '455.00' '325.00' '12.00'
 '9.90' '5.90' '267.75' '399.00' '19.00' '316.00' '18.90' '508.30'
 '183.00' '30.80' '38.00' '32.00' '137.00' '102.00' '590.00' '595.00'
 '81.00' '73.60' '220.00' '415.90' '28.80' '8.90' '40.00' '51.00' '62.00'
 '525.00' '60.00' '112.00' '74.00' '291.00' '89.90' '269.10' '97.00'
 '275.00' '25.00' '410.00' '46.90' '67.86' '92.00' '503.00' '17.00'
 '1258.00' '63.00' '698.00' '48.90' '529.00' '29.90' '75.00' '28.50'
 '415.00' '479.00' '215.00' '548.00' '25.90' '136.62' '46.80' '360.00'
 '6.20' '600.00' '277.20' '251.00' '44.00' '33.00' '23.00' '868.00'
 '24.90' '243.00' '148.57' '41.80' '103.00' '139.80' '146.00' '105.00'
 '1490.00' '194.00' '1069.00' '176.00' '33.50' '15.80' '376.00' '154.00'
 '33.90' '3.90' '27.90' '903.00' '143.50' '458.00' '108.80' '8.50'
 '152.00' '268.80' '5.50' '29.99' '186.00' '568.00' '189.00' '48.80'
 '32.90' '45.80' '18.60' '316.80' '74.90' '6.90' '38.80' '207.00' '22.80'
 '81.79' '1788.00' '58.50' '172.00' '62.80' '20.00' '140.90' '30.10'
 '508.00' '116.00' '149.90' '69.91' '67.00' '57.60' '2640.00' '100.00'
 '47.00' '21.90' '343.00' '557.20' '47.90' '758.00' '201.00' '650.00'
 '30.00']
******************************************************************************************
product_name : ['CLIO 雾面唇彩' 'KIKO 清透滋养润唇蜜' 'YSL/圣罗兰 纯口红 2' None
 'Christian Louboutin 双支...' 'Christian Louboutin 克里...'
 'Dior/迪奥 烈艳蓝金唇膏唇膏/口红' 'Givenchy/纪梵希 高定香榭...'
 'GIORGIO ARMANI/阿玛尼 臻致丝绒哑光唇釉' 'TF 皇家系列口红' 'GIORGIO ARMANI/阿玛尼 臻...'
 'YSL/圣罗兰 小金条纯口红' 'GIORGIO ARMANI/阿玛尼 挚...' 'Christian Louboutin 萝卜...'
 'ZEESEA 轻雾感哑光唇釉' 'ZEESEA 雾感丝绒唇膏' 'Dior 迪奥口红全新烈艳蓝金唇膏' '萝卜丁 女王权杖口红'
 'Lancome/兰蔻 菁纯丝绒雾...' 'Dior/迪奥 烈焰蓝金唇膏' 'Dior/迪奥 全新烈艳蓝金唇膏'
 '香奈儿 炫亮魅力唇膏丝绒系...' '香奈儿 可可小姐炫光唇膏' '花西子 花隐星穹口红' 'Lancome/兰蔻 菁纯丝绒雾面唇膏'
 'Tom Ford/汤姆福特 烈焰幻...' 'MAC/魅可 丝缎柔雾唇膏' 'Christian Louboutin 女王权杖口红唇膏'
 '香奈儿 炫亮魅力唇膏丝绒系列' '亲茉 迪可迪奥口红' 'Chanel/香奈儿 炫亮魅力唇膏唇膏/口红' 'Dior/迪奥 魅惑釉唇膏'
 'YSL/圣罗兰 纯口红' 'Tom Ford/汤姆福特 柔雾缎...' '花西子 花雾迷蝶口红'
 'Christian Louboutin 女王权杖口红' 'MAC/魅可 显色丰润唇膏' 'Dior/迪奥 烈艳蓝金挚红美...'
 'Armani/阿玛尼 臻致丝绒哑光唇釉' 'MAC/魅可 子弹头唇膏当季...' '香奈儿 炫亮魅力柔雾唇膏' '香奈儿 魅力炫光唇釉'
 'MAC/魅可 闪亮星泽唇膏' 'Tom Ford/汤姆福特 琉璃 ...' 'Tom Ford/汤姆福特 璀璨幻...' '迪奥 烈焰蓝金唇膏'
 'Dior/迪奥 魅惑星耀唇膏(...' 'Dior/迪奥 金艳幻彩唇膏' 'MAC/魅可 子弹头口红' 'YSL/圣罗兰 细管纯口红'
 'MAC/魅可 子弹头唇膏口红' 'Armani/阿玛尼 至美诱惑唇膏 - # 400 Four Hundred'
 'Dior/迪奥 魅惑超模唇膏' "L'OREAL /欧莱雅 欧莱雅..." 'Lancome/兰蔻 兰蔻菁纯柔润唇膏'
 'YSL/圣罗兰 小金条口红' 'YSL/圣罗兰 方管口红' 'Christian Louboutin 萝卜丁丝绒口红唇膏'
 'CARSLAN/卡姿兰 雾吻唇膏' 'MAC/魅可 液体丝缎柔雾唇...' '香奈儿 炫亮魅力唇膏丝绒'
 'Lancome/兰蔻 菁纯莹亮纯...' 'NEELAM/尼蓝 国潮风口红礼...' 'Givenchy/纪梵希 高级定制小羊皮口红'
 'EMPORIO ARMANI/阿玛尼 红管唇釉' 'Estee Lauder/雅诗兰黛 雅...' 'Dior/迪奥 烈艳蓝金美唇膏'
 'Estee Lauder/雅诗兰黛 倾...' 'YSL/圣罗兰 莹亮纯魅唇膏' 'YSL/圣罗兰 天鹅绒唇釉3' '曼诗丽 红鸾心动口红礼盒'
 '香奈儿 COCO小姐唇膏' 'MAC/魅可 子弹头唇膏' 'CARSLAN/卡姿兰 小红唇美...' 'CARSLAN/卡姿兰 金致胶原...'
 'MAC/魅可 时尚唇膏' 'MAC/魅可 丝缎柔雾 唇膏' 'Guerlain/娇兰 臻彩宝石唇膏'
 'GIORGIO ARMANI/阿玛尼 阿...' 'CHARLOTTE TILBURY 哑光唇...' 'YSL/圣罗兰 圆管口红'
 'TF 黑金黑管唇膏' 'Sckiquen 胡萝卜素健康唇膏' 'Tom Ford 黑金唇膏'
 'Tom Ford/汤姆福特 礼盒 4支黑管唇膏口红礼盒装' '3CE/三熹玉 丝绒唇釉' 'Estee Lauder/雅诗兰黛 唇...'
 'YSL/圣罗兰 迷魅纯漾唇膏' 'MAC/魅可 MAC经典唇膏' 'Tom Ford/汤姆福特 琉光幻...'
 'YSL/圣罗兰 迷魅唇膏唇膏/口红' 'Givenchy/纪梵希 禁忌之吻...' 'MAC/魅可 时尚口红'
 'CARSLAN/卡姿兰 水吻唇膏' 'CARSLAN/卡姿兰 唇爱密语...' 'Tom Ford/汤姆福特 烈焰幻魅唇膏 TF黑管'
 'GIORGIO ARMANI/阿玛尼 丝滑唇膏' 'Chanel/香奈儿 炫亮魅力唇...' '靓琳 迪奥曼妮口红'
 'YSL/圣罗兰 纯净唇膏' 'Christian Louboutin 小萝卜丁女王的权杖口红' 'PERFECT DIARY/完美日记 ...'
 'Nars/娜斯 72色 魔方唇膏' 'Dior/迪奥 烈艳蓝金精粹唇膏' '香奈儿 炫亮魅力唇膏限量版'
 'Givenchy/纪梵希 高定香榭天鹅绒唇膏' 'Dior/迪奥 烈艳蓝金' '迪奥 烈艳蓝金唇膏促销装组合'
 'GIORGIO ARMANI/阿玛尼 持...' 'Shu-uemura/植村秀 无色...'
 'Tom Ford/汤姆福特 Lip Color唇膏' 'Gucci/古驰 奢华滋润显色口红' '香奈儿 可可小姐 炫光唇膏'
 'GIORGIO ARMANI/阿玛尼 漆...' 'Lancome/兰蔻 菁纯柔润唇膏' 'MAC/魅可 液体柔雾唇膏'
 'MAC/魅可 妆前底唇膏' 'Tom Ford/汤姆福特 TF 口...' 'YSL/圣罗兰 迷魅纯漾润唇膏'
 'Tom Ford/汤姆福特 TF细黑...' 'YSL/圣罗兰 亮泽滋润唇膏' 'MAC/魅可 水漾润泽唇膏唇膏/口红'
 'GIORGIO ARMANI/阿玛尼 小...' 'YSL/圣罗兰 黑管镜光唇釉' '香奈儿 炫亮魅力柔雾唇釉'
 'Tom Ford/汤姆福特 TF限量色唇膏' 'SIXPALACE/六宫粉黛 锦绣...'
 'Christian Louboutin Roug...' 'YSL/圣罗兰 纯口红N' 'Lancome/兰蔻 菁纯柔润丝绒唇膏'
 'COLOUR FEEL 锦服口红8支装...' '香奈儿 炫亮魅力丝绒唇膏' '靓琳 ΙYSL方管口红' 'YSL/圣罗兰 莹亮纯魅唇膏...'
 'Sephora/丝芙兰 滋润唇膏' 'CHIOTURE 稚优泉 方管雾镜...' 'YSL/圣罗兰 纯口红细管'
 'YSL/圣罗兰 黑桃夹心纯魅...' '3CE/三熹玉 3CE唇釉' 'COLOUR FEEL 传统锦服口红...'
 'Guerlain/娇兰 臻彩宝石盈亮唇膏' 'unny(美妆) unny（美妆） muse lip口红' 'unny（美妆） 悠宜炫彩乐章唇釉'
 'GIORGIO ARMANI/阿玛尼 唇...' 'MAC/魅可 MAC唇膏love me' 'Armani/阿玛尼 持色红管唇膏口红'
 'Tom Ford/汤姆福特 黑管口红' 'UKISS/悠珂思 午后果茶轻釉唇膏' 'ZEESEA 水漾丝柔唇膏' '3ce 唇彩'
 'TF 黑金唇膏' 'MAC/魅可 限量版子弹头' 'CHIOTURE 稚优泉 琉光之镜...' 'Givenchy/纪梵希 高定香榭丝缎唇膏'
 'Dior/迪奥 魅惑唇膏' 'Nars/娜斯 敢耀唇膏' "L'OREAL /欧莱雅 纷泽丰..." '鹤禧觉色 荷包口红六支套装'
 '韩熙贞 纯臻丝绒哑光唇釉' 'Dior/迪奥 魅惑润唇蜜' 'Shu-uemura/植村秀 全新无色限唇膏'
 'YSL/圣罗兰 全新圣罗兰细管轻雾纯口红4' 'unny（美妆） 柔润吻感唇釉' 'NARS/纳斯 纵欲惹火口红'
 '乐在其中 星闪植物水润唇膏' 'unny club 黑方口红' 'CARSLAN/卡姿兰 霓幻变色...'
 'UKISS/悠珂思 星之彼端水诱唇釉' 'ysl/圣罗兰 莹亮唇膏' 'Dior/迪奥 2018秋冬限量红管唇膏'
 'qaqv IT-MAC紫管口红' 'YSL/圣罗兰 黑管唇釉' 'MAC/魅可 柔雾唇釉' '香奈儿 炫亮魅力 柔雾唇膏'
 '香奈儿 炫亮魅力唇膏 丝绒...' 'Christian Louboutin 金管...' 'YSL/圣罗兰 全新圣罗兰细...'
 '艾嘉儿 中国风魁色口红' 'Dior/迪奥 烈艳蓝金唇膏唇...' 'Dike Dior/迪可迪奥 烈焰魅惑唇膏'
 'CHIOTURE 稚优泉 轻吻柔雾...' "L'OREAL /欧莱雅 纷泽滋..." 'ROMAND 果汁唇釉'
 'GIORGIO ARMANI/阿玛尼 红...' 'Estee Lauder/雅诗兰黛 花漾唇膏水晶系列' 'MAC/魅可 哑光子弹头'
 'YSL/圣罗兰 YSL圣罗兰奶茶...' 'vnk 悦慕圆管口红' 'Dior/迪奥 粉漾诱惑润唇膏' 'CARSLAN/卡姿兰 盈彩唇膏'
 'ZEESEA 星钻柔雾唇膏' '色彩主义 双色黑唇膏' 'MAC/魅可 清新唇釉' 'Dior/迪奥 魅惑星耀唇膏'
 'KIKO 小黑管耀色口红' '香奈儿 可可小姐唇膏' 'Tom Ford/汤姆福特 LIP COLOR' 'Gucci/古奇 雾面哑光口红'
 'CARSLAN/卡姿兰 诱吻心机...' 'givenchy/纪梵希 魅力唇膏' 'PERFECT DIARY/完美日记'
 'MAC/魅可 柔感哑光唇膏' 'Estee Lauder/雅诗兰黛 雅诗兰黛花漾倾慕丰唇膏' 'Dior/迪奥 魅惑口红'
 'Givenchy/纪梵希 禁忌之吻唇膏黑管' 'YSL/圣罗兰 莹亮纯魅口红' 'bobbi brown/波比布朗 柔润唇膏'
 'Armani/阿玛尼 柔润红唇膏' 'MAC/魅可 磨砂唇釉' 'BOBBI BROWN/芭比波朗 纯色金管唇膏'
 'Estee Lauder/雅诗兰黛 倾慕唇膏魅色系列' 'Guerlain/娇兰 臻彩宝石限量唇膏' 'bourjois/妙巴黎 天鹅绒彩唇釉'
 'CHARLOTTE TILBURY HOT LIPS唇膏' 'ysl/圣罗兰 柔润唇膏' '' '汤姆？福特 Private Blend唇膏'
 '鹤禧觉色 荷包口红礼盒装' 'Christian Louboutin 口红唇膏' 'COLOR KEY 上镜必备唇釉 丝绒'
 'AMORTALS/尔木萄 星漾甜心变色唇膏' 'CPB/肌肤之钥 CPB肌肤之钥...' 'GIORGIO ARMANI/阿玛尼 琉...'
 'vnk 晶冻唇情丝滑口红' 'KIKO 哑光小金管口红' 'SUQQU 丰盈光泽唇膏' 'go go tales 小白管丝绒唇...'
 'Nars/娜斯 纵欲惹火唇膏' 'Lancome/兰蔻 新菁纯莹亮纯色唇膏' 'HOLD LIVE 持久空气唇釉' 'dior/迪奥 诱惑唇彩'
 'JudydoLL/橘朵 橘朵晶冻唇...' 'CHIOTURE 稚优泉 粉色之恋...' 'YSL/圣罗兰 金圆管迷魅亮彩滋润唇膏'
 'Catkin/卡婷 轻颜唇釉' 'ZEESEA 臻润奢缎唇膏' 'CARSLAN/卡姿兰 轻甜唇爱...' 'KIKO 哑光柔雾口红'
 'CHARLOTTE TILBURY 枕边话...' 'MARIE DALGAR/玛丽黛佳 浓...' 'ROMAND 唇釉'
 'Shu-uemura/植村秀 全新...' 'BOBBI BROWN/芭比波朗 限...' '毛戈平 跃龙点韵丰润唇膏'
 'Tom Ford/汤姆福特 LIPS&BOYS黑金限量唇膏' 'Dior/迪奥 瘾诱超模唇膏（银管）' '3CE/三熹玉 三熹玉浓郁哑...'
 'CARSLAN/卡姿兰 丝绒唇膏' 'qaqv 迪奥亚菲口红' 'Givenchy/纪梵希 禁忌之吻唇膏唇膏/口红'
 'JudydoLL/橘朵 小鸟迷你唇...' 'CHIOTURE 稚优泉 方管雾镜哑光口红' 'Revlon/露华浓 丽采炫亮唇...'
 'Givenchy/纪梵希 高级定制唇膏' 'HEDONE #FASHION SNOBS 冰闪星光唇蜜' 'Joocyee 柔感纯色唇膏'
 'BOBBI BROWN/芭比波朗 至...' 'Catkin/卡婷 点绛唇口红' 'Lancome/兰蔻 迷恋唇膏'
 'Givenchy/纪梵希 高定香榭丰唇膏' 'STYLENANDA 3CE 口红' 'KIKO 闪耀假日丝绒口红'
 'red earth/红地球 丝柔倾心唇膏' 'KATO 白噪声丝绒柔雾唇釉' 'MYG/魅颜堂 钻石琉金口红套盒' '3ce 哑光雾面唇膏'
 'chanel/香奈儿 水之吻唇膏' 'Gucci/古奇 极致水润唇膏' 'Mentholatum/曼秀雷敦 什...'
 'Tom Ford/汤姆福特 tf细黑...' '香奈儿 炫亮魅力印记唇釉'
 'CARSLAN/卡姿兰 金致胶原美芯唇膏超级萌熊乐园限量版(II)' 'ROVANCHY/洛梵诗 花蕊柔雾...'
 'BOBBI BROWN/芭比波朗 纯...' 'BURBERRY/博柏利 之吻漆光唇釉' 'vnk 光感晶透水光唇釉'
 'Guerlain/娇兰 臻彩宝石液体唇膏M69' 'Mamonde/梦妆 花心唇膏' 'Guerlain/娇兰 亲亲唇膏'
 'MERENGUE 黑白管口红12支' 'Revlon/露华浓 丽采唇膏' 'Girlcult 乌托邦系列口红'
 'physicians formula 黄油口红' 'Dior/迪奥 烈艳蓝金唇彩唇彩/唇蜜' 'MAC/魅可 哑光唇膏'
 'GIORGIO ARMANI/阿玛尼 黑管唇釉' 'CHIOTURE 稚优泉 绒情迷雾哑光唇釉' '鹤禧觉色 牡丹口红'
 'YSL/圣罗兰 圣罗兰唇膏' '梦华美 炫彩恒润不沾杯口红' 'COLOR KEY 空气唇釉丝绒系列' 'MERENGUE 星座口红'
 'bareMinerals 矿物柔亮裸色...' 'FLORMAR 丝绒口红' 'ROMAND 水光唇彩' 'Hourglass 细管口红'
 'Stage Q 施婷姬蔻持久染色...' 'canmake/井田 高保湿防晒持久滋润唇膏' '戈戈舞 go go tales 印记少女唇膏'
 '碧奥泉 胡萝卜素健康口红唇...' 'JudydoLL/橘朵 炫色纷泽细管唇膏' 'ROMAND 哑光口红'
 'Christian Dior/克里斯汀·迪奥 蓝金口红' 'KIKO KIKO口红' "A'PIEU 水漾极光光彩染唇液唇釉"
 'BOBBI BROWN/芭比波朗 炙...' 'The Saem/得鲜 爱可按钮唇...' 'Estee Lauder/雅诗兰黛 绝...'
 'HEDONE #FASHION SNOBS 蝶...' 'JudydoLL/橘朵 炫彩纷泽唇...' 'COLOR KEY 空气唇釉'
 'Shu-uemura/植村秀 新无色限柔雾唇膏' 'canmake/井田 Melty Lumi...'
 'Mentholatum/曼秀雷敦 水...' 'MARIE DALGAR/玛丽黛佳 国...' 'ROMAND --零丝绒唇釉'
 'Dior/迪奥 烈焰蓝金唇膏口红' 'canmake/井田 甜蜜奶油光泽美容液精华保湿唇膏' 'Cezanne/倩诗丽 高保湿唇膏'
 'Shu-uemura/植村秀 无色限唇膏' 'CROXX（美妆） 银蚀孤品丝...' 'NARS 时尚经典唇膏'
 'CEZANNE/倩丽 润彩裸色唇膏' 'moongate 十二星座口红' 'ROVANCHY/洛梵诗 花蕊绒情...'
 'Dior/迪奥 蓝星唇膏' 'MAKE BOON 黄金小烟管口红' 'CHIOTURE 稚优泉 釉光口红...'
 'Catkin/卡婷 念奴娇唇釉' 'BOBBI BROWN/芭比波朗 悦...' '3CE/三熹玉 雾面丝绒唇釉'
 'msekko/米可儿 米糠滋养倍...' 'Dior/迪奥 魅惑唇彩' '3ce Tinted Lip Balm'
 'sora club 水晶糖光唇釉' 'bbia 丝绒口红' 'CEZANNE/倩丽 高保湿唇膏' '健美创研 滋润保湿唇膏'
 'Y－CID Make UP/施蒂 滋养...' 'MAKE UP FOR EVER/玫珂菲...' 'Sunnies Face 哑光唇膏'
 'Givenchy/纪梵希 深层性感唇膏 # 306 Carmin Escarpin' 'Estee Lauder/雅诗兰黛 魅惑唇膏'
 'lancome/兰蔻 金纯玫瑰唇膏' 'CHIOTURE 稚优泉 天空之镜...' '乔治阿玛尼 夜惑亮泽唇彩'
 'COLOUR FEEL 传统锦服口红' '柏迪芬 克诗迪奥口红' 'CHIOTURE 稚优泉 微光水雾...'
 'Hourglass Confession Lip...' 'Hera/赫妍 赫妍魅感辛彩裸...' 'Mistine 草莓变色唇膏'
 'BOBBI BROWN/芭比波朗 lu...' 'cle de peau beaute/肌肤...'
 "Peach's Secret/半桃 半..." 'CHIOTURE 稚优泉 冬季恋曲唇妆礼盒' 'CPB/肌肤之钥 水晶光透唇...'
 '韩熙贞 半熟期待水光唇釉' '毛戈平 丝柔雅致唇膏' '兰奕 雪花大理石纹柔润口红' 'color fans/迷色粉丝 出色...'
 'PERFECT DIARY/完美日记 倾色慕光唇膏' 'GIORGIO ARMANI/阿玛尼 L...'
 'Hourglass Confession Red...' 'Hourglass GIRL LIP STYLO'
 'Nars/娜斯 NARS 唇膏' 'YSL/圣罗兰 唇釉' 'dior/迪奥 丰彩唇膏' 'FOCALLURE/菲鹿儿 菲鹿儿...'
 'GIORGIO ARMANI/阿玛尼 臻致丝绒哑光唇釉红管' 'Mamonde/梦妆 花心丝绒唇...'
 'PECHOIN/百雀羚 悦色岩彩...' 'mc one 丝绒奢润按压口红' 'HUDAMOJI 璀璨柔雾口红' '璃沫嫣 口红'
 'Givenchy/纪梵希 高定香榭红丝绒唇膏' '韩格丽 萝卜丁权杖口红' '资莱皙 五彩缤纷唇釉' 'Sckiquen 倾心盈润唇膏'
 'Dior/迪奥 全新烈艳蓝金唇...' 'Fresh/馥蕾诗 澄糖滋润护...' 'Opera/娥佩兰 滋润唇膏'
 'CARSLAN/卡姿兰 自然印记唇膏' 'Laneige/兰芝 琉璃晶彩唇...' 'IPSA/茵芙莎 魅色唇膏'
 'CPB/肌肤之钥 奢华艳光订...' '阿芙 精油之吻润色唇膏' '一束红妍 植物三色口红' 'MAC/魅可 哑光磨砂唇膏'
 'PRAMY/柏瑞美 小金灵口红' 'Hince 气质提升口红' 'BAZAAR RED 丝绒亚光唇膏' '美康粉黛 东方美色丝雾唇膏'
 '韩熙贞 尤雾玩家哑光唇釉' '贝雅思 芦荟果冻温变口红' 'UKISS/悠珂思 午夜迷魅丝...' 'Dior/迪奥 瘾诱超模漆光黑管唇膏'
 'CPB/肌肤之钥 花漾盈采丰...' 'INTO YOU 心慕与你女主角致哑致雾唇颊两用唇泥' 'Too Faced 液液融情哑光唇...'
 'ROMAND 零感哑光口红' 'pat mcgrath labs 丝绒雾面...' 'WETCODE/水密码 轻盈丝绒...'
 '透真 光采魅色唇膏' '毛戈平 丝柔雅致唇膏·梅' '季肤爽 口红雨衣' '圣·博蜜思 传奇今生红樱桃...'
 'canmake/井田 啞緻蠟筆唇...' 'IT-MAC 哑光滋养口红' 'Herborist/佰草集 悦.溢...'
 'Catkin/卡婷 颐和园百鸟朝...' 'CHARLOTTE TILBURY 星色唇...' '乐在其中 乐在其中冰雾哑光唇釉'
 'Aekyung/爱敬 水晶口红' 'Sisley/希思黎 魅惑唇膏口...' 'CHIOTURE 稚优泉 琉光之镜水光唇釉'
 'FESINSO/花川秀 花川秀丝...' '天使的诱惑 黑钻丰盈三色口红' '3ce DANGEROUS MATTE LIP COLOR'
 'Qdsuh/巧迪尚惠 粉嘟嘟唇...' 'Nars/娜斯 纳斯 魔方唇膏' 'CHANDO/自然堂 凝色饱满雾...'
 'cocosiliya 迪奥亚菲美颜滋润口红' 'The history of whoo/后 ...' 'HOLD LIVE 幽兰之情唇釉'
 '3ce 唇膏' 'COLOR KEY colorkey空气唇...' 'The Saem/得鲜 按压口红'
 'canmake/井田 唇部专业遮...' 'Maybelline/美宝莲 纵情耀...' 'NARS 唇膏'
 'PERFECT DIARY/完美日记 星动臻色金钻唇膏' '资莱皙 亚光雾面口红套盒' '淘宝心选 淘宝心选柔滑滋润...'
 'Kemelo 蜜恋维他命口红' 'Christian Louboutin 女王...' '清平调 红蓝花口红' 'MAC/魅可 棒棒糖唇釉'
 'Mistine 大草莓唇膏' 'GEL MAGIC KOSE高丝 口红护...' 'CLIO 珂莱欧小黑跟烈焰丝绒...'
 '资莱皙 炫彩烟管口红' '阿芙 玫瑰之吻幻彩润唇膏' '思尚 花漾纷泽魅色口红' '肽润 摩登女神口红'
 'chanel/香奈儿 山茶花四色唇膏盒(限量)' 'Milani 超显色滋润口红' 'Watsons/屈臣氏 骨胶原花...'
 'CHIOTURE 稚优泉 无惧幻想绒雾唇釉' 'LANSUR/兰瑟 真丝π·丝柔...' 'Dior/迪奥 全新魅惑唇膏'
 'BOBBI BROWN/芭比波朗 芭...' 'HANYUL/韩律 宛如自然唇膏' '美康粉黛 醉美东方唇膏丝绒'
 'Skin Menu/肌肤之食 温感...' 'Clio/珂莱欧 小黑跟烈焰丝...' 'manukabee/小蜜坊 无色润...'
 'Sisley/希思黎 漾泽美唇笔' '彩即 奢耀哑光柔雾唇釉' '迪奥·曼尼 口红' 'Hourglass Confession? U...'
 'The Saem/得鲜 清清甜蜜干...' 'manukabee/小蜜坊 无色唇...' 'Leosotoo/莱索兔 萌想灵润...'
 '韩熙贞 纯臻耀色唇釉' 'PERFECT DIARY/完美日记 倾色慕光唇膏3支装' '美康粉黛 凤舞牡丹丝绒唇釉'
 "L'OREAL /欧莱雅 纷泽滋润唇膏" 'Easamia/依圣美 纯魅丝绒...' 'KAREN MURRELL 孕妇口红'
 '肽润 守护系列云雾唇釉' 'YSL/圣罗兰 镜光唇釉' 'BURBERRY/博柏利 丝绒雾彩液体唇膏' '柏蕊诗 鱼子酱雾缎唇膏'
 'Cezanne/倩诗丽 潤彩唇膏' 'CEZANNE/倩丽 金管口红' 'KIKO 丝绒奶油口红' 'vnk 绒情挚爱唇妆限定礼盒'
 '资泊丽 极致魅色雾感唇膏' 'PERIPERA/菲丽菲拉 菲丽菲...' 'go go tales 印记少女唇膏'
 'Catkin/卡婷 点绛唇唇膏' 'L＇oreal/欧莱雅 纷泽琉光...' 'sephora/丝芙兰 养护丰盈4色唇膏'
 'Gucci/古奇 奢华滋养唇膏' '淘宝心选 唇釉*2' 'MacLeod 诗格妮卡慕斯绒情口红' 'JudydoLL/橘朵 恒彩魅泽唇...'
 'Chanel/香奈儿 ROUGE COCO 可可小姐唇膏' 'GIORGIO ARMANI 臻致丝绒哑光唇釉'
 'COLOR KEY 幻彩星动唇膏' '恋意 恒彩护色雨衣口红' 'go go tales 云朵雾色唇釉'
 'Christian Dior/克里斯汀·迪奥 魅惑唇膏' 'Estee Lauder/雅诗兰黛 花漾唇膏炫慕' '相宜本草 丝绒柔光滋润唇膏'
 '桃の夭夭 桃之夭夭甚于惊色...' 'Mamonde/梦妆 花心唇膏笔' '3ce MOOD RECIPE MATTE LI...'
 'wis 迷恋口红' '曼秀雷敦什果冰润唇膏-柠檬' 'LEGEND AGE/传奇今生 红樱桃健康唇膏' '兰奕 悦颜固色雨衣口红'
 'geoskincare/纽西之谜 3g...' 'Cosme Decorte/黛珂 黛珂...' 'Doyes/朵雅而姿 金钻奢耀...'
 'BY TERRY 水滴轻触口红' 'INTO YOU 心慕与你独行系列...' 'Mistine 小草莓唇膏'
 'CHARLOTTE TILBURY 摩登雾...' 'Sunnies Face 丝滑薄雾哑光...'
 'caremille/珂曼 珂曼水润...' 'PERFECT DIARY/完美日记 完美日记 沁色微光水唇釉*'
 'bourjois/妙巴黎 天鹅绒彩...' 'PERFECT DIARY/完美日记 至臻柔色丝绒唇釉'
 'Colorina Pro-Artist 丝雾...' 'qaqv 迪奥·曼妮口红' 'Dior/迪奥 瘾诱超模唇膏'
 'CINDLAND/千迪兰 纯臻丝绒...' 'Nico 琉光奢润唇膏' 'MARIE DALGAR/玛丽黛佳 异...'
 'MAC/魅可 裸色唇膏' 'PRAMY/柏瑞美 无极雾色唇...' 'CPB/肌肤之钥 绝色唇釉' 'Lancome/兰蔻 菁纯丝绒柔雾唇釉'
 '植荟露 小金条口红' 'NOVO 奶油冰淇淋丝绒唇釉' 'MYG/魅颜堂 哑光口红' 'VLONCA/薇罗尼卡 玫瑰精油...'
 'Lime Crime 独角兽唇釉' 'NYX 液体哑光唇釉' 'KIKO 4系小黑管当季潮色' '韩奈儿 VE恒润温变唇膏'
 '8EO 623249324456' 'CHARLOTTE TILBURY CT哑光...' 'Clarins/娇韵诗 漆光丰盈...'
 'Too Faced（美国） 蜜桃之...' '雅歌 绝色唇釉' '4U2 唇釉' 'ysl/圣罗兰 纯漾唇彩'
 "L'OREAL /欧莱雅 恒放溢..." 'Urban Decay 口红' 'nars 唇彩' 'Givenchy/纪梵希 禁忌之吻'
 'sora club 迷雾丝绒哑光唇釉' 'JudydoLL/橘朵 JudydoLL/...' '碧奥泉 健康果冻口红' 'CLIO 水漾染唇露'
 'NUDE by Nature 丝绒哑光幻...' 'Maybelline/美宝莲 绝色持久丝绒哑光轻雾唇釉'
 'KIKO LUMINOUS CHROME LIPSTICK' 'LEVERCIL Levercil倾慕持色...' '肽润 守护系列琉光唇釉'
 'Y.N.M 变色唇膏' '御泥坊 挚爱红天然唇膏' '吴掌柜（美妆） 炫彩植物口红' '曼诗丽 口红' '毛戈平 云汐灿金唇膏'
 'RAREKIND 渐变哑光丝绒口红' 'RAREKIND 精彩碰撞闪亮口红' 'Colorina Pro-Artist 06915'
 'DHC 变色唇膏' 'JILL LEEN 雾色哑光唇釉' 'KAREN MURRELL km有机口红'
 'LIVING NATURE Lipstick口...' 'Revlon/露华浓 持久滋润唇膏' 'Clinique/倩碧 撞色小方雾...'
 'ATORS 小羽毛雾感唇釉-橘...' 'SNR/时千寻 兰蔻口红' 'Flower Knows 泰迪熊雾感口红'
 'Cezanne/倩诗丽 滋润光泽...' '妮可叮叮 魅力润彩温变口红' '启咖 雕花口红套盒' 'Tom Ford/汤姆福特 mini口红'
 'KIKO 亮彩水润唇膏' 'Maybelline/美宝莲 绝色持...' 'MAC/魅可 POP LIP STICK'
 'L＇oreal/欧莱雅 丝柔CC轻...' '和玺 和玺探花口红' 'cisow 保湿滋润口红' 'ISENO/伊丝诺 雾感哑光唇...'
 '雅歌 果冻口红1' 'PERFECT DIARY/完美日记 完美日记 恒色轻慕唇釉' 'Colorfans 出色高定丝绒唇膏'
 'Watsons/屈臣氏 骨胶原丝...' 'KIKO 双头唇釉' 'mannings/万宁 蜂王浆润唇...'
 'mannings/万宁 KH MLY士多...' 'canmake/井田 高保湿唇膏口红' 'lolis/萝莉诗 健康果萃水晶唇膏'
 "L'OREAL /欧莱雅 纷泽溢..." '黛港颜 好气色柔润唇膏' 'EMPORIO ARMANI/阿玛尼 小胖丁'
 'Armani/阿玛尼 全效补水唇彩 - # 402 Rouge' 'KIKO 明彩双头唇釉当季热门'
 'Mistine amour口红3.4g/...' 'MAMEW/麻美 保湿润唇口红' "L'OREAL /欧莱雅 雾感唇..."
 'PRAMY/柏瑞美 淡彩口红' '欧碧芙 红鸾心动口红礼盒' '兰奕 口红雨衣固色修护液'
 'PERFECT DIARY/完美日记 雾色梦境哑光唇釉' 'Mistine 5号6号7号' '正宫御品 云起龙翔丝绒口红'
 'THERA 五效合一口红' 'Ms.Miss/美诗蜜斯 黄金宇...' 'XNIKE/秀妮可 梦回盛唐口...'
 'KIKO 托斯卡纳阳光滋润口红' '100% Pure 燃情丝润红石榴...' 'FLORMAR 黑管口红'
 'Hera/赫妍 魅感小辣椒丰盈...' '淘宝心选 饿了么口红' 'CLIO 珂莱欧柔雾细管唇膏' 'KIKO 夏季限定海蓝天堂哑光...'
 'canmake/井田 高保湿口红' 'Christian Louboutin 萝卜丁女王权杖唇膏口红'
 'Maybelline/美宝莲 巨持色...' 'KIKO 万有引力甜心蜜吻口红' 'Koh Gen Do/江原道 限量柔...'
 'Guerlain/娇兰 亲亲唇釉' 'CYBER COLORS/尚智色彩 C...' 'PERIPERA/菲丽菲拉 墨水持...'
 'sasatinnie 香港限定情怀之...' '透蜜 柔润持色唇膏' 'NUDE by Nature 滋润水亮口...'
 'bareMinerals 矿物3D丰唇液...' '淘宝心选 信号口红' 'Nars/娜斯 敢耀唇膏 Anit...'
 'SUM37°/苏秘37° 苏秘...' 'NUDE by Nature 水亮口红' 'LCHEAR/蕾琪 慕色高光水唇...'
 'Tom Ford/汤姆福特 白管口红' 'HOLD LIVE 慕斯绒情口红（...' 'NUDE by Nature 丝绒口红'
 'KAREN MURRELL 新西兰口红' 'ZEESEA/滋色 轻雾感哑光唇...' 'KIKO 魔法假日丝滑奶油口红'
 'KIKO 魔法假日柔雾哑光唇膏' 'YSL/圣罗兰 夹心圆管口红' '和玺 时空系列口红'
 'Christian Louboutin 挚爱...' 'ulnconve/谙洛伊 谙洛伊u...' '润百颜 润百颜柔缎雾面唇釉'
 '润百颜 润百颜水光丰盈润唇...' 'vnk 助攻告白唇妆礼盒' 'CARSLAN/卡姿兰 轻甜唇爱随心盒' '淘宝心选 淘宝心选柔润口红'
 'Revlon/露华浓 不脱色恒采唇蜜' 'Anna sui/安娜苏 丝绒蔷薇唇膏' '100% Pure 虹色丝绒可可脂...'
 'BOM BIDI BOM 雾感丝滑哑光唇膏' 'PERFECT DIARY/完美日记 至臻柔色丝绒唇釉迷你套组'
 'LEVERCIL 吃土色口红' 'go go tales 空气丝绒唇釉' '墨绿森林 小金条口红套装' '她素 奇幻柔雾丝滑唇膏'
 '一束红妍 魔法口红雨衣啫喱' 'Lavera 有机鲜艳口红' 'Christian Louboutin 唇釉唇彩' 'KIKO 水漾亮泽口红'
 'PRAMY/柏瑞美 无感锁色唇...' '润百颜 故宫口红面膜' 'Antipodes 天然有机口红' 'Clinique/倩碧 小方唇膏'
 '淘宝心选 口红1030' 'Mamonde/梦妆 双头蜡笔口红棒' 'Gucci/古驰 细管唇膏'
 'physicians formula 唇釉' 'red earth/红地球 水晶女...' '3CE/三熹玉 三熹玉丝绒唇...'
 'Shiseido/资生堂 沁色绚彩...' 'vnk 艺术管两支装礼盒' 'wis 魅惑口红' '柳丝木 柳丝木故宫口红女']
******************************************************************************************
shop : ['clubclio海外旗舰店' 'kiko海外旗舰店' 'ysl圣罗兰美妆官方旗舰店' 'givenchy纪梵希官方旗舰店'
 'christianlouboutin美妆官方旗舰店' '欧荻之家' '孓了孑' '阿玛尼美妆官方旗舰店' 'ajian0919'
 '屈臣氏官方旗舰店' '天猫国际进口超市' '天猫国际妙颜社' 'sanmen888' 'zeesea滋色旗舰店' 'yunhao831'
 '燕尾正品企业店' 'lancome兰蔻官方旗舰店' 'shirleysong525' 'tingyuelanfeng'
 'chanel香奈儿官方旗舰店' '花西子旗舰店' '星光贸易001' '杨鹏飞网银yl' 'tomford汤姆福特旗舰店'
 '331217wqr' 'mac魅可官方旗舰店' '金品数码城' '万达总汇' '淘淘免税品' '幻想西游豆商' '亲茉旗舰店'
 'conandanube' 'bibibi君' 'sellor6' 'dior迪奥官方旗舰店' '猪哼少01' '张小燕319' '唐大人街'
 '卡姿兰官方旗舰店' '天天宝贝母婴用品' 'luotao0513' 'kxf2g286' '乐乐医疗2006' '脯拘孝譬' '尼蓝旗舰店'
 '依梦静尔' '我是女王香港代购店' '雅诗兰黛官方旗舰店' 'sunjackwong' '创业小熊' 'qaqv旗舰店'
 'charlottetilbury海外旗舰' '顿庆华' 'shanhai1987' '赠品处理中心' '叶彬儿' 'shop708090'
 'sckiquen旗舰店' '20080901pp' '闹嗨的哪吒' '3ce官方旗舰店' '水清浅漾' 'in20100101'
 'sd1554040' 'ccp19911122' 'ganghuo520' '靓琳旗舰店' '我走在邊緣' '温馨小店名妆铺'
 'perfectdiary旗舰店' 'nars官方旗舰店' '创业良心' 'lucas强者世界' 'szufo80' 'chinayinyue'
 'chongchong39' 'tb002421896' '植村秀官方旗舰店' 'sundaymhc' 'fyw399' '毛小咪vs小晶'
 '顺发1314666888' 'sephora丝芙兰官方旗舰店' '六宫粉黛旗舰店' '霹雳小文哥' 'colourfeel旗舰店'
 '珍珍贸易12' '乖乖爱宝贝永远' 'zyp1014796002' '贝壳里的亡灵' '米拉诺米' '稚优泉化妆品旗舰店'
 'zhs252898484' '品质专注为你' '卡姿兰恋尚专卖店' '美丽小铺8888' '胭脂红粉铺' 'binarmy75204'
 '天边野狼' '蔷薇有梦2597758' 'java' 'cyq201229' '欧莱雅官方旗舰店' '开心女人5988' 'csn616'
 '鹤禧觉色旗舰店' '韩熙贞旗舰店' '天猫国际进口超市国内现货' '星雅郎' '酷醋儿' '乐天天168'
 't_1480498621213_0364' '俏佳人彩妆铺' 'b百分百d' '1号购物网98' '低調是鲥緔' '欧莱雅彩妆官方旗舰店'
 'romand海外旗舰店' '清泠' 'liuyandisusu' 'vnk旗舰店' '小呆獭在日韩' 'bobo猫吃鱼'
 '色彩主义化妆品旗舰店' '小浣熊10' 'iam小点点' '_wwj1125' 'gua_gua_gua' 'faye_hg' 'hrzp01'
 'sz05271130' 'chenlaona' '卡姿兰宏达美景专卖店' '法兰释企业店铺' '简单纪念泽' '欧洲奢侈品专柜正品代购'
 '柏翠丽晶' 'm1ss1ng_n1u' '肌肤之钥官方旗舰店' 'tb1481363' 'chiyuheng1995314' '柠檬黄代购'
 'stunningu' 'gogotales旗舰店' 'kimivsshumi' '何秀娟4126' 'xiaoyangpani' '天猫超市'
 'holdlive旗舰店' 'judydoll橘朵旗舰店' '卡婷旗舰店' '卡姿兰瑞鼎诚专卖店' 'xs潮衣' '玛丽黛佳旗舰店'
 '京都shop' '芭比波朗官方旗舰店' 'cofea1' '毛戈平官方旗舰店' '金秋赵哲' '卡姿兰悦美专卖店' '苏奕suvi'
 '润百颜旗舰店' '诺儿家的爆款' 'raye_mama' '美丽放大镜' '方糖婴童店' '喔喔堂糖' '子唯格格' '月光之凤尾竹'
 '媛媛小0728' 'yaneoaanna' '代婉豫' '小小兔丶ck' '小米需' '灬美牙' 'lmz666' '彩亮美妆'
 '曼秀雷敦旗舰店' 'shinekoreagogogo' '流云小铺' '冀天宇55' '美丽会客厅' '洛梵诗旗舰店' '薏米代购'
 '和悦数码企业店' 'yw_pretty' '甄甄忆萱' '小小雪雪宝' 'tb1796101_2011' 'guerlain娇兰官方旗舰店'
 'harrytaoyee' '美康粉黛旗舰店' '如意的力挽狂澜' 'usgzs' '李英杰19930510' '醉美红妆' '小红蜂全球购go'
 '正前方大向' '江城武汉妹' '曦忆妄幽' 'h272766562' '么么小玄子' 'xrnieguanlan' 'ojinge324'
 '板田菊花君' 'zhangqianqian1207' 'mollyfor2000' 'farmacity海外旗舰店' '碧奥泉旗舰店'
 'tb502161739' '浩0o瀚' 'thesaem得鲜旗舰店' 'hedonefashionsnobs旗舰店'
 'janjiang0323' 'hetianhuiyu' 'colorkey旗舰店' '北京当当实体店' 'canmake海外旗舰店'
 'cc669999999o9' '三世的牵挂' 'rongxiaoxia91' '叼着烟接伆' 'tb25161890' '木月小姐'
 '优婧蜕变' 'croxx旗舰店' 'yaneriy' '小小小豆腐123' '法国娇韵诗官方旗舰店' '海豚小姐妹' '凤舞凯翔' '陈宋林林'
 '蔷薇有梦520' '趣多多only' 'maxin357619099' 'makeboon旗舰店' '安哥拉948' 'axiao8071'
 '尚可620' 'msekko旗舰店' 'wwlshiwo7986' '香菜鸭' '小崩快跑' 'seven7jing' '沸腾的凉茶'
 '乐天的亚马逊' '健美创研力亿专卖店' '天天特卖工厂店' '时尚80公主' 'eashion_1988' 'wjswenjinsong'
 'makeupforever官方旗舰店' 'lynn_zhao00' 'hannah0110' '酷鞋帅衣坊2号' 'pink妞'
 'zara官方旗舰店' '猝死陌花上' '柏迪芬旗舰店' 'tb825453612' 'hourglass海外旗舰店' '曲亚电子商务有限公司'
 'hera赫妍官方旗舰店' '慕恩化妆品专营店' 't_1498102296656_0647' '共享生活1688' '半桃旗舰店' '淘着乐呵'
 'meise0' '林伟忠55' '你的护肤顾问' '赛日好' 't_1505441753577_0480' '张小佳在岛国'
 'keepup1818' 'colorfans迷色粉丝旗舰店' '爱睡觉的小佛爷' 'sexyyiyi' 'ksb20111'
 'soledadsw' '陈经验43' '蔡梓馀' '帝尊鞋服' 'luxiaoci66' 'zeqing015' 'focallure旗舰店'
 '梦幻花8456' '百雀羚旗舰店' 'ayla妈妈' '卡姿兰美诗专卖店' 'allseen' 'kinn_ning'
 'zhangxin5442062' 'tb655510196' '资莱皙旗舰店' '绿蜜蜂海外专营店' 'fresh馥蕾诗官方旗舰店'
 'opera海外旗舰店' '年年月月629' '兰芝官方旗舰店' 'ipsa茵芙莎旗舰店' '迪拜公主曾' '阿芙官方旗舰店' '一束红妍旗舰店'
 '大风起兮啊啊' '乐汐333' 'zcbzcb_z' '柏瑞美旗舰店' 'hince海外旗舰店' '肌肤修养专家' '铄麻麻咪丫'
 '烦燥ing' 'zzczzc9058' 'me_cic1' '鲍鲍1128' 'haihai1343' 'chachachau'
 'vivigao药妆杂货铺' 'qianaiche' 'ukiss旗舰店' 'tb4425927' '韩国代购_may'
 'modernbobo2008' '美宝莲悦宁专卖店' 'toofaced官方海外旗舰店' '秋子mmmm' 'zheng郑相华'
 'wangxuejiao125' 'tb73616282' 'patmcgrathlabs海外旗舰店' 'tb552853' '水密码旗舰店'
 '欧莱雅卡诗批发' 'clw5203344' '舞夜猫族' '透真旗舰店' 'tb66277671' 'tb6420708_2012' '郑啊芳'
 '呵呵一笑吼哈哈' '季肤爽旗舰店' 'gooao' '巴蒂斯图塔414' '美航化妆品专营店' '女神梦工厂2016' 'nb童鞋'
 '佰草集官方旗舰店' '天猫国际海外仓直购' '花西子美妆店铺' 'chengniit' 'usbuyer666'
 'miaoyang332526' 'ningxialala' 'aekyung海外旗舰店' 'sisley希思黎官方旗舰店' '水墨衣荨'
 '花川秀旗舰店' 'ms_uyicool' 'tb6724535115' '美丽甄选护肤' 'zhoudijie' 'ayumiting'
 'tb38665371' '伯特小蜜蜂海外旗舰店' 'qdsuh巧迪尚惠梵可诗专卖' '自然堂旗舰店' '美肤一品堂' 'tb195807278'
 '后官方旗舰店' 'tb814413320' 'haoyou55' 'ads_07888' '采立姿' 'fuyyx'
 'solitaryyuanyuan' 'yanyanfong' '123456hzk00' 'tb048541471' '美宝莲旗舰店'
 '知恩韩妆' '每天可以更美丽' '阿兰在海上' 'tb0840304_2011' '年华似水198901' '饭元气' '淘宝心选'
 'vivi_demi' 'kemelo化妆品旗舰店' '清平调旗舰店' '诗唯雅化妆品专营店' '晓梅_1020' '思琪化妆品专营店'
 '思尚旗舰店' 'toorune肽润旗舰店' '屋顶星月' 'dw020402' '世尘笑笑' 'tb193911902' 'auntshi'
 '以德服人97' '永信化妆品专营店' '信微贸易' '爱茉莉官方海外旗舰店' '伊人飘影女装001' '美康粉黛归真堂专卖店'
 '肌肤之食旗舰店' '藤贸易事务所' 'tb033560639' 'ralnbows' 'cbbill' '小蜜坊旗舰店' '国际贸易商业国'
 '大成就商贸' '豆芽yooo' '莱索兔旗舰店' '本草护肤' '啦啦啦_小太阳' 'ningyuxuan8888' '上海千赢电子科技'
 'margauxbrooke' '依圣美旗舰店' '陈煌good' '胡浩然7330' '深圳市雅靓彩妆有限公司' 'linxicaoxuan'
 'sunniesface海外旗舰店' 'careplus海外旗舰店' '一只船电工小张' '主角baby888' '曼秀雷敦鑫丝路专卖店'
 '卡姿兰童话的峰专卖店' '柏蕊诗化妆品旗舰店' '盈盈笑着哲' 'cezanne海外旗舰店' '请叫我鹿含' '欣悦美妆abc'
 '资泊丽旗舰店' 'elevion' '吴继伟568520' '新时代彩妆' '媚骨天仙' '聪明恩恩4' '巫女judy' '囚心aaaa'
 '艾美迪斯666' 'vicans' '洛杉矶女孩lagirl' '恋意旗舰店' '艾尚依服饰店' '黄家铺子2013'
 '想念你632224479' 'dingfang457269' '无桦之叶' '相宜本草官方旗舰店' '末小朵7713' '桃之夭夭旗舰店'
 '阿莎妮亚' 'tb533587327' 'modelcat77' 'stylenanda海外旗舰店' 'wis旗舰店'
 'tb397044424' 'tb528336855' '左岸右转07' 'qiankun18' '兰奕旗舰店' '阿杰北京的能力'
 '瞬间移动工程sisi' '我的稀奇' '若辰芷菡' '发条蕉' 'geoskincare纽西之谜旗舰店' '黛珂官方旗舰店'
 'thomas5600' 'miemiedou' 'doyes朵雅而姿旗舰店' 'intoyou美妆店' 'caremille珂曼旗舰店'
 'dengmin6714036' 'cozzolino海外旗舰店' 'buying影' '谢小琳1720' '太宅太闹的空姐' '胡小豪1000'
 '千迪兰化妆品旗舰店' 'nico旗舰店' '绯闻天后0' '凤丫9393' 'nanhua1yue' '亍bbjj' 'vivin港人港货'
 'jr1314_吉如' '植荟露旗舰店' 'swanim' '小邹菊jz' '薇罗尼卡旗舰店' 'cs549180039'
 '曹孟德12327374442' '涵妈乐居' 'limecrime海外旗舰店' 'zeesea妙妆专卖店' 'tb3540052_88'
 'kmy19781001' '张果果的天地' '花开半夏_0821' '凤云乌鸡' 'w18565610211' 'alice19890115'
 '陈罗源' '雅歌化妆品旗舰店' '象小新' '鲁伊往逝' '紫涵名品专卖' 'qq634940931' 'urbandecay官方海外旗舰店'
 '靖飞飞飞123' '龙凤呈祥66880' '安然小海hhr' '相逢何必相识7' '春风十里代购' '蓝媚儿0605' 'ldeyn'
 '等风来neverabandon' '1949green' 'chemistwarehouse海外旗舰' 'levercil旗舰店'
 'vivianshaw' '御泥坊旗舰店' '香饽饽瑶瑶' '蔡子云淘淘' '丹丹92355' 'demonkei777' '唯艺佳企业店'
 '佳佳百货香港代购' 'glzgjzfy' 'laox海外旗舰店' 'jillleen旗舰店' 'akplaza海外旗舰店'
 'livingnature海外旗舰店' 'clinique倩碧官方旗舰店' 'ators旗舰店' 'zifeiyu1988'
 'liyulong2884839' '时千寻旗舰店' 'cake_001' '俊逸2222' '启咖化妆品旗舰店' 'yingyinglily'
 'y18973565261' 'chanlee1958' '千色店旗舰店' '幸福的熊米粒' 'haoworld_浩' '美宝莲欧美斯专卖店'
 '影坊创意' 'paticular' '枫林晚54' '小李想007' 'zmslove18' '金岭商贸' 'xiaobin0180'
 '到底要怎样mmm' '湄洲妈祖保佑' '果子的果栗子' '大周的店01' '万宁官方海外旗舰店' '狐狸静68' 'zzg655771'
 'qqlvnana' '流行衣佳人' '甜甜an微笑' '菲儿1988777' '摩托罗拉通讯主营店' '小鑫淘淘屋' '兰花时尚运动'
 '断码正品折扣店' 'sasa莎莎海外旗舰店' '浩瀚19812v2' 'tb161125501' '红火二掌柜' '欧碧芙旗舰店' '琦婷儿'
 '无清藏' 'yibanxa' '小虫美妆6252' '是三个七' '正宫御品旗舰店' '小小婉子' '余留一份温柔' '有兮美妆店'
 '秀妮可旗舰店' 'revlon露华浓官方旗舰店' '苏通科技家居馆' 'tb643262603' '苏宁易购官方旗舰店' 'sihoyuan'
 'waterhuili' '半九十666666' '水果味儿叔叔' '琳儿蛮蛮' 'guoweixiuxiu'
 'kohgendo江原道海外旗舰店' 'tb_5840618' '透蜜旗舰店' 'revlon海外旗舰店' '在这壹方' 'sum37官方旗舰店'
 'tb916664646' '淘me兜兜' 'luxurykin' '长鼻子哼哼' '至尊鞋服' '辰古儿' '和玺化妆品旗舰店'
 'ulnconve谙洛伊美妆店' 'xiaolinjia1' 'neverafraid1988' 'm折翼天使n' '胭脂靓妆护肤'
 'sunflower516' 'huiyuhui1986' '周继超1118' '大智慧的人' 'wushai808' '秀东东宝宝'
 '喵七只菇凉' 'colin3986' '彼岸光景' '曼蒂植物护肤店' 'tasu她素旗舰店' '363840442qq' '全球时尚精品店'
 'coco小仙儿y' '望成莫及_2009' '小柴胡5' '蔚蓝左岸' '果果的妈咪1314' 'babaloos' '一一一筐猪'
 'pf海外旗舰店' 'never_sloppy' 'redearth红地球官方旗舰店' 'shiseido资生堂官方旗舰店']
******************************************************************************************
shop_type : ['淘宝' '天猫']
******************************************************************************************
svolume : [0 '' '5966' '28' '265' '53' '44' '702' '2万+' '1.5万+' '1863' '4' '5万+'
 '447' '860' '929' '10万+' '1486' '295' '1351' '935' '3476' '2769' '3'
 '264' '717' '1170' '1540' '252' '2051' '125' '1万+' '0' '9万+' '139'
 '9000+' '7500+' '1020' '2.5万+' '4.5万+' '2762' '5000+' '509' '134' '1123'
 '3540' '3180' '6000+' '1051' '9500+' '8500+' '5500+' '1614' '1719' '2624'
 '2691' '448' '472' '570' '40' '2625' '9']
******************************************************************************************
title : ['CLIO珂莱欧丝绒唇彩哑光唇釉雾感丝绒小红管口红唇膏' 'KIKO滋养润唇蜜充盈丰满保湿补水镜面水光透明唇蜜口红打底'
 'YSL圣罗兰释爱4支口红套装限定包装方管新色110/120七夕礼盒' ... 'vnk圆管口红艺术管2支装礼盒雾面哑光不易脱显色持久'
 'WIS 魅惑口红哑光唇膏持久保湿不易脱色咬唇轻雾感彩妆正品女学生' '柳丝木小八口红女学生中国风口红唇膏上新了国风故宫哑光滋润口红']

import numpy as np 
# 将销量数据转化为int
data["evaluate"] = data["evaluate"].astype(np.int)
# 看一下各列的数据类型，可看到evaluate已经转化
data.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2654 entries, 0 to 2653
Data columns (total 11 columns):
brand           2654 non-null object
evaluate        2654 non-null int32
location        2654 non-null object
pay_nums        2654 non-null object
place           2642 non-null object
price           2654 non-null object
product_name    2338 non-null object
shop            2654 non-null object
shop_type       2654 non-null object
svolume         2654 non-null object
title           2654 non-null object
dtypes: int32(1), object(10)
memory usage: 217.8+ KB

# pay_nums列，付款次数，进行处理
def due_paynums(x):
    try:
        x = x.replace("+", "")
        # 把pay_nums列变为float类型，汉字万变为数字
        if '万' in x:
            x = float(x.replace("万", "")) * 10000
        else:
            x = float(x)
    except:
        x = np.nan
    return x

data['pay_nums'] = data['pay_nums'].apply(due_paynums)
# 可看到pay_nums列已经转换
data.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2654 entries, 0 to 2653
Data columns (total 11 columns):
brand           2654 non-null object
evaluate        2654 non-null int32
location        2654 non-null object
pay_nums        2632 non-null float64
place           2642 non-null object
price           2654 non-null object
product_name    2338 non-null object
shop            2654 non-null object
shop_type       2654 non-null object
svolume         2654 non-null object
title           2654 non-null object
dtypes: float64(1), int32(1), object(9)
memory usage: 217.8+ KB

# 处理销量svolume，进行去重
data["svolume"].unique()

array([0, '', '5966', '28', '265', '53', '44', '702', '2万+', '1.5万+',
       '1863', '4', '5万+', '447', '860', '929', '10万+', '1486', '295',
       '1351', '935', '3476', '2769', '3', '264', '717', '1170', '1540',
       '252', '2051', '125', '1万+', '0', '9万+', '139', '9000+', '7500+',
       '1020', '2.5万+', '4.5万+', '2762', '5000+', '509', '134', '1123',
       '3540', '3180', '6000+', '1051', '9500+', '8500+', '5500+', '1614',
       '1719', '2624', '2691', '448', '472', '570', '40', '2625', '9'],
      dtype=object)

# 调用due_paynums函数，进行同样的处理
data['svolume'] = data['svolume'].apply(due_paynums)
data.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2654 entries, 0 to 2653
Data columns (total 11 columns):
brand           2654 non-null object
evaluate        2654 non-null int32
location        2654 non-null object
pay_nums        2632 non-null float64
place           2642 non-null object
price           2654 non-null object
product_name    2338 non-null object
shop            2654 non-null object
shop_type       2654 non-null object
svolume         1689 non-null float64
title           2654 non-null object
dtypes: float64(2), int32(1), object(8)
memory usage: 217.8+ KB

# 处理price，转化为float
data["price"] = data["price"].astype(np.float)
data.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2654 entries, 0 to 2653
Data columns (total 11 columns):
brand           2654 non-null object
evaluate        2654 non-null int32
location        2654 non-null object
pay_nums        2632 non-null float64
place           2642 non-null object
price           2654 non-null float64
product_name    2338 non-null object
shop            2654 non-null object
shop_type       2654 non-null object
svolume         1689 non-null float64
title           2654 non-null object
dtypes: float64(3), int32(1), object(7)
memory usage: 217.8+ KB

# 处理地址，split(" ")[0]按空格进行切割，只保留第一个(只要省)
data["location"] = data["location"].apply(lambda x:x.split(" ")[0])
# 进行去重
data["location"].unique()

array(['浙江', '上海', '江苏', '广东', '福建', '北京', '山东', '河南', '四川', '韩国', '辽宁',
       '湖南', '河北', '天津', '安徽', '江西', '香港', '黑龙江', '海南', '云南', '重庆', '湖北',
       '美国', '日本', '新西兰', '澳大利亚', '泰国', '吉林', '荷兰', '加拿大'], dtype=object)

data.head()

	brand	location	pay_nums	place	price	product_name	shop	shop_type	svolume	title
0	CLIO	浙江	28.0	韩国	108.0	CLIO 雾面唇彩	clubclio海外旗舰店	淘宝	NaN	CLIO珂莱欧丝绒唇彩哑光唇釉雾感丝绒小红管口红唇膏
1	KIKO	上海	235.0	意大利	99.0	KIKO 清透滋养润唇蜜	kiko海外旗舰店	淘宝	NaN	KIKO滋养润唇蜜充盈丰满保湿补水镜面水光透明唇蜜口红打底
2	YSL/圣罗兰	江苏	1208.0	法国	1280.0	YSL/圣罗兰纯口红 2	ysl圣罗兰美妆官方旗舰店	天猫	NaN	YSL圣罗兰释爱4支口红套装限定包装方管新色110/120七夕礼盒
3	Givenchy/纪梵希	上海	6500.0	法国	690.0	None	givenchy纪梵希官方旗舰店	天猫	NaN	【七夕礼盒】GIVENCHY纪梵希小羊皮红丝绒n37 口红套装散粉香水
4	Christian Louboutin	浙江	1786.0	美国	1760.0	Christian Louboutin 双支...	christianlouboutin美妆官方旗舰店	天猫	NaN	【七夕礼盒】Christian Louboutin女王权杖双支礼盒 cl萝卜丁口红

# 处理店铺类别数据，将店铺名字规范
def store(e):
    if '天猫' in e:
        return '天猫店铺'
    elif '旗舰店' in e:
        return '旗舰店'
    elif '专营店' in e:
        return '专营店'
    elif '企业店' in e:
        return '企业店铺'
    else:
        return '自营店铺'


data['store_type'] = data['shop'].apply(store)
data.head()

	brand	location	pay_nums	place	price	product_name	shop	shop_type	svolume	title	store_type
0	CLIO	浙江	28.0	韩国	108.0	CLIO 雾面唇彩	clubclio海外旗舰店	淘宝	NaN	CLIO珂莱欧丝绒唇彩哑光唇釉雾感丝绒小红管口红唇膏	旗舰店
1	KIKO	上海	235.0	意大利	99.0	KIKO 清透滋养润唇蜜	kiko海外旗舰店	淘宝	NaN	KIKO滋养润唇蜜充盈丰满保湿补水镜面水光透明唇蜜口红打底	旗舰店
2	YSL/圣罗兰	江苏	1208.0	法国	1280.0	YSL/圣罗兰纯口红 2	ysl圣罗兰美妆官方旗舰店	天猫	NaN	YSL圣罗兰释爱4支口红套装限定包装方管新色110/120七夕礼盒	旗舰店
3	Givenchy/纪梵希	上海	6500.0	法国	690.0	None	givenchy纪梵希官方旗舰店	天猫	NaN	【七夕礼盒】GIVENCHY纪梵希小羊皮红丝绒n37 口红套装散粉香水	旗舰店
4	Christian Louboutin	浙江	1786.0	美国	1760.0	Christian Louboutin 双支...	christianlouboutin美妆官方旗舰店	天猫	NaN	【七夕礼盒】Christian Louboutin女王权杖双支礼盒 cl萝卜丁口红	旗舰店

# 对品牌处理，取前10个
data['brand'].value_counts()[:10].index

Index(['YSL/圣罗兰', 'MAC/魅可', '香奈儿', 'Dior/迪奥', 'Tom Ford/汤姆福特', 'Lancome/兰蔻',
       'GIORGIO ARMANI/阿玛尼', 'Givenchy/纪梵希', 'CARSLAN/卡姿兰',
       'Christian Louboutin'],
      dtype='object')

# 获取品牌字典，将名字进行规范
brands = ['圣罗兰', '魅可', '香奈儿', '迪奥', '汤姆福特', '兰蔻', '阿玛尼', '纪梵希', '卡姿兰', 'Christian Louboutin']
brands = {k: set(v.split('/')) for k, v in zip(brands, data['brand'].value_counts()[:10].index)}
brands

{'圣罗兰': {'YSL', '圣罗兰'},
 '魅可': {'MAC', '魅可'},
 '香奈儿': {'香奈儿'},
 '迪奥': {'Dior', '迪奥'},
 '汤姆福特': {'Tom Ford', '汤姆福特'},
 '兰蔻': {'Lancome', '兰蔻'},
 '阿玛尼': {'GIORGIO ARMANI', '阿玛尼'},
 '纪梵希': {'Givenchy', '纪梵希'},
 '卡姿兰': {'CARSLAN', '卡姿兰'},
 'Christian Louboutin': {'Christian Louboutin'}}

# 品牌归类，进行品牌数量的统计
def classify(e):
    for k, v in brands.items():
        for i in v:
            if i in e:
                return k
                break
    return '其他'


data['new_brand2'] = data['title'].apply(classify)
data['new_brand2'].value_counts()

其他                     1351
迪奥                      233
圣罗兰                     221
魅可                      164
香奈儿                     157
兰蔻                      120
阿玛尼                     112
汤姆福特                    103
纪梵希                      97
卡姿兰                      64
Christian Louboutin      32
Name: new_brand2, dtype: int64

data.head()

	brand	location	pay_nums	place	price	product_name	shop	shop_type	svolume	title	store_type	new_brand2
0	CLIO	浙江	28.0	韩国	108.0	CLIO 雾面唇彩	clubclio海外旗舰店	淘宝	NaN	CLIO珂莱欧丝绒唇彩哑光唇釉雾感丝绒小红管口红唇膏	旗舰店	其他
1	KIKO	上海	235.0	意大利	99.0	KIKO 清透滋养润唇蜜	kiko海外旗舰店	淘宝	NaN	KIKO滋养润唇蜜充盈丰满保湿补水镜面水光透明唇蜜口红打底	旗舰店	其他
2	YSL/圣罗兰	江苏	1208.0	法国	1280.0	YSL/圣罗兰纯口红 2	ysl圣罗兰美妆官方旗舰店	天猫	NaN	YSL圣罗兰释爱4支口红套装限定包装方管新色110/120七夕礼盒	旗舰店	圣罗兰
3	Givenchy/纪梵希	上海	6500.0	法国	690.0	None	givenchy纪梵希官方旗舰店	天猫	NaN	【七夕礼盒】GIVENCHY纪梵希小羊皮红丝绒n37 口红套装散粉香水	旗舰店	纪梵希
4	Christian Louboutin	浙江	1786.0	美国	1760.0	Christian Louboutin 双支...	christianlouboutin美妆官方旗舰店	天猫	NaN	【七夕礼盒】Christian Louboutin女王权杖双支礼盒 cl萝卜丁口红	旗舰店	Christian Louboutin

# pip install pyecharts==0.1.9.4
# 不同品牌店铺占比 饼图
# 拿到品牌字段.value_counts(1)进行占比统计
brand_data = data['new_brand2'].value_counts(1)

from pyecharts import Pie
pie = Pie("口红品牌比例", width=1200, height=600)
pie.add("口红比例", brand_data.index, brand_data.values, is_label_show=True)
pie.render("口红比例饼图.html")
# 生成html页面，下图为插入的图片

在这里插入图片描述

# 不同品牌价格 柱状图
from pyecharts import Bar

brand_data2 = data.groupby('new_brand2')['price'].agg(['mean', 'median'])
bar = Bar("不同品牌价格概况", width=1000, height=400)
bar.add('平均价格', brand_data2.index, round(brand_data2['mean']), is_label_show=True,
        xaxis_label_textsize=14, yaxis_label_textsize=15)
bar.add('中位价格', brand_data2.index, brand_data2['median'], is_label_show=True,
        xaxis_label_textsize=14, yaxis_label_textsize=15)
bar.render("不同品牌价格概况柱状图.html")

在这里插入图片描述

# 不同品牌总销量 柱状图
brand_data3 = data[data['new_brand2'] != '其他'].groupby('new_brand2')['pay_nums'].agg(['sum', 'mean'])
bar = Bar("不同品牌销量", width=1000, height=400)
bar.add('总销量', brand_data3.index, round(brand_data3['sum']), is_label_show=True,
        xaxis_label_textsize=14, yaxis_label_textsize=15)
bar.render("不同品牌销量柱状图.html")

在这里插入图片描述

# 不同品牌平均销量
bar = Bar("不同品牌平均销量", width=1000, height=400)
bar.add('平均销量', brand_data3.index, brand_data3['mean'], is_label_show=True,
        xaxis_label_textsize=14, yaxis_label_textsize=15)
bar.render("不同品牌平均销量柱状图.html")

在这里插入图片描述

# 发货地分析 地图
from pyecharts import Map
# 计算各个发货地的店铺数量
send = data['location'].value_counts()
# 去掉外国
forigen = ['美国', '新西兰', '韩国', '日本', '荷兰', '澳大利亚', '加拿大', '泰国']
loc = [str(i) for i in send.index if i not in forigen]
number = [int(send[i]) for i in send.index if i not in forigen]
# 店铺地址分布图
map0 = Map("店铺地址分布图", width=1000, height=600)
map0.add("", loc, number,
         visual_range=[0, 683], maptype="china",
         is_visualmap=True, visual_text_color='#000',
         is_label_show=True)
map0.render("发货地址分布图.html")

在这里插入图片描述

# 评论分析 词云图
import jieba
import jieba.analyse
from pyecharts import WordCloud
# 获取评论数据
data5 = pd.read_csv('口红评论分类.csv')
data5 = data5.drop(['Unnamed: 0'], axis=1)
data5.head()
# 去掉无用评论
the_data = data5[data5['评论'].isin(['此用户没有填写评论!'])]
title = data['title'].str.cat(sep=" ")
jieba.analyse.set_stop_words('stopwords.txt')
new_words = jieba.analyse.textrank(title, topK=100, withWeight=True)
# 生成词云图
words, rank = [item[0] for item in new_words], [item[1] for item in new_words]
wordcloud = WordCloud(width=1000, height=600)
wordcloud.add('', words, rank, word_size_range=[20, 100])
wordcloud.render("评论词云图.html")

在这里插入图片描述

# 色号分析
data5['分类'].unique()

array(['颜色分类:【剑网3比翼相思联名】 M122 相思绣', '颜色分类:M406檀心绣（豆沙色）',
       '颜色分类:M121凤鸾绣（经典正红色）', '颜色分类:M122绛仙绣（红棕焦糖）', '颜色分类:M123伯牙绣（宝石樱红）',
       '颜色分类:杜鹃·惊鸿-M126（复古绛红色）', '颜色分类:M119湘妃绣（胡萝卜色）',
       '颜色分类:杜鹃·兰心-M409（半醺豆沙色）', '颜色分类:M116彤心绣（烂番茄色）',
       '颜色分类:鼠年知音礼盒（M124知音绣+M123伯牙绣+M408子期绣）', '颜色分类:M602西子绣（半哑偏润草莓色）',
       '颜色分类:M117红鸾绣（正红色）', '颜色分类:M124知音绣（栗子红棕）', '颜色分类:M407玉棠绣（微糖豆沙）',
       '颜色分类:M408子期绣（红柚豆沙）', '颜色分类:M505紫云绣（浆果葡萄）', '颜色分类:M115御宫绣（复古红）',
       '颜色分类:M118丹璃绣（红莓色）', '颜色分类:L102醉红绣（酒红色）'], dtype=object)

# 提取色号
colors = {
    'M122': '红',
    'M406': '豆沙色',
    'M121': '经典正红色',
    'M122': '红棕焦糖',
    'M123': '宝石樱红',
    'M126': '复古绛红色',
    'M119': '胡萝卜色',
    'M409': '半醺豆沙色',
    'M116': '烂番茄色',
    'M117': '正红色',
    'M124': '栗子红棕',
    'M407': '微糖豆沙',
    'M408': '红柚豆沙',
    'M505': '浆果葡萄',
    'M115': '复古红',
    'M118': '红莓色',
    'L102': '酒红色'
}

# 提起色号
def get_color(x):
    c = []
    for k, v in colors.items():
        if k in x:
            c.append(v)
    return c

cs = data5['分类'].apply(get_color).values
cs.shape

(9980,)

# 统计各种颜色购买次数
cs = [j for i in cs for j in i]
cs = pd.Series(cs).value_counts()

# 不同色号售卖概况
bar = Bar('不同色号售卖概况', width=1000, height=500, title_text_size=25)
bar.add('', cs.index, cs.values, is_label_show=True)
bar.render("各种颜色购买次数柱状图.html")

在这里插入图片描述

代码已托管到Github：python-lipstickAnalysis

slaythedragon

关注

1
点赞
踩
42

收藏

觉得还不错? 一键收藏
2
评论
口红数据分析及pyecharts可视化

口红.ipynbimport pandas as pd import jsonimport gcwith open("./taobao.json", encoding='utf-8') as f: data = f.read()data[:1000]'[{\n "img_url": "http://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2379306225/O1CN01kN44fC1vr67mvZCNG_!!0-item_pic.j
复制链接

扫一扫