Load Data from CSV using Numpy

Question

Data

HOD,2012-1-3,1,5000
HOD,2012-1-4,1,5000
HOD,2012-1-5,1,5000
HOD,2012-1-6,1,5000
HOD,2012-1-9,1,5000
HOD,2012-1-10,1,5000

myData = np.genfromtxt(inputFile, dtype=[('Symbol',str),('Date', 'datetime64[D]'),('Value', int),('Allocation', long)], delimiter=',')
print myData

Output

('', datetime.datetime(1969, 12, 31, 0, 0), 1, 5000L)
('', datetime.datetime(1969, 12, 31, 0, 0), 1, 5000L)
('', datetime.datetime(1969, 12, 31, 0, 0), 1, 5000L)
('', datetime.datetime(1969, 12, 31, 0, 0), 1, 5000L)
('', datetime.datetime(1969, 12, 31, 0, 0), 1, 5000L)

Why are my strings lost?

Note that your dates are not being imported correctly, as well :) (Zero padding for the month and day may help...) — summea
– summea, Commented May 28, 2014 at 17:16

falsetru · Accepted Answer · 2014-05-28 17:10:26Z

1

String dtype require you to specify length:

dtype=[('Symbol', 'S3'), ...]

or

dtype=[('Symbol', (str, 3)), ...]

If you want arbitrary-length string, specify object as a type; it will allow any object to be assigned.

answered May 28, 2014 at 17:10

falsetru

371k69 gold badges769 silver badges659 bronze badges

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

Collectives™ on Stack Overflow

Load Data from CSV using Numpy

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related