
经过经纬度、区域转换后,可将特色美食分区查看数量
可按价格排序分类,将美食分为“豪华”“高端”“舒适”“经济”型
以下是可视化代码
宝安 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='宝安')福田 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='福田')龙岗 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='龙岗')龙华 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='龙华')罗湖 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='罗湖')南山 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='南山')坪山 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='坪山')盐田 = pd.read_excel ("各区各类美食数量.xlsx", encoding = "utf8", sep="\t",sheet_name='盐田')
美食搭桥数据
line1 = go.Scatter(x=宝安['类型'],y=宝安['数量'],name = '宝安区')line2 = go.Scatter(x=福田['类型'],y=福田['数量'],name = '福田区')line3 = go.Scatter(x=龙岗['类型'],y=龙岗['数量'],name='龙岗区')line4 = go.Scatter(x=龙华['类型'],y=龙华['数量'],name='龙华区')line5 = go.Scatter(x=罗湖['类型'],y=罗湖['数量'],name='罗湖区')line6 = go.Scatter(x=南山['类型'],y=南山['数量'],name='南山区')line7 = go.Scatter(x=坪山['类型'],y=坪山['数量'],name='坪山区')line8 = go.Scatter(x=盐田['类型'],y=盐田['数量'],name='盐田区')fig = go.Figure([line1,line2,line3,line4,line5,line6,line7,line8])fig.update_layout(title = '深圳各区各层次美食数量',xaxis_title = "类型",yaxis_title = "数量")fig.show()

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

