/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

1 vote152 views1 answer
How to use git with python
Python
37 votes209 views5 answers
Python split list
Python
14 votes137 views4 answers
Python lambda function if else
Python
11 votes147 views2 answers
How to push item to array python
Python
2 votes212 views1 answer
Dataframe get list of index vlaues
Python
0 vote200 views2 answers
Django domain name
Python Django
0 vote140 views1 answer
To check weather a dictionary is empty or not in python
Python
118 votes142 views6 answers
Reverse string
Python
0 vote142 views1 answer
Import matplotlib sub
Python
0 vote155 views1 answer
Reorder list python
Python