Tutors

Innomatics Research Labs

PROGRAM OVERVIEW

CURRICULUM

  Course Took Kit (Discord and Mentoring Link)

  • Discord Innomatics Server Community Link
  • Zoom Mentoring Sessions Link
  • Introduction to Data Science and AI
  • Usecases and Understanding of Jupyter notebook Disocord and LMS
  • Demo File

  Python Programming

  • Basic Python File
  • Python File
  • Strings File -28th Oct
  • List and Tuple - 2nd Nov
  • List and Tuple - Part 2 Nov 3rd
  • Sets File
  • Dictionary File
  • Conditional Statement
  • Operators and IF-ELSE-IF File
  • While Loops File
  • For Loops File
  • List comprehensions and Problems on loops
  • Basic Programming - Part 1
  • Python Programming Operators and Sting - Part 1
  • Strings - II
  • list
  • Tuple and Dictionary
  • Sets
  • Conditional Statement - If Else
  • Conditional Statement
  • Conditional Statement and While Loops
  • Loops and List Dict Comprehensions
  • Functions - Part 1 16th Nov
  • Functions - Part 2 17th Nov
  • Modularity in python, Writing custom Python Modules, Importing packages, Installing packages etc.
  • Recursive Function - 21st Nov File
  • Functions_Exception_Handling File 22nd Nov
  • File Handling and Exception Handling. File
  • OOPs _ 1 File
  • OOPS _ Part 2
  • Functions
  • Problem solving inner loops
  • Functions - Lambda Map Filter Reduce
  • File Handling
  • File and Exceptional Handling
  • OOPS - I
  • OOPS - II
  • OOPS - III Part 1
  • OOPS - III Part 2

  Data Analysis Using Python

  • Intro to Stats
  • Sampling_Methods_Measures_of_central_tendancy fILE
  • Measures of Spread, Quantiles, Quartiles, IQR.
  • Covariance_Correlation_Numpy File
  • Numpy - 5th Dec
  • Numpy 6th Dec File
  • Numpy 7th Dec
  • Numpy final and Pandas part 1 - 8th Dec
  • Pandas - Series and DataFrame - 9th Dec
  • Modifying and Sorting iloc and loc File -12th Dec
  • Groupby
  • pivot table
  • missing value
  • Case Study Fi;e
  • Pandas2_Modifying and Sorting iloc and loc e - 20th Dec
  • Pandas_Multi-indexing & Shift_rank_rolling_clip_cum_funcs - 20th Dec
  • 21st Dec Regex
  • 22nd Regex File
  • Intro to Data Science and Stats
  • Descriptive Stats - Population Sampling Data Measures and Types
  • Different Data Scales, Converting numeric data to categorical, Categorical to Numeric.
  • Descriptive Stats - Central Tendency and Measure of Dispersion
  • Measure of Dispersion - II
  • Pandas - I Pandas Introductions, Series, DataFrames, DataFrame Functionalities.
  • Data Summarization using pandas, reading, writing.
  • Pandas data Access using loc, iloc, modifying, sorting
  • Pandas Merge concat get_dummies cutqcut_append
  • Multi Indexing filtering, Shift, Rank, Rolling functions and Cumulative Functions
  • Pandas Duplicated, Drop duplicated, datetime module of python and pandas.
  • Numpy - I
  • Numpy - II
  • Numpy - III and Matplotlib basics
  • EDA Adv Plots and Regex
  • Regex - II
  • Web Scraping - I
  • Web Scraping - II
  • Different Data Scales, Converting numeric data to categorical, Categorical to Numeric.
  • Web Scraping File
  • Matplotlib File
  • EDA File - 28th Dec
  • Case Study File

  Assignments

  • Python - Variables and Datatypes
  • Python - Strings
  • Python - List and Tuples
  • Python - Sets
  • Python - Dictionary
  • Python - Conditional Statements and Loops
  • Python - Functions
  • Python - Class and Object
  • Data Analysis - Numpy
  • Data Analysis - Pandas
  • Data Analysis - Visualization
  • SQL - Assignment 1
  • SQL - Assignment 2
  • Statistics Assignment

  Projects

  • Web Scraping Project Documentation
  • Web Scraping Project Final Submissions
  • SQL Project Demonstration
  • SQL Project - MUSIC STORE DATA ANALYSIS
  • Excel - Dashboard Project
  • Tableau - DATA ANALYSIS PROJECT

  SQL

  • MySQL Workbench Installation Processor
  • MySQL_Installation Processor
  • 2nd Jan - SQL Introduction, Workbench Tour, DDL, DML, DCL, TCL
  • 3rd Jan - SQL, Create, Drop, Insert, select query
  • 4th Jan - Operators and Constraints File
  • 5th Jan - Constraints_Alter_Groupby
  • 6th Jan - inbuiltFunctions_Practice File
  • 9th Jan - Missing_Value_joins_window
  • 10th Jan - Windows Functions File
  • 11th Jan - Views_Stored_Procecdures File
  • SQL 1 - Databses , Dif between DBMS & RDBMS, OLAP, OLTP, DataWarehouse vs Data lake
  • SQL 2 - DDL_DML Commands
  • SQL 3 - Operators and DML Commands
  • SQL - 4 Groupby constraints
  • SQL 5 - JOINS
  • Practice session on joins and Inner Query
  • SQL 7 - Union,Union All, Case statements, Window Functions
  • SQL 8 - Window Function and Python Connections
  • SQL 9 - Views, stored procedures

  Tableau

  • This section has no content published in it.

  Statistics & Probability

  • 23rd Jan - Descriptive_stats File
  • 24th Jan - Descriptive_stats_ File
  • Introduction to Descriptive Statistics
  • Measure of Dispersion
  • Correlation Correlation, Percentiles, Deciles, Quartiles, IQR, Population, Sample, Data Categories
  • 25th jan - Covariance_Correlation
  • 27th Jan - Probabbility_Theroy_RandomVariable File
  • 30th Jan - Descrete Random Variables File
  • Importance of Probability, Introduction to Probability, Types of Probability
  • Revision of Probability, Conditional Probability, Bayes Theorem, Independent Events
  • random variables, Types of Random Variables , Bernouli , Binomial
  • Expected values, PDF, PMF, CDF, Uniform Distribution in continuous space and discrete space
  • Poisson and Exponential Distributions, Example problems
  • 31st Jan -- Poisson_Exponential Distributions File
  • 2nd Feb Unifrom Distribution File
  • 3rd Feb - Normal Distribution
  • 6th Feb - Normal Distribution File
  • 7th Feb - CLT File
  • Normal Distribution, Empirical Rules, How to Plot Normal Distribution
  • Standard Normal Distribution, Problems on Normal Distribution, Z-tables, Transformations
  • Bootstrapping, Central Limit Theorem
  • Central Limit Theorem for sums, proportions, Python proof of CLT, Problems on CLT.
  • 8th Feb - Confidence Interval
  • CLT for Proportion Estimation of Population parameters point and Interval
  • Confidence Interval, Criterial Value Significance Level
  • Example on CI , T Distribution and Excel Lab
  • 9th Feb - Confidence_Interval_Problems
  • 10th Feb - T distribution, Python Implementation, Confidence Interval with T distribution
  • 13th Feb - What is Hypothesis Testing, Null & Alternative, Apps of CLT in Hypothesis testing.
  • 14th Feb - left & Right Tail and p value approch and evaluation
  • 15th Feb - Hypothesis testing 1 sample testing, z-test, t-test.
  • Chebyshev's theorem, Bias, Introduction to Hypothesis testing, Null & Alternative Hypothesis
  • Hypothesis Testing - Part 2 Type 1 & 2 Errors
  • Z-Test, T-test, p value approach, p value calculation, Example Problems.
  • 17th Feb - Chisqaure File
  • Chi Sqaured and F Distribution & ANOVA
  • Z-Test, T-test, p value approach, p value calculation, Example Problems.
  • Python lab of hyp testing, Chi square dist, Chi square test for independence
  • 20th Feb - Chi Square File
  • 21st Feb - F test and Anova
  • 22nd Feb File

  Machine Learning

  • This section has no content published in it.

  Deep Learning

  • This section has no content published in it.

  Excel Module

  • 1st Mar - Intro to Excel
  • 2nd Mar - Conditional Formatting File
  • 1st Mar - Introduction to Excel
  • 2nd Mar - Conditional formatting
  • 3rd Mar - Excel - Data Validation
  • conditional_formatting File
  • Intro to excel File
  • Data_validation File
  • 6th Mar - Pivot Table
  • Pivot Table File
  • 7th Mar - Dashboard
  • Dashboard File 7th march
  • 9th Mar - VLOOKUP & HLOOKUP
  • VLOOKUP & HLOOKUP File
  • 10th Mar - EXCEL- MACROS
  • Macros File