Sunday February 26th 2017

Machine Learning

Select Features and Target in Scikit Learn Select Features and Target in »

To do Machine Learning in SKlearn, as a first step we need to import following import pandas as [...]


Pre-Modeling: Data Preprocessing and Feature Exploration in Python Pre-Modeling: Data »

In my recent seach on building dummy variables for a loan dataset which I downloaded from kaggle I came [...]


Loading External Data into Scikit lear AKA SKLEARN Loading External Data into »

Scikit learn comes with some toy datasets such as iris. We can load these with from sklearn import [...]


SQL, BI, IT news

Using subqueries to find gaps in sequence

Using subqueries to find gaps in sequence

Using subqueries to find gaps in sequence source Microsoft Database development self-Paced Training Kit Tobias Thernstrom, Ann Weber, Mike Hotek and GrandMasters Create Table #orderdates (customerid int not null, orderdate DateTime not null); Declare @startdate datetime, @enddate datetime, @customerid int set @customerid =1 while [...]

Difference between CTE and Temp Table

Difference between CTE and Temp Table

From Reporting Perspective its import to to know the difference between CTE, derived tables and Temp Tables, following is the some of our attempt to elaborate the differences A common table expression can be thought of as a temporary result that is defined within execution scope of single a single SELEC, INSERT, UPDATE, DELETE or CREATE VIEW [...]

Categories

Crystal Reports

Selecting Null when there is empty »

Selecting Null when there is empty string

Many times we have a limited access to the data and views are created by IT departments and we have to select only the null or empty fields in Crystal [Read More]


Statistics

Understanding Covariance Understanding »

Great video explaining Covariance it discusses the very basics of what covariance is [...]


Forecasting Methods made simple – Exponential Smoothing Forecasting Methods »

A Great video on understanding Alpha There Series of videos by Piyush Shah, under the [...]


Statistics 101: Simple Linear Regression (Part 4), Fit and the Coefficient of Determination Statistics 101: »

In video Brandon explained - how well a regression line fits the data it models. It is [...]