Tag: coding

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 14: Excel-to-CSV Converter

And where I excel is ridiculous, sickening, work ethic. You know, while the other guy’s sleeping? I’m working. Will Smith I like will smith!! 12:50:11 AM   This task was unexpectedly difficult for me, so I am not sure if it is correct [sourcecode language=”python”] #USAGE python excel_2_csv.py import openpyxl, os, sys, logging, csv logging.basicConfig(level=logging.DEBUG, format="%(asctime)s […]

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:Automating Simple Tasks with Python: Using Python…Python Learning: Automate Boring Stuff with Python |…Practicing Python | Think Python: Case study:…Python Learning: Automate Boring Stuff with Python |…Python Learning: Automate […]

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

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

Coding

“Python Learning: Automate Boring Stuff with Python | Chapter 11 : My Solution to Image Downloader from Imgur

So you want to download images without a browser..  challenge accepted 3:43:41 PM   [sourcecode language=”python”] #Image Site Downloader #USAGE: python igmurdownloader.py <category> <limit> import sys, requests, os, logging, bs4, re logging.basicConfig(level=logging.DEBUG, format="%(asctime)s – %(levelname)s – %(message)s") logging.disable(logging.CRITICAL) if len(sys.argv) == 3: logging.info("Command line argument 3") #TODO: get category, and limit category = sys.argv[1] limit = […]

Coding

“Python Learning: Automate Boring Stuff with Python | Chapter 8 : My Solution to Practice Project: Filling in the Gaps

How to fill in the gaps 1:49:09 AM I need help with this! I like this exercise but I cannot seem to find its ideal solution. Could someone suggest in pseudocode, please..? I finally found the right way to post the python code (with indenting of-course) These might interest you:“Python Learning: Automate Boring Stuff with Python…Python […]

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 8 : My Solution to Practice Project: Deleting Unneeded Files

Personally, one of the simplest projects yet This code (when properly indented) helps to list out all files with a size greater than the given limit.   [sourcecode language=”python” wraplines=”false” collapse=”false”] #Usage python big.py limit in MB <source> import sys, os if len(sys.argv) >= 2: limit = sys.argv[1] source = sys.argv[2] if len(sys.argv) == 3 […]

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 8 : My Solution to Practice Project: Selective Copy

As usual… super simple automation.. I know it is quite trivial, but the fact that with a few lines of code I could re-organize my files based on their extensions makes coding really fun even outside of work.      [sourcecode language=”python” wraplines=”false” collapse=”false”] #selective copy #walks through a folder tree and searches for files […]