将Delft-FEWS Series xml文档加载到pandas DataFrame中

import pandas as pd
from xml.etree import ElementTree as ET

tree = ET.parse('path/to/xml/file.xml')
root = tree.getroot()

data = []
for series in root.iter('series'):
    series_id = series.attrib['seriesId']
    for point in series.iter('point'):
        timestamp = pd.to_datetime(point.attrib['date'])
        value = float(point.attrib['value'])
        data.append([series_id, timestamp, value])

df = pd.DataFrame(data, columns=['series_id', 'timestamp', 'value'])