加载能耗数据并统计设备耗电排名

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    csv_data = open_url('https://data.zuihe.com/dbd/ms-smarthome/state_04/energy_usage.csv').read()
    df = pd.read_csv(StringIO(csv_data))
    result = df.groupby('device_id')['kwh'].sum().sort_values(ascending=False)
    for d, kwh in result.head(5).items():
        print(f'{d}: {kwh:.2f}度')