Data enrichment
We have learned how to extract data from various sources, put them into a common or desired structure, and cleanse data issues. However, the data is still in silos from individual sources and it would be valuable to combine data from multiple sources to enrich the data with additional information.
Let us consider a use case where we will publish a schedule of football games for a specific team. Before we do that, we must understand our dataset in order to join relevant tables. We will first print the list of tables that is available in our source database.
Figure 9.49: Printing all tables from the source database for a sporting ticket dataset
We have a list of tables, and the following diagram will illustrate the relationship across different tables in our dataset:
|
Table name |
Description |
|
|
Contains stats... |
