• Coding

    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.. … The script below helped me with some research data for my Research Module (wish me good luck!) 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 a personalised solution [sourcecode lang=”python”] #USAGE python getdata.py from pyexcel_ods import get_data import os , re, json, openpyxl, logging, typing, sys logging.basicConfig(level=logging.DEBUG, format="%(asctime)s – %(levelname)s – %(message)s") def get_rows_xy(sheet: typing.List ): ”’ argument: sheet : a multidimensional list…

  • 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 = os.path.abspath(comic_directory)</p> <p>base_url = "http://www.lefthandedtoons.com"</p> <p>def handle_each_comic(soup: bs4.BeautifulSoup):<br> comic_image = soup.find(class_="comicimage")<br> if comic_image:<br> img_src = comic_image.get("src")<br> comic_name = soup.find(class_="comictitle").find("a")<br> ext_expression = re.compile(r"\.(\w{3})$")<br> comic_name = comic_name.get_text()<br> logging.info("Comic: {} has src {}".format(comic_name, img_src))<br> comic_image_ext = ext_expression.search(img_src)<br> comic_image_ext = (comic_image_ext.groups()[0])</p> <p> #download image<br> if not os.path.exists(comic_directory):<br> os.makedirs(comic_directory)<br> logging.info("Comic Directory Created: " + comic_directory)<br> try:<br> res = requests.get(img_src)<br> res.raise_for_status()<br> #create…

error: Content is protected !!