title: Unable to rename/replace categories in a dataframe after removing unicode u
body: <p>I am trying to rename the categories in a dataframe after removing the unicode u with a .replace('u','',regex) method due to the method removing the other 'u's in the text as well. I have tried using the replace, and the rename_categories method to change the categories into desired format using a dictionary to map but it remains unchanged after removing the unicode u. Does anyone know a better way I can approach this? I have attached a link to the CSV I am working with.</p>
  <p><img src="https://i.stack.imgur.com/5rXiu.png" alt="enter image description here" /></p>
  <pre><code>'''uploaded = files.upload()
  yelpdf = pd.read_csv(io.BytesIO(uploaded['yelp_reviews.csv']))
  print(yelpdf['NoiseLevel'].value_counts())
  yelpdf['NoiseLevel'] = yelpdf['NoiseLevel'].astype(str)
  update_NoiseLevel = {'average': 'Average', 'lod': 'Loud', 'qiet': 'Quiet', 'very_lod': 'Very Loud'}
  yelpdf['NoiseLevel'] = yelpdf['NoiseLevel'].replace('u','',regex=True)
  yelpdf['NoiseLevel'] = yelpdf['NoiseLevel'].astype('category')
  yelpdf['NoiseLevel'] = yelpdf['NoiseLevel'].cat.rename_categories(update_NoiseLevel)
  yelpdf['NoiseLevel'] = yelpdf['NoiseLevel'].replace(update_NoiseLevel)
  
  print(yelpdf['NoiseLevel'].value_counts())'''
  </code></pre>
  <p><a href="https://docs.google.com/spreadsheets/d/1moDKoXVtq84QKT2HTNypeu_H8MB4_X9nG-ncw6IMZek/edit?usp=sharing" rel="nofollow noreferrer">its a CSV file with yelp data and this issue is occurring within the NoiseLevel column</a></p>