- Creation of a local database with python:

1- Store the dog_breed_characteristics.csv into a pandas DataFrame

2- What are the columns dtypes? For object/strings columns what are the maximal lengths of strings?

3- Create a local SQL database with corresponding columns and columns types, and an autoincrementing primary key

4- Pick up one row of your dataframe, prepare it for inserting it into the database, treating missing values as NULL, and test its insertion into the database

5- Insert all rows of the dataframe into the database

6- Make a few check queries to the database

7- Compute, with SQL queries, the mean of the Intelligence column

8- Update your database by inserting into the Intelligence column its mean value on each row where it has a NULL value.

9- Double check that now your Intelligence column only has non NULL values

10- Drop all rows where Group1 or Group2 have NULL values

11- On your updated database, determine which dogs have highest AvgPupPrice