D. Y.

Patil College of Engineering & Technology, Kolhapur

(An Autonomous Institute)

Department of CSE (Data Science)

Institute Vision:
To become a leading institute in producing high quality technical professionals for nation building.

Institute Mission:
• To nurture the students with high quality education.
• To promote creativity, excellence and discipline.
• To explore career opportunities for the students.
• To enhance industry-institute interaction and research activities.
• To create social and environmental awareness.

Department Vision:
To impart quality education among students which instils application of technical skills for
problem solving in the domain of data science with a pivotal focus to prepare them for the industry,
research and societal needs.

Department Mission:
• To impart quality education that goes beyond theoretical knowledge, equipping students
with practical, hands-on technical skills in data science
• To nurture problem-solving abilities and critical thinking in the era of data analytics with cutting
edge tools and techniques.
• To study and implement data intensive system which strengthens socio-economic aspects and
solves multidisciplinary problems.
Programme Educational Objectives (PEO):
PEO1: Graduates will demonstrate successful careers in data science-related fields, holding positions
that leverage their skills and knowledge in organizations such as industry, academia, government, or
research institutions.
PEO2: Graduates will pursue continuous professional development to keep up with emerging trends in
data science.
PEO3: Graduates will engage with the community applying their data science expertise to address
societal challenges.
 PEO4: Graduates will have ethical and moral leadership positions in their organizations, actively
contributing to decision-making processes in the era of data science.

Programme Specific Outcomes (PSO) :

PSO1: Graduates will be able to apply fundamental principles of data science, methodologies, and
modern tools to analyze complex datasets, extracting meaningful insights and making data-driven
decisions.
PSO2: Graduates will be able to design, implement, and apply diverse data-centric algorithms,
including machine learning, deep learning, computer vision and statistical analysis, to solve real-world
problems across various domains.
Program Outcomes (PO):
PO1: Engineering knowledge: Apply the knowledge of mathematics, science, engineering fundamentals,
and an engineering specialization to the solution of complex engineering problems. PO2: Problem analysis:
Identify, formulate, research literature, and analyze complex engineering problems reaching substantiated
conclusions using first principles of mathematics, natural sciences, and engineering sciences.
PO3: Design/development of solutions: Design solutions for 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.
PO4: Conduct investigations of complex problems: Use research-based knowledge and research methods
including design of experiments, analysis and interpretation of data, and synthesis of the information to
provide valid conclusions.
PO5: Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern
engineering and IT tools including prediction and modelling to complex engineering activities with an
understanding of the limitations.
PO6: The engineer and 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.
PO7: Environment and sustainability: Understand the impact of the professional engineering solutions in
societal and environmental contexts, and demonstrate the knowledge of, and need for sustainable
development.
PO8: Ethics: Apply ethical principles and commit to professional ethics and responsibilities and norms of the
engineering practice.
PO9: Individual and team work: Function effectively as an individual, and as a member or leader in diverse
teams, and in multidisciplinary settings.
PO10: Communication: Communicate effectively on complex 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 PO11: Project management
and finance: Demonstrate knowledge and understanding of the 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.
PO12: 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.
PEO-PO-PSO Mapping
PO PSO
PEO
1 2 3 4 5 6 7 8 9 10 11 12 1 2
1 3 3 3 1 - - - - - 1 - 2 3 2
2 - - 1 3 - 3 3 3 - - - - 2 2
3 1 - 1 1 - 1 1 2 1 - 3 - 3 -
4 - 1 - - 3 - - - 3 3 - 3 - 2
 Course Plan

Course Title: Exploratory Data Analysis and Visualization

Course Code :201DSL302 Semester :V

Teaching Scheme : L-T-P : 3-0-0 Credits :3

Evaluation Scheme: ISE+MSE Marks: 20+30 ESE Marks : 50

Course Description: Exploratory Data Analysis (EDA) is an approach to data analysis that
involves the application of diverse techniques to gain insights into a dataset. The course contains
fundamental concept of Exploratory data analysis. The focus is given on analysis and illustration of
data.

Course Objectives:
1. Understand the fundamental concepts of exploratory data analysis using Python.
2. Find missing values in data and identify the correlation between different variables.
3. Understand the hypothesis testing and advance data visualization tools.

Course Outcomes (COs):

Upon successful completion of this course, the students will be able to:

C302.1 Import, clean, and explore data to perform preliminary analysis Apply
C302.2 Identify and transform erroneous data using different data wrangling Analyzing
techniques
C302.3 Understand and interpret results obtained from graphical analysis Understand
C302.4 Explore hypothesis testing and explore techniques of time-series analysis Apply

Prerequisite: Python, Fundamentals of Data Science

Course Articulation Matrix: Mapping of Course Outcomes (COs) with Program Outcomes
(POs) and Program Specific Outcomes (PSOs):

POs PSOs BTL

COs 1 2 3 4 5 6 7 8 9 10 11 12 1 2

C302.1 2 - - - - - - - - - - - - - 3
 C302.2 3 2 2 - 2 - - - - - - 2 1 - 4
C302.3 3 - 2 2 2 - - - - - - 2 1 - 2

C302.4 3 2 2 - - - - - - - - - - - 3

Content Hours
Unit 1: Exploratory Data Analysis Fundamentals: Understanding data science, Steps in
4
EDA, Numerical data, categorical data, measurement scale, software tools for EDA.
Unit 2: Visual Aids For EDA: Study of different charts and plots, EDA with personal
8
email-loading dataset, data transformation, data analysis.

Unit 3: Descriptive Statistics: Understanding statistics, Measures of central tendency:-

mean, mode, median, Measures of dispersion:- Standard 6
deviation, variance, skewness, kurtosis, percentile, quartile.

Unit 4: Grouping dataset: Understanding groupby(), groupby mechanics, data

aggregation-groupwise operation, groupwise transformation, pivot tables and cross 6
tabulation

Unit 5: Correlation and Time series analysis: Types of analysis, Multivariate analysis using
Titanic dataset, Simpsons Paradox, correlation vs. causation, fundamentals of TSA, 6
Characteristic of Time series data, TSA with Open Power System Data.

Unit 6: Hypothesis Testing and advance data visualization tool: Hypothesis testing, p-
hacking, Understanding regression, Types of regression, Model development and
evaluation, Inferential Statistics. 6

Advance data visualization tool: Tableau-Connecting to data, Creating Sheets and

Dashboards, Publishing to the web
Text Books:
1. “Hands-On Exploratory Data Analysis with Python”, Suresh Kumar
Mukhiya, Usman Ahmed, Packt Publication.

Reference Books:
1. “Python for Data Analysis”, Wes Mckinney, O'REILLY Publication. 2017

Online Resources:
1) [Link]
python/exploratory-data- analysis-iNeWs