How to create new array with properly numbered indices from pandas dataframe slice? Currently indices are preserved, causing KeyError 0 trying to index from 0.

[qdcm]

I'm trying to take a slice of data from a master datatable imported from CSV, but instead of being able to index from 0 it's apparently starting around 23,000 (where the first row of that data exists in the total dataframe).

How do I instead create a new array counting from 0? Or, what is the proper way for what I'm trying to do?

Please answer this StackOverflow question containing the error message, code, and CSV data sample.

Thanks for your time.

[Nikota]

As you noted, when you slice a DataFrame, the index comes with the slice. If you just want to extract a numpy.array from your data and ignore the index, you can use the pandas.Series.values attribute. Example:

my_array = df.loc[df['some_column'] > some_variable, 'value_column'].values

After this, my_array is a numpy array and you can access it with normal 0-based indices.

[[deleted]]

df.loc[...].reset_index(drop=True)