Converting python list of delimited items in to a pandas data frame

Question

I have the list like this where items are separated by ":".

   x=['john:42:engineer',

      'michael:29:doctor']

Is there a way to change the data frame like below by using columns Name, Age, and Occupation?

    Name    Age Occupation

0   john    42  engineer

1   michael 29  doctor

Answer 1

You can use the below code:

df = pd.Series(x).str.split(':',expand=True)

df.columns = ['Name','Age', 'Occupation']

df

Out[172]: 

      Name Age Occupation

0     john  42   engineer

1  michael  29     doctor

If you are a beginner and want to know more about Python the do check out the Data Science with Python Course