json_normalize_and_concat

json_normalize_and_concat.py

import pandas as pd

def json_normalize_and_concat(df: pd.DataFrame, col: str) -> pd.DataFrame:
    index_name = df.reset_index().columns[0]
    
    df_json_norm = pd.json_normalize(df[col], max_level=0).reset_index(drop=True)
    df_ret = pd.concat([
        df.reset_index().drop([c for c in df_json_norm.columns if c in df.columns], axis=1),
        df_json_norm
    ], axis=1).set_index(index_name).drop(col, axis=1)
    
    return df_ret