Parsing a JSON string which was loaded from a CSV using Pandas

by

I think applying the json.load is a good idea, but from there you can simply directly convert it to dataframe columns instead of writing/loading it again:

stdf = df['stats'].apply(json.loads)
pd.DataFrame(stdf.tolist()) # or stdf.apply(pd.Series)

or alternatively in one step:

df.join(df['stats'].apply(json.loads).apply(pd.Series))

More Related Contents:

  1. Tuples conversion into JSON with python [closed]
  2. is it possible to do fuzzy match merge with python pandas?
  3. Convert a Pandas DataFrame to a dictionary
  4. Pandas read_csv from url
  5. How to write DataFrame to postgres table
  6. Appending pandas dataframes generated in a for loop
  7. Pandas column access w/column names containing spaces
  8. Coloring Cells in Pandas
  9. Pandas finding local max and min
  10. How to import a text file on AWS S3 into pandas without writing to disk
  11. Python, Pandas : write content of DataFrame into text File
  12. extracting days from a numpy.timedelta64 value
  13. custom matplotlib plot : chess board like table with colored cells
  14. Adding calculated column(s) to a dataframe in pandas
  15. How do you plot a vertical line on a time series plot in Pandas?
  16. why does pandas rolling use single dimension ndarray
  17. Divide multiple columns by another column in pandas
  18. pandas two dataframe cross join [duplicate]
  19. Bin pandas dataframe by every X rows
  20. pandas apply function that returns multiple values to rows in pandas dataframe
  21. return max value from pandas dataframe as a whole, not based on column or rows
  22. Improve Pandas Merge performance
  23. pandas fillna not working
  24. How to select rows with NaN in particular column?
  25. datetime x-axis matplotlib labels causing uncontrolled overlap
  26. How to remove rows in a Pandas dataframe if the same row exists in another dataframe?
  27. Pandas: Nesting Dataframes
  28. Python Pandas – Lookup a variable column depending on another column’s value
  29. How do I convert timestamp to datetime.date in pandas dataframe?
  30. Fastest way to parse large CSV files in Pandas

Leave a Comment