Today we’ll see about the dplyr package in R also known as grammar of data manipulation. In the last tutorial we saw about the ggplot2 which is another famous package in R. It consist of set of functions which helps you for different type of data manipulation. I’ll be using medical cost data set from Kaggle(data source). I’ve listed all possible documentation and resources to learn more about the dplyr package.
Hello Friends! What-IF Analysis is the way/process to check the affect of values in a formula.
Hi Friends! recently I came across with a situation where I’ve to show the Top city and Sale value as percent of total sales. Today we’ll be seeing how to maintain Percent of total even with filter applied. This tutorial is easy to follow.
Hi Friends! Recently I came across a situation where monthly sales where in different columns and the trend has to be displayed in single line chart in Tableau. In this tutorial we’ll see how to combine multiple measure in single chart in Tableau. Also the use of column chart in Tableau.
Today we’ll be seeing how to split data into Training data sets and Test data sets in R. While creating machine learning model we’ve to train our model on some part of the available data and test the accuracy of model on the part of the data.
Recently I came across a situation to find the row number for duplicate values.
In SQL Server there is a inbuilt function ROW_NUMBER() read more but in Excel there is no direct function as such.
Hello Friends! Today we’ll be seeing a very simple and very useful way to find out the errors in Excel sheet. This is very handy if you have a sheet with 100’s of rows and columns and can save lot of time.