Turn CSV values into numpy array with fileds as array indices [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 7 years ago.

Improve this question

I have a CSV file of 625 rows like this-

X_coordinate,Y_coordinate,Value
0,0,10
0,1,6
0,2,7
.
.
1,0,11
1,1,9
1,2,3
.
.
24,23,3
24,24,12

I want to convert this file into a numpy array of 25*25, where array indices contain corresponding values from CSV like-

[[10 6 7....]
 [11 9 3....]
 .
 .
 .
 [......3 12]]

How can I go about scripting this?

What have you tried so far? We can't just do it for you...

Mike Tung
– Mike Tung

2017-11-29 02:57:27 +00:00
Commented Nov 29, 2017 at 2:57 — Mike Tung
– Mike Tung, Commented Nov 29, 2017 at 2:57

dkato · Accepted Answer · 2017-11-29 08:07:46Z

3

You can keep the column names if you use the names=True argument in np.genfromxt. Following code assumes the Value is int:

import numpy as np
data = np.genfromtxt(path_to_csv, dtype=int, delimiter=',', names=True)

Read CSV file to numpy array, first row as strings, rest as float

Then, assign a values for each pair of indices.

m = np.zeros((25, 25))
for x, y, value in data:
    m[x, y] = value

answered Nov 29, 2017 at 8:07

dkato

89510 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Turn CSV values into numpy array with fileds as array indices [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related