深圳美食wtf.png
    经过经纬度、区域转换后,可将特色美食分区查看数量

    可按价格排序分类,将美食分为“豪华”“高端”“舒适”“经济”型

    以下是可视化代码

    1. 宝安 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='宝安')
    2. 福田 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='福田')
    3. 龙岗 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='龙岗')
    4. 龙华 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='龙华')
    5. 罗湖 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='罗湖')
    6. 南山 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='南山')
    7. 坪山 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='坪山')
    8. 盐田 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='盐田')

    美食搭桥数据
    美食搭桥.png

    1. line1 = go.Scatter(x=宝安['类型'],y=宝安['数量'],name = '宝安区')
    2. line2 = go.Scatter(x=福田['类型'],y=福田['数量'],name = '福田区')
    3. line3 = go.Scatter(x=龙岗['类型'],y=龙岗['数量'],name='龙岗区')
    4. line4 = go.Scatter(x=龙华['类型'],y=龙华['数量'],name='龙华区')
    5. line5 = go.Scatter(x=罗湖['类型'],y=罗湖['数量'],name='罗湖区')
    6. line6 = go.Scatter(x=南山['类型'],y=南山['数量'],name='南山区')
    7. line7 = go.Scatter(x=坪山['类型'],y=坪山['数量'],name='坪山区')
    8. line8 = go.Scatter(x=盐田['类型'],y=盐田['数量'],name='盐田区')
    9. fig = go.Figure([line1,line2,line3,line4,line5,line6,line7,line8])
    10. fig.update_layout(title = '深圳各区各层次美食数量',xaxis_title = "类型",yaxis_title = "数量")
    11. fig.show()

    深圳美食线图.png

    1. bar1 = go.Bar(x = 宝安['类型'],y = 宝安['数量'],text = 宝安['数量'],textposition='outside',name='宝安区')
    2. bar2 = go.Bar(x = 福田['类型'],y = 福田['数量'],text = 福田['数量'],textposition='outside',name='福田区')
    3. bar3 = go.Bar(x = 龙岗['类型'],y = 龙岗['数量'],text = 龙岗['数量'],textposition='outside',name='龙岗区')
    4. bar4 = go.Bar(x = 龙华['类型'],y = 龙华['数量'],text = 龙华['数量'],textposition='outside',name='龙华区')
    5. bar5 = go.Bar(x = 罗湖['类型'],y = 罗湖['数量'],text = 罗湖['数量'],textposition='outside',name='罗湖区')
    6. bar6 = go.Bar(x = 南山['类型'],y = 南山['数量'],text = 南山['数量'],textposition='outside',name='南山区')
    7. bar7 = go.Bar(x = 坪山['类型'],y = 坪山['数量'],text = 坪山['数量'],textposition='outside',name='坪山区')
    8. bar8 = go.Bar(x = 盐田['类型'],y = 盐田['数量'],text = 盐田['数量'],textposition='outside',name='盐田区')
    9. fig = go.Figure([bar1,bar2,bar3,bar4,bar5,bar6,bar7,bar8])
    10. fig.update_layout(title = '深圳各区各层次美食数量',xaxis_title = "区域",yaxis_title = "数量")
    11. fig.show()

    深圳美食柱图.png
    深圳各区各层次美食数量条形图.html深圳各区各层次美食数量线图.html