dataframe to dict such that one column is the key and the other is the value [duplicate]

by

Something like this:

In [27]: df
Out[27]: 
  ID  A  B  C
0  p  1  3  2
1  q  4  3  2
2  r  4  0  9

In [30]: df.set_index('ID',inplace=True)
In [31]: df
Out[31]: 
    A  B  C
ID         
p   1  3  2
q   4  3  2
r   4  0  9

In [33]: df.to_dict()['B']
Out[33]: {'p': 3, 'q': 3, 'r': 0}

More Related Contents:

  1. Convert list of dictionaries to a pandas DataFrame
  2. Convert a Pandas DataFrame to a dictionary
  3. How to convert a dataframe to a dictionary
  4. Pandas DataFrame to List of Dictionaries
  5. Nested dictionary to multiindex dataframe where dictionary keys are column labels
  6. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  7. How to create a dictionary of two pandas DataFrame columns
  8. How to convert a dataframe to a dictionary
  9. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  10. Why does the following code cant get value of n_fold = 1?
  11. How to change the order of DataFrame columns?
  12. Add missing dates to pandas dataframe
  13. Pandas: sum DataFrame rows for given columns
  14. Pandas DataFrame: replace all values in a column, based on condition
  15. Calculate average of every x rows in a table and create new table
  16. How to check if any value is NaN in a Pandas DataFrame
  17. Removing prefix from column names in Pandas
  18. Python Pandas replicate rows in dataframe
  19. Can’t drop NAN with dropna in pandas
  20. How to merge multiple dataframes
  21. Extract int from string in Pandas
  22. Cumsum as a new column in an existing Pandas dataframe
  23. Plot a bar plot from a Pandas DataFrame
  24. Using replace efficiently in pandas
  25. Sorting by absolute value without changing the data
  26. Returning multiple values from pandas apply on a DataFrame
  27. Read data (.dat file) with Pandas
  28. Calculate summary statistics of columns in dataframe
  29. Pandas: Join dataframe with condition
  30. UnicodeDecodeError when reading CSV file in Pandas

Leave a Comment