python pandas dataframe columns convert to dict key and value

Question

From a Python pandas dataframe with multi-columns, I would like to construct a dict from only two columns. One as dict's keys and another as 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

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

Answer 1

You can do like this if lakes is your DataFrame,

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

If you wish to learn more about Python, visit the Python tutorial and Python Certification course by Intellipaat.