Plot pandas dataframe values by multiple criteria

Question

I have the following dataframe:

data = [
    ['unit1','A',3000,2.4],['unit1','A',4000,2.5],['unit1','A',5000,2.7],
    ['unit2','A',3000,2.1],['unit2','A',4000,2.3],['unit2','A',5000,2.6],
    ['unit3','A',3000,2.5],['unit3','A',4000,2.6],['unit3','A',5000,2.8]]
df = pd.DataFrame(data, columns=['unitname','channel','frequency','power'])

I would like to plot power over frequency, with each unit its own series and a legend corresponding to the unit name. With putting all of the series in the same plot.

I think what you want is already answered: stackoverflow.com/questions/56632446/… — ALollz
– ALollz, Commented Sep 16, 2019 at 3:02

Trenton McKinney · Accepted Answer · 2019-09-17 16:45:59Z

3

Use `seaborn` to make your plots look nicer:

Using the sample dataframe provided in the question.

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

plt.figure(figsize=(8, 8))
sns.lineplot(x='power', y='frequency', data=df, hue='unitname')
plt.show()

edited Sep 17, 2019 at 16:45

answered Sep 16, 2019 at 3:23

Trenton McKinney

63.2k41 gold badges170 silver badges213 bronze badges

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

Comments

moys · Accepted Answer · 2019-09-16 02:52:16Z

0

IICU, this is what you need

df[df['unitname']=='unit1'].plot(x="power", y="frequency",title='unit1',colormap='Reds_r')
df[df['unitname']=='unit2'].plot(x="power", y="frequency",title='unit2', colormap='Blues_r')
df[df['unitname']=='unit3'].plot(x="power", y="frequency",title='unit3', colormap='Greens_r')

edited Sep 16, 2019 at 2:52

answered Sep 16, 2019 at 2:42

moys

8,1173 gold badges19 silver badges51 bronze badges

Collectives™ on Stack Overflow

Plot pandas dataframe values by multiple criteria

2 Answers 2

Use `seaborn` to make your plots look nicer:

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Use seaborn to make your plots look nicer:

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Use `seaborn` to make your plots look nicer: