Ans: We will use the method of Demand and Supply Total population of India = 1.2bn or 1200 Mn Male = 700 Mn ...
Continue readingGuesstimate 1 – Number of Office chairs sold in India
Q1. Estimate the number of office chairs sold in India. Approach:- To estimate the numbers of office chairs sold in India, ...
Continue readingGuesstimate 2 – How many gmail users are there in India ?
Approach The population of India is - 1,300,000,000 i.e. 1.3BInternet penetration in India is - 30% Assumed Population Distribution - ...
Continue readingGradient Boosting in Python
I hope you are already done with the basic concepts of regression and have covered our previous post on Adaptive Boosting. Nai padhe, toh padh lo yaar..easy haiRemember, If you want to participate in a Hackthon or ...
Continue readingComplete path to master SQL before interview
We have interviewed a lot of candidates and found out that SQL is still something which is very less explored by people who want to get deep into this domain.Remember - Data Science is not about all about ...
Continue reading10 Must have SQL questions
What are the different Analytic functions available in SQL Server? FIRST_VALUE(): Returns the first value in an ordered set of values. If Partition By clause is specified then it returns First Value in ...
Continue readingPractice Numpy
Numpy is one of the basic and most used packages in Python. It is mostly used for scientific computing.Most important Data Type in Numpy is Array.import numpy as npAnd you have installed the numpy package in your ...
Continue readingEDA in Python
The complete Machine Learning journey can be penned down in 4 steps:-1. Exploratory Data Analysis - This is the first thing you do when you get a dataset. Before jumping on to building models, you need to ...
Continue readingStart with Python
Python is one of the most preferred language for Data Science. It is needless to discuss the pros and cons of Python over any other language(R/SAS/Java/C).If you are already comfortable with any other language then it's good, but ...
Continue readingLess asked SQL questions
We have already covered queries on joins, aggregate functions, sub-queries, running sum, etc.This article will concentrate on the theoretical part of SQL which are less asked but are important to know about1.What are the different types of statements ...
Continue reading