How to Convert the powershell script code to python code?

Question

How can I convert a for loop in Powershell script to python code?

Power shell script

 $result = Foreach ($row in $csv)
 {   $row   
 if ($row.Param_Name -eq "p_s3bucket_arn") { $row.Param_Value = $S3Bucketarn }
 }

Python Code:

   with open('C:/test.csv') as csvfile:
   readCSV = csv.reader(csvfile, delimiter=',')
   for row in readCSV:
      if(row[0]=='p_instance_count'):
        row[1]=len(instance_count)   # expecting to write in csv file as p_instance_count,10

Error while Executing Python Code:

if(row[0]=='p_instance_count'):

IndexError: list index out of range

CSV

Param_Name,Param_Value
p_instance_count,
p_tag_name,tag123

list index out of range for row[0] means your row contains nothing. can you add contents of your csv file with the question? — SM Abu Taher Asif
– SM Abu Taher Asif, Commented Sep 23, 2019 at 8:28

Rakesh · Accepted Answer · 2019-09-23 10:42:31Z

1

Looks like you need.

data = []
with open('C:/test.csv') as csvfile:
    readCSV = csv.reader(csvfile, delimiter=',')
    next(readCSV)   #skip header
    for row in readCSV:
        if row[0]=='p_instance_count':
            data.append((row[0], len(instance_count)))   
        else:
            data.append((row[0], ""))

with open('C:/test.csv', "w") as csvfile:
    writer = csv.writer(csvfile, delimiter=',')
    for row in data:
        writer.writerow(row)

Using csv.DictReader

Ex:

data = []
with open('C:/test.csv') as csvfile:
    readCSV = csv.DictReader(csvfile, delimiter=',')
    for row in readCSV:
        if row["Param_Name"]=='p_instance_count':
            data.append((row["Param_Name"], len("instance_count")))   
        else:
            data.append((row["Param_Name"], ""))

edited Sep 23, 2019 at 10:42

answered Sep 23, 2019 at 8:43

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

2 Comments

Mia Over a year ago

I am getting if (row[0] == 'p_instance_count'): IndexError: list index out of range do not know where to change.

Rakesh Over a year ago

Can you try using DictReader

Collectives™ on Stack Overflow

How to Convert the powershell script code to python code?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related