Changes csv row value

Question

This is my code:


import pandas as pd
import re

# reading the csv file
patients = pd.read_csv("partial.csv")
  
# updating the column value/data
for patient in patients.iterrows():
    cip=patient['VALOR_ID']
    new_cip = re.sub('^(\w+|)',r'FIXED_REPLACED_STRING',cip)
    patient['VALOR_ID'] = new_cip
  
# writing into the file
df.to_csv("partial-writer.csv", index=False)
  
print(df)

I'm getting this message:

Traceback (most recent call last): File "/home/jeusdi/projects/workarea/salut/load-testing/load.py", line 28, in cip=patient['VALOR_ID'] TypeError: tuple indices must be integers or slices, not str

EDIT Form code above you can think I need to set a same fixed value to all rows.

I need to loop over "rows" and generate a random string and set it on each different "row".

Code above would be:

for patient in patients.iterrows():
    new_cip = generate_cip()
    patient['VALOR_ID'] = new_cip

Can you add some data sample to question?

jezrael
– jezrael

2021-11-12 09:04:31 +00:00
Commented Nov 12, 2021 at 9:04 — jezrael
– jezrael, Commented Nov 12, 2021 at 9:04

jezrael · Accepted Answer · 2021-11-12 10:18:38Z

2

Use Series.str.replace, but not sure about | in regex. Maybe should be removed it:

df = pd.read_csv("partial.csv")

df['VALOR_ID'] = df['VALOR_ID'].str.replace('^(\w+|)',r'FIXED_REPLACED_STRING')

#if function return scalars
df['VALOR_ID'] = df['VALOR_ID'].apply(generate_cip)

df.to_csv("partial-writer.csv", index=False)

edited Nov 12, 2021 at 10:18

answered Nov 12, 2021 at 9:01

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Zach Young Over a year ago

You can skip the loop, and replace the entire column with that one line, in Pandas?

jezrael Over a year ago

@ZachYoung - exactly. It was reason add first and last line of code from Q.

Jordi Over a year ago

I need to generate a random string to be replaced. I mean, I need each "cell value" has a different value after "transformation". Could you provide a way iterating over "rows"? I'm editing post for more details. I'll really appreciate your help.

jezrael Over a year ago

@Jordi - Can you try df['VALOR_ID'] = df['VALOR_ID'].apply(generate_cip) ?

Collectives™ on Stack Overflow

Changes csv row value

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related