python pandas dataframe columns convert to dict key and value

python pandas dataframe dictionary data-conversion
perigee picture perigee · Aug 2, 2013 · Viewed 119k times · Source

I have a pandas data frame with multiple columns and I would like to construct a dict from two columns: one as the dict's keys and the other as the dict's values. How can I do that?

Dataframe:

           area  count
co tp
DE Lake      10      7
Forest       20      5
FR Lake      30      2
Forest       40      3

I need to define area as key, count as value in dict. Thank you in advance.

Answer

punchagan picture punchagan · Aug 2, 2013

If lakes is your DataFrame, you can do something like

area_dict = dict(zip(lakes.area, lakes.count))

Related questions

Convert list of dictionaries to a pandas DataFrame

I have a list of dictionaries like this: [{'points': 50, 'time': '5:00', 'year': 2010}, {'points': 25, 'time': '6:00', 'month': "february"}, {'points':90, 'time': '9:00', 'month': 'january'}, {'points_h1':20, 'month': 'june'}] And I want to turn this into a pandas DataFrame …

Read More
Convert a Pandas DataFrame to a dictionary

I have a DataFrame with four columns. I want to convert this DataFrame to a python dictionary. I want the elements of first column be keys and the elements of other columns in same row be values. DataFrame: ID A …

Read More
What is the most efficient way to create a dictionary of two pandas Dataframe columns?

What is the most efficient way to organise the following pandas Dataframe: data = Position Letter 1 a 2 b 3 c 4 d 5 e into a dictionary like alphabet[1 : 'a', 2 : 'b', 3 : 'c', 4 : 'd', 5 : 'e']?

Read More