/Python/Create dict from two columns pandas

Create dict from two columns pandas

Dictionary from two columns pandas

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

Source: stackoverflow.com

Create dict from two columns pandas

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

Source: stackoverflow.com

Python how to create dict from dataframe based on 2 columns

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

Source: stackoverflow.com

Pandas create dataframe from multiple dictionaries

sales = [{'account': 'Jones LLC', 'Jan': 150, 'Feb': 200, 'Mar': 140},
         {'account': 'Alpha Co',  'Jan': 200, 'Feb': 210, 'Mar': 215},
         {'account': 'Blue Inc',  'Jan': 50,  'Feb': 90,  'Mar': 95 }]
df = pd.DataFrame(sales)

Source: pbpython.com

Similar codes

1 vote187 views1 answer
Managin media django
Python Django
0 vote303 views2 answers
Funcion que reciba una cadena en python
Python
0 vote144 views1 answer
Query json array
Python
6 votes160 views6 answers
How to check if a value is nan in python
Python
2 votes153 views1 answer
Python how to write pandas dataframe as tsv file
Python
11 votes152 views6 answers
Drop null rows pandas
Python
13 votes144 views1 answer
Python str contains word
Python
0 vote194 views1 answer
Python logging basicConfig+time
Python
0 vote205 views1 answer
Django admin no such table user
Python Django
17 votes151 views4 answers
Get ip address python
Python