Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Logic In Databases International Workshop Lid 96 San Miniato Italy July 1 2 1996 Proceedings Lncs 1154

Authors: Dino Pedreschi ,Carlo Zaniolo

1st Edition

3540618147, 978-3540618140

More Books

Students also viewed these Databases questions