FilesExpand file tree

master

/

final.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

22 lines (18 loc) · 468 Bytes

master

/

final.py

Copy path

Top

File metadata and controls

• Code
• Blame

22 lines (18 loc) · 468 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

import xml.etree.ElementTree as ET

import pandas as pd

from tabulate import tabulate

xmlFile = open('response.xml')

tree = ET.parse(xmlFile)

root = tree.getroot()

l1 = []

l2 = []

for x in root.findall('.//'):

l1.append(x.tag)

l2.append(x.text)

l3 = []

for x in l1:

l3.append(x.split('}', 1)[1])

df1 = pd.DataFrame({'Tags': l3,

'Data': l2})

print(tabulate(df1, showindex=False, headers=df1.columns))

df1.to_csv('final.csv', index=0)