■食べログのpythonスクレイピングと分析 #8 「コスパのよいお店をマッピング／ジャンル別コスパの高いお店を（少し）載せる」

rom bs4 import BeautifulSoup
import time
from tqdm import tqdm
import numpy as np
import pandas as pd
import datetime

def get_lat_lon_from_address(address):
    url = 'http://www.geocoding.jp/api/'
    try:
        payload = {"v": 1.1, 'q': address}
        r = requests.get(url, params=payload)
        ret = BeautifulSoup(r.content,'lxml')
        if ret.find('error'):
            lat = "-"
            lon = "-"
            time.sleep(10)
        else:
            lat = ret.find('lat').string
            lon = ret.find('lng').string
            time.sleep(10)
    except:
        lat = "-"
        lon = "-"
        time.sleep(10)

    return lat, lon

conda install -c conda-forge folium

import pandas as pd
import codecs
import folium

with codecs.open("./data/cospa_map_df_2022-10-11.csv", "r", "Shift-JIS", "ignore") as file:
    df_tokyo_for_mapping = pd.read_table(file, delimiter=",",index_col=0).transpose()
    
# 元のcsvファイルの緯度と経度が逆だったのでDataframeの列名を変更しています．．．👇
# 本来はいらないところです．．．
df_tokyo_for_mapping = df_tokyo_for_mapping.rename(columns={'lat': 'longitude', 'lon': 'latitude'})

cospa_map = folium.Map(
                   location=[35.6895014, 139.6917337], # 都庁の緯度経度です
                   zoom_start=12,
                   tiles='Stamen Terrain'
                   )

tooltip = 'Click me!'

for index, row in df_tokyo_for_mapping.iterrows():
    if (row['longitude'] != "-" and row['latitude'] != "-"):
        folium.Marker([row['longitude'], row['latitude']], 
                      popup='<i>' + index + ' , ' + row['store_name'] + ' , ' + row['cost_hensa'] + '</i>',
                      tooltip=tooltip).add_to(cospa_map)

cospa_map

import pandas as pd
import codecs
import folium
import re

with codecs.open("./data/cospa_map_df_2022-10-11.csv", "r", "Shift-JIS", "ignore") as file:
    df_tokyo_for_mapping = pd.read_table(file, delimiter=",",index_col=0).transpose()
    
df_tokyo_for_mapping = df_tokyo_for_mapping.rename(columns={'lat': 'longitude', 'lon': 'latitude'})

cospa_map = folium.Map(
                   location=[35.6895014, 139.6917337],
                   zoom_start=12,
                   tiles='Stamen Terrain'
                   )

tooltip = 'Click me!'

for index, row in df_tokyo_for_mapping.iterrows():
    if (row['longitude'] != "-" and row['latitude'] != "-"):
        if float(row['cospa']) <= 0:
            if re.match(".*_1",index):
                folium.Marker([row['longitude'], row['latitude']], 
                              icon=folium.Icon(icon_color="yellow", color="black", icon="glyphicon glyphicon-star"), 
                              popup='<i>' + index + ' , ' + row['store_name'] + ' , ' + row['cost_hensa'] + '</i>',
                              tooltip=tooltip).add_to(cospa_map)
            else:
                folium.Marker([row['longitude'], row['latitude']], 
                              icon=folium.Icon(icon_color="white", color="black", icon="glyphicon glyphicon-cutlery"), 
                              popup='<i>' + index + ' , ' + row['store_name'] + ' , ' + row['cost_hensa'] + '</i>',
                              tooltip=tooltip).add_to(cospa_map)
        elif (0 < float(row['cospa'])) and (float(row['cospa']) <= 10):
            if re.match(".*_1",index):
                folium.Marker([row['longitude'], row['latitude']], 
                              icon=folium.Icon(icon_color="yellow", color="blue", icon="glyphicon glyphicon-star"), 
                              popup='<i>' + index + ' , ' + row['store_name'] + ' , ' + row['cost_hensa'] + '</i>',
                              tooltip=tooltip).add_to(cospa_map)
            else:
                folium.Marker([row['longitude'], row['latitude']], 
                              icon=folium.Icon(icon_color="black", color="blue", icon="glyphicon glyphicon-cutlery"), 
                              popup='<i>' + index + ' , ' + row['store_name'] + ' , ' + row['cost_hensa'] + '</i>',
                              tooltip=tooltip).add_to(cospa_map)
        elif (10 < float(row['cospa'])) and (float(row['cospa']) <= 20):
            if re.match(".*_1",index):
                folium.Marker([row['longitude'], row['latitude']], 
                              icon=folium.Icon(icon_color="yellow", color="green", icon="glyphicon glyphicon-star"), 
                              popup='<i>' + index + ' , ' + row['store_name'] + ' , ' + row['cost_hensa'] + '</i>',
                              tooltip=tooltip).add_to(cospa_map)
            else:
                folium.Marker([row['longitude'], row['latitude']], 
                              icon=folium.Icon(icon_color="black", color="green", icon="glyphicon glyphicon-cutlery"), 
                              popup='<i>' + index + ' , ' + row['store_name'] + ' , ' + row['cost_hensa'] + '</i>',
                              tooltip=tooltip).add_to(cospa_map)
        elif 30 < float(row['cospa']):
            if re.match(".*_1",index):
                folium.Marker([row['longitude'], row['latitude']], 
                              icon=folium.Icon(icon_color="yellow", color="red", icon="glyphicon glyphicon-star"), 
                              popup='<i>' + index + ' , ' + row['store_name'] + ' , ' + row['cost_hensa'] + '</i>',
                              tooltip=tooltip).add_to(cospa_map)
            else:
                folium.Marker([row['longitude'], row['latitude']], 
                              icon=folium.Icon(icon_color="black", color="red", icon="glyphicon glyphicon-cutlery"), 
                              popup='<i>' + index + ' , ' + row['store_name'] + ' , ' + row['cost_hensa'] + '</i>',
                              tooltip=tooltip).add_to(cospa_map)

cospa_map