python 3.x - How do you fill uneven pandas dataframe column with first value in column

Question

import pandas as pd

dict = {'Name' : ['John'], 'Last Name': ['Smith'], 'Activity':['Run', 'Jump', 'Hide', 'Swim', 'Eat', 'Sleep']}

df = pd.DataFrame(dict)

How do I make it so 'John' & 'Smith' are populated in each 'Activity' that he does in a dataframe?

question from:https://stackoverflow.com/questions/65904655/how-do-you-fill-uneven-pandas-dataframe-column-with-first-value-in-column

Answer 1

Let us try json_normalize

out = pd.json_normalize(d,'Activity',['Name','Last Name'])
Out[160]: 
       0  Name Last Name
0    Run  John     Smith
1   Jump  John     Smith
2   Hide  John     Smith
3   Swim  John     Smith
4    Eat  John     Smith
5  Sleep  John     Smith

Input

d = {'Name' : ['John'], 'Last Name': ['Smith'], 'Activity':['Run', 'Jump', 'Hide', 'Swim', 'Eat', 'Sleep']}