Let's unpack the works column into a standalone dataframe. We'll also grab the flat columns so we can do analysis. The parameters here are a bit unorthodox, see ...
pandas-json-column-expand
I know I can use read_json to create data frames from the json field, but then I want to re-flatten these data frames into extra columns of the original data set. So, is .... importing pandas module import pandas as pd # new data frame with split value columns data["Team"]= data["Team"].str.split(" ", n = 1, expand = True) # df ... 3925e8d270
pandas json column expand