How to plot (correctly) lineplot from pandas dataframe?

Question

I'm plotting a lineplot from a pandas dataframe. However the labels are overlapped on the right side of the X axis instead of to the relative point mark on the line. What is missing?

Here the full code and the pic

#importing pandas package
import pandas as pd
import matplotlib.pyplot as plt
import csv
import seaborn as sns
# making data frame from csv file
dataset = pd.read_csv('curve.csv.csv')

df = pd.DataFrame(dataset.sort_values('Split')[['Split', 'Score']]) 
df.reset_index(drop=True, inplace=True)

print(df)



ax = df.plot.line(x='Split',y='Score',color='green',marker=".")
ax.set_xlim((0, 1))
ax.grid(True)
# set the tick marks for x axis
ax.set_xticks(df.Score)
ax.set_xticklabels(['.005','.010','.015','.020','.040','.060','.080','1','15','20','25','30','35','40','45','50','55','60'
                    ,'65','70','75','80','85','90','95'])

ax.grid(True, linestyle='-.')
ax.tick_params(labelcolor='r', labelsize='medium', width=3)

plt.show()

My desired output would be to have all the labels on the X axis aligned to the relative marker point on the line.

ax.set_xticklabels(['.005',...What happens when I convert a string to a number? — r-beginners
– r-beginners, Commented Dec 19, 2020 at 12:35

Diziet Asahi · Accepted Answer · 2020-12-19 21:59:38Z

1

You seem to be using the y-values (df.Score) as the positions of your x-ticks.

I assume you meant

ax.set_xticks(df['Split'])

edited Dec 19, 2020 at 21:59

answered Dec 19, 2020 at 12:52

Diziet Asahi

41k8 gold badges67 silver badges85 bronze badges

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

Collectives™ on Stack Overflow

How to plot (correctly) lineplot from pandas dataframe?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related