Append values in dataframe column to string

Question

Suppose I have a dataframe

    col1        col2
0   1       John Constantine
1   2       ML Engineer
2   3       Colorado

I want to append all values in col2 to a list and each row should become a string value in the list. ex

output = ['John Constantine', 'ML Engineer' , 'Colorado']

The issue is when I use

output = df.col2

The output becomes a dataframe again. Even when I use tolist() I get list of list

Mind posting the list you got?

Levi Lesches
– Levi Lesches

2018-02-26 02:01:00 +00:00
Commented Feb 26, 2018 at 2:01 — Levi Lesches
– Levi Lesches, Commented Feb 26, 2018 at 2:01
I got the solution. I had to read it as utf-8.

John Constantine
– John Constantine

2018-02-26 02:01:38 +00:00
Commented Feb 26, 2018 at 2:01 — John Constantine
– John Constantine, Commented Feb 26, 2018 at 2:01

sacuL · Accepted Answer · 2018-02-26 01:58:43Z

2

This should do it

list(df.col2)

answered Feb 26, 2018 at 1:58

sacuL

51.6k9 gold badges88 silver badges115 bronze badges

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

Comments

BENY · Accepted Answer · 2018-02-26 02:00:04Z

1

tolist still work

df.col2.tolist()
Out[401]: ['JohnConstantine', 'MLEngineer', 'Colorado']

answered Feb 26, 2018 at 2:00

BENY

324k22 gold badges176 silver badges250 bronze badges

Comments

ely · Accepted Answer · 2018-02-26 02:00:13Z

0

tolist() should work:

In [14]: df = pandas.DataFrame({
    "col1": [1, 2, 3], 
    "col2": ["John Constantine", "ML Engineer", "Colorado"]
})

In [15]: df.col2.tolist()
Out[15]: ['John Constantine', 'ML Engineer', 'Colorado']

answered Feb 26, 2018 at 2:00

ely

77.8k36 gold badges158 silver badges234 bronze badges

Comments

Pyd · Accepted Answer · 2018-02-26 06:11:51Z

0

I think you need,

df["col2"].tolist()

answered Feb 26, 2018 at 6:11

Pyd

6,16919 gold badges59 silver badges117 bronze badges

Collectives™ on Stack Overflow

Append values in dataframe column to string

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related