from io import StringIO
import pandas as pd
txt1 = """fruits,trees,sports,countries
bananas,mongolia,basketball,Spain
grapes,Oak,rugby,Thailand
oranges,Osage,Orange baseball,Egypt
apples,Maple,golf,Chile"""
txt2 = """cars,flowers,countries,vegetables
Audi,Rose,Spain,Carrots
BMW,Tulip,Nigeria,Celery
Honda,Dandelion,Egypt,Onion"""
df = pd.read_csv(StringIO(txt1))
df2 = pd.read_csv(StringIO(txt2))
Comparing two DataFrames by one column with a return of three different outputs with Panadas