Scribd
Upload
3 views3 pages

Question Bank - Unit-2 Python

This document is a question bank for Unit 2 on Data Preprocessing and Cleaning for a BBA course in Business Analytics. It includes very short answer questions, short answer questions, and descriptive questions, covering topics such as missing values, data cleaning, outliers, and data transformation. The document emphasizes the importance of data preprocessing in business analytics and outlines various techniques and workflows for effective data management.

Uploaded by

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

Question Bank - Unit-2 Python

This document is a question bank for Unit 2 on Data Preprocessing and Cleaning for a BBA course in Business Analytics. It includes very short answer questions, short answer questions, and descriptive questions, covering topics such as missing values, data cleaning, outliers, and data transformation. The document emphasizes the importance of data preprocessing in business analytics and outlines various techniques and workflows for effective data management.

Uploaded by

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

QUESTION BANK

UNIT NO.: 2 – Data Preprocessing and Cleaning

Program: BBA (Business Analytics)


Course Name: Excel for Business Application
Course Code: 24BAN505I
Academic year: 2025-2026 Semester: II

SECTION A: VERY SHORT ANSWER QUESTIONS (2 MARKS EACH)

S.
Questions CO* BL
No.
1 What are missing values in a dataset? CO1 1
2 Define outliers. CO1 1
3 What is data preprocessing? CO1 1
4 What is data cleaning? CO1 2
5 What is data transformation? Give one example. CO1 1
6 What is data inconsistency? CO1 1
7 What is duplicate data? CO1 2
8 Name one method to handle missing data. CO1 1
9 What is normalization? CO1 2
10 Why is data cleaning important? CO1 1

SECTION B: SHORT ANSWER QUESTIONS (5 MARKS EACH)


1 Describe how NumPy helps in numerical computations. Explain with
CO1 2
examples.
2 Explain different types of data preprocessing techniques. CO1 2
3 What are outliers? Explain any two techniques to detect outliers. CO1 4
4 Discuss methods to detect and treat inconsistent data. CO1 2
5 Explain the importance of data cleaning in business analytics. Describe
CO1 2
key steps involved.
6 Describe the steps involved in data cleaning and preparation before
CO1 2
analysis.
7 Explain data transformation techniques with examples. CO1 3
8 Describe how duplicate data can be identified and removed. CO1 2
9 Explain normalization and standardization in data preprocessing. CO1 2
10 Explain data preprocessing techniques used before machine learning. CO1 2

SECTION C: DESCRIPTIVE/LONG ANSWER QUESTIONS (10 MARKS EACH)

1 Explain a complete data preprocessing workflow to prepare a dataset


CO1 2
for analysis using Python.
2 Explain data preprocessing techniques including handling missing
CO1 3
values, detecting outliers, and data transformation with examples
3 A dataset contains missing values, duplicate entries, and inconsistent
CO1 2
formats. Explain how to clean it step by step.
4 Explain the importance of data preprocessing in improving data
CO1 3
quality.
5 Describe methods for detecting and treating outliers with examples. CO1 4
6 Explain different techniques of data transformation and scaling. CO1 3
7 Explain the process of data cleaning in real-world business datasets. CO1 4
8 Discuss challenges in data preprocessing and methods to overcome
CO1 2
them.
9 Explain data validation and consistency checking in preprocessing. CO1 3
10 A company collected customer data but found missing values, outliers,
and duplicate records.
CO1 2
Explain step-by-step how you would clean and preprocess this data
using Python.
** Note: Students to be instructed to draw well labeled diagrams wherever necessary, to
support their answers (especially in level B and C questions)
** The format is for Unit wise question bank; kindly insert the sheets for various units

Signature of Faculty Signature of APMC/ HoD/ Dean

You might also like