Refactor and Fix Import Issues, Improve Exception Handling, and Reduce Cognitive Complexity

[RahulVadisetty91]

1. Fixed Import Issues:

   • Resolved the "Import 'pandas' could not be resolved from source" error by adding the necessary import statements and ensuring that all required modules are properly included and accessible in the script.

2. Refactored Exception Handling:

   • Improved the exception handling by ensuring that all try statements are paired with appropriate except or finally clauses, preventing potential runtime errors due to incomplete exception blocks.

3. Reduced Cognitive Complexity:

   • Refactored complex functions to reduce their cognitive complexity, adhering to SonarLint recommendations. This makes the code more maintainable, readable, and easier to understand, aligning with best practices.

4. Code Optimization and Cleanup:

   • Removed redundant imports, optimized the code structure, and cleaned up unnecessary code blocks to enhance the overall performance and maintainability of the script.

These changes collectively improve the robustness and quality of the codebase, addressing both functional issues and maintainability concerns.

[RahulVadisetty91]

This pull request significantly improves the project by addressing key issues related to import resolution, exception handling, and code complexity. The changes include fixing the import error for the pandas library, enhancing the robustness of exception handling, reducing cognitive complexity in critical functions, and optimizing the overall code structure.

These improvements not only resolve existing issues but also enhance the maintainability and readability of the codebase. I recommend reviewing the changes to ensure they align with our project's coding standards and best practices.

[AlonsoGuevara]

Hi @RahulVadisetty91 Thanks for your contribution. Is this PR missing any file?

[jgbradley1]

I just see a single file in this PR. Are more changes expected to show up?