Welcome to my 100 days journey
in the realm of data science.
Introduction
Over the next 100 days, I’m diving headfirst into the world of data science, exploring new concepts, unraveling complex ideas, and sharing my discoveries along the way—both as a learner and storyteller.
Why this is important?
Much like the winter season symbolizes reflection, growth, and quiet preparation, these 100 days of focused learning are a time to deepen skills, refine understanding, and build a solid foundation. Just as winter prepares nature for the bloom of spring, this period of intense study and writing will set the stage for breakthroughs and future success in the field of data science.
DAY 1: Python Fundamentals
What is numpy; The need; Numpy array vs Python Sequences; Numpy ndarray; Attributes; Changing dtypes; Array operations; Array functions; Indexing and Slicicng; Iterating; Reshaping; Stacking and Splitting; time module; sys.getsizeof(); Advanced Indexing; Broadcasting; Missing vals; Plotting Graph; Extra functions; Meshgrids; Working with Images; Structured arrays; Save and Load np objects;
DAY 2: LTSD & Functions
List; Array vs List; Adv and Disadv; How is list stored dynamically; Characterestics; Create; Access; Add; Edit; Delete; Operations; Functions; Traverse; zip object; Tuples; The use; No Adding nor Editing; Diff between lists nd tuples; Sets ; No Accessing nor Editing;Frozen Set; Comprehensions; Dictionary; Functions; Advs; *args and **kwargs; Variable scope; First-Class citizens; Lambda fxn; Higher Order Functions(HOF); map; filter; reduce;
DAY 3: OOP
What is OOP; Classes and Objects; Banking Application; Methods vs Functions; Class Diagram; Magic/Dunder Methods; True Benefit of Constructor; Concept of self; Objects Acessing Attributes; Reference Variables; Mutability of Object; Encapsulation; Collection of Objects; Static Variables and Methods; Class Relationship; Aggregation; Inheritance; Types; Method Overriding; Super keyword and constructor; Polymorphism; Method and Constructor Overloading; Abstraction;
DAY 4: Files & Exceptions
File I/O; open; append; Writing many lines; Saving; read and readline; Context Manager - with; Reading big chunks; Seek and Tell; Bin files; Serialize and Deserialize; JSON module - dump an load; S & D of Tuples and Nested Dict; Pickling; Pickle vs JSON; Syntax Errors; Exceptions; Handling; Raise ; Create Custom Exceptions; Namespaces and Decorators; Scope and LEGB rule; Iterators vs Iterables; Our own for loop and range; Generators; Yield vs Return; Gen Expression; Benefits;
DAY 5: Numpy
What is numpy; The need; Numpy array vs Python Sequences; Numpy ndarray; Attributes; Changing dtypes; Array operations; Array functions; Indexing and Slicicng; Iterating; Reshaping; Stacking and Splitting; time module; sys.getsizeof(); Advanced Indexing; Broadcasting; Missing vals; Plotting Graph; Extra functions; Meshgrids; Working with Images; Structured arrays; Save and Load np objects;
DAY 6: Flask
Python, Tkinter (for GUI), Custom Database Module (mydb), Custom NLP API Module (myapi), Geometry Managers Tkinter MessageBox (for alerts), Favicon (resources/favicon.ico), Font and UI Styling (using Tkinter), Sentiment Analysis (via API), User Authentication (Login and Registration).
Github LinkAPI used
DAY 7: Pandas Series
Panda series; create; attributes; size; dtype; name; is_unique; index; values; Create from CSV; methods; head and tail; sample; value_counts; sort_values; sort_index; Mathematical func; count; sum; frequency_count; min; max; describe; indexing; slicing; fancy indexing; indexing with labels; Editing; Python functionalities; type conversion; operators; loops; Boolean indexing; plotting graph; as_type; between clip; drop_duplicates; duplicated; is_null; drop_na; fill_na; is_in; apply; copy;
DAY 8: Pandas DF and GroupBy
GroupBy Object; Aggregate func; size; first; last; nth; get_group; .groups; Split Apply Combine Strategy; Groupby on Multiple Cols; Iterating; Reshaping; Stacking and Splitting; Dataframe creation; Attributes; shape; dtypes; index; columns; values; head and tail; sample; is_null; duplicated; rename; info; describe; Math functions; Selecting columns; Selecting Rows; iloc; loc; Both cols and rows; adding new columns; as_type, value_counts, sort_values, rank, sort_index, set_index, reset_index, rename, unique, nunique, Missing values, Duplicates, drop, apply; .
DAY 9: API Dev using Flask
What is Flask; Setup and installation; Creating Routes; Debugging; Rendering Template; HTML pages; Jinja Template; Storing data in JSON; Fetch Data from HTML page to Flask; GET and POST methods; File Handling; Decorators; Get Response from HTML page; Conditional messaging in HTML; API calls; Text Box;
DAY 10: Merging and Multi Index
Concat; Horizontal Stack; Append; Joins/Merge; Left; Right; Inner; Outer; Array operations; Array functions; Indexing and Slicicng; Iterating; Reshaping; Stacking and Splitting; Diff btw 1D and 2D obj; Using Tuples as index; The Problem; Multi-Index Obj; Fetch Values; Stack and Unstack; The Importance(Adv) of Multi-Index Obj; MI Dfs; Sort Index; Transpose; Swap Levels; Long vs Wide Data; melt and pivot_table;
Merging, Joining and Concatenation
Multi-Index Series and DFs
Task 21
DAY 11: Streamlit
Indian Startup Funding: Developed an interactive Streamlit app providing insights into the Indian startup funding ecosystem. It offers two perspectives: Company POV with details on founders, industry, funding rounds, investors, and similar companies, and Investor POV showing recent investments, preferred sectors, stages, and cities with visualizations like pie charts and YoY graphs.
DAY 12: Git and Github
What is Git? What is VCS/SCM? Why Git/VCS is needed? Types of VCS; Advantages; How Git works? Installing git; Creating and Cloning repo; add, commit, add ., gitignore; seeing commits; (log -> oneline); Creating versions of a software; Nonlinear Development (Branching); Merging branches; Undoing changes; Working with a remote repo
DAY 12: VSO and Time Series
Vectorized operations; Problem; solution; String accessor; Upper; lower; capitalized; title; strip; split; replace; starts_with; is_digit; contains; slicing; Datetime; timestamp object; Benefits; Attributes; year, month, day, hour, minute, second; The need? pd.timestamp; daytime_index; daterange function; Time series analysis; time_delta; Time series; example, operations, steps, analysis, names, slicing, limitation of time_delta, plot frequency, resampling; types, usage, rolling window.;
DAY 13: Matplotlib
What Matplotlib; 2D Line Plot; Scatter; Bar Chart; Side by side and Stacked Bar chart; Overlapping Labels; Histogram; Logarithmic Scale; Pie Chart; Auto pct; Explode; Matplotlib Styles;Save and Download charts; Colored Scatter; Fig Size; Annotations; Horizontal and Vertical Lines; 3D Plots and Contour Plot; Pivot Table; HeatMap; Pandas Plot; Subplots; Annotations; Multi Index DataFrames;
DAY 14: PlotlyGo and PlotlyExpress
Why seaborn? Seaborn roadmap; Main Classification plotting; Relational plots; Distribution plots; KDE plot; Matrix plot; Categorical Plots; Stripplot; Figure level function - catplot; Swarmplot; Categorical Distribution Plots; Boxplot; Violinplot; Categorical Estimate Plot - for central tendency; Barplot; Pointplot; Countplot; Faceting; Doubt - error bar issue; Regression Plots; Regplot; Lmplot; Residual Plot; FacetGrid; Pairplot and Pairgrid; JointGrid and Jointplot; Utility Functions - load_dataset;
DAY 15: Seaborn
Why seaborn? Seaborn roadmap; Main Classification plotting; Relational plots; Distribution plots; KDE plot; Matrix plot; Categorical Plots; Stripplot; Figure level function - catplot; Swarmplot; Categorical Distribution Plots; Boxplot; Violinplot; Categorical Estimate Plot - for central tendency; Barplot; Pointplot; Countplot; Faceting; Doubt - error bar issue; Regression Plots; Regplot; Lmplot; Residual Plot; FacetGrid; Pairplot and Pairgrid; JointGrid and Jointplot; Utility Functions - load_dataset;
DAY 16: Open Source Software I and II
What is numpy; The need; Numpy array vs Python Sequences; Numpy ndarray; Attributes; Changing dtypes; Array operations; Array functions; Indexing and Slicing; Iterating; Reshaping; Stacking and Splitting; time module; sys.getsizeof(); Advanced Indexing; Broadcasting; Missing vals; Plotting Graph; Extra functions; Meshgrids; Working with Images; Structured arrays; Save and Load np objects;
DAY 17: Data Gathering
Data Analysis Proces; Importind data from various sources; CSV - sep, names, index_col, header, use_cols, squeeze, skip_rows, nrows, encoding, error_bad_lines, dtype, parse_dates, converters, na_values, chunksize; Excel, sheet_name; JSON; text; SQL, connector; Exporting data in various file formats, sqlalchemy, create_engine; Gathering data through APIs and Web Scraping; requests, Selenium and Chromedriver;
DAY 18: Data Assessing and Cleaning
Data Asessing ; Types of Unclean Data; Write Summary of Data; Types of Assessment; Manual and Automatic; Data Quality Dimension; Data Cleaning; Extraction, Transform and Load Pipeline; Fetch Data from AWS; Apply transformation on Data; Upload Transformed Data back into AWS RDS; Quality Issues; Tidiness Issues;
DAY 19: EDA
Exploratory Data Analysis; The Importance; Steps of EDA; Univarite Analysis; Bivariate Analysis; Multivariate; Feature Engineering;
DAY 20: DataBase Fundamentals
Importance of Data; Introduction to Data and Database; CRUD - Create, Retrieve, Update, Delete Operations; Properties - Integrity, Availability, Security, Independency, Concurrency; Types - Relational, NoSQL, Column, Graph, Key-Value; DBMS and its Core Functionalities, Database Keys, Cardinality of Relationships, Drawbacks of Databases;
DAY 21: DDL
Xampp and MySQL Workbench, What is SQL, Types of SQL Commands; DDL, DML, DCL, TCL; SQL Functions- Built In and User-Defined; Database Commands - CREATE, DROP; Commands for Tables - CREATE, TRUNCATE, DROP; Data Integrity - Constraints, Transactions and Normalization; Constraints - NOT NULL, UNIQUE(combo), PRIMARY KEY, AUTO INCREMENT, CHECK, DEFAULT, FOREIGN KEY, Referential Actions - RESTRICT, CASCADE, SET NULL, SET DEFAULT; ALTER TABLE - Add, Delete, Modify; Adding and Deleting Constraints; No Editing;
DAY 22: DML
Data Manipulation Language; Insert, Variation, Multiple; Importing Data in MySQL Workbench; SELECT - All, Filter cols, Aliasing; Create Expression using cols; Constants; DISTINCT(unique) and combos; WHERE - Filtering Rows; BETWEEN Operator; Query Execution Order; IN and NOT IN Operator; UPDATE Query; Update multiple cols; DELETE; Delete based on multiple cols; SQL Functions - MAX, MIN, AVG, SUM, COUNT, STD, VAR, ABS, ROUND, CEIL, FLOOR;
DAY 23: Tableau - Olympics
ORDER BY; DESC LIMIT; GROUP BY; HAVING Clause; What are SQL Joins; Why have data in multiple cols; Types - Cross(Cartesian), Inner, Left; Right, Full Outer Join; SQL Set Operations; Self Joins; Joining on more than one columns; Joining more than 2 tables; Filtering Columns; Filtering Rows;
DAY 24: Group, Sort & Join
ORDER BY; DESC LIMIT; GROUP BY; HAVING Clause; What are SQL Joins; Why have data in multiple cols; Types - Cross(Cartesian), Inner, Left; Right, Full Outer Join; SQL Set Operations; Self Joins; Joining on more than one columns; Joining more than 2 tables; Filtering Columns; Filtering Rows;
DAY 25: Tableau - Sales
ORDER BY; DESC LIMIT; GROUP BY; HAVING Clause; What are SQL Joins; Why have data in multiple cols; Types - Cross(Cartesian), Inner, Left; Right, Full Outer Join; SQL Set Operations; Self Joins; Joining on more than one columns; Joining more than 2 tables; Filtering Columns; Filtering Rows;
DAY 26: Subqueries
What is a SubQuery; Types; Where can subqueries be used; Independent Subquery - Scalar Subquery, Row Subquery(One Col Mult Rows), Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 27: Case Study - Zomato
What is a SubQuery; Types; Where can subqueries be used; Independent Subquery - Scalar Subquery, Row Subquery(One Col Mult Rows), Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 28: Flights Dashboard
What is a SubQuery; Types; Where can subqueries be used; Independent Subquery - Scalar Subquery, Row Subquery(One Col Mult Rows), Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 29: Window Functions
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 30: Window Functions II
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 31: Cleaning and EDA using SQL
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 32: Datetime in SQL
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 33: Database Design and Norm
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 34: Views and User-Defined Fxns
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 35: Transactions and Stored Procedures
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 36: Descriptive Stats
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 37: PDF, PMF and CDF
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 38: Distributions
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 39: Central Limit Theorem
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 40: Confidence Intervals
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 41: Hypothesis Testing
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 42: Chi-Square & ANOVA
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 43: Tensors, Vectors and Matrices
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 44: Intro to ML
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 45: SLR & MLR
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 46: Optimisation Calculus
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 47: Gradient Descent
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 48: Batch, Stochastic & Mini-batch
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 49: Regression Analysis
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 50: Polynomial Regression
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 51: Assumptions of Lin Reg
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 52: Feature Engineering
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 53: Feature Eng III
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 54: Bias-Variance Tradeoff
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 55: Ridge Regression
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 56: Lasso & ElasticNet
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 57: KNN
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 58: Decision Boundaries
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 59: Classification Metrics
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 60: Curse of Dims
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 61: PCA
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 62: Eigen Values & Vectors
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 63: SVD & ED
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 64: ROC Curve & CV
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 65: Data Leakage
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 66: Hyper-Parameter Tuning
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 67: Probability I & II
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 68: Naive-Bayes I
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 69: Naive-Bayes II & III
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 70: Email Spam Classifier
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 71: Logistic Regression
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 72: Max Likelihood Estimation
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 73: SVM I
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 74: SVM II
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 75: Constraint Optimisation
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 76: Kernel Trick
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 77: Decision Trees
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 78: Decision Trees II
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 79: Ensemble Learning
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
DAY 80: Random Forest
What are Window Functions; How do they differ from GROUP BY; Aggregate Function with OVER; RANK; DENSE_RANK(), ROW_NUMBER(), FIRST_VALUE(), LAST_VALUE(); Concept of Frames - ROWS and BETWEEN Clause, PREECEDING and FOLLOWING; LAG(), LEAD(); Table Subquery(Mult cols mult rows); Correlated subquery; Usage with SELECT, FROM, HAVING, INSERT, UPDATE, DELETE;
Coming Soon...
Nullam et orci eu lorem consequat tincidunt vivamus et sagittis libero. Mauris aliquet magna magna sed nunc rhoncus pharetra. Pellentesque condimentum sem. In efficitur ligula tate urna. Maecenas laoreet massa vel lacinia pellentesque lorem ipsum dolor. Nullam et orci eu lorem consequat tincidunt. Vivamus et sagittis libero. Mauris aliquet magna magna sed nunc rhoncus amet pharetra et feugiat tempus.