Check if string column last characters are numbers in Pandas

Question

I have this dataframe:

   Code               Mark
0  Abd 43212312312   
1  Charles de Gaulle
2  Carlitos 4132411  
3  Antonio

If the last 5 characters of the string in the Code column are numbers, I want that 'Mark' is 'A', so it will look like this:

   Code               Mark
0  Abd 43212312312    A
1  Charles de Gaulle
2  Carlitos 4132411   A
3  Antonio

I'm trying to use isnumeric but I'm constantly getting AttributeError: 'Series' object has no attribute 'isnumeric'

Can someone help on that?

Answer 1

You are close. The trick is to use the .str accessor via pd.Series.str.isnumeric.

Then map to 'A' or an empty string via pd.Series.map:

df['Mark'] = df['Code'].str[-5:]\
                       .str.isnumeric()\
                       .map({True: 'A', False: ''})

print(df)

              Code Mark
0   Abd43212312312    A
1  CharlesdeGaulle     
2  Carlitos4132411    A
3          Antonio