Create a Jupyter notebook that reads all the sheets from the workbook.
Our excel file has multiple sheets, so we will read them in using pandas read_excel funtion.
Since there are multiple sheets, pandas creates a dictionary where the keys are the sheet names, and the values are a dataframe for the corresponding sheet.
Add code that creates a DataFrame just like the shipping sheet, but with each state abbreviation replaced by its full name.
The “adjacent” column in the distances DataFrame should be boolean type; convert it.
Add two columns to the shipping table, one containing the distance between the two states, and the other containing the boolean of whether the two states are adjacent, both taken from the distance table.
Publish the dataset and your notebook with either Deepnote or Colab, your choice.