Jane Lee Jane Lee - 1 year ago 89
Python Question

Plotting two different dataframes with different sizes?

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:

import pandas as pd
import csv
import matplotlib.pyplot as plt

fig1 = plt.figure(figsize= (10,10))
ax = fig1.add_subplot(111)
ax.plot(X, Y)

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

0 -2.343060
1 -2.445431
2 -2.335754
3 -2.478535
4 -2.527026
0 0.026940
1 -0.075431
2 0.024246
3 -0.118535
4 -0.167026
5 -0.145475

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?

Answer Source

Well if you can just ditch the last value of Y then the following should work, assuming you have the index in your dataframe too, that is, your csv looks like this:


and you loaded it like X=pandas.read_csv('x.csv'), then

ax.plot(X.as_matrix().T[1], Y.as_matrix().T[1][:-1])

should work.

As you mentioned in your comment the overlap varies:

ax.plot(X.as_matrix().T[1], Y.as_matrix().T[1][:len(x)])
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download