Split list and create a dataframe in python

Question

I have a list of strings like this:

lis_val = ['Mon 01/12/2020 apple', 'Tue 01/13/2020 orange', 'Wed 01/14/2020 peach']

I need to assemble a dataframe from this list as:

df = Mon  01/12/2020 apple
     Tue  01/13/2020 orange
     Wed  01/14/2020 peach

bigbounty · Accepted Answer · 2020-07-14 01:47:17Z

1

In [82]: lis_val = ['Mon 01/12/2020 apple', 'Tue 01/13/2020 orange', 'Wed 01/14/2020 peach']
    ...:

In [83]: pd.DataFrame([i.split() for i in lis_val])
Out[83]:
     0           1       2
0  Mon  01/12/2020   apple
1  Tue  01/13/2020  orange
2  Wed  01/14/2020   peach

answered Jul 14, 2020 at 1:47

bigbounty

17.5k7 gold badges45 silver badges76 bronze badges

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

1 Comment

DaveM Over a year ago

How to get result in wide format such as instead of three columns I have nine such as: day_1 date_1 fruuit_1 day_2 date_2 fruit_2 day_3 date_3 fruit_3

MrNobody33 · Accepted Answer · 2020-07-14 02:32:22Z

1

You could use pd.Series.str.split() with expand=True:

import pandas as pd

lis_val = ['Mon 01/12/2020 apple', 'Tue 01/13/2020 orange', 'Wed 01/14/2020 peach']
df=pd.DataFrame(lis_val)[0].str.split(expand=True)
print(df)

Output:

     0           1       2
0  Mon  01/12/2020   apple
1  Tue  01/13/2020  orange
2  Wed  01/14/2020   peach

edited Jul 14, 2020 at 2:32

answered Jul 14, 2020 at 1:50

MrNobody33

6,5039 silver badges20 bronze badges

Collectives™ on Stack Overflow

Split list and create a dataframe in python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related