Creating the Churn Database Using SQlite and Python

In this segment, Favio will create the churn database using all the data that we have with us.

In order to extract the data set on Python, we will start with reading all the data into Python with the help of Pandas’ read_csv function. Let us go ahead and watch the forthcoming video.

So, as you saw in the video, Favio was able to read all the csv files using Python. Moving on, in the next video, we will be creating the SQLite database using Python.

So, now that you have watched the video, you must have understood how you can add all the dataframes into your SQLite database. In the next segment, Favio will create an entity relationship diagram (ERD) and see whether the database matches the properties of an RDBMS.