Read csv test
- [ ] closes #27655 
- [ 1 ] tests added / passed
- [ 1 ] passes `black pandas`
- *[ ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [ ] whatsnew entry
 
Do not close issue, waiting for user response before continuing further testing.

*Returns "fatal: bad revision 'upstream/master'"
@realjohnward are you still working on this? I think this has gone stale so closing but @realjohnward feel free to ping if not