Python Data Science/AI Course:
Objective:>Understand Python Programming environment and coding.
>Working on Machine Learning, Data Analytics,SQL, Adv xl,etc.
>Deep Understanding of Python Applications.
Who can attend?
>Freshers seeking career in Python Programming.
>Working/experienced who want to explore Python Data Science/Data Analytics.
Python Data Science Syllabus:
MODULE 1: PYTHON BASICS
Introduction to Python
Variables, keywords and Data types
Operators
Control Statements
Lists
Tuple
Sets
Dictionary
Functions
Strings
Arrays
MODULE 2: PYTHON ADVANCED
Modules and Packages
Exception Handling
File Handling
Object Oriented Programming
Multi-Threading
Regular Expressions
GUI Programming-tkinter
MODULE 3:SQL
Introduction to Database
SQL Architecture
SQL Commands
Storage Classes
Data Types
Create Table
Operators
SQL Clauses
Adding Constraints
Joining Tables
Table Relations
Sub Queries
MODULE 4: DATA ANALYTICS
CH1: Learning NumPy
NumPy basics
Shape manipulation
Copies and Views
Broadcasting rules
Indexing with array of indices
Indexing with boolean array
Indexing with strings
Linear algebra operations
Numpy benefits with matplotlib
CH2: Pandas
Series and Dataframes
Creating dataframes from csv
Plotting csv data
Adding/deleting coulmns with index
Stack/Unstack/Transpose functions
Filtering & Sorting
Grouping
Ways to calculate outliers
Reading data from SQL databases
Exporting data to txt/csv/excel
Visualization with matplotlib
CH3: Matplotlib & seaborn
Basics of graph plotting
Line plot
Scatter plot
Bar graph
Histogram
Contour plot
Pie chart
Grids
Text plot
Multi plot
3D plotting
MODULE 5: MACHINE LEARNING ALGORITHMS
CH1: Supervised Learning
Linear Regression
Dimensionality reduction
Logistic Regression
KNN (k-Nearest Neighbour)
SVM (Support vector machines)
Random Forest
Decision tree
CH2: Unsupervised Learning
K-means clustering
Agglomerative Clustering Algorithm
Comparing and Evaluating Clustering Algorithms
MODULE 6: ADVANCED EXCEL
Introduction to SpreadSheets
Reading data in to Excel
Data Manipulations
Basic Funciton
SpreadSheet Functions
IF Command
LOOKUP Functions
Excel Based Simulation
Filtering, Pivot Tables & Charts
Data Filtering
Advanced Graphing and Charting
Plots and Histograms
MODULE 7: SHELL SCRIPTING
Introduction To Scripting
IO Commands
Operators
Manipulators
Control Statements
Functions
Arrays
MODULE 8: PROJECT WORK(Students Can Work on Two+ Projects )