Aug-15-2019, 05:10 PM
The following function should do the trick. This won't win any beauty prize however as I just quickly hacked this together.
def repeat_cols(columns): last_non_unnamed = '' if 'unnamed' in columns[0].lower() else columns[0] new_columns = [] new_column = '' for column in columns: if 'unnamed' in column.lower(): new_column = last_non_unnamed else: new_column = column last_non_unnamed = new_column new_columns.append(new_column) return new_columns df.columns = repeat_cols(df.columns)