Reading a CSV into pandas where one column is a json string,df.join(df['stats'].apply(json.loads).apply(pd.Series))