Remove leading and trailing "M" characters from the Title column:
>>> view=catalog.get_view("GROCERYCUSTOMER")>>> view["TitleStrip"]=view["Title"].str.strip("M")>>> view.preview(5).filter(regex="Title") Title TitleStrip0 Ms. s.1 Ms. s.2 Mr. r.3 Mrs. rs.4 Mr. r.