Semester- III

Data Analytics using Python

Course Code 22MCA31 CIE Marks 50
Teaching Hours/Week (L:P:SDA) 3:0:0:0 SEE Marks 50
Total Hours of Pedagogy 40 Total Marks 100
Credits 03 Exam Hours 03
Course Learning objectives:
 Explain the basic of Python programming
 Design real time application using Python collection Objects and classes
 Familiarize the concept of Data Visualization with NumPy, Seaborn
 Define the Web Scraping and Numerical Analysis
Module-1
Python Basic Concepts and Programming
Interpreter, Parts of Python Programming Language, Identifiers, Keywords, Statements and Expressions,
Variables, Operators, Precedence and Associativity, Data Types, Indentation, Comments, Program Execution,
Reading Input, Print Output, Type Conversions, The type( ) Function and Is Operator, Control Flow Statements,
The if Decision Control Flow Statement, The if…else Decision Control Flow Statement, The if…elif…else Decision
Control Statement, Nested if Statement, The while Loop, The for Loop, The continue and break Statements,
Sequences – Strings, Built-In Functions, Commonly Used Modules, Function Definition and Calling the Function,
The return Statement and void Function, Scope and Lifetime of Variables, Default Parameters, Keyword
Arguments, *args and **kwargs, Command Line Arguments.
Teaching- Chalk and Talk/PPT/Web Content
Learning
Process
Module-2
Python Collection Objects, Classes
Strings- Creating and Storing Strings, Basic String Operations, Accessing Characters in String by Index Number,
String Slicing and Joining, String Methods, Formatting Strings, Lists-Creating Lists, Basic List Operations,
Indexing and Slicing in Lists, Built-In Functions Used on Lists, List Methods. Sets, Tuples and Dictionaries. Files:
reading and writing files. Class Definition – Constructors – Inheritance – Overloading
Teaching- Chalk and Talk/PPT/Web Content
Learning
Process
Module-3
Data Pre-processing and Data Wrangling
Acquiring Data with Python: Loading from CSV files, Accessing SQL databases. Cleansing Data with
Python: Stripping out extraneous information, Normalizing data AND Formatting data. Combining and
Merging Data Sets – Reshaping and Pivoting – Data Transformation – String Manipulation, Regular
Expressions.
Teaching- Chalk and Talk/PPT/Web Content
Learning
Process
Module-4
Web Scraping And Numerical Analysis
Data Acquisition by Scraping web applications –Submitting a form - Fetching web pages – Downloading web pages
through form submission – CSS Selectors. NumPy Essentials: TheNumPy

Teaching- Chalk and Talk/PPT/Web Content

Learning
Process
Module-5
Data Visualization with NumPy Arrays, Matplotlib, and Seaborn
Data Visualization: Matplotlib package – Plotting Graphs – Controlling Graph – Adding Text – More Graph Types –
Getting and setting values – Patches. Advanced data visualization with Seaborn.- Time series analysis with Pandas.

@#25102023 1
 Teaching- Chalk and Talk/PPT/Web Content
Learning
Process
Assessment Details (both CIE and SEE)
The weightage of Continuous Internal Evaluation (CIE) is 50% and for Semester End Exam (SEE) is 50%. The
minimum passing mark for the CIE is 50% of the maximum marks. Minimum passing marks in SEE is 40% of the
maximum marks of SEE. A student shall be deemed to have satisfied the academic requirements and earned the
credits allotted to each subject/ course if the student secures not less than 50% (50 marks out of 100) in the sum
total of the CIE (Continuous Internal Evaluation) and SEE (Semester End Examination) taken together.
Continuous Internal Evaluation:
 Three Unit Tests each of 20 Marks
 Two assignments each of 20 Marks or one Skill Development Activity of 40 marks
to attain the COs and POs
The sum of three tests, two assignments/skill Development Activities, will be scaled down to 50 marks
CIE methods /question paper is designed to attain the different levels of Bloom’s taxonomy as per the
outcome defined for the course.
Semester End Examination:
 The SEE question paper will be set for 100 marks and the marks scored will be proportionately reduced to 50.
 The question paper will have ten full questions carrying equal marks.
 Each full question is for 20 marks. There will be two full questions (with a maximum of four sub-questions)
from each module.
 Each full question will have a sub-question covering all the topics under a module.
 The students will have to answer five full questions, selecting one full question from each module

Suggested Learning Resources:

Books
 Allen B. Downey, “Think Python: How to Think Like a Computer Scientist„„, 2nd edition,Updated for Python
3, Shroff/O„Reilly Publishers, 2016 (http://greenteapress.com/wp/thinkpython/)
 Guido van Rossum and Fred L. Drake Jr, ―An Introduction to Python – Revised and updated for Python 3.2,
Network Theory Ltd., 2011.
 Jake Vander plas, “Python Data Science Handbook: Essential tools for working with data”, O„Reilly Publishers, I
Edition.

Reference Books

 Mark Lutz, “Programming Python”, O'Reilly Media, 4th edition, 2010.

 Tim Hall and J-P Stacey, “Python 3 for Absolute Beginners”, Apress, 1st edition, 2009.
 Magnus Lie Hetland, “Beginning Python: From Novice to Professional”, Apress, Second Edition, 2005.
 4. Shai Vaingast, “Beginning Python Visualization Crafting Visual Transformation Scripts”, Apress, 2nd edition,
2014. 6. Wes Mc Kinney, “Python for Data Analysis”, O'Reilly Media, 2012.

Web links and Video Lectures (e-Resources):

 https://youtu.be/4SJ7bEILPJk
Course outcome (Course Skill Set)
At the end of the course the student will be able to :
Sl. No. Description Blooms Level
CO1 Understand and comprehend the basics of Python programming. L2
CO2 Apply knowledge in real time applications L3
CO3 Apply the Data Pre-processing & Data Wrapping L3
CO4 Demonstrate the Web Scraping And Numerical Analysis L3

@#25102023 2
 Mapping of COS and POs
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12
CO1
CO2 X X X
CO3 X X
CO4 X

@#25102023 3