DataFrame with MultiIndex to dict

by

For converting whole dataframe to dictionary Try:

df.groupby(level=0).apply(lambda df: df.xs(df.name).to_dict()).to_dict()

{'bar': {'01.01': {'total1': 40, 'total2': 36},
  '02.01': {'total1': 52, 'total2': 85},
  '03.01': {'total1': 18, 'total2': 5},
  '04.01': {'total1': 11, 'total2': 92}},
 'baz': {'01.01': {'total1': 23, 'total2': 50},
  '02.01': {'total1': 39, 'total2': 49},
  '03.01': {'total1': 45, 'total2': 51},
  '04.01': {'total1': 70, 'total2': 65}},
 'foo': {'01.01': {'total1': 23, 'total2': 64},
  '02.01': {'total1': 97, 'total2': 56},
  '03.01': {'total1': 17, 'total2': 94},
  '04.01': {'total1': 97, 'total2': 45}},
 'qux': {'01.01': {'total1': 13, 'total2': 80},
  '02.01': {'total1': 73, 'total2': 8},
  '03.01': {'total1': 38, 'total2': 61},
  '04.01': {'total1': 4, 'total2': 50}}}

For converting one particular column, select before converting it to dictionary i.e 

df.groupby(level=0).apply(lambda df: df.xs(df.name)[colname].to_dict()).to_dict()

More Related Contents:

  1. Remap values in pandas column with a dict, preserve NaNs
  2. Split / Explode a column of dictionaries into separate columns with pandas
  3. Convert list of dictionaries to a pandas DataFrame
  4. Convert a Pandas DataFrame to a dictionary
  5. Replace values in a pandas series via dictionary efficiently
  6. How to convert a dataframe to a dictionary
  7. Pandas DataFrame to List of Dictionaries
  8. Nested dictionary to multiindex dataframe where dictionary keys are column labels
  9. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  10. How to create a dictionary of two pandas DataFrame columns
  11. Unpack dictionary from Pandas Column
  12. How to json_normalize a column with NaNs
  13. Dictionary column in pandas dataframe
  14. How to convert a dataframe to a dictionary
  15. Nested Dictionary to MultiIndex pandas DataFrame (3 level)
  16. Pandas DataFrame performance
  17. dataframe to dict such that one column is the key and the other is the value [duplicate]
  18. Rename columns in Pandas based on a dictionary
  19. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  20. Filter pandas DataFrame by substring criteria
  21. Pandas Extract Number from String
  22. How to flatten a pandas dataframe with some columns as json?
  23. pandas groupby to nested json
  24. Pandas won’t fillna() inplace
  25. How to estimate how much memory a Pandas’ DataFrame will need?
  26. FastAPI is very slow in returning a large amount of JSON data
  27. How can I get a random key-value pair from a dictionary?
  28. Disabling sorting mechanism in pprint output
  29. Pandas: Create missing combination rows with zero values
  30. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it

Leave a Comment