I want to join 2 tables, with same column names, table 1 has data universe with some NA’s, table 2 has valid data for which table 1 has NA values.
I want to populate NA value in table 1 based on table 2 using joins
I tried this
import pandas as pd
data1 = pd.DataFrame([[1, 2, 3], [4, 5, 6], [7, 8,]], columns=[‘A’, ‘B’, ‘C’])
data2 = pd.DataFrame([[7, 8, 9]], columns=[‘A’,’B’,’C’])
data1.merge(data2, on=[‘A’,’B’], how=’left’)
Output I expect:
Output I got:
2