%load_ext watermark %watermark -v -p numpy -d -u %%file example.csv 1,2,3,4 5,6,,8 10,11,12, import numpy as np ary = np.genfromtxt('./example.csv', delimiter=',') print('%s x %s array:\n' %(ary.shape[0], ary.shape[1])) print(ary) np.isnan(np.nan) np.isnan(ary) np.count_nonzero(np.isnan(ary)) np.count_nonzero(~np.isnan(ary)) np.sum(ary) print('total sum:', np.nansum(ary)) print('column sums:', np.nansum(ary, axis=0)) print('row sums:', np.nansum(ary, axis=1)) ary[~np.isnan(ary).any(1)] ary0 = np.nan_to_num(ary) ary0 ary0[ary0==0] = np.nan ary0 ary[~np.isnan(ary)] x = np.array([1,2,np.nan]) x[~np.isnan(np.array(x))]