'Trying to rename repeated columns in pandas DataFrame

I have a list of duplicate columns in my DataFrame (named as df here in the code) and I am trying to rename duplicate columns by adding a number in the end. For example:

If there are two columns named col, then I want two columns named col1 and col2.

But this code gives two column names as col1 and col1 again.

for col in duplicate_col:
    counter = 1 
    for col2 in df.columns:
        if(col2==col):
        df.rename(columns={col2:col2+str(counter)},inplace=True)
        counter = counter+1


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source