Making a scatter plot with string in x axis in pandas

Question

I have two columns: genres (more than 10 unique) and price and I want to compare them using scatter plot. How can I write string names in x axis?

price 2.99 3.54 7.00 and so on

genre fiction drama psychology and so on

Another option: convert string to category and somehow convert category numbers to string during graphing. Is it possible?

df['genre'] = df['genre'].astype("category").cat.codes 
Plot = df.plot.scatter(x='genre',
                      y='price',
                      c='DarkBlue')

Ragıp Gürlek · Accepted Answer · 2020-05-10 12:51:03Z

2

You can leave the genre column as object, aka string, Dtype in pandas and plot it. Try running just the line below.

df.plot.scatter(x='genre', y='price', c='DarkBlue')

Here is a working example.

import seaborn as sns
iris = sns.load_dataset('iris')

iris.plot.scatter("species", "sepal_length")

edited May 10, 2020 at 12:51

answered May 10, 2020 at 12:23

Ragıp Gürlek

1608 bronze badges

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

4 Comments

Ksenia Over a year ago

No, it says: "scatter requires x column to be numeric"

mechanical_meat Over a year ago

@Ksenia: what version of Pandas are you on? This works for me on 1.0.3.

Ksenia Over a year ago

@mechanical_meat: I have the 1.0.1. Maybe that's a problem.

mechanical_meat Over a year ago

I think this is the bug: github.com/pandas-dev/pandas/issues/18755

YKerem · Accepted Answer · 2020-05-10 12:20:59Z

0

I think you are asking about axis labels?

if so it's as simple as this

plot.xlabel("Genre")

answered May 10, 2020 at 12:20

YKerem

822 silver badges14 bronze badges

Collectives™ on Stack Overflow

Making a scatter plot with string in x axis in pandas

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related