nan Questions

3

Solved

I am reading in a bunch of CSV files (measurement data for water levels over time) to do various analysis and visualizations on them. Due to various reasons beyond my control, these time series oft...
Unconquerable asked 12/3, 2015 at 10:54

6

I have a dataframe with ~300K rows and ~40 columns. I want to find out if any rows contain null values - and put these 'null'-rows into a separate dataframe so that I could explore them easily. I ...
Disk asked 9/1, 2013 at 22:22

2

Solved

Why does double.IsNegative(double.NaN) unexpectedly return true whereas double.NaN < 0 returns false as expected?
Overpowering asked 20/5, 2021 at 18:25

4

Solved

I have a dataFrame in pandas and several of the columns have all null values. Is there a built in function which will let me remove those columns?
Holmen asked 1/6, 2012 at 22:5

2

Solved

I want to use numpy.where() to add a column to a pandas.DataFrame. I'd like to use NaN values for the rows where the condition is false (to indicate that these values are "missing"). Cons...
Jambalaya asked 10/5, 2021 at 21:12

10

Solved

For my unittest, I want to check if two arrays are identical. Reduced example: a = np.array([1, 2, np.NaN]) b = np.array([1, 2, np.NaN]) if np.all(a==b): print 'arrays are equal' This does not w...
Erelia asked 22/5, 2012 at 21:18

3

Solved

I have a data series which looks like this: print mydf id_L1 2 NaN 3 NaN 4 NaN 5 NaN 6 NaN 7 NaN 8 NaN I would like to check if all the values are NaN. My attempt: pd.isnull(mydf).all() Output: ...
Bonze asked 15/10, 2015 at 11:19

4

Solved

How could I randomly introduce NaN values ​​into my dataset for each column taking into account the null values ​​already in my starting data. I want to have for example 20% of NaN values ​​by col...
Biff asked 23/1, 2019 at 15:21

5

Solved

Is it possible to set an element of an array to NaN in Python? Additionally, is it possible to set a variable to +/- infinity? If so, is there any function to check whether a number is infinity or...
Lambard asked 25/3, 2011 at 22:24

8

Solved

I am trying to print or to get list of columns name with missing values. E.g. data1 data2 data3 1 3 3 2 NaN 5 3 4 NaN I want to get ['data2', 'data3']. I wrote following code: print('\n'.j...
Pervert asked 21/5, 2016 at 18:37

3

Solved

I have a DataFrame which looks like this: one | two a | 2 | 5 b | 3 | 6 NaN | 0 | 0 How do I replace the NaN in the index with a string, say "No label"? I tried: df = df.replace(np.NaN, "No ...
Matabele asked 10/9, 2015 at 16:2

1

Solved

When casting double infinity to float and vice versa, will it still be infinity? Is it the same with NaN?
Drive asked 6/4, 2021 at 13:0

5

Solved

I'm familiar with NaN being "weird" in JavaScript, i.e., NaN === NaN always returns false, as described here. So one should not make === comparisons to check for NaN, but use isNaN(..) in...
Dennis asked 22/3, 2021 at 9:35

1

I have a pandas DataFrame: df['total_price'].describe() returns count 24895.000000 mean 216.377369 std 161.246931 min 0.000000 25% 109.900000 50% 174.000000 75% 273.000000 max 1355.900000 Name: to...
Saying asked 14/11, 2018 at 18:44

3

Solved

My question is related to this one. I have a file named 'test.csv' with 'NA' as a value for region. I want to read this in as 'NA', not 'NaN'. However, there are missing values in other columns in ...
Mobile asked 23/10, 2019 at 16:57

4

Solved

iv'e tried using a for loop to filter out the null and nan values but still the nan value is added to the listview. this is just a part where the calculation is done. double rs1 = (qz1 * c11) + (a...
Raft asked 19/1, 2014 at 7:1

4

Solved

For certain columns of df, if 80% of the column is NAN. What's the simplest code to drop such columns?
Halutz asked 9/4, 2017 at 20:25

0

My colleague was doing some basic experiments with NaN and was puzzled by the behavior on Visual Studio that did not match his expectations. After discussion, it seems that he uncovered a probable ...
Meridethmeridian asked 1/3, 2021 at 10:8

2

Solved

I am trying to write my first neural network to play the game connect four. Im using Java and deeplearning4j. I tried to implement a genetic algorithm, but when i train the network for a while, the...
Idiom asked 5/2, 2021 at 1:53

3

Solved

While nan == nan is always False, in many cases people want to treat them as equal, and this is enshrined in pandas.DataFrame.equals: NaNs in the same location are considered equal. Of course,...
Institutionalism asked 25/1, 2018 at 22:27

10

Solved

I was just studying OCPJP questions and I found this strange code: public static void main(String a[]) { System.out.println(Double.NaN==Double.NaN); System.out.println(Double.NaN!=Double.NaN); }...
Jonas asked 11/1, 2012 at 13:2

2

Solved

It is well known that for any variable of floating-point type x != x iff (if and only if) x is NaN (not-a-number). Or inverse version: x == x iff x is not NaN. Then why did WG14 decide to define is...
Pachston asked 29/1, 2021 at 21:17

3

Solved

How can I check whether a float variable is NaN or not? e.g. math.Log(1.0) // not NaN math.Log(-1.0) // NaN
Sassanid asked 6/7, 2015 at 12:43

3

Solved

I have a table containing some countries and their KPI from the world-banks API. this looks like . As you can see no nan values are present. However, I need to pivot this table to bring int into ...
Hepplewhite asked 22/9, 2016 at 6:58

3

Solved

I am running a sum function of one hive table in Hue, and get a return value of NaN. Here is my code: select sum(v1) from hivedb.tb1; I don't know why it is giving me a NaN result. I checked if ...
Ditch asked 20/4, 2017 at 17:33

© 2022 - 2024 — McMap. All rights reserved.