[WIP] STY: activate pytest.raises context manager code check
xref #24332

- [x] pandas/tests/arrays/sparse/test_libsparse.py
- [x] pandas/tests/computation/test_eval.py
- [x] pandas/tests/frame/test_nonunique_indexes.py
- [x] pandas/tests/indexes/interval/test_interval_new.py
- [x] pandas/tests/indexing/multiindex/test_partial.py
- [ ] pandas/tests/indexing/test_floats.py: seperate PR #25748
- [ ] pandas/tests/io/test_pytables.py: tbc once #25004 is merged 
- [x] pandas/tests/series/test_constructors.py