python: write a dictionary into a pandas.DataFrame row

Question

I am looking for a one-liner solution to write a dictionary into a pandas DataFrame row. The other way round works quite intuively with an expression like df.loc[2, :].to_dict(dct).

Illustration

I am looking for a shot expression to replace the for key in dct.keys()-loop in the following code:

>>> import numpy as np
>>> import pandas as pd
>>> df = pd.DataFrame(np.arange(12).reshape(3,4), columns=list('abcd'))
>>> dct = {'a': 77, 'c':-1}
>>> 
>>> df
   a  b   c   d
0  0  1   2   3
1  4  5   6   7
2  8  9  10  11
>>> dct
{'a': 77, 'c': -1}
>>> 
>>> for key in dct.keys():
...     df.loc[1, key] = dct[key]
... 
>>> 
>>> df
    a  b   c   d
0   0  1   2   3
1  77  5  -1   7
2   8  9  10  11

Shubham Sharma · Accepted Answer · 2020-07-01 06:34:57Z

7

You can use:

df.loc[1, dct.keys()] = dct.values()

Result:

print(df)
    a  b   c   d
0   0  1   2   3
1  77  5  -1   7
2   8  9  10  11

answered Jul 1, 2020 at 6:34

Shubham Sharma

71.8k6 gold badges26 silver badges58 bronze badges

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

1 Comment

Markus Dutschke Over a year ago

beautiful ... this is exactly what I was looking for

jezrael · Accepted Answer · 2020-07-01 06:36:55Z

3

One idea with DataFrame.update:

df.update(pd.DataFrame(dct, index=[1]))

print (df)
      a  b     c   d
0   0.0  1   2.0   3
1  77.0  5  -1.0   7
2   8.0  9  10.0  11

edited Jul 1, 2020 at 6:36

answered Jul 1, 2020 at 6:33

jezrael

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

1 Comment

Ch3steR Over a year ago

Had the same idea!

Markus Dutschke · Accepted Answer · 2021-11-23 13:47:40Z

1

if your columns dtype is object

the accepted answer fails, if df.dtype is object. You need an additional cast to list on the right handside of the df.loc[1, dct.keys()] = dct.values() assignment.

df.update(pd.DataFrame(dct, index=[1])) works for this case.

>>> import pandas as pd
>>> df = pd.DataFrame([['A', 'B', 'C'], ['D', 'E', 'F']], columns=list('abc'))
>>> df.dtypes
a    object
b    object
c    object
dtype: object
>>> df
   a  b  c
0  A  B  C
1  D  E  F
>>> dct = {'a': 'x', 'c': 'y'}
>>> df.loc[1, dct.keys()] = dct.values()
>>> df
        a  b       c
0       A  B       C
1  (x, y)  E  (x, y)
>>> df.loc[1, dct.keys()] = list(dct.values())
>>> df
   a  b  c
0  A  B  C
1  x  E  y

answered Nov 23, 2021 at 13:47

Markus Dutschke

10.8k5 gold badges73 silver badges67 bronze badges

Collectives™ on Stack Overflow

python: write a dictionary into a pandas.DataFrame row

3 Answers 3

1 Comment

1 Comment

if your columns dtype is object

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

if your columns dtype is object

Comments

Your Answer

Sign up or log in

Post as a guest

Related