How to retrieve a cell values from CSV file in Python

Question

I am working on a tracking project in which I am implementing trilateration algorithm. I have data in csv file. I want to retrieve values of cells in csv file one by one in my algorithm. Following is the screenshot of dataset for reference.

For example: At first (see picture above) I have to retrieve '-49' then '-51' and then '-56' and so on I have to retrieve all the values. Is there any shortcut method through loop to do this efficiently.

What did you search for, and what did you find? What did you try, and how did it fail? Reading CSV files is a very common question here; please search before asking. — tripleee, Mar 02 '21 at 13:17

score 0 · Answer 1 · edited Mar 02 '21 at 13:13

0

With pandas library, you can retrieve columns as below and iterate over them with for loops.

import pandas as pd

data = pd.read_csv("datasetname.csv")

gateA = data['GateA']
gateB = data['GateB']
gateC = data['GateC']

for i in range(len(gateA)):
    first = gateA[i]
    second = gateB[i]
    third = gateC[i]

edited Mar 02 '21 at 13:13

Dharman

30,962
25
85
135

answered Mar 02 '21 at 13:07

Burhan Bilen

83
2
7

Simpler: `for first, second, third in zip(gateA, gateB, gateC):` – Tomerikoo Mar 02 '21 at 13:19
I wasn't sure of that if zipping 3 lists is possible or not, that's why I didn't write that way, but with your answer, I realized that your solution is better. – Burhan Bilen Mar 02 '21 at 13:41
Read more about [`zip()`](https://docs.python.org/3/library/functions.html#zip) – Tomerikoo Mar 02 '21 at 13:42

How to retrieve a cell values from CSV file in Python

1 Answers1