How to remove all rows in a numpy.ndarray that contain non-numeric values

by 
>>> a = np.array([[1,2,3], [4,5,np.nan], [7,8,9]])
array([[  1.,   2.,   3.],
       [  4.,   5.,  nan],
       [  7.,   8.,   9.]])

>>> a[~np.isnan(a).any(axis=1)]
array([[ 1.,  2.,  3.],
       [ 7.,  8.,  9.]])

and reassign this to a.

Explanation: np.isnan(a) returns a similar array with True where NaN, False elsewhere. .any(axis=1) reduces an m*n array to n with an logical or operation on the whole rows, ~ inverts True/False and a[ ] chooses just the rows from the original array, which have True within the brackets.

More Related Contents:

  1. Is there a NumPy function to return the first index of something in an array?
  2. Understanding NumPy’s einsum
  3. Intuition and idea behind reshaping 4D array to 2D array in NumPy
  4. Is there any numpy group by function?
  5. numpy: most efficient frequency counts for unique values in an array
  6. Computing the correlation coefficient between two multi-dimensional arrays
  7. Removing nan values from an array
  8. Why is numpy’s einsum faster than numpy’s built in functions?
  9. How to return 0 with divide by zero
  10. Numpy sum elements in array based on its value
  11. Reshape an array in NumPy
  12. Efficiently return the index of the first value satisfying condition in array
  13. Most efficient way to forward-fill NaN values in numpy array
  14. NumPy array initialization (fill with identical values)
  15. Numpy – add row to array
  16. Why does numpy.zeros takes up little space
  17. Generalise slicing operation in a NumPy array
  18. How to split a numpy array in fixed size chunks with and without overlap?
  19. Parameters to numpy’s fromfunction
  20. List to array conversion to use ravel() function
  21. Efficient distance calculation between N points and a reference in numpy/scipy
  22. Why does numpy.linalg.solve() offer more precise matrix inversions than numpy.linalg.inv()?
  23. Fastest save and load options for a numpy array
  24. NumPy array/matrix of mixed types
  25. load csv into 2D matrix with numpy for plotting
  26. Numpy find indices of groups with same value
  27. Inverting a numpy boolean array using ~
  28. Python, OpenCV: Increasing image brightness without overflowing UINT8 array
  29. Add single element to array in numpy
  30. argsort for a multidimensional ndarray

Leave a Comment