I have two dataframes
df1
name |
---|
Elias |
David |
Simon |
Manuel |
and a second df2
name |
---|
Gabriel |
Brian |
Simona |
Danielle |
Dilara |
Martin |
David |
Simon |
I one to put them into one column
I expecting an output like these:
name |
---|
Elias |
David |
Simon |
Manuel |
Gabriel |
Brian |
Simona |
Danielle |
Dilara |
Martin |
where every name occur once, so remove also duplicates.
i tried these
frames = [df1,df2]
but these gave me something different
Advertisement
Answer
Assuming the columns names are ‘A’ and ‘B’:
df3 = pd.concat([df1['A'], df2['B']], axis = 0).drop_duplicates().reset_index(drop=True)