SUPERVISED LEARNING

Source: https://www.youtube.com/watch?v=OTAR0kT1swg



Dealing with univariate Outliers using Boxplot:


  1. COUNT IFS: Counts a value in a given range if it satisfies the mentioned criterias. Syntax:


1. Analyze data for bias and credibility. Four common types of biasing cases I have come across:


  1. ASK: Ask questions, define the problem, use structured thinking and communicate with others to learn more about the problem and potential solution.
  2. PREPARE: Understand how data is collected and generated. Identify data and use different data formats, types, structures. …

WITH CTE_Employee as 
(SELECT FirstName, LastName, Genbder, Salary,
COUNT(Gender) OVER (PARTITION BY Gender) as TotalGender,
AVG(Salary)…


Credits: https://commons.wikimedia.org/wiki/File:SQL_Joins.svg
SELECT *
FROM EmployeeDemographics
Inner Join EmployeeSalary
ON EmployeeDemographics.EmployeeID=EmployeeSalary.EmployeeID


CREATE TABLE EmployeeSalary
(EmployeeID int,
JobTitle varchar(50),
Salary int)
SELECT TOP(1000) [EmployeeID], [FirstName], [LastName],[Age],[Gender]
FROM [SQL].dbo.[EmployeeDemographics]
INSERT INTO EmployeeDemographics VALUES
( 1001, 'Ishita', 'Tandon, 20, 'Female'),
(1002, 'Ish', 'Tan', 31, 'Female')

BIG O NOTATION

Source: codebasics (yt channel) DSA Playlist

Ishita Tandon

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store