Problem with for-loop and multiple CSV files

Question

It looks like the first for loop only considers the first line in the first csv file and does not continue comparing. I have tried to rewrite it a bunch of ways but now im totally lost so im turning to you guys.

Can anyone tell me if there is anything wrong writing the code as i did here:

with open("./products.csv", mode="r") as products_list1:
    with open("./products2.csv", mode="r") as products_list2:
        with open("./results.csv", mode="a") as results:
            for i in products_list1:
                for j in products_list2:
                    jaccard = get_jaccard_sim(i, j)
                    if jaccard >= 0:
                        results.writelines(i+","+j+"\n"+","+str(jaccard))

You need to provide more information about what you want to accomplish. — Dimitar
– Dimitar, Commented Mar 1, 2019 at 12:31
Files aren't lists and must be re-opened each time before iterating over them. — martineau
– martineau, Commented Mar 1, 2019 at 12:31
for i in products_list1: should read for i in products_list1.readlines(): to get an actual list to loop over — Hoog
– Hoog, Commented Mar 1, 2019 at 12:31

dkb · Accepted Answer · 2019-03-01 12:42:10Z

1

you can try this

with open("./products.csv", mode="r") as products_list1:
    lines1 = products_list1.readlines()
with open("./products2.csv", mode="r") as products_list2:
    lines2 = products_list2.readlines()
with open("./results.csv", mode="a") as results:
    for i in lines1:
        for j in lines2:
            jaccard = get_jaccard_sim(i, j)
            if jaccard >= 0:
                results.writelines(i + "," + j + "\n" + "," + str(jaccard))

answered Mar 1, 2019 at 12:42

dkb

4,6364 gold badges44 silver badges60 bronze badges

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

1 Comment

dkb Over a year ago

similar to what @Satya had mentioned here:stackoverflow.com/a/54944794/2987755

Sssssuppp · Accepted Answer · 2019-03-01 12:34:16Z

1

You should do something like this before opening any for loops:

pdt_list1 = products_list1.readlines()
pdt_list2 = products_list2.readlines()

and perform your operations on pdt_list1 and pdt_list2.

This will fix the issue! Good Luck!

answered Mar 1, 2019 at 12:34

Sssssuppp

7112 gold badges9 silver badges31 bronze badges

Collectives™ on Stack Overflow

Problem with for-loop and multiple CSV files

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related