Featured Post
Welcome to Scriptopia!
Python tkinter – YouTube content downloader (MP4 & MP3)
Here we will be creating a YouTube content downloader, it will make use of the tkinter framework which will enable us to a UI. The script will take input from the user and give the option to download content as either MP4 or MP3 format. To download content we will be using pytube which isContinue reading “Python tkinter – YouTube content downloader (MP4 & MP3)”
Python – Downloading YouTube captions
In this post we will be creating a script that will download the captions of a YouTube video. We will be using pytube which is a lightweight, Pythonic, dependency-free, library for downloading YouTube Videos. The library is very easy to use and quite intuitive. We start by taking input which will be the URL ofContinue reading “Python – Downloading YouTube captions”
Python – Downloading YouTube videos as MP3 files
Todays script will download YouTube content as MP3 format files. We will be using pytube which is a lightweight, Pythonic, dependency-free, library for downloading YouTube Videos. The library is very easy to use and quite intuitive. We start by taking input which will be the URL of the YouTube video we are interested in, usingContinue reading “Python – Downloading YouTube videos as MP3 files”
Python – Downloading YouTube videos
In todays write we’ll be creating a short and simple script that will download YouTube videos using a Python script. We will be using pytube which is a lightweight, Pythonic, dependency-free, library for downloading YouTube Videos. The library is very easy to use and quite intuitive. We start by taking input which will be theContinue reading “Python – Downloading YouTube videos”
Python – Microsoft Word to PDF
The following will convert an existing Microsoft Word document into a PDF file type. I find this especially useful for bulk conversions before doing some form of mass mailout. Find the full source code for this project below:
Python Twitter Bot – Tweeting scraped content
In this post we will be creating a Twitter bot that will scrape some content online and post this as tweets to a Twitter account. Please not that this is for educational purposes only and in this post we will be using a news site to get hold of the details of their latest story.Continue reading “Python Twitter Bot – Tweeting scraped content”
Python MySQL – Truncating a table
MySQL is an open-source relational database management system. Here we will be creating a Python script that will truncate all data within a specified table. By truncating a table we will be removing all rows from a table, but the table structure and its columns, constraints, indexes will remain. You may also be interested inContinue reading “Python MySQL – Truncating a table”
Data Analysis – Finding the mean, mode and median of combined CSV files
In this post we will be trying to find the mean, mode and median for data located within two CSV spreadsheets. The script will read from each of the spreadsheets and then concatenate the two together before finding the mean, mode and median. Mean – This is the same as the average value of aContinue reading “Data Analysis – Finding the mean, mode and median of combined CSV files”
Python MySQL – Retrieving data
MySQL is an open-source relational database management system. In this post we will be retrieving MySQL data via a Python script. You may also be interested in inserting data, updating data and deleting 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 – Retrieving data”
Python Selenium – Scraping Google search result headings
In this project we will use Selenium and a Chrome web driver to scrape the headers 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 headings”
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”
