enter image description here
This is an image of my excel template, I need to retrieve data from it and fill my postgres table which is:
CREATE TABLE public.test (
“Test_Id” int4 NOT NULL,
“Test_Name” text NOT NULL,
“Test_Code” text NULL,
“Test_Description” text NOT NULL,
“Test_Parent_Id” numeric NOT NULL,
“Level_Test_Id” numeric NULL,
“Level_Test_Name” text null
CONSTRAINT "Test_Id_pkey" PRIMARY KEY ("Test_Id")
);
The difference here is that the format of the excel table as showing above, is not matching with the table in the database.
How to write a python code that could fill each column of the database table with the data in the excel file ?
Safa edligo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.