Data-Preprocessing

This report is created by extracting the data from two xlsx files and understanding the data

a: To prepossess the rental report data, input new column names and tidy the data by changing it into a longer format

b: Changing data types to correct types.

c: Then dropping unnecessary columns and rows to prepare for merging.

d: The missing values are scanned and outliers for preprocessing the crime statistics data.

e: The data columns are changed into a more comprehensive format and tidied up.

f: Unnecessary rows and columns are dropped and both datasets are joined.

g: A transformation is performed for data values to fix skewness and reduce bias.