This assignment is to load data from CSV, populate them in a SQLite database, and run in-database analytics with SQL.

Data Source

name of database file: default of credit card clients dataset

According to the site:

This dataset contains information on default payments, demographic factors, credit data, history of payment, and bill statements of credit card clients in Taiwan from April 2005 to September 2005.

Write Python code to do the following.

1. Focus on the Marriage column of the datasheet.

2. Count the total number of singles (Marriage=2 is single, marriage=3 (others) counted towards single).

3. Count the total number of married (Marriage =1 is married)

4. Count the total number of the column for default.payment.next.month for single (2 and 3) and for married (1).

5. Divide the two numbers obtained in step 4 with number from step 2 and step 3. For example:

o Total number of single default.payment.next.month/total number of singles

o Total number of marrieddefault.payment.next.month/total number of married

6. What does the two numbers tell you from step 5?