Using regex matched groups in pandas dataframe replace function

by

I think you have a few issues with the RegEx’s.

As @Abdou just said use either '\\2 \\1' or better r'\2 \1', as '\1' is a symbol with ASCII code 1

Your solution should work if you will use correct RegEx’s:

In [193]: df
Out[193]:
              name
0        John, Doe
1  Max, Mustermann

In [194]: df.name.replace({r'(\w+),\s+(\w+)' : r'\2 \1'}, regex=True)
Out[194]:
0          Doe John
1    Mustermann Max
Name: name, dtype: object

In [195]: df.name.replace({r'(\w+),\s+(\w+)' : r'\2 \1', 'Max':'Fritz'}, regex=True)
Out[195]:
0            Doe John
1    Mustermann Fritz
Name: name, dtype: object

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  3. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  4. Why does concatenation of DataFrames get exponentially slower?
  5. Remove unwanted parts from strings in a column
  6. Combine Date and Time columns using python pandas
  7. Pandas: How to easily share a sample dataframe using df.to_dict()?
  8. Pandas/Python: Set value of one column based on value in another column
  9. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  10. Pandas Timedelta in Days
  11. how to get ticks every hour?
  12. How to add value labels on a bar chart
  13. How to remove blanks/NA’s from dataframe and shift the values up
  14. Why does my Pandas DataFrame not display new order using `sort_values`?
  15. How to check if a column exists in Pandas
  16. Difference(s) between merge() and concat() in pandas
  17. Seaborn showing scientific notation in heatmap for 3-digit numbers
  18. How can I see the formulas of an excel spreadsheet in pandas / python?
  19. flattening nested Json in pandas data frame
  20. Count distinct words from a Pandas Data Frame
  21. How to annotate each segment of a stacked bar chart
  22. subsetting a Python DataFrame
  23. How to use Pandas stylers for coloring an entire row based on a given column?
  24. How to define format when using pandas to_datetime?
  25. python pandas groupby() result
  26. Max and Min date in pandas groupby
  27. pd.read_html() imports a list rather than a dataframe
  28. How to implode(reverse of pandas explode) based on a column
  29. Pandas concat yields ValueError: Plan shapes are not aligned
  30. Creating dummy variables in pandas for python

Leave a Comment