Load data from csv into numpy array

Question

I am trying to load data in a csv file (with delimiter ',') into a numpy array. Example of a line is: 81905.75578271,81906.6205052,50685.487931,.... (1000 columns). I have this code but it seems to not be working properly as in the exit of the function the debugger cannot recognize the data, and when I call the xtrain.shape it returns 0:

def load_data(path):
    # return np.loadtxt(path,dtype=int,delimiter=',')
    file = open(path,'r')
    data = []
    for line in file:
        array_vals = line.split(",")
        array = []
        for val in array_vals:
            if not val:
                array.append(float(val))
        data.append(np.asarray(array))
    return np.asarray(data)

x_train =  load_data(path)

use pandas read_csv method.

Nihal
– Nihal

2018-06-13 07:09:49 +00:00
Commented Jun 13, 2018 at 7:09 — Nihal
– Nihal, Commented Jun 13, 2018 at 7:09
Are you getting any errors?

Rakesh
– Rakesh

2018-06-13 07:15:55 +00:00
Commented Jun 13, 2018 at 7:15 — Rakesh
– Rakesh, Commented Jun 13, 2018 at 7:15

Rakesh · Accepted Answer · 2018-06-13 07:20:52Z

4

This should give you your required output.

import numpy as np
def load_data(path):
    return np.loadtxt(path,delimiter=',')

answered Jun 13, 2018 at 7:20

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

1 Comment

Adrián Arroyo Perez Over a year ago

I actually tried before, but it didnt work. Ive just realized that there were some ',' at the end of some lines in the file -.-

Collectives™ on Stack Overflow

Load data from csv into numpy array

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related