Pandas: convert all columns in dataframe to string

Question

I have dataframe

 0     1     2
12     34   23
10     12    0

Desire output

upd_string
12, 34, 23
10, 12, 0

I try

df_upd = pd.DataFrame()
df_upd['upd_string'] = df[df.columns.values.tolist()].apply(str)

But it returns

ValueError: no results

jezrael · Accepted Answer · 2017-12-07 11:13:55Z

4

First cast to strings if numeric and then apply join:

df.astype(str).apply(', '.join, axis=1)

for new DataFrame:

df_upd = pd.DataFrame({'upd_string': df.astype(str).apply(', '.join, axis=1)})
print (df_upd)
   upd_string
0  12, 34, 23
1   10, 12, 0

answered Dec 7, 2017 at 11:13

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

it returns TypeError: data type not understood

It seems some data relative problem

Are data confidental?

I create data with df = pd.DataFrame(result_list) where result_list = [[12, 34, 23], [10, 12, 0]]

Problem has solved with restarting the kernel) Thank you!

|