Pandas AttributeError: 'DataFrame' object has no attribute 'concat'

[Yoriz]

The error line 24

df_total = df_total.concat(df)

does not match your posted code line 24

df = excel_file.parse(sheet_name = sheet)

neither does the next line

df_total = df_total.append(df)

DataFrame does not have a concat method
Pandas has a concat function

pandas.concat(objs, *, axis=0, join='outer', ignore_index=False, keys=None, levels=None, names=None, verify_integrity=False, sort=False, copy=True)

Concatenate pandas objects along a particular axis.

Allows optional set logic along the other axes.

Can also add a layer of hierarchical indexing on the concatenation axis, which may be useful if the labels are the same (or overlapping) on the passed axis number.