convert 2 columns to dictionary pandas

Comment

2

dict(zip(df.a,df.b))

Popularity 8/10 Helpfulness 9/10 Language python

Source: Grepper

Tags: dictionary pandas python

Share

Link to this answer
Share Copy Link

Contributed on Oct 25 2022

Tired Toad

0 Answers Avg Quality 2/10

dictionary from two columns pandas

Comment

11

pd.Series(df.A.values,index=df.B).to_dict()

Popularity 10/10 Helpfulness 9/10 Language python

Source: stackoverflow.com

Tags: dictionary d

Share

Link to this answer
Share Copy Link

Contributed on Sep 25 2020

Blushing Booby

0 Answers Avg Quality 2/10

python how to create dict from dataframe based on 2 columns

Comment

1

In [9]: pd.Series(df.Letter.values,index=df.Position).to_dict()
Out[9]: {1: 'a', 2: 'b', 3: 'c', 4: 'd', 5: 'e'}

Popularity 9/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: dataframe data

Share

Link to this answer
Share Copy Link

Contributed on Jan 15 2021

Witty Whale

0 Answers Avg Quality 2/10

create dict from two columns pandas

Comment

2

In [6]: df = pd.DataFrame(randint(0,10,10000).reshape(5000,2),columns=list('AB'))

In [7]: %timeit dict(zip(df.A,df.B))
1000 loops, best of 3: 1.27 ms per loop

In [8]: %timeit pd.Series(df.A.values,index=df.B).to_dict()
1000 loops, best of 3: 987 us per loop

Popularity 10/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: pandas pa

Share

Link to this answer
Share Copy Link

Contributed on Sep 08 2020

Busy Boar

0 Answers Avg Quality 2/10

dict column to be in multiple columns python

Comment

1

In [2]: df = pd.DataFrame({'a':[1,2,3], 'b':[{'c':1}, {'d':3}, {'c':5, 'd':6}]})

In [3]: df
Out[3]:
   a                   b
0  1           {u'c': 1}
1  2           {u'd': 3}
2  3  {u'c': 5, u'd': 6}

In [4]: df['b'].apply(pd.Series)
Out[4]:
     c    d
0  1.0  NaN
1  NaN  3.0
2  5.0  6.0

Popularity 9/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: multiple-columns mult

Share

Link to this answer
Share Copy Link

Contributed on Jun 20 2020

Magnificent Mongoose

0 Answers Avg Quality 2/10

convert 2 columns to dictionary pandas

Contents

More Related Answers