How to rename a column in Snowflake Members Public

Learn how to rename a column in Snowflake by using the alter table SQL command.

Stephen Allwright
Stephen Allwright
Snowflake

How to use Snowflake's IFNULL function Members Public

IFNULL is a helpful function in Snowflake which returns a defined value when the initial expression is NULL.

Stephen Allwright
Stephen Allwright
Snowflake

Select all columns except one or multiple in Snowflake Members Public

Learn how to write SQL queries that select all columns in Snowflake except for one or more, by using the exclude and rename functions.

Stephen Allwright
Stephen Allwright
Snowflake

Fit Predict #2: Fluff your SQL and don't be imbalanced Members Public

In this issue of the Fit Predict newsletter, we look at fixing imbalanced datasets, running causal inference, the reality of working as a Data Scientist, and more.

Stephen Allwright
Stephen Allwright

Fit Predict #1: Evolving from Pandas to Polars Members Public

In this issue of the Fit Predict Data Science newsletter, we look at Snowflake extensions for VSCode, Reinforcement Learning at Spotify and more.

Stephen Allwright
Stephen Allwright
Extract year from DateTime in Pandas

Extract year from DateTime in Pandas Members Public

Being able to extract the year from a DateTime object in Pandas can be extremely helpful for feature engineering. In this post, I will walk through how to do this simply in multiple variations.

Stephen Allwright
Stephen Allwright
Pandas
Get year from DateTime Python

Get year from DateTime in Python Members Public

Being able to extract the year from a DateTime object in Python can be extremely helpful for feature engineering. In this post, I will walk through how to do this simply in multiple variations.

Stephen Allwright
Stephen Allwright
Pandas
Pandas convert DateTime to date in Python

Pandas convert DateTime to date Members Public

Being able to convert a datetime64 object in Pandas to just the date can make it easier to understand and work with. In this post, I will show you how to do this simply in multiple variants.

Stephen Allwright
Stephen Allwright
Pandas