ENH:Add EA types to read CSV
Closes GH23228

- [x ] closes #23228
- [ x] tests added / passed
- [x ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x ] whatsnew - May need some  guidance on this part.
