concatenate all strings in the dataframe column

Question

I want to convert all the strings in a dataframe column as a single empty string and then convert it in to list of words:

import pandas as pd
df = pd.DataFrame({'read': ["Red", "is", "my", "favorite", "color"]})
print(df)
    read
0   Red
1   is
2   my
3   favorite
4   color

I tried to join strings but I don't know how to add space.

string = ""
for i,j in df.iterrows():
    string += j["read"]

Output:

'Redismyfavoritecolor'

Required Output:

"Red is my favorite color"

jezrael · Accepted Answer · 2018-08-16 07:22:12Z

42

Use join with whitespace:

out = ' '.join(df["read"])
print (out)
Red is my favorite color

answered Aug 16, 2018 at 7:22

jezrael

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

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

4 Comments

Sai Kumar Over a year ago

I am getting a type error when I try it in my dataframe. It's says expected str instance but got float. How can I fix it?

jezrael Over a year ago

@sai_636 - How working ' '.join(df["read"].astype(str)) or ' '.join(df["read"].dropna()) if float values are NaNs

Sai Kumar Over a year ago

This code ' '.join(df["read"].astype(str)) this fixed it. Does this line convert all values to string before joining?

jezrael Over a year ago

@sai_636 exactly, it convert values to string.

bouvierr · Accepted Answer · 2025-01-29 13:54:38Z

1

The easiest and optimal solution for concatenating or joining all strings in a column (Series) is to use pandas.Series.str.cat which lets you specify a separator.

df['read'].str.cat(sep=' ')

answered Jan 29 at 13:54

bouvierr

3,8603 gold badges30 silver badges36 bronze badges

Collectives™ on Stack Overflow

concatenate all strings in the dataframe column

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related