Bounce, Fade, Animate 05/03/2019 11:56:52 PM Intro into React Transitions In case you are a newbie in the world of react transitions, you should probably read this post (React Transitions for Dummies | Part 1 : Transition, Styled Components and RandomColor) before continuing. <Transition> If you want to animate a react component, wrap it with […]
Category Archives: Coding
React Transitions for Dummies | Part 1 : Transition, Styled Components and RandomColor
04/29/2019 12:49:21 AM Overview Simply learning on how to use the React Transition Group “Transition” component to make websites look awesome! Who is this for? This should be useful for those who are confused as I was and (to some extent) still am about component and page transitions especially in React. Why I wanted to […]
Beginner Automating with Python | Converting MYSQL database tables into single CSV files
Things you might need before coding Install python here Since this solution is realised by using the programming language called python, you should probably install it as instructed in the website linked above. Additionally, you may need to understand the programming principles independent of programming language and also learn the code syntax in python. An […]
HTML5 for Beginners 2019 : Interesting Elements | Part 1
So you are a learning web developer who uses a lot of divs right ? Well… what if I told you, there is a whole new world to be explored…..
Practicing Python | Think Python: Case study: interface design – Exercise 4.3
Make a more general version of circle called arc that takes an additional parameter
angle, which determines what fraction of a circle to draw
Practicing Python | Think Python: Functions – Exercises
A function object is a value you can assign to a variable or pass as an argument. For
example, do_twice is a function that takes a function object as an argument and calls it twice:
def do_twice
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:
|
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 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 |
[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 = [] for key in dict_keys: temp.append(child.find(key).text) mdlist.append(temp) return mdlist def to_Excel(mdlist): ''' Generates excel file with given data mdlist: 2 Dimenusional list containing data ''' wb = Workbook() ws = wb.active for i,row in enumerate(mdlist): for j,value in enumerate(row): ws.cell(row=i+1, column=j+1).value = value newfilename = os.path.abspath("./xml_to_excel.xlsx") wb.save(newfilename) print("complete") return def to_Json(mdlist): ''' Generates json file with given data mdlist: 2 Dimenusional list containing data ''' #create a file newfilename = os.path.abspath("./data.json") json_file = open(newfilename, "w"); dictionary = {"data":mdlist} my_json_string = json.dumps(dictionary) json_file.write(my_json_string) json_file.close(); print("complete") def to_CSV(mdlist): ''' Generates csv file with given data mdlist: 2 Dimenusional list containing data ''' newfilename = os.path.abspath("./data.csv") fh = open(newfilename, "w") writer = csv.writer(fh, delimiter=' ',quotechar='|') #each value is separated by space; if "," substitute " " with "," for row in mdlist: writer.writerow(row) fh.close() print("complete") result = readFile("./dataset.xml") if result: to_CSV(result) [/sourcecode] |
Resulting CSV File
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
|
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 45 46 47 48 49 50 51 52 53 54 55 56 57 58 |
[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 root: temp = [] for key in dict_keys: temp.append(child.find(key).text) mdlist.append(temp) return mdlist def to_Excel(mdlist): ''' Generates excel file with given data mdlist: 2 Dimenusional list containing data ''' wb = Workbook() ws = wb.active for i,row in enumerate(mdlist): for j,value in enumerate(row): ws.cell(row=i+1, column=j+1).value = value newfilename = os.path.abspath("./xml_to_excel.xlsx") wb.save(newfilename) print("complete") return def to_Json(mdlist): ''' Generates json file with given data mdlist: 2 Dimenusional list containing data ''' #create a file newfilename = os.path.abspath("./data.json") json_file = open(newfilename, "w"); dictionary = {"data":mdlist} my_json_string = json.dumps(dictionary) json_file.write(my_json_string) json_file.close(); print("complete") result = readFile("./dataset.xml") if result: to_Json(result) [/sourcecode] |
Resulting File Recommended Read: Python File Handling: Create, Open, Append, Read, Write Python 4 Beginners: XML to Excel within a minute python: Creating a […]
Python 4 Beginners: XML to Excel within a minute
So you have an xml file with data you need extracted and converted into an excel sheet ?
Python 4 Beginners: how to generate a list of random values
I recently just learned how to do this without using loops: That is all I know for now. I will update this when I find new and more efficient methods… Check out Python: Matplotlib – How to use csv and subplots for beginners python: Creating a simple bar plot with python, matplotlib module and csv […]