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

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

2 votes196 views1 answer
Flask make static directory
Python Flask
-1 vote217 views1 answer
Python encoding declaration
Python
0 vote196 views1 answer
How do you amke function in python
Python
13 votes193 views6 answers
Read pickle file
Python
0 vote184 views1 answer
Randomly splits this DataFrame with the provided weights
Python
-1 vote214 views4 answers
How to say hello world in c++
Python
1 vote183 views1 answer
[Solved] TypeError: ‘numpy.float64’ object cannot be interpreted as an integer
Python
0 vote185 views1 answer
Back button django template
Python
22 votes205 views4 answers
Access first element of dictionary python
Python
1 vote210 views1 answer
Query with condition django
Python