Python if statement wont execute for csv

Question

I am trying to count the number of times a certain word appears in a csv file.

import csv

path = r'C:\Users\Ahmed Ismail Khalid\Desktop\test.csv'
str = "line"
count = 0


with open(path,'rt',encoding="utf-8") as f :
    reader = csv.reader(f)
    for row in reader :
       print(row)
       if str == row[0] :
       count = count + 1

print("\n \n The count is :",count)

Whenever i run the code, I always get the output 0 for count. However, all the rows are printed out. My csv file is has two columns, id and text and the data is as below :

id               text
1                this is line 1
2                this is line 2
3                this is line 3
4                this is line 4

You can see that all the lines contain str and the count should be 4 but it is always printed as 0.

Any help would be appreciated.

Thanks

There appaers to be an intendation error: count = count + 1 — Fourier
– Fourier, Commented Jun 3, 2018 at 12:27

Saleh · Accepted Answer · 2018-06-03 12:33:40Z

1

Specify 'newline' , 'delimiter' and 'quote char' exactly to get your desired result when opening csv file. See the example below:

>>> import csv
>>> with open('eggs.csv', newline='') as csvfile:
...     spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')
...     for row in spamreader:
...         print(', '.join(row))
Spam, Spam, Spam, Spam, Spam, Baked Beans
Spam, Lovely Spam, Wonderful Spam

answered Jun 3, 2018 at 12:33

Saleh

1,9622 gold badges22 silver badges49 bronze badges

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

Comments

Hannnn · Accepted Answer · 2018-06-03 12:33:11Z

0

import csv

count = 0
find = 'line'

with open('test.csv', 'rt', encoding='utf-8') as f:
    reader = csv.reader(f)
    for row in reader:
        line = ', '.join(row)
        if find in line:
            count = count + 1

print('The count is :', count)

FYI: You can avoid join if you want to calculate how many times word appears in the file. Just read file by lines without the csv module.

answered Jun 3, 2018 at 12:33

Hannnn

1445 bronze badges

1 Comment

Stevi G Over a year ago

Thanks this worked. But what do you mean by reading without csv module? Treat the file as a text file?

Rakesh · Accepted Answer · 2018-06-03 13:10:11Z

0

Use in to look for your string.

Ex:

with open(path,'rt',encoding="utf-8") as f :
    reader = csv.reader(f)
    for row in reader :
       print(row)
       if str in row[1] :
           count = count + 1

Edit as per comment

import csv
checkStr = 'line'
result = []
with open(path,'rt',encoding="utf-8") as f :
    reader = csv.reader(f)
    for row in reader :
       if checkStr not in row[1]:    #Check if 'line' not in row
           result.append(row)

with open(filename,'w') as f:        #Write new result. 
    writer = csv.writer(f)
    for row in result:
        writer.writerow(row)

Append all rows that do not have checkStr
Write the result to new file.

edited Jun 3, 2018 at 13:10

answered Jun 3, 2018 at 12:29

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

5 Comments

Stevi G Over a year ago

Tried that but the error still persists. Still getting count to be 0

Rakesh Over a year ago

Updated snippet use row[1]

Rakesh Over a year ago

Please accept one of the ans that helped you. Thanks

Stevi G Over a year ago

Any idea how i could delete the entire row if it contains str? That would be helpful and would certainly save me from starting another thread

Rakesh Over a year ago

Updated snippet. Please check.

Collectives™ on Stack Overflow

Python if statement wont execute for csv

3 Answers 3

Comments

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related