Trouble With Left Joining Tables Pandas (valueerror: You Are Trying To Merge On Object And Int64 Columns.)

I have two lists where I want to left join one. This is how I generate the first list: # NB Oracle connection first_list = pd.read_sql('SELECT firstname, lpad(identifier, 4, 0) fro

Solution 1:

Use pandas.DataFrame.merge with how='left':

final_list = pd.merge(first_list, second_list, on='identifier', how='left')

print(final_list)
         name  identifier         BIC                         BANK
0   Firstname        1201  DNBANKNOKK                 DNB Bank ASA
1  Secondname           0UNKNOWNUnknown2   Thirdname        1855    EIDSNO21           Eidsberg Sparebank
3  Fourthname        3333    RYGSNO21  Sparebank1 Østfold Akershus
4   Fifthname        1414    LOSKNO21      Sparebank 1 Lom og Sjåk

A good an extensive explenation about merging in pandas can be found here: Pandas Merging 101

Solution 2:

try like below use merge

import pandas as pdfinal_list= pd.merge(first_list, second_list, how='outer',left_on=['identifier'], right_on=['identifier'])