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 […]

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: #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 […]

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 #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 […]

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: import random x = [0 for _ in range(10)] #underscore used when you do not need the value from the list. So here 0 replaces the value from range(10) #expected output [0, 0, 0, 0, 0, 0, 0, 0, 0, 0] y = [random.random() […]