Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve this, Data Mining import pandas as pd import numpy as np data = { 'Student ID': [1, 2, 3, 4, 5], 'Name': ['Norah', 'Mohammed',

solve this, Data Mining


student submitted image, transcription available below 

import pandas as pd import numpy as np data = { 'Student ID': [1, 2, 3, 4, 5], 'Name': ['Norah', 'Mohammed', 'Faisal', 'Ali', 'Lama'], 'Age' [19, 20, 'unknown', 'unknown', 21], 'Gender': ['Female', 'Male', 'Male', 'Male', 'Female'], 'Score': [85, 92, 78, 88, 'unknown'] } # ((((PRINT THE HEAD AFTER EACH STEP)))) #Task 1: Load the dataset into a Pandas DataFrame # Task 2: Drop Columns that Aren't Useful #Task 3: Handle Missing Values #replace unknown with NaN # Count missing values in each column and print the result missing_values = df.isnull().sum () print (missing_values) # Fill missing values in 'Age' and 'Score' with the mean (you can use the built in method mean () Task 4: Convert Categorical Values to Numeric for gender column #Task 5: Apply Feature Scaling/Normalization for age and score columns using MinMaxScaler (search about it)

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

Elementary Statistics

Authors: Neil A. Weiss

8th Edition

321691237, 978-0321691231

More Books

Students also viewed these Programming questions

Question

Look at the following class definitions:

Answered: 1 week ago

Question

Why does this person have this want or need?

Answered: 1 week ago

Question

What does this person want or need from me?

Answered: 1 week ago

Question

4.3 Describe the five stages of active listening

Answered: 1 week ago