Please see the youtube links and files for all Excel lessons after the Python codes.

#Titanic Python Swarm Plot Codes

#import Python liberary

import numpy as np

import pandas as pd

import matplotlib.pyplot as plt

import seaborn as sns

sns.set(style=”white”)

# Load the Data

titanic = sns.load_dataset(“titanic”)

#see the first five rows of the data

titanic.head()

#see the description for each column

titanic.info()

#the codes for slide 7 on the Youtube video

sns.catplot(x=”embark_town”, y=”age”,  s = 5, height=5, aspect=1.7,

             data=titanic, kind=”swarm”)

#the codes for slide 8 on the Youtube video

plt.figure()

sns.swarmplot(data=titanic, x=”embark_town”, y=”fare”, hue = “pclass”).set_title(“Distribution of fare prices by Class”)

#the codes for slide 10 on the Youtube video

sns.swarmplot(x=”sex”, y=”age”, data=titanic)

plt.title(‘Ages of Passengers’)

#the codes for slide 12 on the Youtube video

sns.catplot(x=”sex”, y=”age”, col=”pclass”,  s = 7,

             data=titanic, kind=”swarm”)

#the codes for slide 16 on the Youtube video

sns.catplot(x=”sex”, y=”age”, col=”pclass”,   s = 7,

            hue = “survived”, data=titanic, kind=”swarm”,

           palette=sns.color_palette([‘silver’, ‘cornflowerblue’]))

#the codes for slide 18 on the Youtube video

sns.catplot(x=”sex”, y=”age”,

            hue = “survived”, data=titanic, kind=”swarm”,

           palette=sns.color_palette([‘silver’, ‘cornflowerblue’]))

#End of the codes

Five-Minute Excel Lesson 2 (2D Pie Charts)

Five-Minute Excel Lesson 3 (3D Pie Charts & Donut Charts)

Five-Minute Excel Lesson 4 (Line Charts)

Five-Minute Excel Lesson 5 (Column Charts)

Five-Minute Excel Lesson 6 (Bar Charts)

Five-Minute Excel Lesson 7 (Scatter Plots)

Five-Minute Excel Lesson 8 (Histogram)

Five-Minute Excel Lesson 9 (Box Plot)

Five-Minute Excel Lesson 10 (Map Charts)

Five-Minute Excel Lesson 11 (Pivot Tables) (Note: Lesson 11, 12, 13, and 14 use the same data file)

Five-Minute Excel Lesson 12 (Pivot Charts)

Excel Lesson 13 (Drilling down the data set for actionable recommendations / insights)

Excel Lesson 14 (Presenting actionable recommendations / insights with charts)

Excel Lesson 15 (Relative & absolute cell reference, Min, Max, Average, Sum, Large, Small)

Excel Lesson 16 (Mixed Cell Reference)

Excel Lesson 17 (IF)

End of this document, updated on May 8, 2024