Python: list of lists and string to dataframe

Question

I have a list with the following format:

data = [
    ['string1', [a, b, c]],
    ['string2', [d, e, f]],
    ['string3', [g, h, i]],
    ['string4', [j, k, l]],
]

and I would like to transform it into a data frame like so, with the strings as column names and the lists as column content:

string1     string2     string3     string4
a           d           g           j
b           e           h           k
c           f           i           l

How can I achieve that?

jezrael · Accepted Answer · 2021-10-06 12:29:44Z

2

Convert values to dictionary and then to DataFrame constructor:

df = pd.DataFrame(dict(data))
print (df)
  string1 string2 string3 string4
0       a       d       g       j
1       b       e       h       k
2       c       f       i       l

edited Oct 6, 2021 at 12:29

answered Oct 6, 2021 at 12:24

jezrael

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

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

Collectives™ on Stack Overflow

Python: list of lists and string to dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related