create dataframe from list of list python

Question

I have list of list(t):

[[{'CreationDate': b"D:20191125142104+05'00'",
   'Creator': b'PDF-XChange Editor 7.0.325.1',
   'ModDate': b"D:20191125142754+05'00'",
   'Producer': b'PDF-XChange Core API SDK (7.0.325.1)'}],
 [{'CreationDate': b"D:20200215153643+05'00'",
   'Creator': b'Adobe Acrobat 11.0.23',
   'ModDate': b"D:20200215191411+05'00'",
   'Producer': b'Adobe Acrobat Pro 11.0.23 Paper Capture Plug-in'}],
 [{'CreationDate': b"D:20200215153532+05'00'",
   'Creator': b'Adobe Acrobat 11.0.23',
   'ModDate': b"D:20200215191426+05'00'",
   'Producer': b'Adobe Acrobat Pro 11.0.23 Paper Capture Plug-in'}]]

I need create a DataFrame, where columns=['CreationDate', 'Creator', 'ModDate', 'Producer']. I try to do next: pd.DataFrame(t, columns=['CreationDate', 'Creator', 'ModDate', 'Producer']) and I get error:

 4 columns passed, passed data had 1 columns

If I do pd.DataFrame(t[0], columns=['CreationDate', 'Creator', 'ModDate', 'Producer']), I get an one-row DataFrame. How to do a good DataFrame? Thanks.

jezrael · Accepted Answer · 2020-11-02 14:38:58Z

1

You can select first lists from nested lists in list comprehension:

df = pd.DataFrame([x[0] for x in t])

Or flatten nested lists, then get all nested lists:

df = pd.DataFrame([y for x in t for y in x])

print (df)
                 CreationDate                          Creator  \
0  b"D:20191125142104+05'00'"  b'PDF-XChange Editor 7.0.325.1'   
1  b"D:20200215153643+05'00'"         b'Adobe Acrobat 11.0.23'   
2  b"D:20200215153532+05'00'"         b'Adobe Acrobat 11.0.23'   

                      ModDate  \
0  b"D:20191125142754+05'00'"   
1  b"D:20200215191411+05'00'"   
2  b"D:20200215191426+05'00'"   

                                            Producer  
0            b'PDF-XChange Core API SDK (7.0.325.1)'  
1  b'Adobe Acrobat Pro 11.0.23 Paper Capture Plug...  
2  b'Adobe Acrobat Pro 11.0.23 Paper Capture Plug...

answered Nov 2, 2020 at 14:38

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Comment

MarryTorichelli Over a year ago

Thanks! It's really helps me!

Mehdi Golzadeh · Accepted Answer · 2020-11-02 15:05:38Z

1

Use concat and from_dict:

df=pd.concat([pd.DataFrame().from_dict(x) for x in ls])

answered Nov 2, 2020 at 15:05

Mehdi Golzadeh

2,5931 gold badge18 silver badges28 bronze badges

Collectives™ on Stack Overflow

create dataframe from list of list 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