python - json_normalize "activity" column in dataframe made whit "historical locations" from google

Question

I'm trying to use json_normalize in a column containing my activity imformation, download from Google takeout.

This is the dataframe:

this is the code i found to do what i need:

import numpy as np
import pandas as pd
from ast import literal_eval



# fillna
data['activity'] = data['activity'].fillna('[]')

# literal_eval
data['activity'] = data['activity'].apply(literal_eval)

# explode
data = data.explode('activity').reset_index(drop=True)

# fillna again
data['activity'] = data['activity'].fillna({i: {} for i in data.index})

# use json_normalize
data = data.join(data.json_normalize(data.activity), meta=['type', 'confidence']).drop(columns=['activity'])

This error comes out:

I would be very grateful if someone can help me!

Answer 1

等待大神解答