Python Pandas Dataframe to Dictionary (Column Values to Keys/Values)

Question

I have a dataframe

+---+------------+-----------+
|   | wavelength | intensity |
+---+------------+-----------+
| 1 |        400 |        12 |
| 2 |        401 |        20 |
| 3 |        402 |        25 |
+---+------------+-----------+

and want to convert it to a dictionary

{400:12,
 401:20,
 402:25}

None of the orient parameters for the pandas.DataFrame.to_dict function gives me this output. How do I best get the desired output?

steboc · Accepted Answer · 2019-12-18 09:43:32Z

1

dict(zip(df['wavelength'],df['intensity']))

answered Dec 18, 2019 at 9:43

steboc

1,1811 gold badge7 silver badges18 bronze badges

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

Comments

jezrael · Accepted Answer · 2019-12-18 09:43:23Z

1

Create Series with index by wavelength column and then use Series.to_dict:

d = df.set_index('wavelength')['intensity'].to_dict()

answered Dec 18, 2019 at 9:43

jezrael

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

Collectives™ on Stack Overflow

Python Pandas Dataframe to Dictionary (Column Values to Keys/Values)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related