When working with a Pandas dataframe ... values, you can use Python’s replace method and provide a list. Extracting a substring within Excel requires the usage of the LEFT, MID, or RIGHT ...