PLEASE DO NOT COPY PASTE FROM CHEGG/OTHERWISE I'LL REPORT YOU

none 26.4 22.25 34.4 89 free/reduced master's degree group C associate: free/reduce none 16.2 58 /" 24.4 54 group D associate": free/reduce none 10.5 18.4 43 group D associate': free/reduce none 16.2 58 24.4 54 group D associate': free/reduce none none 19.8 high school standard 19.5 18.75 NaN 25.2 56 group B some colle free/reduc completed 28 Group D: some colle standard none 13.2 13.5 21.2 47 group C: some high standard none 20.7 18.25 29.2 71 group D: some high standard none 20.7 18.25 29.2 71 free/reduced bachelor's degree 32 22.2 17.75 78 master's group A free/reduced none 21.9 18.5 Group B some colle standard none 20.7 13.5 22 55 bachelor's standard none 20.1 17.25 30 A a single gender two females, three females, and four females 5 males, 6 females, 8 females, 9 males, 10 males, 11 females, 12 males, 13 males, 14 females, 15 males, 16 females, 17 females, 18 males, 19 females, 19 males, 19 females, 19 males 20 males, 21 females, 22 males, 23 females, 20 males, 21 females 26 male 27 male 28 male 29 female 24 male 25 female 24 male 25 female 24 male 25 female 24 male 25 female 24 male 25 female 24 male 25 group D 71 group B 50 points #8 Problem Consider the information in the CSV file HW4DataB, which was received from a public source. Take a look at the following data description: Table 2: Data Explanation gender (field description) Race/ethnicity of the student's gender The student's ethnic background (masked) parental education level The greatest level of education attained by either of the student's parents. Whether the student pays for lunch at the usual cost or receives it for free or at a reduced rate during the exam preparation course whether or not the student took and finished the preparatory course prior to the test is debatable. grade in math The math evaluation resulted in a score for the student (out of 30) score in reading The reading assessment resulted in a score for the student (out of 25) making a score in the writing evaluation, the student obtained a score (out of 40) gk rating in the general knowledge (GK) assessment, the student received a score out of 100) Complete the following tasks in the following order, using the data from HW Data and Table-2.. Please note that you must use Python to answer all of the questions above. For all of the aforementioned analyses, use the Pandas Sklearn library. 8-1: Assumed Data Data should be read and shown. Determine the number of rows and columns in the table. Is there any missing data in any of the columns?' Display both numeric and non-numeric column descriptions. 8-2: Consistency of type. Determine the kind of each field for each column and confirm that the ench column in Python is appropriately identified. B- 3. Data that is inconsistent. When reviewing the data, two sorts of inconsistencies were discovered some of the scores were recorded with negative siga, and others were submitted with positive siga fly mistake). Or, in other situations, we discovered numbers that were higher than the highest possible score. Assume the score is out of 100 for all of these entries, and scale it out of the matching maximum score. (For example, if your math score is 70, you scale it by dividing it by 100 and multiplying it by the minimum math score (1.6 30).) B-4. Dealing with NaN values. If there is any missing data in the score fields, replace the NaN value with the student's average score from other exam scores. (HINT. Taking the average of the row rather than the column. Keep be mind that the scores are based on many selesa) B-5: Working with NaN values. Fill in any missing dates for replace the NaN value) in the non-numeric columns as follows: The mode depending on race/ethnicity will be used to replace the NaN value. (For crumple, if the lunch field for any student is empty, use the mode for the same mace/ethnicity the student belongs to, not the mode for all students.) not group B group group B group A group group B group B group 3 group group B group B group Babcd efghabc paternal race/ethnicity le exam de lunch Preparing for a test in math, science, or writing Ek sec score Bachelor's degree standard: 21.6 some colle standard completed 72 29.6 71 20.7 22.5 35.2 NaN 27 master's d d d d d d d d d associate': free/reduce none 56 some colle standard none 75 19.5 30 77 associate's standard none 21.3 20.75 31.2 77 some colle standard completed associate's standard none 21.3 20.75 31.2 77 some colle standard completed associate's standard completed associate's standard completed associate's standard completed associate's standard completed associate's standard completed associate's standard completed associate's standard completed associate's standard completed associate's standard completed associate's standard completed associate's standard 92 some coile free/reduce none 26.4 23.75 NaN group D 12 10.75 15.6 40 free/reduced high school diploma 17.4 13.5 20.8 55 associate: standard none 12 13 17.2 NaN high schoc standard none 19.5 20.25 29.2 -75 group A some colle standard completed 19.2 16-26.8 66 group B high schoc free/reduc none 11.4 15 20 55 group C associate: standard none 17.4 13.5 20.8 55 associate: standard none 12 13 17.2 NaN high schoc standard none 19.5 20.25 29.2 -75 master's d standard none 50 13.25 23.2 group A master's d standard none master's d standard none master's d standard none master's d standard none master's NaN group C some high standard none 69 18.75 31.2 74 group C high schod standard none 26.4 22 25 34.4 89 group B some high free/reduce none 5.48 11.2 27 group C high schod standard none 26.4 22.25 34.4 89 group Chigh schod standard