Python Split Different List

Question

I have a list that I am trying to split into a pandas data frame. I can split simple lists by comma, but there are commas in the values that I need to split. Here is the way my list is setup:

[{'Name':'Smith, John','Date of Birth':datetime.datetime(2016, 5, 10, 0, 0),'Email Address':'[email protected]'},
 {'Name':'Smith, Jane','Date of Birth':datetime.datetime(2010, 6, 5, 0, 0),'Email Address':'[email protected]'},
 {'Name':'Doe, Monica','Date of Birth':datetime.datetime(2012, 10, 3, 0, 0),'Email Address':'[email protected]'}]

I have tried various ways to split the data, but it always comes out odd. The expected result should have been:

    Name           Date of Birth        Email Address
0   Smith, John    05-10-2016           [email protected]
1   Smith, Jane    06-05-2010           [email protected]
2   Doe, Monica    10-03-2012           [email protected]

but I keep getting things like below where the title is still in the column.

'Name':'Smith, John'

Any help would be greatly appreciated

You should show your code, its not clear how you're getting things like that given you're passing in a list of dictionaries — Sayse
– Sayse, Commented Nov 19, 2019 at 15:17

Zachary Cross · Accepted Answer · 2019-11-19 15:22:50Z

2

Does passing the list into pandas.DataFrame() not work?

import pandas
import datetime

l = [{'Name':'Smith, John','Date of Birth':datetime.datetime(2016, 5, 10, 0, 0),'Email Address':'[email protected]'},
     {'Name':'Smith, Jane','Date of Birth':datetime.datetime(2010, 6, 5, 0, 0),'Email Address':'[email protected]'},
     {'Name':'Doe, Monica','Date of Birth':datetime.datetime(2012, 10, 3, 0, 0),'Email Address':'[email protected]'}]

df  = pandas.DataFrame(l)
print(df)

gives me:

  Date of Birth   Email Address         Name
0    2016-05-10   [email protected]  Smith, John
1    2010-06-05  [email protected]  Smith, Jane
2    2012-10-03     [email protected]  Doe, Monica

answered Nov 19, 2019 at 15:22

Zachary Cross

2,3281 gold badge17 silver badges23 bronze badges

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

1 Comment

NLMDEJ Over a year ago

It seems as if it is the simple solution that makes the most sense. I was trying to loop through the list and splitting them, and them appending them to a DataFrame. This is much easier. Thanks!

rrrttt · Accepted Answer · 2019-11-19 15:22:50Z

2

import pandas as pd
import datetime

data = [{'Name':'Smith, John','Date of Birth':datetime.datetime(2016, 5, 10, 0,      0),'Email Address':'[email protected]'},
{'Name':'Smith, Jane','Date of Birth':datetime.datetime(2010, 6, 5, 0, 0),'Email Address':'[email protected]'},
{'Name':'Doe, Monica','Date of Birth':datetime.datetime(2012, 10, 3, 0, 0),'Email Address':'[email protected]'}]

df = pd.DataFrame(data=data)

The output of df will be:

 Date of Birth   Email Address         Name
0    2016-05-10   [email protected]  Smith, John
1    2010-06-05  [email protected]  Smith, Jane
2    2012-10-03     [email protected]  Doe, Monica

answered Nov 19, 2019 at 15:22

rrrttt

4693 silver badges12 bronze badges

Comments

Green Cloak Guy · Accepted Answer · 2019-11-19 15:22:53Z

You can actually just pass that into a pandas.DataFrame() call and it'll work more-or-less as you want (but with the indentation/justification changed up slightly):

>>> import pandas as pd
>>> my_list = [{'Name':'Smith, John','Date of Birth':datetime.datetime(2016, 5, 10, 0, 0),'Email Address':'[email protected]'},
...  {'Name':'Smith, Jane','Date of Birth':datetime.datetime(2010, 6, 5, 0, 0),'Email Address':'[email protected]'},
...  {'Name':'Doe, Monica','Date of Birth':datetime.datetime(2012, 10, 3, 0, 0),'Email Address':'[email protected]'}]
>>> x = pd.DataFrame(my_list)
>>> print(x)
          Name Date of Birth   Email Address
0  Smith, John    2016-05-10   [email protected]
1  Smith, Jane    2010-06-05  [email protected]
2  Doe, Monica    2012-10-03     [email protected]

Collectives™ on Stack Overflow

Python Split Different List

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related