In this type of Machine Learning Model, we have labelled training data. For example, we are given the data of Age and Income of customers and based on that, we have to build a classification model that predicts if the customer will buy a computer.
Now our goal will be…
“An agent is said to learn from experience with respect to some class of tasks and a performance measure P if the learner’s performance at tasks in the class as measured by P improves with experience”. This type of learning where we learn from experiences is called Inductive learning.
What is an outlier?
An outlier is an observation that lies an abnormal distance from other values in a random sample from a population.
A boxplot is a standardized way of displaying the distribution of data based on a five-number summary (“minimum”, first quartile(Q1), median, third quartile(Q3) and “maximum”). …
=COUNTIFS (range1, criteria1, [range2], [criteria2], …)
2. SUM IFS: Sums all values in a given range that meet the specified criteria. Syntax:
3. AVERAGE IFS: Averages all values in a given range that…
A. Sample bias: Sampling bias occurs when some members of a population are systematically more likely to be selected in a sample than others.
B. Observer Bias: Observer bias is a form of detection bias originating at a study’s stage of observing or recording information.
C. Interpretation Bias: Interpretation bias…
CTEs, Temp Tables, String Functions and Subqueries
The EmployeeDemographics TABLE referred to in the video contains columns EmployeeID, FirstName, LastName, Age, Gender, and the EmployeeSalary TABLE contains columns EmployeeID, JobTitle, Salary
CTEs: Common Table Expression
WITH CTE_Employee as
(SELECT FirstName, LastName, Genbder, Salary,
COUNT(Gender) OVER (PARTITION BY Gender) as TotalGender,
JOIN- INNER, OUTER, RIGHT, LEFT
The EmployeeDemographics TABLE referred to in the thread contains columns EmployeeID, FirstName, LastName, Age, Gender, and the EmployeeSalary TABLE contains columns EmployeeID, JobTitle, Salary
DIFFERENCE BETWEEN INNER, OUTER, LEFT AND RIGHT JOIN
Inner Join EmployeeSalary
CREATING A TABLE
CREATE TABLE EmployeeSalary
SELECTING TOP ROWS FROM A TABLE
SELECT TOP(1000) [EmployeeID], [FirstName], [LastName],[Age],[Gender]
INSERTING DATA INTO TABLE
INSERT INTO EmployeeDemographics VALUES
( 1001, 'Ishita', 'Tandon, 20, 'Female'),
(1002, 'Ish', 'Tan', 31, 'Female')
PULLING DATA FROM ALL COLUMNS FROM…
Big O notation is used to measure how running time or space requirements for your program grows as the input size grows.
Let's say we have some function, as the size of input increases, time took also increases
The time taken in running a program also depends on the configuration…