Python - Automation Framework for Api , Web applications

Looking for an automation framework on python should have the below features- This should have 2 variants: ************************************************************************************** First One: pyunit & pytest Page object model Data and keyword-driven approach from Excel Python methods reusable library Allure reporting or any other suitable ************************************************************************************** 2. Second one: Robot Framework Python methods reusable library Data and keyword-driven approach from Excel Allure reporting ************************************************************************************** Data and keyword-driven approach from Excel: what has to be achieved here is - ******************************************************************************************* There will be one main Excel Sheet [Test Runner] with Test Modules listed along with that the flagged test cases to be Run as Yes/No. There will be test modules Workbooks, per module one workbook. This test module workbook will have two sheets. The first sheet will have test case IDs and keywords to be run listed in a horizontal keyword-driven sequence. The second sheet will have the test case IDs and data to be used; mentioned column-wise, this data will be used in the keyword methods from sheet1. Behavior to be achieved: The flagged cases as Yes from the main sheet will be picked against the test modules; based on the keywords arranged in sheet1; will be run; using the test data from sheet 2. The key identifier is TC ID from the main sheet to test module workbook [sheet1 ,sheet2] The keywords mentioned in sheet 1 here are testng methods from script class. Documents Attached: Main sheet is : Test Runner Test Module Sheet sample: MobileSite_Test