python csv text file to array[i,j]

Question

I just started to learn python, so I need some help.

I have closeparams.txt file, it has CSV structure:

3;700;3;10;1
6;300;3;20;1
9;500;2;10;5

I need read this file to 2 dimension array. a[i,j] where i - is row and j - is column

I searched but not found exactly samples. I will use this massive like this:

i=0
j=3
print a(i,j)

I suppose that display:

Or

i=2
j=1
print a(i,j)

I suppose that display:

what have you tried ? there are a lot of methods to load a csv file : csv module, numpy.genfromtxt, ... — lucasg
– lucasg, Commented Nov 14, 2012 at 15:30
there are also a lot of ways one could parse/interpret the example data you've provided? — Cameron Sparr
– Cameron Sparr, Commented Nov 14, 2012 at 15:31
I no problem with separated read and array working, but I stuck with working this two at at once. — RedSubmarine
– RedSubmarine, Commented Nov 14, 2012 at 15:34

heltonbiker · Accepted Answer · 2012-11-14 15:36:02Z

4

I suggest to use numpy if you want to deal with arrays. In your case:

import numpy

a = numpy.loadtxt('apaga.txt', delimiter=';')

print a[0,3]

You didn't specify how important will the array construct be for you, but Numpy is very, very powerful for complex tasks, and can be very lean to perform smaller, quick'n'dirty tasks in a compact, fast and readable way.

answered Nov 14, 2012 at 15:36

heltonbiker

27.7k30 gold badges151 silver badges270 bronze badges

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

5 Comments

RedSubmarine Over a year ago

I have try something like this

RedSubmarine Over a year ago

import numpy a = numpy.loadtxt(filename='closeparams.txt', delimiter=';') print a[0,3]

heltonbiker Over a year ago

Two possible causes: 1) you are using Python 3.x, if so then print(a[0,3]) should do; 2) you are putting everything in one line, if so then separate lines.

RedSubmarine Over a year ago

Yes, I use Python 3.1.1, I correct print(a[0,3]) but in shell - import numpy ImportError: No module named numpy

Paolo Moretti Over a year ago

@RedSubmarine You have to install numpy first. An alternative solution would be to use the built-in csv module.

Pedro del Sol · Accepted Answer · 2012-11-14 15:47:03Z

3

display_list = []

with open('closeparams.txt') as data_file:
   for line in data_file:
      display_list.append(line.strip().split(';'))

print(display_list[0][3]) # [i][j]

edit - python3 print()

edited Nov 14, 2012 at 15:47

answered Nov 14, 2012 at 15:34

Pedro del Sol

2,8419 gold badges43 silver badges52 bronze badges

2 Comments

Pedro del Sol Over a year ago

change the print statement to a print function call; print()

Pedro del Sol Over a year ago

or install numpy and try heltonbiker's solution

Karim Tabet · Accepted Answer · 2014-10-03 14:13:01Z

3

How about:

import csv
sheet = list(csv.reader(open(source_path)))
print sheet[0][0]

Just typecast the opened csv to a list!

edited Oct 3, 2014 at 14:13

answered Oct 3, 2014 at 13:15

Karim Tabet

1,8671 gold badge17 silver badges35 bronze badges

1 Comment

Keith Pinson Over a year ago

Your post has shown up in the Low Quality Posts review queue. This is likely because you haven't provided any explanation. Your code is fairly clear, so I am going to mark this answer "Looks OK", but explained code has greater potential to be helpful.

Collectives™ on Stack Overflow

python csv text file to array[i,j]

3 Answers 3

5 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related