How do you extract a substring within column that contains people's Name & title that are in "Myles, Mr. Thomas Francis" format and only want "Mr."

Question

enter image description hereenter image description hereWant to add matched results as new column of dataframe within a python function

I tried using re.search() expression

for i in input_df["Name"]:
   Title[i] = re.search(".$",i)

I get Type_error and not sure how to write pattern to get desired result