Split / Explode a column of dictionaries into separate columns with pandas

I know the question is quite old, but I got here searching for answers. There is actually a better (and faster) way now of doing this using json_normalize:

import pandas as pd

df2 = pd.json_normalize(df['Pollutant Levels'])

This avoids costly apply functions…

Related Contents:

  1. How to json_normalize a column with NaNs
  2. flattening nested Json in pandas data frame
  3. Remap values in pandas column with a dict, preserve NaNs
  4. Convert list of dictionaries to a pandas DataFrame
  5. How can I convert JSON to CSV?
  6. JSON to pandas DataFrame
  7. Convert a Pandas DataFrame to a dictionary
  8. Replace values in a pandas series via dictionary efficiently
  9. Efficient way to unnest (explode) multiple list columns in a pandas DataFrame
  10. How to extract multiple JSON objects from one file?
  11. Converting dictionary to JSON
  12. Access a particular field in arbitrarily nested JSON data [duplicate]
  13. How to convert a dataframe to a dictionary
  14. Convert Pandas Dataframe to nested JSON
  15. Pandas DataFrame to List of Dictionaries
  16. How to convert an XML string to a dictionary?
  17. Pandas read nested json
  18. Storing Python dictionaries
  19. How to dump a dict to a JSON file?
  20. Python – How to convert JSON File to Dataframe
  21. How to flatten a pandas dataframe with some columns as json?
  22. How can I access the nested data in this complex JSON, which includes another JSON document as one of the strings?
  23. How to flatten a nested JSON recursively, with flatten_json
  24. Nested dictionary to multiindex dataframe where dictionary keys are column labels
  25. String to Dictionary in Python [duplicate]
  26. Convert numpy type to python
  27. How to normalize json correctly by Python Pandas
  28. Convert a python dict to a string and back
  29. Pandas groupby.size vs series.value_counts vs collections.Counter with multiple series
  30. How to flatten multilevel/nested JSON?
  31. pandas.io.json.json_normalize with very nested json
  32. FastAPI is very slow in returning a large amount of JSON data
  33. pandas groupby to nested json
  34. How to create a dictionary of two pandas DataFrame columns
  35. JSON object must be str, bytes or bytearray, not dict
  36. pandas read_json: “If using all scalar values, you must pass an index”
  37. Unpack dictionary from Pandas Column
  38. How to convert a dataframe to a dictionary
  39. How to completely traverse a complex dictionary of unknown depth?
  40. Python: Read several json files from a folder
  41. Nested Dictionary to MultiIndex pandas DataFrame (3 level)
  42. Pandas DataFrame performance
  43. Reading multiple JSON records into a Pandas dataframe
  44. Pretty print JSON dumps
  45. Creating a dictionary from a csv file?
  46. How do I merge a list of dicts into a single dict?
  47. How to overcome TypeError: unhashable type: ‘list’
  48. Pandas every nth row
  49. How to recursively find specific key in nested JSON?
  50. How can I create the minimum size executable with pyinstaller?

Leave a Comment