We like Python. Anaconda is a popular distribution of Python and the R programming languages, which includes package management and deployment tools, with hundreds of packages pre-installed. Anaconda is aimed at data scientists and people working with machine learning, but it’s useful for anyone. It… Read More »How to Install Anaconda (Python & R) on Ubuntu
This article takes you through the creation of a COVID vaccination rate notifier. This project works by scraping data from the web and then displaying system notifications with Python. It hasn’t been the greatest year – but there’s light at the end of the tunnel.… Read More »COVID Vaccination Rate Notifier [Project] – Scraping and Displaying with Python
MySQL SELECT queries are commands that pull data from your database tables according to conditions each record must meet. Complex queries will often need to combine the results from two or more SELECT queries – this is what the UNION operator does. UNION Syntax SELECT… Read More »Using the ‘UNION’ Operator in MySQL and MariaDB
In this project, we take you through building, packaging, and publishing a command-line application using Python to resize and watermark images. Whenever I complete an article for LinuxScrew, I need to go through and add watermarks and make other small adjustments to any photos I’ve… Read More »Building a Python Script to Resize & Watermark Images [Code Included]
In this guide, we cover foreign key constraints in MySQL and MariaDB, along with a number of useful examples. MySQL (and its fork MariaDB) are Relational Database Management Systems (RDBMS) – Database Systems which hold data in tables which can be related to each other. Tables in… Read More »Guide to Foreign Key Constraints in MySQL and MariaDB [With Examples]
This tutorial explains how to create loops in Python by using the “while” statement. Included below are the syntax and examples. In programming (and thus, in Python), a loop is a statement which will execute a block of code repeatedly until a condition is met, or… Read More »Python “while” Loops [with Examples]
There is a useful function in Python called ‘sleep()’. It’s part of the ‘time’ module and allows you to pause, sleep, wait, or stop a Python script or application. Python can be used to make useful command-line tools to streamline your workflow, but sometimes you… Read More »Python time.sleep() to Pause, Sleep, Wait or Stop a Python Script
In Python, there’s an easy way to sort lists: using the sort() method. This tutorial explains how to use sort(), with examples. We’ve covered the following in Python: Removing list items Checking if items are in lists Finding items in lists Now it’s time to… Read More »Python List ‘sort()’ Method – Sorting Lists in Python Easily
This tutorial explains how to find items within a list in Python and return the values, using “filter”. Previously we covered checking whether items exist in a list in Python, but that could only tell us whether they were present, or not (with a boolean return value containing… Read More »Python: Find in a List and Return Values [using ‘filter’]
You’ll want to process and tidy your user input before you do anything with it when building PHP apps. trim() is one of the tools available to do this – it removes all white space from the beginning and end of a string. Whitespace is things like… Read More »PHP trim() Function [With Examples]
