Error in creating new dataframe from comparison of 2 dataframe in python

Question

I have 2 dataframe whose sample is as below:

df1:

                     Table                Field
0                    AOI                  AEDAT
1                    AEI                  AEDTZ
2                    AOI                  AEENR
3                    AEO                  AENAM
4                    AEO                  AEOST

df2:

        View       Field
0    Accounting 1  AEDAT
1    Accounting 1  AEDAT
2    Accounting 1  AEOST
3    Accounting 1  AEOST

What I want is compare Field columns of the 2 dataframe and if they are similar then in the third dataframe add the View field from the df2 or else add NA as the row to the 3rd dataframe.

Here is what I wrote so far:

df3 = pd.DataFrame(columns=['view'])
for index, row in df1.iterrows():
    for index2, row2 in df2.iterrows():
        if row['Field'] == row2['Field']:
            df3['view'].append(row2['View'])

When I run this code I get following error: TypeError: cannot concatenate object of type '<class 'str'>'; only Series and DataFrame objs are valid

How do I correct this?

Does this answer your question? Pandas Merging 101

BigBen
– BigBen

2022-03-28 17:41:58 +00:00
Commented Mar 28, 2022 at 17:41 — BigBen
– BigBen, Commented Mar 28, 2022 at 17:41

BENY · Accepted Answer · 2022-03-28 17:39:28Z

2

Check with merge

df3 = df1.merge(df2, how = 'left', on  = 'Field')

answered Mar 28, 2022 at 17:39

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Comments

pyaj · Accepted Answer · 2022-03-28 22:37:58Z

0

Drop Table and Field columns

df3 = df1.merge(df2, how ='left', on='Field').drop(['Table', 'Field'], axis=1 )

answered Mar 28, 2022 at 22:37

pyaj

6407 silver badges17 bronze badges

Collectives™ on Stack Overflow

Error in creating new dataframe from comparison of 2 dataframe in python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related