Hi,
As an alternative, you can open this in excel (or open office...) and then save it as a csv
(comma separated) file. Then, you could use mlab.csv2rec to easily get
the different columns in a numpy recarray:
In [43]: from matplotlib.mlab import csv2rec
In [44]: a = csv2rec('stuff.csv',names=['0','1','2','3','4'])
In [45]: a
Out[45]:
rec.array([(0, 1, 4, 1, 'RewardA'), (4, 5, 4, 1, 'DistractorR'),
(8, 2, 4, 1, 'RewardB'), (12, 3, 4, 1, 'PunishmentA'),
(16, 2, 4, 1, 'RewardB'), (20, 2, 4, 1, 'RewardB'),
(24, 1, 4, 1, 'RewardA'), (28, 4, 4, 1, 'PunishmentB'),
(32, 0, 2, 1, 'NULL'), (34, 1, 4, 1, 'RewardA'),
(38, 1, 4, 1, 'RewardA'), (42, 5, 4, 1, 'DistractorR'),
(46, 2, 4, 1, 'RewardB'), (50, 6, 4, 1, 'DistractorP')],
dtype=[('0', '<i4'), ('1', '<i4'), ('2', '<i4'), ('3', '<i4'), ('4', '|S11')])
In [46]: a['2']
Out[46]: array([4, 4, 4, 4, 4, 4, 4, 4, 2, 4, 4, 4, 4, 4])
In [47]: a['4']
Out[47]:
rec.array(['RewardA', 'DistractorR', 'RewardB', 'PunishmentA', 'RewardB',
'RewardB', 'RewardA', 'PunishmentB', 'NULL', 'RewardA', 'RewardA',
'DistractorR', 'RewardB', 'DistractorP'],
dtype='|S11')
Cheers,
Ariel
--
Ariel Rokem
Helen Wills Neuroscience Institute
University of California, Berkeley
http://argentum.ucbso.berkeley.edu/ariel