Aviation Data Analysis using SQL and ggplot2

Aim

A tutorial with the following objectives:

• simple data analysis of on-time performance aviation data

• writing SQL select queries

• Using SQL in R with the help of sqldf

Datasets

The anyflights() from the anyflights package is used to obtain data of the domestic flights such that:

• the flights originate from the airports that serve NYC region (i.e. LGA, JFK, EWR).

• The flights were scheduled in the first two months of 2023.

Important links

Youtube Video link: https://youtu.be/vy06h_f_Sk8

Rendered QMD file: https://gaurav0502.github.io/aviation-data-analysis/

References

• anyflights: https://cran.r-project.org/web/packages/anyflights/anyflights.pdf

• sqldf: https://cran.r-project.org/web/packages/sqldf/sqldf.pdf