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
![1. [4] Identify all the inconsistencies in the data. Resolve the inconsistencies.<br>2. [2] Replace all missing values in column 'input_1' with the mode of that column.<br>[ ]:<br>1 #Answer for A1.1<br>1 #Answer for A1.2<br>A2.<br>Do the following:<br>1. [2] Draw a bivariate histogram for 'input_9' and 'input_10' columns using 10 bins.<br>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<br>1 #Answer for A2.1<br>1 #Answer for A2.2<br>АЗ.<br>Do the following:<br>1. [2] Transform column](https://s3.us-east-1.amazonaws.com/storage.unifolks.com/qimg-008/008_fefuxz0-1jeesxyi.png)
Extracted text: 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 1 #Answer for A1.2 A2. 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 АЗ. 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.