各位,七夕快到了,想好要送什么礼物了吗?
昨天有朋友私信我,问我能用Python分析下网上小猫咪的数据,是想要送一只给女朋友,当做礼物。
网上的数据太多、太杂,而且我也不知道哪个网站的数据比较好。所以,只能找到一个猫咪交易网站的数据来分析了
地址:
importcsv#内置模块f=open('猫咪1.csv',mode='a',encoding='utf-8',newline='')csv_writer=csv.DictWriter(f,fieldnames=['地区','店名','标题','价格','浏览次数','卖家承诺','在售只数','年龄','品种','预防','联系人','联系方式','异地运费','是否纯种','猫咪性别','驱虫情况','能否视频','详情页'])csv_writer.writeheader()#写入表头csv_writer.writerow(dit)print(title,area,shop,price,views,promise,num,age,kind,prevention,person,phone,postage,purebred,sex,video,worming,index_url,sep='|')
frompyechartsimportoptionsasoptsfrompyecharts.chartsimportWordCloudfrompyecharts.globalsimportSymbolTypefrompyecharts.globalsimportThemeTypewords=[(i,1)foriincat_info['品种'].unique()]c=(WordCloud(init_opts=opts.InitOpts(theme=ThemeType.LIGHT)).add("",words,shape=SymbolType.DIAMOND).set_global_opts(title_opts=opts.TitleOpts(title="")))c.render_notebook()
frompyechartsimportoptionsasoptsfrompyecharts.chartsimportTreeMappingzhong=cat_info['品种'].value_counts().reset_index()data=[{'value':i[1],'name':i[0]}foriinzip(list(pingzhong['index']),list(pingzhong['品种']))]c=(TreeMap(init_opts=opts.InitOpts(theme=ThemeType.LIGHT)).add("",data).set_global_opts(title_opts=opts.TitleOpts(title="")).set_series_opts(label_opts=opts.LabelOpts(position="inside")))c.render_notebook()
frompyechartsimportoptionsasoptsfrompyecharts.chartsimportPictorialBarfrompyecharts.globalsimportSymbolTypelocation=list(price['品种'])values=list(price['价格'])c=(PictorialBar(init_opts=opts.InitOpts(theme=ThemeType.LIGHT)).add_xaxis(location).add_yaxis("",values,label_opts=opts.LabelOpts(is_show=False),symbol_size=18,symbol_repeat="fixed",symbol_offset=[0,0],is_symbol_clip=True,symbol=SymbolType.ROUND_RECT,).reversal_axis().set_global_opts(title_opts=opts.TitleOpts(title="均价排名"),xaxis_opts=opts.AxisOpts(is_show=False),yaxis_opts=opts.AxisOpts(axistick_opts=opts.AxisTickOpts(is_show=False),axisline_opts=opts.AxisLineOpts(linestyle_opts=opts.LineStyleOpts(opacity=0),),),).set_series_opts(label_opts=opts.LabelOpts(position='insideRight')))c.render_notebook()
frompyechartsimportoptionsasoptsfrompyecharts.chartsimportBarfrompyecharts.fakerimportFakerx=['1-3个月','3-6个月','6-9个月','9-12个月','1年以上']y=[69343,115288,18239,4139,5]c=(Bar(init_opts=opts.InitOpts(theme=ThemeType.LIGHT)).add_xaxis(x).add_yaxis('',y).set_global_opts(title_opts=opts.TitleOpts(title="猫龄分布")))c.render_notebook()