how to plot a diagonal plot in python

Question

I am trying to create a diagonal plot in python, I am working off an example that works but I am getting a key error message. The code is the following:

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

filename = 'https://library.startlearninglabs.uw.edu/DATASCI410/Datasets/JitteredHeadCount.csv'
headcount_df = pd.read_csv(filename)
headcount_df.describe()

num_cols = ["TablesOcc", "ablesOpen", "HeadCount", "TablesClosed", "DayNumber"] 
sns.pairplot(headcount_df.loc[:, num_cols], hue='DayOfWeek', 
             palette="seismic", diag_kind="kde", 
             size=2).map_upper(sns.kdeplot, cmap="Blues")

I am getting a key error messaging KeyError: 'DayOfWeek'and

KeyError                                  Traceback (most recent call last)

I am not sure why it is not working this time. any help would be appreciated.

Are you passing the 'DayOfWeek' column to pairplot?

S. Strempfer
– S. Strempfer

2020-07-14 01:42:36 +00:00
Commented Jul 14, 2020 at 1:42 — S. Strempfer
– S. Strempfer, Commented Jul 14, 2020 at 1:42
Typo too - "ablesOpen" should be "TablesOpen".

BigBen
– BigBen

2020-07-14 01:46:56 +00:00
Commented Jul 14, 2020 at 1:46 — BigBen
– BigBen, Commented Jul 14, 2020 at 1:46

S. Strempfer · Accepted Answer · 2020-07-14 01:47:22Z

2

This should work

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns

filename = 'https://library.startlearninglabs.uw.edu/DATASCI410/Datasets/JitteredHeadCount.csv'
headcount_df = pd.read_csv(filename)
headcount_df.describe()

sns.pairplot(headcount_df, hue='DayOfWeek', 
             palette="seismic", diag_kind="kde", vars=["TablesOcc", "TablesOpen", "HeadCount", "TablesClosed", "DayNumber"],
             size=2).map_upper(sns.kdeplot, cmap="Blues")

answered Jul 14, 2020 at 1:47

S. Strempfer

2982 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Greg Sullivan Over a year ago

Do you have much experience with Jupiter Notebook? I am having issues with the code not computing. The code is simple so should only take a few seconds to complete but this is the second time I have had an issue with the code not computing in this book. any ideas why that may be?

S. Strempfer Over a year ago

It seems like pairplot is just an expensive function and it probably doesn't help that there are 175,000 entries in your csv file

S. Strempfer Over a year ago

stackoverflow.com/questions/37612434/…

Collectives™ on Stack Overflow

how to plot a diagonal plot in python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related