Dictionary column in pandas dataframe

by

As per https://stackoverflow.com/a/38231651/454773, you can use .apply(pd.Series) to map the dict containing column onto new columns and then concatenate these new columns back into the original dataframe minus the original dict containing column:

dw=pd.DataFrame( [[20, 30, {"ab":"1", "we":"2", "as":"3"},"String"]],
                columns=['ColA', 'ColB', 'ColC', 'ColdD'])
pd.concat([dw.drop(['ColC'], axis=1), dw['ColC'].apply(pd.Series)], axis=1)

Returns:

ColA    ColB    ColdD   ab  as  we
20      30      String  1   3   2

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. How to convert a dataframe to a dictionary
  14. Nested Dictionary to MultiIndex pandas DataFrame (3 level)
  15. Pandas DataFrame performance
  16. DataFrame with MultiIndex to dict
  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. How to apply a function to two columns of Pandas dataframe
  21. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  22. Load data from txt with pandas
  23. Coloring Cells in Pandas
  24. How to import data from mongodb to pandas?
  25. How to group a pandas dataframe by a defined time interval?
  26. How to sort a Pandas DataFrame by index?
  27. pandas two dataframe cross join [duplicate]
  28. Get first row of dataframe in Python Pandas based on criteria
  29. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  30. Pandas data frame to dictionary of lists

Leave a Comment