Replace pylint message types with explicit message names
- [ ] Updates #48855 
- Replaces "C", "R", and "W" message types with explicit message names to be disabled.
- Groups messages by type
For some reason my local pylint wasn't catching the warning at `pandas/_libs/tslibs/__init__.py:38:0: W0406: Module import itself (import-self)`.