Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is not all data but, I want the codes in general which can you assume any data like in the picture Consider data given
This is not all data but, I want the codes in general which can you assume any data like in the picture
Consider data given in excel file HW2Datal obtained from a public repository'. Excel sheet "stu- dentsData" contains the data, and excel sheet "dataDescription" contains the data description. Do the following tasks using the above data: A-1: Assume the first row in "studentsData" contains the column headings. Read and display the first 10 rows of data. A-2: Count the number of rows and columns in the data. Count the number of non-null rows for each column. A-3: Identify the columns that are numeric. Identify the columns that are non-numeric. Display statis- tical summaries for all the columns. A-4: For numeric columns replace null values with mean of the non-null values in that column. For non-numeric columns replace null values with mode of the non-null values in that column. A-5: Modify columns G1, G2 and G3 in-place as follows: Any decimal value 0.5 should be rounded-up. A-6: Create a new column called "advising", which contains the following values: Any student who has 10% and 25% of "absences" and 25% of "absences" and 3 in health should have a value "concern" in the "advising" column. A-7: Display all rows related to male students. A-8: Display all rows where students age is either 15 or 16. A-9: Count the munber of students whose either of the parents job is categorized as teachers, health, or services. A-10: Select the students whose either of the parents are teachers, and the parents live together. Display top 10 (sorted by G3 score) such students. * Note: Solve all the above questions using Python. Use Pandas library for all the above analysis. Field Description school student's school (binary: 'GP' or 'MP') gender student's gender (binary: 'F' female or 'M' age student's age (numeric: from 15 to 22) address student's home address type (binary: 'U' urban or 'R' famsize family size (binary: 'LE3' less or equal to 3 or 'GT3' greater than or equal to 3) Pstatus parent's cohabitation status (binary: 'T' living together or 'A' - apart) 3 Medu mother's education (numeric: 0 - none, 1 - primary education (4th grade), 2 - 5th to 9th grade, 3 - secondary education, or 4 - higher education) ) Fedu father's education (numeric: 0-none, 1 - primary education (4th grade), 2 - 5th to 9th grade, 3 - secondary education, or 4 - higher education) O Mjob mother's job (nominal: 'teacher', 'health care related, civil services' (e.g. administrative or police), 'at_home' or 'other') 1 Fjob father's job (nominal: teacher', 'health care related, civil services' (e.g. administrative or police), 'at_home' or 'other') 2 reason reason to choose this school (nominal: close to 'home', school reputation', 'course' preference or 'other') 13 guardian student's guardian (nominal: 'mother', 'father' or 'other') 14 traveltime home to school travel time (numeric: 1 - 1 hour) 15 studytime weekly study time (numeric: 1 - 10 hours) 16 failures number of past class failures (numeric: n if 1Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started