pandas 更改单元格的值_使用for循环替换pandas列每行中的单元格值

Please, help me understand my error.

I'm trying to change one column in my .csv file.

I have .csv file as following:

sku,name,code

k1,aaa,886

k2,bbb,898

k3,ccc,342

k4,ddd,503

k5,eee,401

I want to replace "k" symbol with the "_" symbol in the "sku" column.

I wrote the code:

import sys

import pandas as pd

import numpy as np

import datetime

df = pd.read_csv('cat0.csv')

for r in df['sku']:

r1 = r.replace('k', '_')

df['sku'] = r1

print (df)

But the code inserts the last value in every row of the "sku" column. So I get:

sku name code

0 _5 aaa 886

1 _5 bbb 898

2 _5 ccc 342

3 _5 ddd 503

4 _5 eee 40