SQL for EDA
SQL allows us to the ability to investigate our data directly after manipulating it, and often requesting it, from the database in SQL. CTE’s, Views & Sub-queries are all tools we will use in our analysis.
EDA
Looks like the wealthiest boroughs are Kensington & Chelsea, Westminster and Camden.
When we explore the data associated with the borough of Kensington & Chelsea we see the relative equal number of males and females, 7.38 happiness, middle aged (35-41) & a low number of children.
It would therefore seem that most wealthy people therefore seem that the population was made up of middle-aged couples with possibly one child.
It would also be of interest to look into the least wealthy brough, Barking & Dagenham. Relative equal number of males and females, 7.67 happiness, young aged (0-10), high number of children.
It seems logical to assume this area is made up of young parents/large families.
We can also choose to represent just the top five values on their own using a sub-query.
We can represent out findings form the most expensive and least expensive boroughs in a single table using a view.
