Replacing NaN with None in NumPy
Example 1: The data frame, for which ‘Nan’ is to be replaced with ‘None’ , is as follows:
[ 1. nan 3. 6. 7.]
It creates a NumPy array named temp, replaces the np.nan values with None using np.where, and then prints the modified temp array.
Python3
import numpy as np temp = np.array([ 1 , np.nan, 3 , 6 , 7 ]) print (arr) temp = np.where(np.isnan(temp), None , temp) print (temp) |
Output:
[1.0 None 3.0 6.0 7.0]
Example 2: The data frame, for which ‘Nan’ is to be replaced with ‘None’ , is as follows:
[ 4. 5. nan nan 7.]
It creates a NumPy array named temp, replaces the np.nan values with None using np.where, and then prints the modified temp array.
Python
import numpy as np temp = np.array([ 1 , np.nan, 3 , 6 , 7 ]) print (arr) temp = np.where(np.isnan(temp), None , temp) print (temp) |
Output
[4.0 5.0 None None 7.0]
Replacing Pandas or Numpy Nan with a None to use with MysqlDB
The widely used relational database management system is known as MysqlDB. The MysqlDB doesn’t understand and accept the value of ‘Nan’, thus there is a need to convert the ‘Nan’ value coming from Pandas or Numpy to ‘None’. In this article, we will see how we can replace Pandas or Numpy ‘Nan’ with a ‘None’.
Contact Us