How to convert a list into multiple columns using Python?

Question

Example:

l = ['3.4', '3.2', '2.3', '4.3', '2.3']

Is there a way to convert the list above into separate columns?

For example, I am can do this:

Header
3.4
3.2
2.3
4.3
2.3

with the following code:

df = pdf.DataFrame(l)

However, I would like to achieve the following:

3.4 | 3.2 | 2.3 | 4.3 | 2.3 -> separate columns, rather than rows.

Thank you!

The end result, I am looking to get a data frame on separate columns so that I can later export in .csv. I have a larger code that builds multiple lists, and for some reason, transpose doesn't work. — g3lo
– g3lo, Commented Jul 19, 2019 at 19:22
Can you describe "transpose does not work"? What Output do you see? — harpan
– harpan, Commented Jul 19, 2019 at 19:33

BENY · Accepted Answer · 2019-07-19 19:25:05Z

2

I usually using Series

df = pd.Series(l).to_frame('Header').T

edited Jul 19, 2019 at 19:25

answered Jul 19, 2019 at 19:22

BENY

324k22 gold badges176 silver badges250 bronze badges

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

3 Comments

harpan Over a year ago

I think OP wants pd.Series(l).to_frame('Header').T.

g3lo Over a year ago

Right, so this shows it in rows. I need it in columns, for example: Header 1 - 3.4 Header 2 - 3.2 Header 3 - 2.3 Header 4 - 4.3 Header 5 - 2.3

harpan Over a year ago

@WeNYoBen, always there to help :)

Abhishek Kumar · Accepted Answer · 2019-07-19 19:26:58Z

0

You can use below snippet

l = ['3.4', '3.2', '2.3', '4.3', '2.3']
l = np.array(l)
df = pd.DataFrame(l.reshape(-1,len(l)))
df =
    0   1   2   3   4
0   3.4 3.2 2.3 4.3 2.3

Hope this helps

answered Jul 19, 2019 at 19:26

Abhishek Kumar

7981 gold badge8 silver badges24 bronze badges

Comments

Krishna Rao · Accepted Answer · 2019-07-19 19:28:52Z

0

You can use in similar code, but use list of lists:

df = pdf.DataFrame([l])

answered Jul 19, 2019 at 19:28

Krishna Rao

999 bronze badges

Comments

flashy · Accepted Answer · 2019-07-19 19:33:21Z

0

You can use this code:

l = ['3.4', '3.2', '2.3', '4.3', '2.3']

for i in range(len(l)):
    if i == list(range(len(l)))[-1]:
        print("└───", end="")
    else:
        print("├───", end="")
    print(l[i])

edited Jul 19, 2019 at 19:33

answered Jul 19, 2019 at 19:23

flashy

57411 silver badges26 bronze badges

2 Comments

g3lo Over a year ago

I may have been not 100% clear. I am looking for columns. So 5 headers and 1 row.

flashy Over a year ago

Don't you want this?

johnDanger · Accepted Answer · 2019-07-19 19:45:18Z

0

You can either transpose the dataframe after initialization

df.transpose()

OR

you can change the list to begin with to change its shape from (4, 1) to (1, 4)

l2 = [l]
pd.DataFrame(l2)

OR

Create a new dictionary to feed into pandas (dictionaries are the typical way to create a dataframe)

colNames = ['a','b','c','d'] 
pd.DataFrame(dict(list(zip(l, colNames))))

Cheers!

answered Jul 19, 2019 at 19:45

johnDanger

2,37920 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to convert a list into multiple columns using Python?

5 Answers 5

3 Comments

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related