How to change column value while iterating a dataframe?

Asked Jan 26 '21 at 06:23

Active Jan 26 '21 at 06:23

Viewed 30 times

Let's say I have a panda dataframe like below:

A         B         C               E
iPhone    $540      smartphone     white,red,black

What I want to do is that, for each row, if a column's value is delimited by a comma, I need to replace the comma with a vertical bar |. Then I want to iterate through the dataframe and modify the row individually:

for index, row in df.iterrows():

   pass

I don't know which columns might need this modification beforehand. I need to check the value of each column to see whether they are delimited by a comma. In the example above, the column E needs this operation. Other columns may need this modification too.

Without knowing column name, how to access the value of each row's columns?

asked Jan 26 '21 at 06:23

marlon

6,029
8
42
76

So is possible use `df = df.replace(',','|')` ? – jezrael Jan 26 '21 at 06:24
@jezrael are you sure? :D. – Quang Hoang Jan 26 '21 at 06:28
@QuangHoang - No, so ask ;) – jezrael Jan 26 '21 at 06:29
This looks like sub-string replace. So something like `df.replace(',', '\|', regex=True)`? – Quang Hoang Jan 26 '21 at 06:31
ya, understand, use `df.replace(',', '|', regex=True)` – jezrael Jan 26 '21 at 06:43
@QuangHoang, df.replace() operates on all columns at once? – marlon Jan 26 '21 at 06:49
@marlon yes, for plain string. The function itself is a lot more flexible. See [documentation](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.replace.html) for more details. – Quang Hoang Jan 26 '21 at 06:51

How to change column value while iterating a dataframe?

0 Answers0