Python: import and join

As seen in the previous exercise, importing and joining two datasets can be a lengthy process with lots of clicking. Python can be used to consolidate everything and make it more efficient. This is especially true as the imports and filtering become more complicated.

In this exercise, you will perform the same actions - import and join - with a Python script. The code was prepared for you with some minor modifications needed.

If you have lost any progress, close any open reports and load 1_3_load_python.pbix from the Exercises folder on the Desktop.