Pandas Dataframe empty value's type issue

Question

Let's say there's an empty cell in a data frame. If I print out the type of the empty cell, It prints out:

<class 'float'> nan

Why does it print out the type as class 'float'?

And if a cell has nan value in a cell and the other cell has empty, can I handle these two cells as same as NaN value in it?

Seems that missing data is represented as NaNs pandas.pydata.org/pandas-docs/stable/user_guide/… What does the "empty" cell look like, can you give an example of how to create such an empty? — Bemmu
– Bemmu, Commented Apr 17, 2020 at 6:29

Udit Hari Vashisht · Accepted Answer · 2020-04-17 06:31:29Z

2

NaN is a special value which is part of the IEEE floating-point specification. Hence, when you will check the type of NaN it will show it as a float.

The empty cell will be using Pythonic Missing data value i.e. None, so it is advisable to use pandas.fillna for comparing two cells.

answered Apr 17, 2020 at 6:31

5494 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1