Jyoti Kumar – Medium

Jyoti Kumar

Master Google Sheets — A video Series

Most of the people in any organization/ business have been using excel for quite a long time. Even though we have tools like Python, R etc…

4 min readMar 3, 2024

--

Master Google Sheets — A video Series

--

Jyoti Kumar

Repeats: A Business Case Study using Python

For any business, there are mainly two types of customers — new and repeats. We can get new customers through organic search, websites and…

5 min readJul 22, 2023

--

Repeats: A Business Case Study using Python

--

Jyoti Kumar

Python: Add a column quickly

Adding a column is an integral part of any Analytics/ Data Science project. A new column can be added in any of the following cases: …

4 min readAug 20, 2022

--

2

Python: Add a column quickly

--

2

Jyoti Kumar

Quick EDA using Pandas Plots

In this blog, I will discuss creating plots using pandas. I will discuss the commonly used plots in Exploratory Data Analysis : scatter…

5 min readAug 14, 2022

--

Quick EDA using Pandas Plots

--

Jyoti Kumar

Python Seaborn for plots

In this blog, I will discuss frequently used plots in exploratory data analysis such as scatterplot, bar plot, box plot and histogram using…

4 min readAug 7, 2022

--

Python Seaborn for plots

--

Jyoti Kumar

Python-Pandas cheat sheet: 30 functions-methods

In this blog, I have mentioned 30 useful python-pandas functions/methods used frequently in data analysis. The following activities can be…

4 min readAug 5, 2022

--

2

Python-Pandas cheat sheet: 30 functions-methods

--

2

Jyoti Kumar

Date and time in python

In this blog, I will discuss how to convert date time column from string to pandas._libs.tslibs.timestamps.Timestamp format using…

4 min readJun 18, 2022

--

1

Date and time in python

--

1

Jyoti Kumar

Date and time in R

In 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…

3 min readApr 3, 2022

--

--

Jyoti Kumar

Group by and Summarize: R and python

One of the most frequently used step to analyze data is by grouping data using one or more variable and then summarizing using functions…

2 min readFeb 24, 2022

--

--

Jyoti Kumar

Average Sales Variants — Tableau

In this blog, I will discuss average sales calculation. It seems simple to do average calculation but based on requirement there can be a…

4 min readDec 26, 2021

--

Average Sales Variants — Tableau

--

Jyoti Kumar

Jyoti Kumar

I have experience in Predictive Modelling and Dashboards. I have rich working experience on various tools and software like Python, R, Tableau, Power BI and SQL

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams