give me a python code to be used in google colab for the attached tasks. i have $4$ excel sheets which i believe i cannot attach here but will tell the contents of it$.$ i need a proper and creative code which does not have any logical errors and run in colab free of errors. i have $4$ data which shows;

Average House Prices from $1992$ to $2022$ of Melbourne Suburbs

$$ Crime incidents and rate from the year $2014$ to $2022$

$$ Population and suburb areas for each suburbs from $2001$ to $2021..$ i need to make a correlation in google colab to prove the hypothesis wether it is correct$/$incorrect$.$ help me and make sure the code you give me contains propoer comments on it$.$ the hypothesis are; The mean house prices are higher in more populated areas.$$

$$A higher population density $($people per square km$)$ results in a higher number of crimes committed.$$

$$The crime rate is higher in areas with low mean house prices.$$ i will attach the picture of the tasks. since i cannot upload excel sheet, here are the brief contents of what each data lookslike. i will upload the excel in my goggle colab myself but the code needs to be correct. the mean house sheet have this first row ; bYear Alpine Shire Ararat Rural City Ballarat City Banyule City Bass Coast Shire Baw Baw Shire Bayside City Benalla Rural City Greater Bendigo City Boroondara City Brimbank City Buloke Shire Campaspe Shire Cardina Shire Casey City Central Goldfields Shire Colac Otway Shire Corangamite Shire Greater Dandenong City Darebin City East Gippsland Shire Frankston City Gannawarra Shire Greater Geelong City Glen Eira City Glenelg Shire Golden Plains Shire Hepburn Shire Hindmarsh Shire Hobsons Bay City Horsham Rural City Hume City Indigo Shire Kingston City Knox City Latrobe City Loddon Shire Macedon Ranges Shire Manningham City Mansfield Shire Maribyrnong City Maroondah City Melbourne City Melton City Mildura Rural City Mitchell Shire Moira Shire Monash City Moonee Valley City Moorabool Shire Moreland City Mornington Peninsula Shire Mount Alexander Shire Moyne Shire Murrindindi Shire Nillumbik Shire Northern Grampians Shire Port Phillip City Pyrenees Shire Borough of Queenscliffe Greater Shepparton City South Gippsland Shire Southern Grampians Shire Stonnington City Strathbogie Shire Surf Coast Shire Swan Hill Rural City Towong Shire Wangaratta Rural City Warrnambool City Wellington Shire West Wimmera Shire Whitehorse City Whittlesea City Wodonga City Wyndham City Yarra City Yarra Ranges Shire Yarriambiack Shire. after year the rest are suburb name. the second excel sheet is population data and the first row is like; Year Alpine Ararat Ballarat Banyule Bass Coast Baw Baw Bayside Benalla Greater Bendigo Boroondara Brimbank Buloke Campaspe Cardinia Casey Central Goldfields Colac Otway Corangamite Greater Dandenong Darebin East Gippsland Frankston Gannawarra Greater Geelong Glen Eira Glenelg Golden Plains Hepburn Hindmarsh Hobsons Bay Horsham Hume Indigo Kingston Knox Latrobe Loddon Macedon Ranges Manningham Mansfield Maribyrnong Maroondah Melbourne Melton Mildura Mitchell Moira Monash Moonee Valley Moorabool Moreland Mornington Peninsula Mount Alexander Moyne Murrindindi Nillumbik Northern Grampians Port Phillip Pyrenees Queenscliffe Greater Shepparton South Gippsland Southern Grampians Stonnington Strathbogie Surf Coast Swan Hill Towong Wangaratta Warrnambool Wellington West Wimmera Whitehorse Whittlesea Wodonga Wyndham Yarra Yarra Ranges Yarriambiack.. the third sheet is crime rate and the first row is like; Year Local Government Area Incidents recorded Crime rate per $100,000$ population.. the fourth sheet is suburb area and its first column is like; Property

Area sq Km

need the code urgently... Hypothesis testing based on provided data

Correlation vs causation

Hypotheses for bachelors:

"The mean house prices in Victoria control the level of crime in an area."

Hypotheses for Masters and certificate courses:

CS

"The mean house prices are higher in more populated areas."

"The crime rate is higher in areas with low mean house prices." Task $3$: Coding

Commenting and proper variable names for better code understanding Task $1$: Explore available data

Possible relationships to the hypotheses

Understanding the raw data and how to obtain clean data $($not covered $$ missing data$)$

Spatial and temporal coverage of data

Task $2$: Design the experiments

CS Brainstorming of things to do$,$ like which plots and what data to use

CS$)$ Irstat cudesrippets achieve ine goal hner

Create a flowchart showing how the hypotheses testing is performed Average House Prices from $1992$ to $2022$ of Melbourne Suburbs

CS Crimefincidepitshandatiofoorihecypar $2014$ to $2022$

Population and suburb areas for each suburbs from $2001$ to $2021$