Introduction to Programming 3hr

What is a programming language ? Source code Vs bytecode Vs machine code
Compiler Vs Interpreter ,C/C++, Java Vs Python

Jupyter notebook basics 1hr

Different type of code editors in python introduction to Anaconda and
jupyter notebookFlavours of python.

Python Programming Basics 2hr

Variable Vs identifiers Vs strings, Operators Vs operand Procedure
oriented Vs modular programming

Statistics basics 2hr

Introduction to statisticsMean,median, mode, Standard deviation,
AverageIntroduction to probability,permutations and
combinationsIntroduction to linear Algebra

Git and GitHub 2hr

Learn the key concepts of the Git source control system,Configure SSH for authentication,Create and use a remote repository on GitHub,Git Overview

Programming Basics &Environment Setup hr

Installing Anaconda, Anaconda, Basics, and Introduction, Get familiar with version control, Git, and GitHub.Intro to Jupyter Notebook environment. Basics Jupyter notebook Commands.Programming language basics.

Python Programming Overview hr

Python 2.7 vs Python 3,Writing your First Python Program
Lines and Indentation,Python Identifiers,Various Operators and Operators
Precedence ,Getting input from User,Comments,Multi line Comments.

Strings, Decisions And Loop
Control hr

Working With Numbers, Booleans and Strings,String types and
formatting, String operations Simple if Statement, if-else Statement
if-elif Statement. Introduction to while Loops. Introduction to for Loops,Using
continue and break.

Python Data Types hr

List,Tuples,Dictionaries,Python Lists,Tuples,Dictionaries,Accessing Values,Basic Operations,Indexing, Slicing, and Matrixes,Built-in Functions & Methods,Exercises on List,Tuples And Dictionary

Functions And Modules hr

Introduction To Functions – Why Defining Functions. Calling Functions
Functions With Multiple Arguments.Anonymous Functions – Lambda
Using Built-In Modules, User-Defined, Modules, Module Namespaces,Iterators And Generators

File I/O And Exceptional Handling and Regular Expression hr

Opening and Closing Files,open Function,file Object Attributes
close() Method ,Read,write,seek.Exception Handling, try-finally Clause
Raising Exceptions, User-Defined Exceptions. Regular Expression- Search
and Replace. Regular Expression Modifiers. Regular Expression Patterns,re module.

Data Analysis Using Numpy And
Pandas hr

Introduction to Numpy. Array Creation, Printing Arrays, Indexing, Slicing and Iterating, Shape Manipulation -Changing the shape, stacking, and splitting of the array. Vector stacking, Broadcasting.

Pandas : Introduction to Pandas,Importing data into Python
Pandas Data Frames, Indexing Data Frames, Basic Operations With Data frame,
Renaming Columns, Subletting, and filtering a data frame.

Data Visualisation using Python:
Matplotlib and Seaborn hr

Matplotlib: Introduction,plot(),Controlling Line Properties,Subplot with Functional Method, MUltiple Plot, Working with Multiple Figures,Histograms

Seaborn :Intro to Seaborn And Visualizing, statistical relationships , Import and Prepare data.Plotting with categorical data and Visualizing linear relationships Seaborn Exercise

Tools Covered

R programming hr

Installing R and R Studio,Setting up the environment,R Datatypes, Operators, Variables Coercion rules in R Functions and arguments Matrices Data Frame Constants,Data Inputs and Outputs with R,Vectors and Vector operation,Advanced Visualization,Using the script vs. using the console

Data Manipulation hr

Vector Manipulation & Sub Setting,List Manipulation, Sub Setting & Merging,Matrix Manipulation, rep fn & Data Frame,Data transformation with R – the Dplyr package ,Sampling data with the Dplyr package,Using the pipe operator in R Tidying data in R – gather() and separate(),Tidying data in R – unite() and spread(),Melting & Casting,String Manipulation with Stringi Package,Data Definition Language Commands,Data Manipulation Language Commands

Visualization in R hr

Introduction to ggplot2,Building a histogram with ggplot2,Building a bar chart with ggplot2,Building a box and whiskers plot with ggplot2,Building a scatterplot with ggplot2,Low Level Plotting,Timeseries Plots,Bar Plot & Density Plot,Combining Plots,MatPlot, ECDF & BoxPlot with IRIS Data set,QPlot, ViolinPlot, Statistical Methods & Correlation Analysis Set.Seed Function & Preparing Data for Plotting

Data Preparation hr

How to handle Missing Data,Data Filtering using is.na() and which(),Reseting the dataframe index,Replacing Missing Data,Median Imputation Method,Factual Analysis Method,Deriving Values Method,Visualizing results in R

Fundamentals of Math and
Probability hr

Basic understanding of linear algebra,Matrics, vectors. Addition and
Multimplication of matrics.Fundamentals of Probability
Probability distributed function and cumulative distributed function.

Descriptive Statistics hr

Describe or sumarise a set of data Measure of central tendency and
measure of dispersion.The mean,median,mode, curtosis and skewness. Computing Standard deviation and Variance.Types of distribution.

Inferential Statistics hr

What is inferential statistics,Different types of Sampling techniques
Central Limit Theorem,Point estimate and Interval estimate
Creating confidence interval for,population parameter
Characteristics of Z-distribution and T-,Distribution. Basics of Hypothesis
Testing. Type of test and rejection,region. Type of errors in Hypothesis yesting,

Hypothesis Testing hr

Hypothesis Testing Basics of Hypothesis Testing ,Type of test and Rejection Region,Type o errors-Type 1 Errors,Type 2,Errors. P value method,Z score
Method. The Chi-Square Test of, Independence.Regression. Factorial Analysis of
Variance. Pearson Correlation, Coefficients in Depth. Statistical,Significance, Effect Size

Data Processing & Exploratory
Data Analysis hr

What is Data Wrangling, Data Pre-processing and cleaning?
How to Restructure the data? What is Data Integration and Transformation

What is Time Series & Forecasting 8hr

Introduction,Forecasting model creation,Time Series – Basic Notations
Graphical Displays,Numerical Description of Time Series Data,Feature Engineering Basics Resampling,Use of Data Transformations and Adjustments,General Approach to Time Series Modeling and Forecasting, Evaluating and Monitoring Forecasting Model Performance,White Noise,Differencing ,Random Walk

Basic Properties,Linear Processes,Introduction to ARIMA Processes,SARIMA model,Test Train Split,Auto Regression Model,Spectral Analysis,Nonstationary and Seasonal Time Series Models,Multivariate Time Series,State-Space Models

Forecasting Techniques hr

The ARAR Algorithm,The Holt–Winters Algorithm,The Holt–Winters Seasonal Algorithm,Choosing a Forecasting Algorithm,Introduction to Neural Networks,Creating Perceptron model,Gradient Descent,Back Propagation,Hyperparameters

Transfer Function Models,Intervention Analysis,Long-Memory Models
Random Variables and Probability Distributions,Distribution Functions and Expectation,Random Vectors,The Multivariate Normal Distribution,Mean Square Convergence

Basics hr

Creating a New Workbook,Navigating in Excel ,Moving the Cell Pointer
Using Excel Menus,Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars Entering Values in a Worksheet and Selecting a Cell Range ,Previewing and Printing a Worksheet Saving a Workbook & Re-opening a saved workbook

Formatting a Worksheet hr

Creating Headers, Footers, and Page Numbers,Adjusting Page Margins and Orientation,Adding Print Titles and Gridlines, rows to repeat at top of each page,Formatting Fonts & Values,Adjusting Row Height and Column Width,Changing Cell Alignment,Adding Borders ,Applying Colors and Patterns,Using the Format Painter
Merging Cells, Rotating Text Using Auto Fill

Managing your workbooks hr

Switching Between Sheets in a Workbook ,Inserting and Deleting Worksheets
Renaming and Moving Worksheets ,Protecting a Workbook ,Hiding Columns, Rows and Sheets,Splitting and Freezing a Window ,Inserting Page Breaks,Advanced Printing Options

Editing a Workbook hr

Entering Date Values and using AutoComplete ,Editing, Clearing, and Replacing Cell Contents Cutting, Copying, and Pasting Cells Moving and Copying Cells with Drag and Drop,Collecting and Pasting Multiple Items Using the Paste Special Command Inserting and Deleting Cells, Rows, and Columns Using Undo, Redo, and Repeat Checking Your Spelling Finding and Replacing Information ,Inserting Cell Comments

Formulas hr

Formulas Creating a basic Formula,Cell Referencing,Calculating Value Totals with AutoSum Editing & Copying Formulas ,Fixing Errors in Your Formulas
Formulas with Several Operators and Cell Ranges ,Conditional Formatting

Working with the Forms Menu hr

Working with the Forms Menu ,Sorting, Subtotaling & Filtering Data
Copy & Paste Filtered Records ,Using Data Validation

Creating & Working with Charts hr

Creating a Chart ,Moving and Resizing a Chart,Formatting and Editing Objects in a Chart,Changing a Chart’s Source Data,Changing a Chart Type and Working with Pie Charts,Adding Titles, Gridlines, and a Data Table ,Formatting a Data Series and Chart Axis,Using Fill Effects

Data Analysis & Pivot Tables hr

Creating a PivotTable ,Specifying the Data a PivotTable Analyzes,Changing a PivotTable’s Calculation,Selecting What Appears in a PivotTable ,Grouping Dates in a PivotTable ,Updating a PivotTable,Formatting and Charting a PivotTable

Automating Tasks with Macros hr

Recording a Macro
Playing a Macro and Assigning a Macro a Shortcut Key