How to rename a column in Snowflake Paid Members Public
Learn how to rename a column in Snowflake by using the alter table SQL command.
How to use Snowflake's IFNULL function Paid Members Public
IFNULL is a helpful function in Snowflake which returns a defined value when the initial expression is NULL.
Select all columns except one or multiple in Snowflake Paid 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.
Fit Predict #2: Fluff your SQL and don't be imbalanced Paid 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.
Fit Predict #1: Evolving from Pandas to Polars Paid 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.
Extract year from DateTime in Pandas Paid 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.
Get year from DateTime in Python Paid 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.
Pandas convert DateTime to date Paid 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.
