Introduction

This article looks at a few techniques that if mastered, equips the user with the tools to deal with a wide range of data types. This article does not cover anything relation to database management such as table creation or schemas.

Exploring the Example Data

Let’s take a quick look at the table before we filter it.

SELECT *
FROM avocados
LIMIT 50

There are also 2 mapping tables in this dataset for type and regionid which map these numeric categories to their actual text.

#window-functions #advanced #sql #data-science