How do you generate a python code to import the data from this Excel sheet into MySQL workbench? I only know some basics of Python like print, list, operation. Really need some help on this one.

Note:

Schema: Testing

Tables: Tester, Gov, PrivateCompany

Tester table has columns: Login, Name, Email, Mobile

Gov table has columns: Gov_id, Gov_name

PrivateCompany table has columns: Private_id, Private_name

CPF, HDB, TP are attributes of Gov_name.

DBS, FairPrice are attribute of Private_name

We have two Excel file: Tester and GovPrivate, the screenshot is shown below:

Tester

Login Name Email Mobile Residence Ty Password-ha CPF HDB TP DBS FairPrice S1234567A Tester1 tester1@ one 91111111 Citizen dusc5019pdn TRUE FALSE TRUE FALSE TRUE S3948373B Tester2 tester2@ one 92222222 Citizen Okrvx7kobgfc TRUE TRUE FALSE TRUE FALSE S2948573C Tester3 tester3@ one 93333333 Citizen mluz74j67 ul FALSE TRUE TRUE TRUE FALSE S3049383D Tester4 tester4@ one 94444444 PR h930t91566s FALSE TRUE TRUE FALSE TRUE S4938485E Tester5 tester5@ one 95555555 PR 6x1|6b3xyars/ TRUE FALSE FALSE FALSE FALSE S2049583F Tester6 tester6@ one 96666666 Pass gvh2aza9jo3 FALSE TRUE FALSE TRUE FALSE S2058374G Tester7 tester7 @ one 97777777 Pass aksrhyborjojo TRUE FALSE TRUE FALSE FALSE S4303398H Tester8 tester8@ one 98888888 Pass 7txzw1fk3xn' TRUE TRUE FALSE TRUE TRUE T59398341 Tester9 tester9@ one 91010101 Citizen zw51kaapvd FALSE TRUE FALSE FALSE FALSE S5068473J Tester10 tester110@c 91212121 Citizen uOxi5mssq94 TRUE FALSE TRUE TRUE TRUEGov Agent Private Company CPF DBS HDB FairPrice TP