PythonValueError: Can only compare identically-labeled Series objects

Question

The 2 dataframes I am comparing are of different size (have the same index though) and I suppose that is why I am getting the error. Can you please suggest me a way to get around that. I am looking for those rows in df2 whose user_id match with those of df1. Thanks and appreciate your response.

 data = np.array([['user_id','comment','label'],
            [100,'RT @Dvillain_: #oomf should text me.',0],
            [100,'Buy viagra',1],
            [101,'#nowplaying M.C. Shan - Juice Crew Law on',0],
            [101,'Buy viagra two',1]])

 data2 = np.array([['user_id','comment','label'],
            [100,'First comment',0],
            [100,'Buy viagra',1],
            [102,'Buy viagra two',1]])

df1 = pd.DataFrame(data=data[1:,0:],columns = data[0,0:])
df2 = pd.DataFrame(data=data2[1:,0:],columns = data[0,0:])

df = df2[df2['user_id'] == df1['user_id']]

BENY · Accepted Answer · 2018-02-06 03:17:39Z

3

You are looking for isin

df = df2[df2['user_id'].isin(df1['user_id'])]
df
Out[814]: 
  user_id        comment label
0     100  First comment     0
1     100     Buy viagra     1

answered Feb 6, 2018 at 3:17

BENY

324k22 gold badges176 silver badges250 bronze badges

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

3 Comments

pault Over a year ago

Just beat me to it!

BENY Over a year ago

@pault just a little bit quick .I am lucky:-)

BENY Over a year ago

@Chandan yw~ happy coding

Collectives™ on Stack Overflow

PythonValueError: Can only compare identically-labeled Series objects

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related