How to convert multiple columns to string in pandas dataframe?

0 votes

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.

Jul 18 in Python by Shabnam
• 920 points
32 views

1 answer to this question.

0 votes

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)
answered Jul 18 by Taj
• 1,040 points

Related Questions In Python

0 votes
1 answer

How to convert a Pandas GroupBy object to DataFrame in Python

g1 here is a DataFrame. It has a hierarchical index, ...READ MORE

answered Nov 12, 2018 in Python by Nymeria
• 3,500 points
4,485 views
0 votes
1 answer

How to convert string in Pandas Series to lower case?

Suppose you have the series stored in ...READ MORE

answered May 13 in Python by Raj
58 views
0 votes
1 answer

How to convert date string to date object in python?

Use this :-  >>> datetime.datetime.strptime('24052010 ...READ MORE

answered Oct 22, 2018 in Python by Priyaj
• 56,200 points
104 views
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 6 in Python by Neha
• 330 points

edited Jul 8 by Kalgi 168 views
+4 votes
6 answers
0 votes
1 answer

How to iterate over row in a Dataframe in Pandas?

Hi, You can use df.iterrows(), it yields both ...READ MORE

answered Jul 18 in Python by Taj
• 1,040 points
18 views
0 votes
1 answer

How to rename columns in pandas?

Hi,  To rename columns in pandas, you can ...READ MORE

answered Aug 9 in Python by Taj
• 1,040 points
7 views