This report explores the various levels of join operations using the tidyverse and nycflights13 datasets. It transitions from basic mutating and filtering joins to complex non-equi joins and self-joins. Key highlights include: - Custom datetime transformation from integer (HMM) formats. - Advanced join_by() syntax for inequality and rolling window matches. - Practical applications of anti-joins for data integrity and semi-joins for filtering. - Self-joins with restricted time windows to analyze consecutive flight departures.

Cleaning and Analysis of a dataset from kaggle to practice data skills using R.