Get element from a column python

Question

I need to extract column from a table and compare each element of this column with number 5. I am getting a list of element from the column but it shows an empty output in console.

def compare():
    with open('table.csv') as csv_file:
        lines = csv_file.readlines()
        for line in lines[1::]:
            array = line.split(',')
            list_pk = array[1]
        if list_pk == "5":
            print("Match")

where do you get error and what error is it? Can you provide an example of file input? — Daemon Painter
– Daemon Painter, Commented Sep 27, 2019 at 13:47

Heapify · Accepted Answer · 2019-09-27 13:56:22Z

1

At a first glance of your code, your if statement should be inside the for loop for it to print anything unless you get lucky and last line has a match:

def compare():
    with open('table.csv') as csv_file:
        lines = csv_file.readlines()
        for line in lines[1::]:
            array = line.split(',')
            list_pk = array[1]
            if list_pk == 5:
                print("Match")

answered Sep 27, 2019 at 13:56

Heapify

2,97623 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Get element from a column python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related