Fix for issue 62001; ENH: Context-aware error messages for optional dependencies
#62001

Summary

  This PR enhances import_optional_dependency() to provide context-aware error messages that suggest relevant alternatives when       
  dependencies are missing, addressing issue #62001.

  Before:
  Missing optional dependency 'openpyxl'. Use pip or conda to install openpyxl.

  After:
  Missing optional dependency 'openpyxl'. For Excel file operations, try installing xlsxwriter, calamine, xlrd, pyxlsb, or odfpy.     
   Use pip or conda to install openpyxl.

  Implementation Details

  - Core Enhancement: Added operation_context parameter to import_optional_dependency() with 13 predefined contexts (excel,
  plotting, html, xml, sql, performance, compression, cloud, formats, computation, timezone, testing, development)
  - Smart Alternative Filtering: Excludes the failed dependency from suggestions to avoid confusion
  - Backward Compatibility: All existing calls work unchanged; new parameter is optional
  - Strategic Implementation: Updated high-impact locations where users commonly encounter missing dependencies:
    - Excel operations (5 readers: openpyxl, xlrd, calamine, pyxlsb, odf)
    - Plotting operations (matplotlib)
    - HTML parsing operations (html5lib)

  Files Modified

  1. pandas/compat/_optional.py: Core enhancement with context mapping and message building
  2. pandas/tests/test_optional_dependency.py: Updated test patterns and added comprehensive context tests
  3. pandas/io/excel/_*.py: Added context to 5 Excel readers
  4. pandas/plotting/_core.py: Added plotting context
  5. pandas/io/html.py: Added HTML parsing context
  6. doc/source/whatsnew/v3.0.0.rst: Added whatsnew entry

  Testing

  - All existing tests pass with updated patterns
  - New tests verify context functionality works correctly
  - Manual verification confirms all files compile successfully
  - Backward compatibility maintained for existing calls

- [x] closes #xxxx (Replace xxxx with the GitHub issue number)
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

Please make sure to double check I am still new to contributions and let me know if there are any mistakes.
Also I suspect this PR was AI generated so closing. We discourage heavily AI generated pull requests It partially was, I appreciate the review, it makes sense, thank you