Preserve full surname, get initials of first name (and middle name if some) in pandas column

Question

I have the pandas Dataframe with the column expressing this surname and name of several tennis players like this:

   | Player              | 

   |---------------------|

0  | 'Roddick Andy'      |

1  | 'Federer Roger'     |

2  | 'Tsonga Jo Wilfred  |

I want to have the full surname also get that initial of that name and middle name if there is. So panda's column should look like this:

   | Player            | 

   |-------------------|

0  | 'Roddick A.'      |

1  | 'Federer R.'      |

2  | 'Tsonga J.W.'     | N.B. J.W. with no space

Does anyone have any suggestions? 

Answer 1

Here is an approach with the str.extractall and groupby:

(df.Player

  .str.extractall('(?P<Surname>\w*)\s(?P<Name>\w*)')

  .groupby(level=0)

  .agg({'Surname':'first',

        'Name': lambda x: x.str[0].add('.').sum()

        })

  .agg(' '.join, axis=1)

)

Output:

0     Roddick A.

1     Federer R.

2    Tsonga J.W.

dtype: object

Learn Python for Data Science Course to improve your technical knowledge.