# Boruta Algorithm

While working on Machine Learning/Predictive Modelling problems, feature selection is an important step. It is because, we get a dataset with too many variables in practical model building problems in which all variables are not relevant to the problem, and this we don’t know in advance. Also, there are some disadvantages of using all given[…]

# Conditional Formatting in Tableau – II

I guess most of us know about conditional formatting in excel. For those, who don’t know, I am giving a brief intro of Conditional formatting in excel. Conditional Formatting (CF) is a tool that allows us to apply formats to a cell or range of cells, and have that formatting change depending on the value[…]

# Conditional Formatting in Tableau – I

I guess most of us know about conditional formatting in excel. For those, who are new to excel, I am giving a brief intro of Conditional formatting in excel. Conditional Formatting (CF) is a tool that allows us to apply formats to a cell or range of cells, and have that formatting change depending on[…]

# Descriptive Vs Inferential Statistics

Descriptive Statistics is the term given to the analysis of the data, which will show meaningful insights, patterns present in data. However this doesn’t allow us to make any conclusions beyond the given data points. Let us take an example, Suppose in a company if Higher Management asked for Revenue data. Then directly giving him[…]

# Topic Modelling

What it is? I came across this technique while working with Text. I was trying to analyse Twitter’s tweets and Facebook’s posts from page after Reliance Jio Launch. Analysis invloves: Data Collection Data Cleaning Word Cloud creation Sentiment Analysis After this I was thinking to do something else, while searching on net I found this new[…]

# Solution of Errors Faced while creating WordCloud and TermDocumene Matrix in R

I have faced two issues, which I thought of sharing with you all: First one is: Error in UseMethod(“meta”, x) : no applicable method for ‘meta’ applied to an object of class “character” To resolve this issue: Use content_Transformer(tolower), you will get rid of above error. corpus=Corpus(VectorSource(df1\$message)) corpus=tm_map(corpus,content_transformer(tolower)) corpus=tm_map(corpus,removePunctuation) corpus=tm_map(corpus,removeNumbers) corpus=tm_map(corpus,removeWords,stopwords(“en”)) corpus=Corpus(VectorSource(corpus)) tdm=TermDocumentMatrix(corpus) Second Issue[…]

# How to customize Row/Column Total in Tableau

I got a requirement to display total of only two levels and I was having 4 levels in dimension variable put in Column of the table. Column/Row Total simply adds all columns/Rows. To achieve the target, I have used Calculated fields. I am using Superstore dataset to recreate the problem, and its solution. I have[…]

# Connecting R with SQL Server

This post states the steps to connect R studio with SQL Server, so that we can directly access tables and can do analysis on data stored in SQL Server. System Related Settings 1. Go to Control panel of your system. 2. Click on Administrative tools 3. Select User dsn -> click on “add” -> “Sql[…]

# How to show columns forcefully which have blank (or NULL) value for a row in Tableau

I am using Sample-Superstore data set to state the scenario and its solution. Let’s first create a table which have Categories in columns and days of Order date as rows showing Profit. Filter out it for one month of a year, so I am showing data for December 2014. There are missing values on few[…]