The nycflights13
dataset is a well-known dataset for beginners tutorials in data analysis. It is, for example, available on Kaggle, as a R package and as a Python package.
This repository provides the data ready to be imported in a MySQL or MariaDB database.
First, you will need a database and the credentials required to access it. Edit my.cnf
to your needs by entering all required information. Hint: You can first copy my.cnf
to .my.cnf
, if you want to prevent Git from tracking the file.
Next, ensure you have the package mysql-client
installed on your Linux machine. The tools mysql
and mysqlimport
will be used.
Finally, run ./run.sh
to import the dataset into the desired database. Take note that existing tables of the same name will be deleted without further confirmation.
The following data is this dataset: