Delete the second character of a string in DataFrame

advertisements

I have a DataFrame with a column of names that include the middle initial. I need to remove the middle initial which is the second character in the string.

df = pd.DataFrame({'alpha': ['1', '2', '3'],
                   'beta': ['JRLeparoux', 'BJHernandez,Jr.','SXBridgmohan'],})

Here is what I tried:

def fixbadname(word):
    filelist2= []
    filelist = []
    for elem in word:
        filelist.append(elem)
         for file in filelist:
            file = file.replace(file[1],"")
            filelist2.append(file)

    return filelist2

df['beta'].apply(fixbadname)

This is the desired output:

df = pd.DataFrame({'alpha': ['1', '2', '3'],
                   'beta': ['JLeparoux', 'BHernandez,Jr.','SBridgmohan'],})


df.beta = df.beta.str[0:1] + df.beta.str[2:];
That should work.
If you want some explanations; ask me.