input_1input_2input_3input_4input_5input_6input_7input_8input_9input_10output0

Private School Physics Riyadh Male $735 18,180 9.2 9.1 6.0 0.933 9.81

Public School Mathematics Madinah Male $742 2,6216.6 9.57.8 0.95 35.42

Public School Physics Madinah Female $675 17,692 6.1 7.6 7.9 0.92 35.73

Public School Physics Al-Khobar Female $841 17,738 9.99.1 9.4 0.17 41.14

Private School Chemistry Hail Female $596 10,6047.7 6.7 9.6 0.17 37.3

Run Markdown 1. [4] Identify all the inconsistencies in the data. Resolve the inconsistencies. 2. [2] Replace all missing values in column 'input_1' with the mode of that column. []: 1 #Answer for A1.1 7 [ ]: 1 #Answer for A1.2 A2. [4 marks] Do the following: 1. [2] Draw a bivariate histogram for 'input_9' and 'input_10' columns using 10 bins. 2. [2] Display the total number of records for every combination of 'input_2' and 'input_3'. Which combination has the highest number of recor []: 1 #Answer for A2.1 [ ]: 1 #Answer for A2.2 A3. [4 marks] Do the following: 1. [2] Transform column "input_3" as follows: Riyadh', 'Al-Baha', 'Hail' should be transformed as 'Central Region' Jeddah', 'Makkah', 'Madinah', 'Jizan', 'Taif', 'Tabuk' should be transformed as 'Western Region' 'Dammam', 'Al-Khobar' should be transformed as 'Eastern Region' 2. [2] Transform column "input_2" using one hot encoding method. Do not drop any of the encoded column