How to convert multiple columns to string in pandas dataframe

Question

I have dataframes with different datatypes(code is given below). 

repair['SCENARIO']=repair['SCENARIO'].astype(str)

repair['SERVICE_TYPE']= repair['SERVICE_TYPE'].astype(str)

I want a function that would help me pass multiple columns and convert them into strings.

Answer 1

Hi,

To convert multiple columns to string, include a list of columns to your above-mentioned command:

df[['one', 'two', 'three']] = df[['one', 'two', 'three']].astype(str)

# you can add any number of columns

To convert all columns into string, you need to construct the list of columns:

all_columns = list(df) # Creates list of all column headers
df[all_columns] = df[all_columns].astype(str)

Comments

Thank you so much for sharing info..this saved lot of my time.

---

Hi, @There,

Thanks for your contribution. Please do upvote the answer in case you found it helpful!