Python docx – Retrieving text from a Word document

In todays post we will be retrieving the contents of a Word document via a python script. To do this we will use docx which is a Python library for creating and updating Microsoft Word (.docx) files. The script will take the location of a file which will come as user input. This will thenContinue reading “Python docx – Retrieving text from a Word document”

Microsoft Excel – Text to columns

Text to columns is useful feature in Microsoft Excel that allows that allows us to parse data in a single cell to many cells based on a defined delimiter. To do this carry out the following steps: Highlight the cell or column that you are wanting to parse. Select the ‘Data’ tab and then clickContinue reading “Microsoft Excel – Text to columns”

Microsoft Excel – Highlighting cells with duplicate values

In todays post we will be highlighting cells with duplicate values, to do this carry out the following steps: Start by highlighting the range of cells where duplicates may exist. Within the ‘Home‘ tab click on ‘Conditional Formatting‘ button, within the dropdown click ‘Highlight Cells Rules‘ and in the next sub menu click ‘Duplicate Values…‘Continue reading “Microsoft Excel – Highlighting cells with duplicate values”

Python psutil – Battery percentage notifications

Psutil is is a cross-platform library for retrieving information on running processes and system utilization, in todays post we will be using this library to retrieve our machines battery percentage. Using plyer we will then push this as an on screen notification. We start by retrieving the current percentage of our machines battery. We then move on toContinue reading “Python psutil – Battery percentage notifications”

Microsoft Excel – Removing blank cells in a spreadsheet

In todays post we will go through removing blank cells within a spreadsheet, to achieve this you will need to carry out the steps listed below: Start by highlighting the range of cells where you are wanting to remove the blanks. Within the ‘Home‘ tab click on ‘Find & Select‘ and then click ‘Go toContinue reading “Microsoft Excel – Removing blank cells in a spreadsheet”

Python Plyer – Enabling desktop notifications

Desktop notifications are a great way to get the users attention, in this post we will be creating a script in python that will push out desktop notifications. To do this we’ll be using the plyer which is used to access the features of hardware, in particular their notifications module. Our notification in this exampleContinue reading “Python Plyer – Enabling desktop notifications”

Python tkinter – YouTube captions scraper | Content generator

In this post we will be creating a Python script that will scrape YouTube captions and post these to a WordPress site as a blog. The prerequisite of this project is that you have a WordPress site with the post by option enabled, more on how to do this can be found here. To downloadContinue reading “Python tkinter – YouTube captions scraper | Content generator”

Python NLTK – Text spinner (Adjectives)

Here we have created what some may call a start to a text spinner, the following will find and replace adjectives with a synonym. To achieve this, we are using the Python NLTK (natural language toolkit) which is a Python package for natural language processing (NLP). We begin by marking the words in the sentenceContinue reading “Python NLTK – Text spinner (Adjectives)”