First, unzip the dataset in your preferred folder:

$ unzip {dataset.zip}

The logic to load the data into Pandas dataframes is shown in the pandas.ipynb notebook.

You can either download and run the notebook or use the Python code inside as a sample.