/Python/ValueError: Input contains NaN, infinity or a value too large for dtype('float32').

ValueError: Input contains NaN, infinity or a value too large for dtype('float32').

ValueError: Input contains NaN, infinity or a value too large for dtype('float32'). site:stackoverflow.com

np.all(np.isfinite(mat))

Source: stackoverflow.com

ValueError: Input contains NaN, infinity or a value too large for dtype('float32').

# Loads your dataset, drops labels and response variable as usual...
df = pd.read_csv('train_test.csv', sep=',')
X = df.drop(["label_1","label_2","response_var"], axis=1)
y = df['response_var']

# this will print TRUE or FALSE for positions containing or not NaN
# values in your dataset

print(np.isnan(X))

ValueError: Input contains NaN, infinity or a value too large for dtype('float32'). site:stackoverflow.com

np.any(np.isnan(mat))

Source: stackoverflow.com

Input contains NaN, infinity or a value too large for dtype('float64').

import numpy as np

# generate example matrix
matrix = np.random.rand(5,5)
matrix[0,:] = np.inf
matrix[2,:] = -np.inf
>>> matrix
array([[       inf,        inf,        inf,        inf,        inf],
       [0.87362809, 0.28321499, 0.7427659 , 0.37570528, 0.35783064],
       [      -inf,       -inf,       -inf,       -inf,       -inf],
       [0.72877665, 0.06580068, 0.95222639, 0.00833664, 0.68779902],
       [0.90272002, 0.37357483, 0.92952479, 0.072105  , 0.20837798]])

# find min and max values for each column, ignoring nan, -inf, and inf
mins = [np.nanmin(matrix[:, i][matrix[:, i] != -np.inf]) for i in range(matrix.shape[1])]
maxs = [np.nanmax(matrix[:, i][matrix[:, i] != np.inf]) for i in range(matrix.shape[1])]

# go through matrix one column at a time and replace  + and -infinity 
# with the max or min for that column
for i in range(matrix.shape[1]):
    matrix[:, i][matrix[:, i] == -np.inf] = mins[i]
    matrix[:, i][matrix[:, i] == np.inf] = maxs[i]

>>> matrix
array([[0.90272002, 0.37357483, 0.95222639, 0.37570528, 0.68779902],
       [0.87362809, 0.28321499, 0.7427659 , 0.37570528, 0.35783064],
       [0.72877665, 0.06580068, 0.7427659 , 0.00833664, 0.20837798],
       [0.72877665, 0.06580068, 0.95222639, 0.00833664, 0.68779902],
       [0.90272002, 0.37357483, 0.92952479, 0.072105  , 0.20837798]])

Source: stackoverflow.com

Similar codes

24 votes291 views5 answers
Remove a part of a string python
Python
4 votes257 views3 answers
Module 'tensorflow._api.v2.train' has no attribute 'gradientdescentoptimizer'
Python
2 votes297 views3 answers
List inside a list in python
Python
0 vote335 views1 answer
Python Print Variable Using comma , character to separate the variables in a print statement
Python
2 votes335 views1 answer
Python overwrite text that is already printed
Python
0 vote301 views1 answer
Random.choices without repetition
Python
0 vote284 views1 answer
How to make code only go once python
Python
0 vote270 views1 answer
Python plot outline imdbpy
Python
24 votes307 views3 answers
Get last n characters of string python
Python
0 vote283 views2 answers
How to create an empty 2d list in python
Python