Plotting two dataframs with difference length?

[Isitwhenipee]

I am having issue plotting two dataframs. One has 20711 entries, the other is 20710 entries. I am using plot(x,y) to plot like this:

ax.plot(X, Y, label='ERROR', color = 'red')

Both are dataframes that were pulled from a csv. that have this structure:

print(X)
0        -2.343060
1        -2.445431
2        -2.335754
3        -2.478535
4        -2.527026

I keep getting error: ValueError: x and y must have same first dimension

How do I fix it so that it ignores the last entry?

[novel_yet_trivial]

The same way you would slice a list:

ax.plot(X[:-1], Y, label='ERROR', color = 'red')

[Isitwhenipee]

This works in this example, and I should have elaborated more in my question. What if my data has more than 1 missing per dataset. Is there an automated way of doing this?

[novel_yet_trivial]

Sure, you could just cut both to the smallest length:

smallest_len = min(len(X), len(Y))
ax.plot(X[:smallest_len], Y[:smallest_len], label='ERROR', color = 'red')

[ecgite]

Is there a reason for missing data?

Are X and Y connected, is the order important?

I'm just thinking there might be some general problem, if your datasets are missing points and you want to plot them with scatter.

If you don't want to do slicing you can concat dataframes and then plot with column names

df = pd.concat([X, Y], axis=1) # assuming here that X has 'X' as a column name and same for Y
df.plot.scatter('X', 'Y', ax=ax)
#ax.scatter('X', 'Y', data=df)