Creating a dataframe with lists in python

Question

I would like to create a dataframe from 2 python lists that I have.

Say I have the following 2 lists;

x = [1,2,3]
z = ['a','v','d']

I have initialized a dataframe

data = pd.DataFrame(columns = ['Type', 'Data']

and this is one of the things that I have tried doing.

df = data.append({'Type': x, 'Data' : z}, ignore_index = True)

but it results in the following dataframe

   Type       Data
0 [1, 2, 3]  [a, v, d]

However, this is what I actually want it to look like

   Type    Data
0  1      a
1  2      v
2  3      d

How would I do this? Thank you in advance.

pd.DataFrame({'Type': x, 'Data' : z})?

Chris
– Chris

2019-09-12 10:46:22 +00:00
Commented Sep 12, 2019 at 10:46 — Chris
– Chris, Commented Sep 12, 2019 at 10:46
Possible duplicate of Convert Python dict into a dataframe

Chris
– Chris

2019-09-12 10:46:46 +00:00
Commented Sep 12, 2019 at 10:46 — Chris
– Chris, Commented Sep 12, 2019 at 10:46

Arkistarvh Kltzuonstev · Accepted Answer · 2019-09-12 10:48:01Z

2

Try this :

df =  pd.DataFrame(zip(x,z),columns=['Type', 'Data'])
print(df)

Output :

   Type Data
0     1    a
1     2    v
2     3    d

answered Sep 12, 2019 at 10:48

Arkistarvh Kltzuonstev

6,9837 gold badges32 silver badges62 bronze badges

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

Comments

jezrael · Accepted Answer · 2019-09-12 10:46:46Z

1

Convert dictionary to DataFrame:

data = pd.DataFrame(columns = ['Type', 'Data'])
df = data.append(pd.DataFrame({'Type': x, 'Data' : z}), ignore_index = True)
print (df)
  Type Data
0    1    a
1    2    v
2    3    d

answered Sep 12, 2019 at 10:46

jezrael

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

2 Comments

Susan-l3p Over a year ago

Thank you this is what I wanted. But now I'm just not sure how I would append to this dataframe. Say I want to add r = [5,6,7] to Type and w = [r,t,w] to Data in the same way. How would I do this?

jezrael Over a year ago

@Susan-l3p - You can again call df = data.append(pd.DataFrame({'Type': x, 'Data' : z}), ignore_index = True)

Allen Qin · Accepted Answer · 2019-09-12 11:28:39Z

0

You can use assign:

data.assign(Type=x, Data=z)

  Type  Data
0   1   a
1   2   v
2   3   d

answered Sep 12, 2019 at 11:28

Allen Qin

20k9 gold badges55 silver badges68 bronze badges

Collectives™ on Stack Overflow

Creating a dataframe with lists in python

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related