How to use SELECT, FROM, WHERE, and AND in SQL statements

The SELECT statement is the most simple of all SQL queries and allows you to retrieve the precise data you want from one or more tables, or even databases. In...

How to import a MySQL database

SQL is one of the most widely used languages in data science so it’s important to know at least the basics required in order to fetch the data you’ll need...

How to read QR codes in Python using OpenCV

The QR code or Quick Response code is a two-dimensional or matrix barcode invented in the early nineties by a Japanese car manufacturer. QR codes started to become popular in...

How to calculate month start and month end dates in Python

When creating business reports or running queries against a database or web analytics platform in a business setting, you’ll often need to know the start and end dates of the...

How to calculate ISO week numbers and start and end dates in Python

In ecommerce and marketing it’s relatively common to use ISO week numbers when reporting data. The ISO week system is a leap week calendar that forms part of the ISO...

How to forecast Google Trends search data with NeuralProphet

In ecommerce, it is often difficult to tell whether your search traffic is performing to expectations. What your boss perceives to be caused by an on-site or marketing-related issue may...

How to use dictionaries in Python

Alongside the Python list, the dictionary is the most commonly used data storage structure in Python. Dictionaries allow you to store numeric and text-based data as a series of key-value...

How to analyse Average Order Value with Jenks natural breaks classification

Average Order Value or AOV is one of the most critical ecommerce metrics. Along with your sessions and conversion rate, it ultimately controls how much revenue an ecommerce business generates....

How to check if URLs are redirected using Requests

The requests HTTP library for Python allows you to make HTTP requests to servers and receive back HTTP status codes, site content, and other data. It’s extremely useful for building...