Scribd
Upload
5 views1 page

Handling Missing Data in AI Datasets

The document outlines a lab assignment for B. Tech students in Artificial Intelligence and Machine Learning, focusing on handling missing data in a custom dataset. Students are required to create a CSV file with personal data, perform various operations to detect and count missing values, and submit their findings along with screenshots. The assignment emphasizes practical data manipulation skills using Python functions like isnull() and notnull().

Uploaded by

Vivek Sreekar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views1 page

Handling Missing Data in AI Datasets

The document outlines a lab assignment for B. Tech students in Artificial Intelligence and Machine Learning, focusing on handling missing data in a custom dataset. Students are required to create a CSV file with personal data, perform various operations to detect and count missing values, and submit their findings along with screenshots. The assignment emphasizes practical data manipulation skills using Python functions like isnull() and notnull().

Uploaded by

Vivek Sreekar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

(B. Tech in Artificial Intelligence and Machine Learning)

NAME: USN:

LAB WORK 1: Handling Missing Data


 Create your own family text dataset([Link] file) by using primary data
collection method with minimum of 10 records including fields Name,
DOB, Email_id, Phone_number, Gender, age, Current_location,
Permanent_location, Qualification, Occupation. Ensure that each column
should contains at least one Missing value excluding Name column
Note: First record should be your record
 Perform the following operations on dataset
a) Read and display the content present in the dataset (making data
frame from csv file)
b) Detect and Display the records having NULL values in any of the
column using isnull() function
c) Detect and Display the records having NULL values for Gender using
isnull() function
d) Count missing values in the "Name" column
e) Count missing values in the "Email_id" column
f) Detect and Display the records having NULL values in any of the
column using notnull() function
g) Detect and Display the records having NULL values for
Current_location using notnull() function
h) Count not missing values in the " Occupation" column using notnull()
function

Solution: attach screenshots and upload USN_Lab [Link], [Link] and USN.
Ipynb files to LMS
a)

[Link] | [Link]

You might also like