Python Selenium – Scraping Google search result URL’s

In this project we will use Selenium and a Chrome web driver to scrape the URL’s of Google search results. The prerequisite of the project is that you have a Chrome web driver stored on your machine. You may download the web driver by clicking here, note that it needs to match your current versionContinue reading “Python Selenium – Scraping Google search result URL’s”

Python MySQL – Deleting data

MySQL is an open-source relational database management system. In this post we will be deleting MySQL data using a Python script. You may also be interested in inserting data, updating data and retrieving data. The script expects two columns which are ‘Name’ and ‘Age’ to already exist as part of our database table. In thisContinue reading “Python MySQL – Deleting data”

Python MySQL – Updating data

MySQL is an open-source relational database management system. In this post we will be updating MySQL data via a Python script. You may also be interested in inserting data, deleting data and retrieving data. The script expects two columns which are ‘Name’ and ‘Age’ to already exist as part of our database table. In thisContinue reading “Python MySQL – Updating data”

Python MySQL – Inserting data

MySQL is an open-source relational database management system. Here we will be creating a Python script that will take user input and insert this to a MySQL database. You may also be interested in updating data, deleting data and retrieving data. In this example the user input will consist of two variables which are nameContinue reading “Python MySQL – Inserting data”

Work Automation – email send out with Word/PDF attachments

Another one around the topic of automated email sending, we have previously covered sending emails via in-house mail servers, Gmail servers as well as Outlook servers. In this post we’ll run through the sending of emails with file attachments. This script caters for most file types i.e. Word documents, PDF’s as well as Excel spreadsheets.Continue reading “Work Automation – email send out with Word/PDF attachments”

Data Analysis – Finding the mean, mode and median for data in a CSV file

In this post we will be trying to find the mean, mode and median for data located within a CSV spreadsheet. I anticipate getting into machine learning and what the Python language has to offer in this realm, I have also heard a lot about the use of R in data analysis and so IContinue reading “Data Analysis – Finding the mean, mode and median for data in a CSV file”

Work Automation – email send out with image attachments

The topic of automated emails seems to be a popular one, we have previously covered sending emails via in-house mail servers, Gmail servers as well as Outlook servers. In this post we will be going through how to add images as attachments to these automated emails. Find the full source code for this project below,Continue reading “Work Automation – email send out with image attachments”

Python yfinance – Retrieving price data from Yahoo Finance

In this one we will be retrieving basic price data from Yahoo finance via the yfinance python library. The library makes it very easy to do this without the need for any authentication, do note that any price data received from Yahoo finance is delayed by 15 minutes. The script will take user input, whichContinue reading “Python yfinance – Retrieving price data from Yahoo Finance”

Nord VPN – Python automatic location switcher

The following will automatically switch Nord VPN locations after a set period of time. The prerequisite of this script is Nord VPN must be installed on your machine; the script will check your machine automatically for the Nord program files. In the script we create a list which contains all Nord VPN server locations. ThenContinue reading “Nord VPN – Python automatic location switcher”

Python Selenium – LinkedIn connect and message bot

In this project we will use Selenium and a Chrome web driver to create a script that will connect with and message people on LinkedIn. Prerequisite of the project is that you have a LinkedIn account and a Chrome web driver stored on your machine. You may download the web driver by clicking here, noteContinue reading “Python Selenium – LinkedIn connect and message bot”