• Coding

    Python 4 Beginners: XML to CSV within a minute

    Hey yall! Another snippet to convert the same XML file in Python 4 Beginners: XML to JSON within a minute into a simple CSV file.  XML File: Code: [sourcecode lang="python"] #XML TO EXCEL FILE import xml.etree.ElementTree as ET from openpyxl import Workbook import os import json import csv def readFile(filename): ''' Checks if file exists, parses the file and extracts the needed data returns a 2 dimensional list without "header" ''' if not os.path.exists(filename): return tree = ET.parse(filename) root = tree.getroot() #you may need to adjust the keys based on your file structure dict_keys = ["id","first_name","last_name","email","gender","ip_address" ] #all keys to be extracted from xml mdlist = [] for child in root: temp…

  • Coding

    Python 4 Beginners: XML to JSON within a minute

    This is an extension of the Python 4 Beginners: XML to Excel within a minute. A simple function will help generate a json file. This is the XML File  xml_to_excel The Code [sourcecode lang="python"] #XML TO EXCEL FILE import xml.etree.ElementTree as ET from openpyxl import Workbook import os import json def readFile(filename): ''' Checks if file exists, parses the file and extracts the needed data returns a 2 dimensional list without "header" ''' if not os.path.exists(filename): return tree = ET.parse(filename) root = tree.getroot() #you may need to adjust the keys based on your file structure dict_keys = ["id","first_name","last_name","email","gender","ip_address" ] #all keys to be extracted from xml mdlist = [] for child in…

error: Content is protected !!