How to properly plot dataframe with matplotlib

Question

I'm trying to plot a dataframe with two columns:

    Compound_ID,Averages
  0  M0001,0.75
  1  M0002,0.87
  2  M003,0.45

Instead of showing the 'Compound_ID' on the x axis it is showing the index. When I explicitly try to plot, it raises and error.

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

df = pd.read_csv('teste.csv')
plt.plot(df['Averages'], df['Compound_ID'])
plt.show()


AttributeError: 'Series' object has no attribute 'find'

It is probably something easy to solve, but can someone take a look at my code?

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

df = pd.read_csv('teste.csv')
plt.plot(df['Averages'])
plt.show()

Possible duplicate of How to fix AttributeError: 'Series' object has no attribute 'find'? — Andrew L
– Andrew L, Commented Aug 10, 2017 at 12:14
Are you after: df.plot.bar(x='Compound_ID', y='Averages', rot=0)? — MaxU - stand with Ukraine
– MaxU - stand with Ukraine, Commented Aug 10, 2017 at 12:15

Andrey Lukyanenko · Accepted Answer · 2017-08-10 12:20:29Z

3

You can do this:

plt.plot(df['Averages'])
plt.xticks(range(len(df['Compound_ID'])) , df['Compound_ID'])

This way you plot xticks separately. The first element is numerical indexes, second - names.

answered Aug 10, 2017 at 12:20

Andrey Lukyanenko

3,8712 gold badges21 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How to properly plot dataframe with matplotlib

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related