Capture the entire data difference between two dataframes in row wise

Asked Jan 29 '20 at 10:19

Active Jan 29 '20 at 10:27

Viewed 98 times

is there any easier way to compare two different dataframes in row wise and capture the difference.

df 1

country from to flag

('GB', 'GB390065', 'GB66903', 'Y')

('FR', 'FR418458', 'FR765617', 'Y')

('FR', 'FR629810', 'FR855277', 'Y')

('FR', 'FR494010', 'FR332891', 'Y')

('FR', 'FR740500', 'FR907878', 'Y')

('FI', 'NB444135', 'NB234471', 'Y')

df 2

country from to flag

('GB', 'GB390065', 'GB66903', 'Y')

('FR', 'FR418458', 'FR7656', 'Y')

('FR', 'FR629810', 'FR855277', 'Y')

('FR', 'FR4910', 'FR33891', 'Y')

('FR', 'FR740500', 'FR907878', 'Y')

('FI', 'NB444135', 'NB234471', 'Y')

my expected output:

country    from         to       flag

('FR',  'FR418458', 'FR7656',   'Y')

('FR',  'FR4910',   'FR33891',  'Y')

edited Jun 20 '20 at 09:12

Community

asked Jan 29 '20 at 10:19

sumathi

I didn't get the answer which am looking for @jezrael – sumathi Jan 29 '20 at 11:19
OK, please add your solutions to question and also explain why not working – jezrael Jan 29 '20 at 11:19

0 Answers0