pandas apply function to column to create multiple new columns

See: https://stackoverflow.com/questions/16236684/apply-pandas-function-to-column-to-create-multiple-new-columns

You have

Listing 1: original

import pandas as pd

df = pd.DataFrame({"val": ["a,b,c"]})

print(df)

Result

     val
0  a,b,c

You want

Listing 2: expected

df = pd.DataFrame({"first": ["a"], "second": ["b"], "c": ["c"]})
print(df)

Result

  first second  c
0     a      b  c

Solution

Listing 3: solution

df = pd.DataFrame({"val": ["a,b,c"]})
res = df.apply(lambda row: row["val"].split(","), axis=1, result_type="expand")
print(res)

Result

   0  1  2
0  a  b  c