DEPARTMENT OF DATA SCIENCE

Lab Report

Data Analytics and Visualization Lab

(BCDS-551)
2025-26

Faculty Name: Mr. Rajan Kumar

Submitted By:

Name:
Roll No:

PRANVEER SINGH INSTITUTE OF TECHNOLOGY, KANPUR

Kanpur - Agra - Delhi National Highway (NH-19), Bhauti - Kanpur - 209305
 Vision & Mission Statements of the Institute

Vision Statement of the Institute:

To achieve excellence in professional education and create an ecosystem for the holistic
development of all stakeholders.

Mission Statement of the Institute:

To provide an environment of effective learning and innovation transforming students into

dynamic, responsible and productive professionals in their respective fields, who are capable
of adapting to the changing needs of the industry and society.
 Vision & Mission Statements of the Department

Vision Statement of the Department:

To be a recognized department of Data Science & Engineering that produces versatile Data
Science engineers, capable of adapting to the changing needs of computer and related
industry.

Mission Statement of the Department:

1. To provide broad based quality education with knowledge and attitude to succeed in Data
Science, Computer Science & Engineering careers.

2. To prepare students for emerging trends in computer and related industry.

3. To develop competence in students by providing them skills and aptitude to foster culture
of continuous and life-long learning.

4. To develop practicing engineers who investigate research, design and find workable
solutions to complex engineering problems with awareness & concern for society as well
as environment.
 PEOs, POs, PSOs of the Department

Program Educational Objectives (PEOs):

1. The graduates will be efficient leading professionals with the knowledge of Computer
Science & Engineering discipline that enables them to pursue higher education and/or
successful careers in various domains.

2. Graduates will possess capability of designing successful innovative solutions to real

life problems that are technically sound, economically viable and socially acceptable.

3. Graduates will be competent team leaders, effective communicators and capable of

working in multidisciplinary teams following ethical values.

4. The graduates will be capable of adapting to new technologies/tools, constantly

upgrading their knowledge and skills with an attitude for lifelong learning.

Program Outcomes (POs):

1. Engineering Knowledge: Apply the knowledge of mathematics, science and

Computer Science & Engineering fundamentals to the solution of complex
engineering problems.

2. Problem Analysis: Identify, formulate, review research literature, and analyze

complex Computer Science & Engineering problems reaching substantiated
conclusions using principles of mathematics, natural sciences, and engineering.

3. Design/Development of Solutions: Design solutions for Computer Science &

Engineering and allied fields related complex engineering problems and design
system components or processes that meet the specified needs with appropriate
consideration for the public health and safety, and the cultural, societal, and
environmental considerations

4. Investigation: Use research-based knowledge of Computer Science & Engineering

and research methods including design of experiments, analysis and interpretation of
data, and synthesis of the information to provide valid conclusions.

5. Modern Tool Usage: Create, select, and apply appropriate techniques, resources, and
modern engineering and IT tools including prediction and modeling to complex
Computer Science & Engineering activities with an understanding of the limitations.

6. The Engineering & Society: Apply reasoning informed by the contextual knowledge
to assess societal, health, safety, legal and cultural issues and the consequent
 responsibilities relevant to the professional engineering practice in the field of
Computer Science & Engineering.

7. Environment & Sustainability: Understand the impact of the professional Computer

Science & Engineering solutions in societal and environmental contexts, and
demonstrate the knowledge of, and need for sustainable development.

8. Ethics: Apply ethical principles and commit to professional ethics and responsibilities
and norms of the Computer Science & Engineering practice.

9. Individual &Team Work: Function effectively as an individual, and as a member or

leader in diverse teams, and in multidisciplinary settings

10. Communication: Communicate effectively on complex Computer Science &

Engineering activities with the engineering community and with society at large, such
as, being able to comprehend and write effective reports and design documentation,
make effective presentations, and give and receive clear instructions.

11. Project Management & Finance: Demonstrate knowledge and understanding of the
Computer Science & Engineering and management principles and apply these to
one’s own work, as a member and leader in a team, to manage projects and in
multidisciplinary environments.

12. Life-Long Learning: Recognize the need for and have the preparation and ability to
engage in independent and life-long learning in the broadest context of technological
change.

Program Specific Outcomes (PSOs)

1. Use algorithms, data structures/management, software design, concepts of

programming languages and computer organization and architecture.

Understand the processes that support the delivery and management of information systems
within a specific application environment.
 CO -PO Mapping

CO

PO10

PO11

PO12
PO1

PO2

PO3

PO4

PO5

PO6

PO7

PO8

PO9
BCDS-551-1 3 - - - - - - - - - - -
BCDS -551.2 - 3 - - - - - - - - - -
BCDS -551.3 - - 3 - - - - - - - - -
BCDS -551.4 - - - - 3 - - - - - - -
BCDS -551.5 - - - - 3 - - - - - - -
Avg. 3.00 3.00 3.00 - 3.00 - - - - - - -

BCDS - Implement numerical and statistical analysis on various data sources

551.1
(CO1)
BCDS - Apply data preprocessing and dimensionality reduction methods on raw
551.2 data.
(CO2)
BCDS - Implement linear regression techniques on numerical data for
551.3 prediction.
(CO3)
BCDS - Execute clustering and association rules mining algorithms on
551.4 different datasets
(CO4)
BCDS - Implement and evaluate the performance of KNN algorithm on
551.5 different datasets
(CO5)

BCDS -551.1 PO1: Student would substantially be able to define the basic numerical
with and statistical techniques
PO1
BCDS -551.2 PO2: Student would be able to apply data preprocessing techniques on
with datasets
PO2
BCDS -551.3 PO3: Students would be able to analyze linear regression algorithm for
with numerical data.
PO3
BCDS -551.4 PO5: Students would be able to implement clustering algorithms using
with modern tools.
PO5
BCDS -551.5 PO5: Students would be able to analyze the various visualization of KNN
with algorithm through modern tools.
PO5
 BCDS -551 Data Analytics and Visualization Lab (Session: 2025-26)

List of Experiments

Date of Date of
Sr. No. Experiment Name Signature Remarks
Experiment Submission

To get the input from the user and perform

1 numerical operations (MAX, MIN, AVG, SUM, 13/08/2025
SQRT, ROUND) using R/Python.

To perform statistical operations (Mean,

2 Median, Mode and Standard Deviation) using 20/08/2025
R/Python.

To perform data import/export

3 (.CSV, .XLS, .TXT) operations on data frames 27/08/2025
using R/Python.
To get the input matrix from user and perform
Matrix addition, subtraction, multiplication,
4 03/09/2025
inverse transpose and decision operations
using vector concept in R/Python.
To perform data pre-processing operations –
using R/ Python.
5 10/09/2025
1) Handling Missing Data
2) Min-Max Normalization

10

11
 Experiment – 1

Q.1 ) To get the input from the user and perform numerical operations (MAX, MIN, AVG,
SUM, SQRT, ROUND) using R/Python.