Coerce None according to the dtype of the container

Fixes #7939
you can use ``self.is_numeric`` for this.