DMI ENGNIEERING COLLEGE

Kumarapuram Road, Aralvaimozhi – 629 301

Department of Artificial Intelligence And

Data Science

COURSE PLAN
(Regulation 2021 )

Subject Code & AD 3301 DATA EXPLORATION AND

Name VISUALIZATION

Programme Artificial Intelligence And Data Science

Year & Semester II & III

Nature of Course / Theory / Laboratory Credits :3

Credit

Name of the faculty Mrs.G.LINGESHWARI

VISION AND MISSION OF THE INSTITUTE & DEPARTMENT

Vision Mission

 To provide
 To build across the institute a
disciplined life with
culture of excellence in
the spiritual base to
teaching and learning with
remain fully alive
needed performance and
and fully human
accountability from all
Institute  To transform our
support activities.
institution into a
 To enhance the institute
quality technical
standing as the institute of
education hub
choice for students across
imparting updated
the country; and to augment
technical
the presence of international
knowledge to the
students to at least ten
students in rural
percent of student body.
areas

Departmen
t 
 2. SYLLABUS

Subject Name : L T P C
3 0 2 4
Artificial Intelligence And Data
Programme
Science Sem: III Category:
:
Prerequiste Learn data science (technical and non-technical)
To learn about characteristics and potential problems of a data set without
Aim:
the need to formulate assumptions about the data beforehand.
Course Objectives:
1 To outline an overview of exploratory data analysis.
2 To implement data visualization using Matplotlib.
3 To perform univariate data exploration and analysis.
4 To apply bivariate data exploration and analysis.
To use Data exploration and visualization techniques for multivariate and
5 time series data.

UNIT I EXPLORATORY DATA ANALYSIS

9

EDA fundamentals – Understanding data science – Significance of EDA –

Making sense of data –Comparing EDA with classical and Bayesian analysis –
Software tools for EDA - Visual Aids for EDA- Data transformation techniques-
merging database, reshaping and pivoting, Transformation techniques -
Grouping Datasets - data aggregation – Pivot tables and cross-tabulations.

UNIT - II VISUALIZING USING 9

Importing Matplotlib – Simple line plots – Simple scatter plots – visualizing
errors – density and contour plots – Histograms – legends – colors – subplots
– text and annotation – customization –three dimensional plotting -
Geographic Data with Basemap - Visualization with Seaborn.

UNIT - III UNIVARIATE ANALYSIS 9

Introduction to Single variable: Distributions and Variables - Numerical

Summaries of Level and Spread - Scaling and Standardizing – Inequality -
Smoothing Time Series.

UNIT - IV BIVARIATE ANALYSIS

9

Relationships between Two Variables - Percentage Tables - Analyzing

Contingency Tables - Handling Several Batches - Scatterplots and Resistant
Lines – Transformations.
UNIT - V MULTIVARIATE AND TIME SERIES ANALYSIS 9

Introducing a Third Variable - Causal Explanations - Three-Variable

Contingency Tables and Beyond - Longitudinal Data – Fundamentals of TSA –
Characteristics of time series data – Data Cleaning – Time-based indexing –
Visualizing – Grouping – Resampling.
Total: 45 Periods

3. Course Outcome (COs): (should follow Bloom’s taxonomy)

Course Outcomes: After successful completion of the course, the students

should be able to

Cos CO Statements Pos

Understand the fundamentals Po1,
CO1: of exploratory data analysis. po2,po3,po4,po9,po10,po11,po12
Implement the data Po1,po2,po3,po4,po5, po9,po10,
CO2: visualization using Matplotlib. po11,po12
Perform univariate data Po1,po2,po3,po4,po5,,po9,po10,po
CO3: exploration and analysis. 11,po12
Apply bivariate data Po1,po2,po3,po4,po9,po10,po11,
CO4: exploration and analysis. po12
Use Data exploration and Po1,po2,po3,po4,po5,,po9,po10,
visualization techniques for po11,po12
CO5: multivariate and time series
data.

4. Instructional Learning outcomes (unit wise / assignments /

tutorials / slip test)

Unit Assessment Procedure

I Assignments, quiz and slip test
Assignments ,quiz and slip test
II
III Assignments, quiz and slip test

IV Assignments, quiz and slip test

 V Assignments, quiz and slip test

5. Program Educational Objectives (PEOs) (max. 4)

S.No Topic PEOs

Utilize their proficiencies in the fundamental

Fundament
knowledge of basic sciences, mathematics,
PEO1 al Artificial Intelligence, data science and statistics to
Knowledge build systems that require management and
analysis of large volumes of data.

Advanced their technical skills to pursue

Technical pioneering research in the field of AI and data
PEO2
aspect science and create disruptive and sustainable
solutions for the welfare of ecosystems.

Think logically, pursue lifelong learning and

Career collaborate with an ethical attitude in a
PEO3 Developme multidisciplinary team.
nt Design and model AI based solutions to critical
problem domains in the real world.

Social Exhibit innovative thoughts and creative ideas for

PEO4
Identity effective contribution towards economy building.

6. Program Outcomes (POs) (12 attributes)

PO’s No KNOWLEDGE STATEMENTS

Apply the knowledge of mathematics, science,

engineering fundamentals and an engineering
Engineering specialization to the solution of complex
1
Knowledge: engineering problems.

Identify, formulate, review research literature, and

2 Problem
analyze complex engineering problems reaching
Analysis: substantiated conclusions using first principles of
mathematics, natural sciences, and engineering
 sciences.

Design solutions for complex engineering

problems and design system components or
processes that meet the specified needs with
Design / appropriate consideration for the public health
3 Development of and safety, and the cultural, societal, and
Solutions: environmental considerations.

Use research-based knowledge and research

Conduct methods including design of experiments, analysis
Investigations of and interpretation of data, and synthesis of the
4
Complex information to provide valid conclusions.
Problems:

Create, select, and apply appropriate techniques,

resources, and modern engineering and IT tools
including prediction and modeling to complex
Modern Tool
5 engineering activities with an understanding of
usage: the limitations.

Apply reasoning informed by the contextual

knowledge to assess societal, health, safety, legal
The Engineer
6 and cultural issues and the consequent
and Society:
responsibilities relevant to the professional
engineering practice

Understand the impact of the professional

Environment engineering solutions in societal and
7 and environmental contexts, and demonstrate the
Sustainability: knowledge of, and need for sustainable
development

Apply ethical principles and commit to

8 Ethics: professional ethics and responsibilities and norms
of the engineering practice.

Individual and Function effectively as an individual, and as a

9 member or leader in diverse teams, and in
Team Work:
multidisciplinary settings
 Communicate effectively on complex engineering
activities with the engineering community and
with society at large, such as, being able to
10 Communication: comprehend and write effective reports and
design documentation, make effective
presentations, and give and receive clear
instructions
Demonstrate knowledge and understanding of the
engineering and management principles and
Project apply these to one‘s own work, as a member and
11 leader in a team, to manage projects and in
Management
multidisciplinary environments.
and Finance:

Recognize the need for, and have the preparation

and ability to engage in independent and life-long
Life-long learning in the broadest context of technological
12
Learning: change.

7. Program Specific Outcomes (PSOs) (max.3)

Graduating student shall be able to:

PSO1 Evolve AI based efficient domain specific processes for effective

decision making in several domains such as business and
governance domains.

PSO2 Strong theoretical foundation leading to excellence and

excitement towards research.
 8. CO and PO mapping (3 point scale)

COURSE OUTCOMES VS PROGRAM OUTCOMES MAPPING

Course Program Outcomes Program

Outcome Specific
s Outcomes
PO PO PO PO PO PO PO PO PO PO PO PO PSO PSO
1 2 3 4 5 6 7 8 9 10 11 12 1 2
CO 1 3 1 3 3 - - - - 2 3 3 3 2 2
CO 2 2 2 2 1 1 - - - 3 2 3 1 3 1
CO 3 2 1 2 1 1 - - - 3 2 1 2 2 2
CO 4 2 2 2 1 - - - - 1 2 1 3 1 3
CO 5 3 1 1 2 1 - - - 3 2 1 2 2 2
Enter correlation levels 1, 2 & 3 define as: 1-low, 2- medium, & 3-high

COURSE OUTCOME & PROGRAM OUTCOME JUSTIFICATION

Correlat
ion –
MAPPING Strong / JUSTIFICATION
Medium
/Low
Unit 1
Co1&po1 3

Co1&po3 3
 To should develop the basic fundamentals of data
Co1&po4 3 exploitation and analysis.

Co1& po10 2  To implement the software tools and

transformation techniques by using EDA.
Co1&po11 3

Co1&po12 3

Co1&po9 2
Co1&po2 1

Unit 2

Co2&po9 3

Co2&po11 3

Co2&po1 2  To should implement the data visualization using

matplotlip tools.
Co2&po2 2

Co2&po3 2
 We can implement the sub plots , three
Co2&po10 2 dimensional plot, and contour plot by using
visualization tools.
Co2&po4 1

Co2&po5 1

Co2&po12 1

Unit 3

Co3&po9 3

Co3&po1 2
 To implement univariate data exploration and
Co3&po3 2 analysis.

Co3&po10 2

Co3&po12 2

Co3&po2 1  To develop the more variables and implement the

scaling by using visualization tools.
Co3&po4 1

Co3&po5 1

Co3&po11 1

Unit 4

Co4&po12 3
Co4&po1 2
 To develop the bivariate data exploration and
Co4&po2 2 analysis.
Co4&po3 2
 Co4&po10 2
 To implement the tables and transformation by
Co4&po4 1 using bivariate analysis.
Co4&po9 1
Co4&po11 1

Unit 5
Co5&po1 3
Co5&po9 3
Co5&po4 2
Co5&po10  To develop Data exploration and visualization
2 techniques for multivariate and time series data.
Co5&po12 2
Co5&po2 1  To develop the grouping and resampling the data
Co5&po3 by using time series analysis.
1
Co5&po5 1
Co5&po11 1

9. Text Books & Reference Books

S. Text / Title of the Author/Publisher/ Web link

No Reference Book Year/ Edition
. book
“Hands-On
Text https://
Exploratory Suresh Kumar Mukhiya, books.google.co.in/books?
Data Analysis Usman Ahmed, Packt id=QcHZDwAAQBAJ&prints
1 with Publishing, 2020. (Unit ec=frontcover&source=gb
Python” 1) s_ge_summary_r&cad=0#
v=onepage&q&f=false
"Python Data
2 Text Jake Vander Plas, Oreilly, https://www.google.co.in/
Science 1st Edition, 2016. (Unit books/edition/_/
Handbook: 2) xYmNDQAAQBAJ?
Essential hl=en&gbpv=1
Tools for
Working with
 Data"
“Exploring Data: https://
An Introduction
books.google.com.gi/
to Data Analysis Catherine Marsh, Jane Elliott,
books?
3 Text for Social Wiley Publications, 2nd
id=qAcXIgxMF98C&printse
Edition, 2008. (Unit 3,4,5)
Scientists” c=frontcover#v=onepage
&q&f=false
Catherine Marsh, Jane Elliott, https://
“Data
Wiley Publications, 2nd
Visualization and books.google.com.gi/
Edition, 2008. (Unit 3,4,5)
Exploration “ books?
4 Text
id=qAcXIgxMF98C&printse
c=frontcover#v=onepage
&q&f=false
Catherine Marsh, Jane Elliott, https://
“Fundamentals of
Wiley Publications, 2nd
Data books.google.com.gi/
Edition, 2008. (Unit 3,4,5)
Visualization” books?
5 Text
id=qAcXIgxMF98C&printse
c=frontcover#v=onepage
&q&f=false

“Data Visualization https://www.amazon.in/

and Exploration Interactive-Data-
with R, GeoSpatial Visualization-Foundations-
Training service”
Eric Pimpler, GeoSpatial
6 Reference Applications/dp/
Training service, 2017.
1482257378?
asin=1482257378&revisio
nId=&format=4&depth=1
“Fundamentals of
https://
Data Visualization”
books.google.co.in/books?
id=WmmNDwAAQBAJ&prin
Claus O. Wilke, O’reilly tsec=frontcover&source=g
7 Reference
publications, 2019. bs_ge_summary_r&cad=0
#v=onepage&q&f=false

“Interactive Data https://

Visualization:
books.google.co.in/books?
Foundations, Matthew O. Ward, Georges
id=XHZ3CAAAQBAJ&prints
Reference Techniques, and Grinstein, Daniel Keim, 2nd
8 ec=frontcover&source=gb
Applications” Edition, CRC press, 2015
s_ge_summary_r&cad=0#
v=onepage&q&f=false
10.Web Resources: (other than NPTEL, SWAYAM and other e
learning resources)

S.No Topic Web link

.

1 Comparing EDA https://www.youtube.com/watch?

with classical and v=3JYqtYauG0s
Bayesian analysis

2 Histograms https://www.youtube.com/watch?
v=RWP2q4wyRds

3 Smoothing Time https://www.youtube.com/watch?

Series v=5KEy1OBnkJo

4 Analyzing https://www.youtube.com/wach?
Contingency Tables v=W95BgQCp_rQ

5 Fundamentals of https://www.youtube.com/watch?
TSA v=DtCPLDuzk8M

11.E – learning videos/NPTEL/ SWAYAM and other resources

(IMPORTANT!)

Data
1
Analysis for https://nptel.ac.in/courses/102103092
Biologists

Data
2
Analysis and
Decision https://nptel.ac.in/courses/110104094
Making - I

Data
3
Analysis &
Decision https://nptel.ac.in/courses/110104125
Making - III
12.Magazines & Journals (one or two)

(Web link to be provided)

13.Lesson Plan

Mode of
Text/
Hours teaching Page
S.no Unit Topic to be covered Ref.
need (BB/PPT/ no
book
Others)

1 EDA fundamentals,
Understanding data 1 Blackboard T1 8
science
2 Significance of EDA 1 Blackboard T1 9
3 Making sense of
1 Blackboard T1 12
data
4 Comparing EDA with
classical and
Bayesian analysis, 2 Blackboard T1 20
Software tools for
EDA
I
5 Visual Aids for
1 Blackboard T1 36
EDA
6 Data transformation
techniques-merging
database, reshaping
2 Blackboard T1 92
and pivoting,
Transformation
Techniques
7 Grouping Datasets 1 Blackboard T1 163
8 data aggregation 1 Blackboard T1 170
9 Pivot tables and
2 Blackboard T1 178
cross-tabulations

10 II Importing Matplotlib 1 Blackboard T2 218

11 Simple line plots 2 Blackboard T2 224
12 Simple scatter plots 1 Blackboard T2 230
13 visualizing 1 Blackboard T2 237
 errors ,density and
contour plots
14 Histograms ,legends
2 Blackboard T2 245
, colors ,subplots
15 text and annotation,
1 Blackboard T2 268
customization
16 three dimensional
2 Blackboard T2 290
plotting
Geographic Data
1 Blackboard T2 298
17 with Basemap
18 Visualization with
1 Blackboard T2 311
Seaborn

19 Introduction to
1 Blackboard T3
Single variable
20 Distributions and
1 Blackboard T3
Variables
21 Numerical
Summaries of Level
1 Blackboard T3
III and
Spread
22 Scaling and
1 Blackboard T3
Standardizing
23 Inequality 1 Blackboard T3
24 Smoothing Time
1 Blackboard T3
Series

25 Relationships Blackboard T3
between Two 1
Variables
26 Percentage Tables 1 Blackboard T3
27 Analyzing
1 Blackboard T3
IV Contingency Tables
28 Handling Several
1 Blackboard T3
Batches
29 Scatter plots and
1 Blackboard T3
Resistant Lines
30 Transformations. 1 Blackboard T3

31 V Introducing a Third
1 Blackboard T3
Variable
32 Causal Explanations 1 Blackboard T3
33 Three-Variable 1 Blackboard T3
Contingency Tables
and
 Beyond
34 Longitudinal Data 1 Blackboard T3
35 Fundamentals of
1 Blackboard T3
TSA
36 Characteristics of
1 Blackboard T3
time series data
37 Data
Cleaning ,Time- 1 Blackboard T3
based indexing
38 Visualizing ,Groupin
1 Blackboard T3
g
39 Resampling 1 Blackboard T3
Total Hours Needed: 45 Hours
*Beyond the syllabus topics to be included

14. Class Time Table

12.30-1.00
PERIOD I II IV V VI VII VIII
III
10.4 10.5 2.4
9.00 – 9.50 – 0 - 0- 11.40- 1.00- 1.45- 2.30- 0- 3.25-
DAY/TIME
9.50 10.40 10.5 11.4 12.30 1.45 2.30 2.40 3.2 4.10
0 0 5
AD 3301
MONDAY
DEV
AD 3301
TUESDAY
DEV LU BREAK
WEDNESDA NC
Y BREA H
AD K BR
THURSDAY 3301 EA AD 3301 DEV
DEV K
AD
FRIDAY 3301
DEV
PERIOD I II III IV V VI VII VIII
12.30-1.00

10.
2.4
40
9.00 – 9.50 – 10.50- 11.40- 1.00- 1.45- 2.30- 0- 3.25-
DAY/TIME -
9.50 10.40 11.40 12.30 1.45 2.30 2.40 3.2 4.10
10.
5
50
AD AL BRE AD AD LU MA CS
MONDAY 3391 3391 AK 3351 3301 NC 3354 3351 BREAK AD 3351 DAA
DBDM AI DAA DEV H DM DPCO
BR
CS MA AL AD AD
EA AD 3381 Database Design and
TUESDAY 3351 3354 3391 3301 K 3391
Management Lab
DPCO DM AI DEV DBDM
MA AL AD CS AD
WEDNESDA
3354 3391 3351 3351 3391 AD 3311 Artifical Intelligence Lab
Y
DM AI DAA DPCO DBDM
THURSDAY AD AD CS AD MA AL BREAK AD 3301 DEV
3301 3351 3351 3391 3354 3391
 DEV DAA DPCO DBDM DM AI
MA AD AD AD
AL 3391 CS 3351 Prof.
FRIDAY 3354 3301 3391 3351
AI DPCO develop
DM DEV DBDM DAA

15.Course Time Table

16.Assignments

Assignmen Description Submission due

t No.

1 Visual Aids for EDA 26/09/2023

2 Three dimensional plotting 17/10/2023

3 Scaling and Standardizing 8/11/2023

4 Percentage Tables 29/11/2023

5 Longitudinal Data 21/12/2023

17.Assignment Rubrics:

Quality Marks
Submission on Date 2
Understanding 3
Solving skill/ Presentation 3
End results with correct units conversions / 2
Conclusion

18.Mapping of CO to Assignment:

CO’s CO – STATEMENTS A1 A2 A3 A4 A5

CO1: Understand the fundamentals of exploratory

data analysis.
Implement the data visualization using 
CO2: 
Matplotlib
 Perform univariate data exploration and 
CO3:
analysis

CO4: Apply bivariate data exploration and analysis 

Use Data exploration and visualization 

CO5: techniques for multivariate and time series
data.

19.Assessment Methodologies:

Assessment Tool Description

Internal Test
(30%)
40
Direct ___
Assignments %
Assessme
(10%)
nt
(80%)
End semester 60
Examination %
Indirect Course End Survey
Assessme (80%)
nt
Exit Survey (20 %)
(20%)

20.Distribution of portions for assessment tests

Assessments Portion Covering Unit % of weightage

IAT – I Unit I & unit II (50%) 15
IAT – II Unit II (50%) & Unit III 15
Model Exam Unit I to V 25
Assignments Unit – I to Unit-V 15
Class Test Unit – I to Unit-V 15
Attendance 15
End Semester Unit - I to V 100

21.Content beyond syllabus

1.
2.
3.
 Prepared by: Approved by:
Signature

Mrs.G.Lingeshwa Mrs.A.Thava Dr.Raghupath

Name : Dr.A.Albert Raj
ri vinu y

Designatio Academic
Prof. / AI&DS HoD / AI&DS Principal
n: coordinator