B-1. /2 Marks]: Given Data HW3 DataB1. Read the data and display the first three rows of the data. Identify the number of rows and columns. Display the statistical summaries of numerie columns and then non-numeric columns. Page 5 of 11 ISE-291: Homework 03 B-2. 3 Marks/: Type and Consistency. For each column in HW3 DataB, identify the type for each field based on value. Also, identify the data types in Python. Report any inconsistency. B-3. /2 Marks/: Handling Missing data. First, permanently remove the "id" column and any inconsistent column(s) from the data. Further, check whether any column has missing data. If there is, apply appropriate imputation to fill the data. Display info of DataFrame before and after the imputation. B-4. 16 Marks/: Data Transformation. Apply standardization on numeric columns. Apply manual label encoding on "level" and an appropriate transformation (label encoding or one hot encoding) on the remaining categorical column(s) in the updated HW3 DataB1 data. Display the statistical summaries of all columns in the transposed form. Considering only the numeric columns on which standardization was applied, identify the rows in which absolute value is higher than 3 in any of these columns as outlier rows. Drop these rows from the DataFrame. Print the number of rows in the DataFrame after the dropping of outlier rows. B-5. /4 Marks/: Exploratory analysis plot. Provide the plot of the pairwise relationship using the updated HW3 DataB1 data for the numeric variables 'rating', 'attack', 'defenee', 'budget', and 'worth': B-6. /5 Marks/: OLS Regression. The hypothesis is that all the explanatory variables are linearly related to an explained variable named "rating". Use the closed form formula (=(XX)1XY) to calculate the OLS coefficient estimates of updated HW3 DataB1 data. Save A1 Branch \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & D. & E & F. & G & H & 1 & 1 & K. & L. & & N & 0 & p & Q \\ \hline ComponeiGender & acromial ic & cervicale fict & chest_circe & est hey & ot lengt & Actional & ad leng: & aulder _. & ting het & & Waist cire & ist dep & ight kg & ight m \\ \hline Combat SiRegular Ai Female & 1282 & 1336 & 922 & 1095 & 246 & 1028 & 184 & 1062 & 803 & 1647 & 850 & 217 & 65.7 & 1.56 \\ \hline Combat St Regular Ar female & 1379 & 1440 & 839 & 1234 & 249 & 1117 & 189 & 1014 & 835 & 1751 & 708 & 168 & 53.4 & 1.665 \\ \hline Combat Si Regular Ai Female & 1369 & 1451 & 874 & 1226 & 265 & 1060 & 195 & 1049 & 904 & 1779 & 727 & 159 & 66,3 & 1.711 \\ \hline Combat Si Regular Aifemale & 1356: & 1430 & 1008 & 1170 & 265 & 1069 & 186 & 1121 & 875 & 1708 & 923 & 235 & 78.2 & 1.66 \\ \hline Combat A Regular At Female & 1303 & 1362 & 1089 & 1112 & 247 & 1039 & 187 & 1151 & 824 & 1702 & 1163 & 300 & 88.6 & 1.572 \\ \hline Combat Sa Regular As Female. & 1428 & 1485 & 1031 & 1275 & 270 & 1145 & 198 & 1094 & 860 & 177 & 968 & 255 & 83.7 & 1.707 \\ \hline Combat SiRegular Aifemale & 1352 & 1405 & 988 & 1184 & 241 & 1094 & 167 & 1072 & 876 & 1608 & 964 & 258 & 73.2 & 1.644 \\ \hline Combat Si Regular Ai Female & 1383 & 1428 & 969 & 1190 & 255 & 1081 & 177. & 1066 & 881 & 1701 & 914 & 220 & 76 & 1.671 \\ \hline Combat SiRegular Au Female & 1237 & 1293 & 831 & 1083 & 234 & 1014 & 174 & 994 & 797 & 1605 & 755 & 199 & 54.5 & 1.521 \\ \hline Combat Si Regular Anfemale & 1301 & 1360 & 1010 & 1075 & 245 & 980 & 175 & 985 & 857 & 1540 & 944 & 233 & 68.4 & 1.59 \\ \hline Combat Se Regulat Arfemale & 1395 & 1462 & 1065 & 1205 & 270 & 1117 & 210 & 1174 & 902 & 1833 & 935 & 240 & 99 & 1.707 \\ \hline Combat SiRegular Ai Female & 1360 & 1425 & 1034 & 1218 & 260 & 1101 & 186 & 1110 & 873 & 1774 & 942 & 248 & 74.2 & 1.668 \\ \hline Combat Si Regular AuFemale & -1368 & 1417 & 1063 & 1201 & 234 & 1105 & 178 & 1145 & 862 & 1722 & 995 & 244 & 781 & 1.654 \\ \hline Combat Si flegular Aifemale & 1368 & 1430 & 937 & 1189 & 263 & 1054 & 190 & 1151 & 874 & 1798 & 848 & 200 & 71.8 & 1,666 \\ \hline CombatSaRegular Ai Female & 1315 & 1379 & 989 & 1164 & 235 & 1052 & 178 & 1116 & 834 & 1690 & 929 & 244 & 70.9 & 1.599 \\ \hline Combat SiRegular Aifemale & 1371 & 1429 & 940 & 1212 & 249 & 1054 & 177 & 1013 & 883 & 1657 & 835 & 217 & 67.2 & 1.673 \\ \hline Combat Si Regular Au Female & 1337 & 1408 & 835 & 1171 & 257 & 998 & 187 & 1055 & 899 & 1687 & 772 & 185 & 62 & 1.647 \\ \hline Combat Si Regular As Female & 1387 & 1440 & 897 & 1228 & 256 & 1086 & 186 & 967. & 871 & 1670 & 805 & 200 & 59.5 & 1.678 \\ \hline Combat SiRegular Ar Female & 1374 & 1422 & 979 & 1211 & 253 & 1099 & 187 & 1128 & 853 & 1797 & 868 & 214 & 74.1 & 1.679 \\ \hline Combatsi Regular Atfemale & 1309 & 1375 & 853 & 1166 & 235 & 983 & 175 & 1011 & 886 & 1603 & 792 & 178 & 60.5 & 1.615 \\ \hline Combat Si Hegular AuFemale & 1239 & 1280 & 1090 & 1055 & 233 & 1024 & 169 & 1119 & 830 & 1539 & 1137 & 318 & 80 & 1.517 \\ \hline Combat Si Regular Aufemale & 1356 & 1423 & 241 & 1219 & 250 & 1079 & 184 & 1005 & 852 & 1782 & 881 & 218 & 74.7 & 1.674 \\ \hline Combat Si Regular Arfemale & 1335 & 1388 & 857 & 1164 & 231 & 1011 & 174 & 919 & 863 & 1602 & 702 & 165 & 49.1 & 1.623 \\ \hline Combat Si flegular Aifemale & 1382 & 1437 & 973 & 1194 & 251 & 1063 & 175 & 1064 & 880 & 1646 & 954 & 249 & 70.3 & 1. 668 \\ \hline Combat Si Regular Ai female & 1361 & -1433 & 975 & 1197 & 258 & 1006 & 195 & 1066 & 825 & 1763 & 796 & 198 & 71.5 & 1.644 \\ \hline Combat 5i Regular Au Female & 1290 & 1366 & 1026 & 1120 & 242 & 1071 & 177 & 1087 & 810 & 1595 & 1000 & 266 & 70.8 & 1.579 \\ \hline Combat SARefular AuFemale & 1146 & 1208 & 832 & 1000 & 223 & B35 & 155 & 954 & 854 & 1323 & 742 & 188 & 48.8 & 1.445 \\ \hline Combat Si Regular Au Female & 1343 & 1404 & 921 & 1191 & 236 & 1003 & 173 & 1017 & 867 & 1639 & 912. & 222 & 69.1 & 1.62 \\ \hline Combat Si hecular Aifemale & 1386 & 1440 & 1032 & 1229 & 251 & 1000 & 182 & 1077 & 883 & 1687 & 913 & 219 & 73 & 1.684 \\ \hline & san & tan & ans. & 1360 & x, & 1075 & 104 & 1071 & & & 801 & & Kit & 1. 619 \\ \hline \end{tabular}