Case Study on Extracting Table Information With Python

In this segment, Favio will write some logic so that you can understand the structure of the database. For this, Favio will be writing two logic:

1. The first logic will be used to print all the table names and their respective columns.
2. The second logic will print the schema of any of the tables.

In the forthcoming video, Favil will write the function for printing the table names and their respective columns. Let us go ahead and watch the video.

So, in the video, Favio created a function named “table_info,” which can directly print the names of all the tables present in the database along with their respective columns. We will be using this later while exploring our churn data set.

Moving on, in the next video, Favio will show you how to print the schema of any of the tables present in the database. Let’s watch the video.

So, in the video, you learned how to see a table schema in Python.

This brings us to the end of the first session of this module. In the next session, Favio will start with the use case, where we will be using all the concepts taught in this session to begin analyzing our data set.