如何使用类似于GIS融合操作的Pandas在Python中汇总分段的道路数据？

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

data = pd.read_csv('road_data.csv')

# 去除重复数据
data = data.drop_duplicates()

# 处理缺失值
data = data.dropna()

# 分段汇总道路数据
segmented_data = data.groupby('segment_id').agg({
    'road_length': 'sum',
    'max_speed': 'mean',
    'traffic_volume': 'sum'
}).reset_index()

# 可视化结果
plt.bar(segmented_data['segment_id'], segmented_data['road_length'])
plt.xlabel('Segment ID')
plt.ylabel('Road Length')
plt.title('Road Length by Segment')
plt.show()