-
Notifications
You must be signed in to change notification settings - Fork 0
/
XmlParser.py
44 lines (31 loc) · 1.2 KB
/
XmlParser.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
# Python program to read json file - party list as example, and export into excel
# import library for working with json
import json
# import pandas for working with data and export to excel file
import pandas as pd
# Opening JSON file - for reading - as example is used party list
f = open("JsonParserPython\\PartyList.json")
# returns JSON object as a dictionary
data = json.load(f)
print("Dictionary created from json...")
# choose "my_party_list"
party_list = data["my_party_list"]
# Iterating through the json list
for i in data['my_party_list']:
print(i["first_name"] + "\t" + i["last_name"] + "\t" + i["phone"] + "\t" + i["email"])
# Rename keys using a dictionary comprehension
party_list = [{
"First Name": entry["first_name"],
"Last Name": entry["last_name"],
"Phone": entry["phone"],
"Email": entry["email"]
} for entry in party_list]
# Creating Excel Writer Object from Pandas
writer = pd.ExcelWriter('JsonParserPython\\party_list.xlsx',engine='xlsxwriter')
df = pd.DataFrame.from_dict(party_list)
df.to_excel(writer,sheet_name='Party list',startrow=0 , startcol=0)
# Closing excel file
writer.close()
print("Dictionary converted into excel...")
# Closing json file
f.close()