我想提取下表内容并通过pandas将其保存在CSV文件中,但只提取日期(例如,星期四,11/02)和所有值,这些值用€/MWh标记。提前非常感谢大家。在
源代码:
Thu, 11/02 | Fri, 12/02 | Sat, 13/02 | Sun, 14/02 | Mon, 15/02 | Tue, 16/02 | Wed, 17/02 | ||
---|---|---|---|---|---|---|---|---|
00 - 01 | €/MWh | 23.82 | 22.81 | 22.23 | 13.06 | 16.57 | 25.99 | 32.45 |
MWh | 10,266.0 | 9,626.6 | 12,255.9 | 11,084.7 | 11,039.5 | 13,134.7 | 9,958.1 | |
01 - 02 | €/MWh | 21.48 | 21.59 | 21.10 | 12.17 | 16.00 | 23.65 | 31.27 |
MWh | 9,843.3 | 9,494.4 | 11,823.3 | 10,531.9 | 9,970.5 | 12,875.6 | 9,958.8 | |
02 - 03 | €/MWh | 21.00 | 21.30 | 20.21 | 8.81 | 14.55 | 22.91 | 29.72 |
MWh | 9,857.0 | 9,427.9 | 11,755.2 | 10,061.9 | 9,881.7 | 12,841.0 | 9,896.9 | |
03 - 04 | €/MWh | 19.94 | 19.86 | 19.94 | 6.74 | 13.14 | 22.04 | 27.44 |
MWh | 9,486.2 | 10,492.7 | 12,609.1 | 11,216.6 | 10,199.9 | 11,209.7 | 9,698.5 |