Aug 20Python: Add a column quicklyAdding a column is an integral part of any Analytics/ Data Science project. A new column can be added in any of the following cases: - Adding a column using a single column - Adding a column using multiple columns - Adding a column after group by There are many…Python4 min read

Aug 14Quick EDA using Pandas PlotsIn this blog, I will discuss creating plots using pandas. I will discuss the commonly used plots in Exploratory Data Analysis : scatter plot, bar plot and box plot. Dataset — Brain Stroke Dataset from Kaggle Resource — Pandas Documentation Pandas plot has many arguments. …Pandas5 min read

Aug 7Python Seaborn for plotsIn this blog, I will discuss frequently used plots in exploratory data analysis such as scatterplot, bar plot, box plot and histogram using Seaborn library. Dataset — Brain Stroke Dataset from Kaggle Resource — Seaborn Documentation First, we will import the libraries import pandas as pd import numpy as np …Python 34 min read

Aug 5Python-Pandas cheat sheet: 30 functions-methodsIn this blog, I have mentioned 30 useful python-pandas functions/methods used frequently in data analysis. The following activities can be done using the functions/methods mentioned in the blog: Loading and understanding data Selecting columns/rows or both Filtering data using one or multiple columns Sorting data and dropping a column Summarizing…Python 34 min read

Jun 18Date and time in pythonIn this blog, I will discuss how to convert date time column from string to pandas._libs.tslibs.timestamps.Timestamp format using pd.to_datetime or datetime.datetime format using datetime.datetime.strptime function. I will also discuss ways to change a datetime column into other formats. At first, import pandas and datetime libraries import datetime import pandas as…Python 34 min read

Apr 3Date and time in RIn this blog, I will discuss one of the most common challenges faced while analyzing data from a file. Most of the times the dates in the files are not in the standard format like yyyy-mm-dd. …R3 min read

Feb 24Group by and Summarize: R and pythonOne of the most frequently used step to analyze data is by grouping data using one or more variable and then summarizing using functions like count, distinct count, sum, mean etc. It can be done using R or python in a few lines of codes. …Data2 min read

Dec 26, 2021Average Sales Variants — TableauIn this blog, I will discuss average sales calculation. It seems simple to do average calculation but based on requirement there can be a few variants of the calculation. Let’s understand this by an example. Tableau public version — 2021.4.2 Dataset — Sample — Superstore The tableau workbook is published…Data Visualization4 min read

Oct 9, 2021MTD, YTD in Tableau for Indian Financial YearThis blog is a sequence to my previous blog https://jyoti05iitd.medium.com/mtd-ytd-in-tableau-using-a-reference-date-parameter-50829230a475 In this blog, I will discuss how to do MTD (MTD_IndianFY), YTD (YTD_IndianFY), Previous Year MTD (MTD_IndianPFY) and Previous Year YTD (YTD_IndianPFY) calculations in Tableau using a Reference Data Parameter. Tableau version — 2021.2.0 Dataset — Sample — SuperstoreTableau4 min read

Oct 3, 2021MTD, YTD in Tableau using a Reference Date ParameterIn this blog, I will discuss how to do MTD, YTD calculations in Tableau using a Reference Data Parameter. Tableau version — 2021.2.0 Dataset — Sample — Superstore Problem Statement — Calculate Sales On the Selected Date, MTD Sales and YTD Sales based on Selected Date Parameter. The Link to…Tableau2 min read