How to Replace Commas with Dashes in a Pandas Dataframe String Column?

Replacing Characters in a Pandas Dataframe String Column

You may encounter situations where you have a dataframe column containing textual data and need to replace specific characters. Let's consider a scenario with a column named 'range' having values in the following format:

range
"(2,30)"
"(50,290)"
"(400,1000)"

Your goal is to replace the commas with dashes. However, you've faced challenges with the following method:

org_info_exc['range'].replace(',', '-', inplace=True)

Solution:

Instead of using the replace function directly on the Pandas Series, utilize the vectorized str method. Here's how to achieve the desired result:

df['range'] = df['range'].str.replace(',','-')

After running this code, your dataframe will be updated as follows:

      range
0    (2-30)
1  (50-290)

Reason for Previous Failure:

When using the replace function on a Pandas Series, it attempts to replace exact string matches. Since the comma character in your example is not an exact match, the replacement failed. The str method, on the other hand, allows for more versatile string manipulation.

The above is the detailed content of How to Replace Commas with Dashes in a Pandas Dataframe String Column?. For more information, please follow other related articles on the PHP Chinese website!