Python Please Convert Xml Given Dataframe Format Analyze Data Thanks Q43824371
IN PYTHON:
can you please convert XML given below into dataframe that is ina format so that I can analyze the data .Thanks.
<?xml version=”1.0″ encoding=”UTF-8″standalone=”yes”?>
<Game Date=”2017/01/11″ Viewers=”6740″ Place=”NewlandsStadium”>
<Team Title=”Barcelona”>
<Players>
<Player Position=”V” Surname=”Sam” Name=”Sidney”Nr=”16″/>
<Player Position=”A” Surname=”Cisovsky” Name=”Marian”Nr=”17″/>
<Player Position=”U” Surname=”Verratti” Name=”Marco”Nr=”24″/>
<Player Position=”A” Surname=”Hummels” Name=”Mats”Nr=”27″/>
<Player Position=”U” Surname=”Quintero” Name=”Juan”Nr=”33″/>
<Player Position=”U” Surname=”Díaz” Name=”Marcelo”Nr=”37″/>
<Player Position=”A” Surname=”Criscito” Name=”Domenico”Nr=”39″/>
<Player Position=”A” Surname=”Filip” Name=”Lucian”Nr=”55″/>
<Player Position=”V” Surname=”Saviola” Name=”Javier”Nr=”56″/>
<Player Position=”A” Surname=”Streller” Name=”Marco”Nr=”64″/>
<Player Position=”U” Surname=”Weidenfeller” Name=”Roman”Nr=”73″/>
<Player Position=”A” Surname=”Amelia” Name=”Marco”Nr=”75″/>
<Player Position=”A” Surname=”Sandro” Name=”Alex”Nr=”84″/>
<Player Position=”U” Surname=”Djuricic” Name=”Filip”Nr=”89″/>
<Player Position=”A” Surname=”Varela” Name=”Silvestre”Nr=”94″/>
<Player Position=”A” Surname=”Sauro” Name=”Gastón”Nr=”96″/>
</Players>
<Shifts>
<Shift Time=”23:34″ Nr1=”16″ Nr2=”64″/>
</Shifts>
<Base>
<Player Nr=”37″/>
<Player Nr=”75″/>
<Player Nr=”73″/>
<Player Nr=”16″/>
<Player Nr=”24″/>
<Player Nr=”96″/>
<Player Nr=”55″/>
<Player Nr=”89″/>
<Player Nr=”27″/>
</Base>
<Faouls>
<Faoul Time=”41:40″ Nr=”27″/>
<Faoul Time=”56:24″ Nr=”96″/>
</Faouls>
<Goal>
<VG Time=”06:09″ Nr=”24″ Kick=”N”>
<P Nr=”96″/>
<P Nr=”55″/>
</VG>
<VG Time=”11:07″ Nr=”73″ Kick=”N”>
<P Nr=”24″/>
<P Nr=”37″/>
<P Nr=”16″/>
</VG>
</Goal>
</Team>
<Team Title=”Sochi”>
<Players>
<Player Position=”A” Surname=”Debess” Name=”Nils”Nr=”9″/>
<Player Position=”A” Surname=”Zibens” Name=”Vilhelms”Nr=”21″/>
<Player Position=”V” Surname=”Rausis” Name=”Vidmants”Nr=”22″/>
<Player Position=”A” Surname=”Zibens” Name=”Janka”Nr=”25″/>
<Player Position=”U” Surname=”Palodze” Name=”Rihards”Nr=”28″/>
<Player Position=”A” Surname=”Paraugs” Name=”Ciltvairis”Nr=”30″/>
<Player Position=”A” Surname=”Antena” Name=”Bo”Nr=”33″/>
<Player Position=”U” Surname=”Grants” Name=”Linards”Nr=”34″/>
<Player Position=”U” Surname=”Rokturis” Name=”Francis”Nr=”36″/>
<Player Position=”A” Surname=”Svilpe” Name=”Einars”Nr=”39″/>
<Player Position=”V” Surname=”Zirnis” Name=”Anderss”Nr=”41″/>
<Player Position=”A” Surname=”Kompass” Name=”Rolands”Nr=”44″/>
<Player Position=”U” Surname=”Kabacis” Name=”Kens”Nr=”47″/>
</Players>
<Shifts>
<Shift Time=”29:24″ Nr1=”25″ Nr2=”44″/>
</Shifts>
<Base>
<Player Nr=”9″/>
<Player Nr=”36″/>
<Player Nr=”21″/>
<Player Nr=”39″/>
<Player Nr=”25″/>
<Player Nr=”34″/>
<Player Nr=”30″/>
<Player Nr=”28″/>
<Player Nr=”47″/>
</Base>
<Faouls>
<Faoul Time=”50:57″ Nr=”36″/>
</Faouls>
<Goal>
<VG Time=”20:04″ Nr=”47″ Kick=”N”>
<P Nr=”9″/>
<P Nr=”25″/>
</VG>
<VG Time=”35:38″ Nr=”34″ Kick=”N”>
<P Nr=”30″/>
<P Nr=”28″/>
<P Nr=”44″/>
</VG>
<VG Time=”63:21″ Nr=”39″ Kick=”N”>
<P Nr=”34″/>
</VG>
</Goal>
</Team>
<T Surname=”Antamo” Name=”Dennis”/>
<T Surname=”Prompa” Name=”Pedro”/>
<VT Surname=”Rausis” Name=”Rihards”/>
</Game>
Expert Answer
Answer to IN PYTHON: can you please convert XML given below into dataframe that is in a format so that I can analyze the data .Tha…
OR