WIP: avoid some numpy warnings #8537
closes #8537 
- avoid numpy comparison to `None` warnings
- change null indexing from `ValueError` to `TypeError` (more consistent with other errors)
- elementwise comparisons with index names xref #11162
- elementwise comparisons vs string-likes
