Python: How can I manipulate csv data in a list?

Question

I have created a list which has the totality of all the data in the csv file.
How do I seperately call upon data in rows and columns?

For instance:

 **a, b ,c** 
**1** a1 b1 c1
**2** a2 b2 c2

How can I identify a single cell within the list?

• OneCricketeer: Are you using Numpy / Pandas?
• Yousuf Farhan: No, and I cannot as well.
• Kind Stranger: We don't know how your data looks. You say you have it in a list, is this a list for each row? Can you post an example?
• Jack Homan: docs.python.org/3/tutorial/…
• Kind Stranger: @YousufFarhan sounds like you want a dictionary

Answer 1

try below code:

l = ['a', 'b', 'c','1','a1', 'b1', 'c1', '2', 'a2', 'b2','c2']
columns = 3
result = list(zip(*[iter(l[columns:])]*(columns+1)))
result2 = {i[0]:i[1:] for i in result}
item_id = '2'
result2[item_id]

output:

 ('a2', 'b2', 'c2')

or you could try below code:

l = ['a', 'b', 'c','1','a1', 'b1', 'c1', '2', 'a2', 'b2','c2']
columns = 3
item_id = '2'
index = l.index(item_id)
l[index:index+columns]

output:

['a2', 'b2', 'c2']