Connect excel data sheets with tableau and visualize

Let’s connect the Superstore dataset into tableau. This excel file has three sheets named as Orders, People, Returns.

First open the tableau tool.

Bar chart race used to animate the data

Installation

• pip install bar_chart_race

(or)

• conda install -c conda-forge bar_chart_race

Install the bar_chart_race plugin using the above command.

Import plugins

import pandas as pdimport numpy as npimport bar_chart_race as bcr

Import panda, numby and bar_chart_race

Dataset

Currently i’m taking dataset of covid19 day wise. Reference:- Day_wise CSV

Read the csv file and display the top 5 data

covidDayWise=pd.read_csv(“day_wise.csv”)
covidDayWise.head(5)

The NTILE() function divides rows in a sorted partition into a specific number of groups. Each group is assigned a bucket number starting at one. For each row, the NTILE() function returns a bucket number representing the group to which the row belongs.

NTILE() Syntax

NTILE(buckets) OVER ( [PARTITION BY…

The NTH_VALUE() is a window function that allows you to get a value from the Nth row in an ordered set of rows.

NTH_VALUE Syntax

NTH_VALUE(expression, N) FROM FIRST OVER ( partition_clause order_clause frame_clause )

Data Set

Here we are trying to use HR data which has ID, Name and…

Character

1. ASCII — This function returns the ASCII value of given character

SELECT ASCII(‘A’) — This gives the result of “65”

String

1. CHAR_LENGTH() or CHARACTER_LENGTH() — Both function can be used and both returns the length of the string, “it counts space also as a value”.

SELECT CHAR_LENGTH(“Hello”);
SELECT CHARACTER_LENGTH(“Hello”); — Returns…