[Python] Joining two dataframes then combining data in fields with same name using Pandas

I have seven dataframes with hundreds of rows each that I need to combine on a column. There are instances where these seven dataframes have columns with the same names. In those instances, I would like to combine the data therein and delimit with a semicolon.

For example, if Row 1 in DF1 through DF7 have the same identifier, I would like Col1 in each dataframe (given they have the same name) to be combined to read:

dfdata1; dfdata2; ...; dfdata7


In cases where a column name is unique, I'd like it to appear in the final combined dataframe.

I've included a simple example

data1 = pd.DataFrame(
[['Banana', 'Sally', 'CA'], ['Apple', 'Gretta', 'MN'], ['Orange', 'Samantha', 'NV']],
columns=['Product', 'Cashier', 'State']
)

data2 = pd.DataFrame(
[['Shirt','', 'CA'], ['Shoe', 'Trish', 'MN'], ['Socks', 'Paula', 'NM', 'Hourly']]
)


My expected output:



How do I do this?

Continue reading...