ENH: str.replace on multiple columns

[manel00]

#IT WORKS
df['Total'] = df['Total'].str.replace(r'\.', '')
df['Homes'] = df['Homes'].str.replace(r'\.', '')
df['Dones'] = df['Dones'].str.replace(r'\.', '')

#IT DOESNT WORK
cols = ["Total", "Homes", "Dones"]
df[cols] = df[cols].str.replace(r'\.', '')

On Pandas 1.0.1

[WillAyd]

There is no .str accessor for data frame, only series. This is similar to #27581 but same comment applies - I'm not sure we really would want to add .str or .dt accessors to DataFrames anyway

[hirolau]

It is not too much hassle to do:

for col in ["Total", "Homes", "Dones"]:
    df[col] = df[col].str.replace(r'\.', '')

[mroeschke]

Thanks for the suggestion but for a similar reason as #27581 there is hesitation to add accessors that operate on dataframe due to the nature of mixed dtypes. Closing