Data Analytics with Python (3:0:0)
Sub Code : 2MCA3C08 CIE : 50%
Hrs/Week : 03 SEE : 50%
SEE Hrs : 03 Max. Marks : 100
Course Outcome: On successful completion of the course the students will be able to
1. Exemplify the need for data and analysis of data in today’s context and Introduce the
fundamentals of Python
2.Apply the control structures the concepts of inheritance and overlaoding for given problem
3. Introduce and illustrate the usage of Numpy and pandas library.
4. Introduce and illustrate the usage of Pandas depth.
5. Illustrate data visualizations using Matplotlib library.
MODULE 1 8 Hours
An Introduction to data analysis and Python programming
Knowledge domains of data, Understanding the nature of data, The data analysis process,
Qualitative and quantitative data analysis,Python the programming language, Python the
interpreter, Py2 and py3, PyPi, Introduction to SciPy
Self-Learning Exercise: Examples for quantitative data analysis and Learning the IDEs
available.
MODULE 2 8 Hours
Python Collection Objects, Classes
Strings- Creating Strings, Basic String Methods, Accessing Characters in String by Index
Number, String Slicing Joining,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
Self-Learning Exercise:Overloading
MODULE 3 10 Hours
The NumPy and Pandas library
History, Installation of Numpy and Pandas library, NdArray, Basic operations, Indexing and
slicing, Array operations,the data analysis library, pandas data structures, series, data frames and
others.
Self-Learning Exercise: Python scripts on slicing
MODULE 4 7 Hours
Pandas: Reading and writing data
I/O API tools, CSV and Textual files, Reading and writing data to csv and text files, read and
write to HTML, XML and JSON files.
Self-Learning Exercise: Database interaction and fundamentals.
MODULE 5 7 Hours
Data Manipulation
Pandas in depth:Data Preparation, Data merging,Data concatenation, data transformation,
matplotlib library, The architecture, Pyplot, Data wrangling:Reading and writing data in text
format,interacting with databases.
Self-Learning Exercise: String manipulation
Text books
1. “Python Data Analytics”, Fabio Nelli, 2nd edition, Apress Publications, 2018
2. “Think Python”,Allen B.Downey,2nd edition,O'Reilly Publications
3. “Python for data analysis”, wes mckinney,2nd edition,O'Reilly Publications
Reference Books
1. “Data Analysis with Python: A modern approach”, David Taieb, 1st edition, Packt publishers,
2018
2. “Data Analytics: Concepts, Techniques, and Applications”, Mohiuddin Ahmed, 1st edition,
Packt publishers, 2018