Using np.where() with Pandas to Insert Values into a New Column Based on Conditions

Understanding How Wildcards Work in MySQL's REGEXP_REPLACE Function

Understanding and Extracting Substrings from Strings in Pandas DataFrames with Python