python pandas dataframe columns convert to dict key and value
If lakes
is your DataFrame
, you can do something like
area_dict = dict(zip(lakes.area, lakes.count))
With pandas it can be done as:
If lakes is your DataFrame:
area_dict = lakes.to_dict('records')
You can also do this if you want to play around with pandas. However, I like punchagan's way.
# replicating your dataframelake = pd.DataFrame({'co tp': ['DE Lake', 'Forest', 'FR Lake', 'Forest'], 'area': [10, 20, 30, 40], 'count': [7, 5, 2, 3]})lake.set_index('co tp', inplace=True)# to get key value using pandasarea_dict = lake.set_index('area').T.to_dict('records')[0]print(area_dict)output: {10: 7, 20: 5, 30: 2, 40: 3}