我们如何计算重复的街道地址，并在Folium中绘制结果？

import pandas as pd
import folium
from geopy.geocoders import Tencent

# 读取包含街道地址的数据集
data = pd.read_csv('data.csv')

# 数据清洗
data['address'] = data['address'].str.strip().str.lower()

# 计算重复的地址
duplicate_addresses = data.groupby('address').size().reset_index(name='count')
duplicate_addresses = duplicate_addresses[duplicate_addresses['count'] > 1]

# 地理编码
geolocator = Tencent(api_key='your_tencent_api_key')
duplicate_addresses['location'] = duplicate_addresses['address'].apply(geolocator.geocode)

# 创建地图
map = folium.Map(location=[latitude, longitude], zoom_start=12)

# 在地图上绘制重复地址
for index, row in duplicate_addresses.iterrows():
    address = row['address']
    count = row['count']
    location = row['location']
    latitude = location.latitude
    longitude = location.longitude
    
    # 在地图上标记地址位置
    folium.Marker([latitude, longitude], popup=f'{address} (Count: {count})').add_to(map)

# 保存地图为HTML文件
map.save('map.html')