Traceability Matrix & Python script

[angshumanmukherjee]

What is Traceability?

Traceability is the ability to trace all processes from procurement of raw materials to production, consumption, and disposal to clarify "when and where the product was produced by whom."

Parameters to include in the Requirement Traceability Matrix

• Requirement ID
• Requirement Type and Description
• Use case ID
• Use case Description
• Test Case ID
• Test Case Description
• Test Cases with Status

Advantage of Requirement Traceability Matrix

• It confirms 100% test coverage
• It highlights any missing requirements or document inconsistencies
• It shows the overall defects or execution status with a focus on business requirements
• It helps in analyzing or estimating the impact on the QA team's work to revisiting or re-working the test cases

Create a Requirement Traceability Matrix using Python script with Pandas.

• Pandas is a software library written in Python for data manipulation and analysis.

---

Lint to Python Gist

[angshumanmukherjee]

RTM write to Google Sheets by Python scrip

https://github.com/user-attachments/assets/72259ba3-b620-44d3-9578-4347c6e12c86

[angshumanmukherjee]

Lint to Python Gist