Python Splitting column into 2

[Eclipse]

So I'm working on a deliverable assignment for my bootcamp, I'm trying to split the "name" column into "first_name" and "last_name"

In the image below (in the spoiler tag):
The first cell is the dataframe
The one below it is my code with the error

Spoiler: Image

 

[menator01]

Maybe something like this

import pandas as pd #import pandas
file = 'test.csv' # Name of csv file
path = __file__.split('/') # Get executing file a list
path.pop(len(path)-1) # Pop off the executing file
path = '/'.join(path) # Join the path of executing folder/directory
path = path + f'/{file}' # Add csv file
data = pd.read_csv(path) # Read csv into pandas
fname = [] # Create a list to hold first names
lname = [] # Create a list to hold last names
for name in data['name']: # Loop through dataframe name column
    name = name.split() # split the names
    fname.append(name[0].strip()) # Append first name to fname list
    lname.append(name[1].strip()) # Append last name to lname list
data.rename(columns={'name':'first name'},inplace=True) # Rename the name column to first name
data.insert(3, 'last name', '') # Insert at index 3 new column name (last name)
data['last name'] = lname # Add lname list to last name column
data['first name'] = fname # Add fname list to first name column
print(data) # Print new dataframe

output

  backer_id  cf_id first name last name               email
0     av166    968     Angelo   Vincent   [email protected]
1     ha127    563     Hubert    Arnold  [email protected]
2    ace123    544       John       Doe       [email protected]