Read csv category fix
- [x] closes #18186
- [x] tests added / passed
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] whats new entry

Summary:

- Fix the bug as suggested by @TomAugspurger in issue #18186 
- Added a unit test which ensures fix is working.
