Merging two CSV files which have different row using Python

Asked Apr 27 '22 at 07:34

Active Apr 27 '22 at 07:34

Viewed 14 times

I am trying to merge two files but didn't get as I want

table 1 is

table 2 is

the result I want is
table 3

the code I am using is

a = pd.read_csv("table1.csv")
b = pd.read_csv("table2.csv")
b = b.dropna(axis=1)
merged = a.merge(b, on='title')
merged.to_csv("output.csv", index=False)

but it did not give me the output I want, need help

asked Apr 27 '22 at 07:34

Desta Werash

1

maybe dupe is wrong, `merge` should working well, only maybe need `merged = a.merge(b, on='title', how='outer')` – jezrael Apr 27 '22 at 07:41
1

Just do this: `pd.concat([df1, df2], axis=1)` as `df1` one is the first dataframe and `df2` is the other one. – Hadi Hajihosseini Apr 27 '22 at 07:41

Merging two CSV files which have different row using Python

0 Answers0