Python list to pandas dataframe

Question

I have a list that follows this format:

a=['date name','10150425010245 name1','10150425020245 name2']

I am trying to convert this to Pandas df:

newlist=[]
for item in a:
    newlist.append(item.split(' '))

Now, convert this to df:

pd.DataFrame(newlist)

which results in

                  0     1
0              date  name
1    10150425010245 name1
2    10150425020245 name2

I want to have 'date' and 'name' as header, but I can't manage to do that. Is there a more efficient way to automatically convert a list of strings into a dataframe than this?

MattDMo · Accepted Answer · 2015-04-26 20:30:26Z

4

Here's one approach.

Use list comprehensions instead of loops.

In [160]: data = [x.split('') for x in a]

In [161]: data
Out[161]: [['date', 'name'], ['10150425010245', 'name1'], ['10150425020245', 'name2']]

Then use data[1:] as values and data[0] as column names.

In [162]: pd.DataFrame(data[1:], columns=data[0])
Out[162]:
             date   name
0  10150425010245  name1
1  10150425020245  name2

edited Apr 26, 2015 at 20:30

MattDMo

103k21 gold badges251 silver badges239 bronze badges

answered Apr 26, 2015 at 20:15

Zero

77.4k22 gold badges153 silver badges153 bronze badges

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

1 Comment

Anastasia Over a year ago

Thanks! This works. It should be x.split(' '), but other than that it works.

Amrita Sawant · Accepted Answer · 2015-04-27 04:39:45Z

4

you were on the right track. With slight modification, your code works fine.

    import pandas as pd
    a=['date name','10150425010245 name1','10150425020245 name2']
    newlist=[]
    for item in a:
        newlist.append(item.split(' '))

    newlist2=pd.DataFrame(newlist,columns=["date","name"])[1:]

    newlist2

    date            name
    10150425010245  name1
    10150425020245  name2

answered Apr 27, 2015 at 4:39

Amrita Sawant

11k4 gold badges25 silver badges26 bronze badges

Comments

fixxxer · Accepted Answer · 2015-04-28 10:30:09Z

1

Tempted to summarise the answers already given in one line:

a=['date name','10150425010245 name1','10150425020245 name2']
pd.DataFrame(
     map(str.split, a)[1:],
     columns=a[0].split(),
)

Output:

Out[8]:
              date  name
0   10150425010245  name1
1   10150425020245  name2

edited Apr 28, 2015 at 10:30

answered Apr 27, 2015 at 8:20

fixxxer

16.2k15 gold badges64 silver badges78 bronze badges

2 Comments

Zero Over a year ago

Not quite. Two issues here. 1) Output will have column names repeated there, rather it should be pd.DataFrame( map(str.split, a)[1:],columns=['date', 'name']) 2) Column names should rather taken from list than manually passing it.

fixxxer Over a year ago

The index starting at 1 was a bother. Updated it with your comments.

Collectives™ on Stack Overflow

Python list to pandas dataframe

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related