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 Select the correct answer from above options

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 python for data science course