Tag: python

Coding, Python

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

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

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

Coding

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

Book 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 [sourcecode language=”python”]</p> <p>#usage python download_lefthand_comic.py<br> import logging, os, requests, bs4,time, re</p> <p>logging.basicConfig(level=logging.DEBUG, format="%(asctime)s – %(levelname)s – %(message)s")</p> <p>comic_directory = os.path.join("c:\\", "comicbooks", "lefthandedtoons")<br> comic_directory = […]

Coding

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     [sourcecode language=”python”] #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 […]

Coding

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 These might interest you:Python Learning: Automate Boring Stuff with Python |…Python Learning: Automate Boring Stuff with Python |…Python […]

Coding

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

Coding

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 These might interest you:“Python Learning: Automate Boring Stuff with Python…Automate Simple Tasks with Python: Excel Table to…Python Learning: Automate Boring Stuff with Python |…Python Learning: Automate Boring Stuff with Python |…“Python Learning: […]

Coding

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. [sourcecode language=”python”] #USAGE python sheet2text.py <EXCELFILE> import logging, sys, os, 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): logging.error("Excel File […]

Coding

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 These might interest you:Python Learning: Automate Boring Stuff with Python |…Python Learning: Automate Boring Stuff with Python |…Python Learning: Automate Boring Stuff with Python |…Python Learning: Automate Boring Stuff with Python |…Python Learning: Automate Boring […]

Coding

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

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     [sourcecode language=”python”] #USAGE python sheetinverter.py <WB> import logging, openpyxl, os,sys logging.basicConfig(level=logging.DEBUG, format="%(asctime)s – %(levelname)s – %(message)s") if len(sys.argv) == 2: #TODO: EXTRACT WB wb = sys.argv[1] wb […]