plot data from column with specific value

Question

how can I plot column A as x-axis and B as y-axis with data only related to C. looking for a graph that looks like density graph.

usa = df[df.Country == 'USA'] selects a subset of rows in the dataframe. To select a subset of columns, such as score & profit, try: usa[['score', 'profit']]. — DarrylG
– DarrylG, Commented Jan 30, 2022 at 4:47
Stackoverflow encourages data (such as your table) to be provided as text rather than an image. This allows responders to more easily post answers using your data. — DarrylG
– DarrylG, Commented Jan 30, 2022 at 4:54

Malvi Patel · Accepted Answer · 2022-01-30 05:24:15Z

1

If you are having error while extracting specific columns then, it might be because of extra spaces, just try removing extra space.
Here is code:

usa = df[df.Country == 'USA']
usa.columns = usa.columns.to_series().apply(lambda x: x.strip())
usa[['Score', 'Profit']]

For Density Graph, the question is still unclear, but here density plot based on what I have understood

import seaborn as sns
p=sns.kdeplot(usa['Score'], shade=True, color="r")
p=sns.kdeplot(usa['Profit'], shade=True, color="b")

answered Jan 30, 2022 at 5:24

Malvi Patel

1062 silver badges9 bronze badges

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

2 Comments

qhfalice Over a year ago

thank you! for second question, I was wondering if there is any plot that I can choose both x and y axis but still looks similar to the density graph (smooth line, not line graph)

Malvi Patel Over a year ago

Link Do have a look at this question, is this what you are looking for

Collectives™ on Stack Overflow

plot data from column with specific value

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related