Medium-20210509-2.py

Medium-20210509-2.py

# load both files into separate dataframes
file1 = pd.read_csv('file1.csv', sep=';', encoding='UTF-8')
file2 = pd.read_csv('file2.csv', sep=';', encoding='UTF-8')

# save the list of column names for each dataset
columnnames1 = list(file1)
columnnames2 = list(file2)

# check if the columns match
if collections.Counter(columnnames1) == collections.Counter(columnnames2):
    print ("Number of columns and Names match, Comparison possible...\n\n")
else:
    print ("Number of columns and Names are not matching!!! Please check the input!")
    sys.exit('Error!')