Convert class 'pandas.indexes.numeric.Int64Index' to numpy

Question

I am isolating some row ids from a Pandas dataframe, like this:

data = df.loc[df.cell == id]
rows = df.index

print(type(rows))
< class 'pandas.indexes.numeric.Int64Index'>

I want to convert rows to a numpy array so I can save it to a mat file using sio.savemat. This is returning an error though:

row_mat = rows.as_matrix()
AttributeError: 'Int64Index' object has no attribute 'as_matrix'

What is the correct way, please? Thanks

user3404344 · Accepted Answer · 2016-06-22 04:02:09Z

53

try rows = df.index.values instead

answered Jun 22, 2016 at 4:02

user3404344

1,73715 silver badges13 bronze badges

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

1 Comment

I think the OP wanted df.loc[df.cell == id].index.values. If they confirm, you can update your answer.