Good morning fellow R users!
I need to read multiple .XML files now gathered in one folder and collect
them in a table in R. The files have only numeric names and are named nearly
continuously (e.g 1.xml, 2.xml, 3.xml ..... up to about 40000.xml) but with
a few missing numbers/files. So the code must be able to handle missing
files.
Can someone suggest a FOR-loop in R that could be able to read all these
files and categorize them correctly? I've pasted an example underneath. (For
those interested, this is an "Urgent Market Message" on Nord Pool Spot. I
would like to systematize them to observe the power market reserve margin as
historic time series. That is estimate how much electricity is actually
available for the market.
<?xml version="1.0" encoding="ISO-8859-1" ?>
- <#> <participant_umm>
<effect_after>100</effect_after>
<station>Vinje</station>
<affected_units>G1, G2, G3</affected_units>
- <#> <umm predecessor_id="*0*" parent_id="*5244*" new_followup="*New*"u_id
="*5244*">
<event_start>19.07.04 hour 11:15</event_start>
<registered>19.07.04 hour 11:15</registered>
<event_type>Production failure</event_type>
<status>Approved and does not have a Followup</status>
<decission>19.07.04 hour 11:15</decission>
<event_stop />
<predefined_remark />
<approved>19.07.04 hour 11:17</approved>
<affected_areas>NO1</affected_areas>
<remarks>Failure G2, unavailable until further notice.</remarks>
<company>Statkraft SF</company>
</umm>
<effect_before>100</effect_before>
<affected_fuels>Hydro</affected_fuels>
<effect_during>0</effect_during>
<prodcons>Production</prodcons>
<effect_installed>300</effect_installed>
</participant_umm>
Thanks a lot!
Best,
Jørgen Blystad Houge
MSc student Norwegian University of Science and Technology
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
