楽天モバイルの基地局の地図を作製

楽天モバイル https://www.tele.soumu.go.jp/musen/SearchServlet?pageID=4&IT=G&DFCD=0000524258&DD=2&styleNumber=00

https://www.tele.soumu.go.jp/musen/SearchServlet?SC=1&pageID=3&SelectID=3&CONFIRM=0&NA=%8Ay%93V%83%82%83o%83C%83%8B%8A%94%8E%AE%89%EF%8E%D0&CATINDEXCD=A001&IT=G&HC=38&HV=202&MK=&TSNJK=&FF=&TF=&HZ=3&NA2=%8Ay%93V%83%82%83o%83C%83%8B%8A%94%8E%AE%89%EF%8E%D0&NA1=%8Ay%93V%83%82%83o%83C%83%8B%8A%94%8E%AE%89%EF%8E%D0&DFY=&DFM=&DFD=&DTY=&DTM=&DTD=&SK=2&DC=100&as_fid=a45270860a8cb3e7a7b65b2b8a54a42896f8841a#result

import pandas as pd
import folium

url = "https://docs.google.com/spreadsheets/d/e/2PACX-1vS74zyg2Q6lC4N0591Bx2_7BhPjir1gRGv8KY3_aoXOA07j8-hNasD_e430ER5T7xTU2cy973sw9wiX/pub?gid=0&single=true&output=csv"

df = pd.read_csv(url)

df

colors = {"開局": "green", "未開局": "yellow"}

imabari_map = folium.Map(location=[34.06604300, 132.99765800], zoom_start=12)

for i, r in df.iterrows():

    color = colors.get(r["status"], "black")

    folium.Marker(
        location=[r["latitude"], r["longtude"]],
        popup=r["name"],
        icon=folium.Icon(color=color, icon="signal"),
    ).add_to(imabari_map)
    folium.Circle(
        location=[r["latitude"], r["longtude"]],
        popup=r["name"],
        radius=2000,
        color=color,
        fill=True,
        fill_color=color,
    ).add_to(imabari_map)

# ここからは下は勝手に基地局追加

# かみとくの湯
folium.Circle(
    location=[34.039893248086905, 133.01205912457712],
    radius=2000,
    color="red",
    fill=True,
    fill_color="red",
).add_to(imabari_map)

# 市営体育館
folium.Circle(
    location=[34.07259426656803, 132.99259956654348],
    radius=2000,
    color="red",
    fill=True,
    fill_color="red",
).add_to(imabari_map)

# 県病院
folium.Circle(
    location=[34.08573221092478, 132.9887154862471],
    radius=2000,
    color="red",
    fill=True,
    fill_color="red",
).add_to(imabari_map)

# イオン新都市
folium.Circle(
    location=[34.04196921477711, 132.9608585492133],
    radius=2000,
    color="red",
    fill=True,
    fill_color="red",
).add_to(imabari_map)

# 地図描画
imabari_map