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: 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

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

Python: Matplotlib – How to use csv and subplots for beginners

So how do I use subplots? 08/26/2018 The code below is custom to my csv file (see below), so make sure you either use the same format or change the “get_file” function to the properly process your file. MOCK_DATA_2 File Content The file above looks like this: x,y 64,13 57,14 16,30 92,29 65,97 11,33 CODE […]

python: Creating a simple bar plot with python, matplotlib module and csv data 2020

This is so simple, it needs no heading.. 08/19/201810:10:49 PM Drinks Coffee as usual… Straight to the point: So this is the CSV data I will be working with ( generated using the website: https://mockaroo.com) MOCK_DATA Goal Create a bar plot showing  the number of emails based on the alphabets they begin with . For instance, […]

Automate Simple Tasks with Python: Excel Table to HTML Table using the python Dominate Module

If you need help with your excel table conversion, i provide such a service here 😀 Sometimes a database is really not necessary. Why not try a simple excel sheet Coded this in an hour; sips on coffee though 9:06:34 PM I generated the excel workbook using a website called Mockaroo. Today’s task is to convert a […]

Automating Simple Tasks with Python: Using Python and Window Task Scheduler to get the word of the day

❝Learning is a treasure that will follow its owner everywhere.❞‒Chinese Proverb So I want to learn one english word per day, but I am too lazy and forgetful to visit the website ? Hmm…. bulb floats on head Let us create a python script, that runs daily by the Windows Task Scheduler 12:16:00 AM Coffee break… […]

How Python helps outside of work: ods data to excel

I hate copying and pasting, so might as well automate it 9:43:24 PM Trying to complete my research paper.. … If you have any question, do ask in the comment section. See you! This allows for transforming my .ods file to .xlsx //Note –> You will have to tweak this to your needs. This is […]

Python Learning: Automate Boring Stuff with Python | Chapter 15: Scheduled Web Comic Downloader

  The world is indeed comic, but the joke is on mankind. H. P. Lovecraft true.. true.. 6:23:15 PM I made different functions to handle a specific (one) task; Division of labor   # usage python download_lefthand_comic.py import logging import os import requests import bs4 import time import re # TODO: CHECK FOR LAST UPDATE # […]

Python Learning: Automate Boring Stuff with Python | Chapter 15: Prettified Stopwatch

I want to turn the clock back to when people lived in small villages and took care of each other. Pete Seeger And more coffee.. 4:05:04 PM #usage Prettified_Stopwatch.py import time , pyperclip #TODO: start by enter #TODO: store start time #TODO: create lapNum #TODO: loop until user ctrl c input() startTime = time.time() lapNum = […]

Python Learning: Automate Boring Stuff with Python | Chapter 13: Brute-Force PDF Password Breaker

“I can stand brute force, but brute reason is quite unbearable. There is something unfair about it’s use. It is hitting below the intellect.” ― Oscar Wilde, The Picture of Dorian Gray I don’t get it.. 11:20:21 PM # USAGE python brute_force.py import PyPDF2 import os import sys import logging logging.basicConfig(level=logging.DEBUG, format=”%(asctime)s – %(levelname)s – %(message)s”) […]

Python Learning: Automate Boring Stuff with Python | Chapter 13: Custom Invitations as Word Documents

“Nothing annoys people so much as not receiving invitations.” ― Oscar Wilde, The Importance of Being Earnest I know that feeling…humph.. 10:36:20 PM   # usage python invitation.py <textFile> import docx import os import sys import logging from docx.enum.text import WD_ALIGN_PARAGRAPH logging.basicConfig(level=logging.DEBUG, format=”%(asctime)s – %(levelname)s – %(message)s”) if len(sys.argv) == 2: # TODO: GET TEXT FILE […]

Python Learning: Automate Boring Stuff with Python | Chapter 13: PDF Paranoia

“Paranoid? Probably. But just because you’re paranoid doesn’t mean there isn’t an invisible demon about to eat your face.” scary… 9:13:00 PM my solution # usage pdf_paranoia_encrypt.py import PyPDF2 import os import sys import logging logging.basicConfig(level=logging.DEBUG, format=”%(asctime)s – %(levelname)s – %(message)s”) # TODO: GET PASSWORD FROM COMMAND LINE if len(sys.argv) == 2: # TODO: OS WALK […]

Python Learning: Automate Boring Stuff with Python | Chapter 12: Spreadsheet to Text Files

Chapter 12 done!!! Finally Now I can sleep.. for 10 minutes though.. 3:42:14 AM Suggestions are welcomed. # USAGE python sheet2text.py import logging import sys import os import openpyxl logging.basicConfig(level=logging.DEBUG, format=”%(asctime)s – %(levelname)s – %(message)s”) if len(sys.argv) == 2: # TODO: EXTRACTS EXCEL FILE excelfile = sys.argv[1] excelfile = os.path.abspath(excelfile) excelfile_name = os.path.basename(excelfile).split(“.”)[0] if not os.path.exists(excelfile): […]

Python Learning: Automate Boring Stuff with Python | Chapter 12: Text Files to Spreadsheet

1 hour laturr….. I need coffee but if I drink coffee, I will go to sleep… drinks green tea instead 3:18:41 AM Code # USAGE python text2sheet import logging import sys import os import openpyxl logging.basicConfig(level=logging.DEBUG, format=”%(asctime)s – %(levelname)s – %(message)s”) if len(sys.argv) > 1: # TODO: EXTRACT TEXT FILES files = sys.argv[1:] # TODO:CREATE NEW WORKBOOK […]

Python Learning: Automate Boring Stuff with Python | Chapter 12: Spreadsheet cell Inverter 2020

This isn’t too bad …right ? Not too tired but would rather be sleeping now. Unfortunately I have to finish this chapter before Sunday.. sighs deeply 2:53:05 AM     # USAGE python sheetinverter.py import logging import openpyxl import os import sys logging.basicConfig(level=logging.DEBUG, format=”%(asctime)s – %(levelname)s – %(message)s”) if len(sys.argv) == 2: # TODO: EXTRACT WB wb […]

Python Learning: Automate Boring Stuff with Python | Chapter 12: Blank Row Inserter

I really don’t know how useful this automation is, but okay.. 04:07:22 still tired… Korean indie music playing in the background; this is going to be fun. Note: I did not check to see if the file to be read / workbook already has content in the rows. To do so, I could simply add […]