In this blog series, powerful Python libraries are leveraged to help uncover some hidden statistical truths in basketball. The first step in any data-driven approach is to identify and collect the data needed. Luckily for us, Basketball-Reference.com hosts pages of basketball data that can be easily scraped. The processes of this walkthrough can be easily … Read more
I’ve always wondered if a slow and high-level trading strategy focusing on long-term trends could outperform a buy-and-hold strategy. To answer this question, I created a Python script that would utilize a momentum-based strategy to tell me when to buy and when to sell Bitcoin. Despite my busy life and doubts that day trading would … Read more
What is the Meaning of the Tilde Operator ~ in Python? Python’s Tilde ~n operator is the bitwise negation operator: it takes the number n as binary number and “flips” all bits 0 to 1 and 1 to 0 to obtain the complement binary number. For example, the tilde operation ~1 becomes 0 and ~0 … Read more
Pandas is a great library for data analysis in Python. With Pandas, you can create visualizations, filter rows or columns, add new columns, and save the data in a wide range of formats. The workhorse of Pandas is the DataFrame. 👉 Recommended: 10 Minutes to Pandas (in 5 Minutes) So the first step working with … Read more
This article will review some of the critical techniques used in Exploratory Data Analysis, specifically for Bivariate Analysis. We will review some of the essential concepts, understand some of the math behind correlation coefficients and provide sufficient examples in Python for a well-rounded, comprehensive understanding. What is Bivariate Analysis? Exploratory Data Analysis, or EDA, is … Read more
Problem Formulation and Solution Overview When working with data, you may encounter a string or list of strings containing two (2) double quotes. This article shows you how to remove one set of these double quotes. 💬 Question: How would we write code to remove the extra set of double quotes? We can accomplish this … Read more
Problem Formulation and Solution Overview This article will show different ways to read and filter an Excel file in Python. To make it more interesting, we have the following scenario: Sven is a Senior Coder at K-Paddles. K-Paddles manufactures Kayak Paddles made of Kevlar for the White Water Rafting Community. Sven has been asked to … Read more
💬 Programming Challenge: Given a Pandas DataFrame or a Pandas Series object. How to convert them to a NumPy array? In this short tutorial, you’ll learn (1) how to convert a 1D pandas Series to a NumPy array, and (2) how to convert a 2D pandas DataFrame to an array. Let’s get started with the … Read more
Problem Formulation Say, you have a function create_df() that creates a DataFrame from some data that may be read from a CSV file, the web, or from another variable in the code (e.g., a nested list)—doesn’t matter. You want to return the DataFrame to the caller of the function at runtime. ⚡ However, the code … Read more
Problem Formulation and Solution Overview This article will show you how to remove text within parentheses in Python. To make it more interesting, we have the following running scenario: Rivers Clothing has a CSV file containing all their employees. The format is currently first name (middle name) and last name (for example, Martin (Robert) Simpson). … Read more
Problem Formulation and Solution Overview This article will show you how to subtract minutes from a datetime in Python. To make it more interesting, we have the following running scenario: ToyMax has 200 employees. All employees must swipe in and out daily using a time card reader. Sometimes the employee swipe-in times do not appear … Read more
A Time Series is essentially a tabular data with the special feature of having a time index. The common forecast task is ‘knowing the past (and sometimes the present), predict the future’. This task, taken as a principle, reveals itself in several ways: in how to interpret your problem, in feature engineering, and in which … Read more