Python DataAnalytics
Module 1
Introduction to DataAnalytics with Python
Introduction to Data Analytics: Importance, Uses and Examples
Overview of Python Libraries for Data Analytics
Setting up the Python Environment for Data Analytics
Introduction to NumPy: Arrays, Array Operations, Mathematical Functions, Indexing and Slicing
Module 2
Data Maniputlation with pandas
Introduction to pandas
Data Structures in pandas: Series and DataFrames
Importing and Exporting Data
Data Cleaning Techniques: Handling Missing Data, Dropping Duplicates, Filtering
Data Transformation: Merging, Reshaping, Pivoting
Data Aggregation and Grouping
Module 3
Basic Statistics for Data Analysis
Descriptive Statistics: Mean, Median, Mode, Variance, Standard Deviation
Introduction to Probability and Probability Distributions: Normal, Binomial, etc.
Inferential Statistics: Hypothesis Testing, p-value, t-test, chi-square test
Correlation and Regression Analysis
Using SciPy for Statistical Analysis
Module 4
Data Visualization
Introduction to Data Visualization with matplotlib and seaborn
Basic Plotting with matplotlib: Line Plots, Scatter Plots, Bar Plots, Histograms
Plotting with seaborn: Statistical Data Visualization
Customizing Plots: Colors, Labels, Legends, Titles
Module 5
Database Programming
Introduction to Relational Database
Anatomy of Database Systems
Client/Server Architectures
Distributed Databases
ER Modelling
Entity
Relationships
Types of Entities and their Relations
Design Considerations
Applications
Relational Modelling
Introduction to Relational Algebra
Anatomy of Relational Model
Design Issues
Applications
Structured Query Language
Introduction to SQL
Data Definition
Data Manipulation
SQL constructs
Select
Insert
Update
Delete
Expressions
Grouping and Aggregate Functions
Different types of Joins
Sub-Queries and Co-related Queries
Set Operations
Interacting with Database.
SqlLite
Connections
Operations
Login Framework
Module 6
Web Programming
Introduction to Web
HTTP
Client-Server Architecture
Dynamic Content Generation
Web Page
Introduction to HTML
Introduction to CSS
Introducton to JS
Flask
Routes
Route Handlers
Forms
Blueprint
PageFlow
Session Management
Login Module
Restful Interface
Module 7
Exam System Project
Requirement Gathering and System Design
Setting up the Flask enabled Web Application
Building the Database Model and Relationships
Creating the Views and Controllers
Deployment of the System