What is imported from an Access database for empty boxes?

Asked Jul 20 '22 at 16:10

Active Jul 21 '22 at 12:11

Viewed 41 times

I got a pandas DataFrame of a table I have imported from an Access database. Some of the values in that Access table are empty. As I was playing with the data frame, I stumbled into this situation: The type of the data in a specific box (row, column) does not match a the corresponding boolean statement.

type(df.loc['3000', 'email'])
>>> NoneType
type(df.loc['3000', 'email']) == None
>>> False

Tried several ways but it seems like the data is printed out as None but isn't actually None. Any idea why? What is actually imported for empty boxes? What will be a True equality statement? Thank you.

edited Jul 21 '22 at 12:11

asked Jul 20 '22 at 16:10

David

`df.loc['3000', 'email'] == None` – Nick ODell Jul 20 '22 at 16:12
Try `df.dropna()` and count up what's left. – Alphy13 Jul 20 '22 at 16:17
type(df.loc['3000', 'email']) == type(None) – Neo Jul 20 '22 at 16:20
@NickODell - Testing `thing == None` is not recommended practice. `thing is None` is preferred. – Gord Thompson Jul 20 '22 at 18:12
@Neo - Testing `type(x) == type(y)` is also discouraged (PEP8 E721). The preferred construct for that test would be `isinstance(thing, types.NoneType)`, but `thing is None` is better. – Gord Thompson Jul 20 '22 at 18:15
@NickODell - That statement returnd that all **aren't** None. – David Jul 21 '22 at 11:59
Thanks all. It was more a question about the type of data that is imported from an Access database for empty boxes. Printing the pandas data frame resulted whith a None value. But it seemed like it isn't actually None. – David Jul 21 '22 at 12:01

What is imported from an Access database for empty boxes?

0 Answers0