Create a Python script

have a csv files. The file consists of json format text.
I would like to extract extract each unique ‘id’ and its corresponding ‘name’

Example :
[{'id': '24256d23-51f9-506e-8002-173dace95c66', 'name': 'Unknown_AccountsWithoutPID', 'slug': 'unknowna-b-c-dcom', 'businessUnit': '', 'riskProfile': {'businessImpact': 'MBI'}}, {'id': '72050ca4-1ceb-556d-b6b8-4a1012e4a274', 'name': 'PID-13243-Platform a-b-c-d - Gen2 Azure', 'slug': 'pid13243platform-a-b-c-d-gen2-azure', 'businessUnit': '', 'riskProfile': {'businessImpact': 'MBI'}}, {'id': '19171113-4f4e-5dc0-90ba-1e18d949c117', 'name': 'Dep-ClientTech', 'slug': 'depclienttech', 'businessUnit': '', 'riskProfile': {'businessImpact': 'HBI'}}, {'id': 'a564b913-a828-583d-bffa-fde53459b4a5', 'name': 'Azure Cloud Infrastructure', 'slug': 'azure-cloud-infrastructure', 'businessUnit': '', 'riskProfile': {'businessImpact': 'MBI'}}]


ID Name
24256d23-51f9-506e-8002-173dace95c66 Unknown_AccountsWithoutPID
72050ca4-1ceb-556d-b6b8-4a1012e4a274 PID-13243-Platform a-b-c-d - Gen2 Azure
19171113-4f4e-5dc0-90ba-1e18d949c117 Dep-ClientTech
a564b913-a828-583d-bffa-fde53459b4a5 Azure Cloud Infrastructure

Next, extract the numbers after ‘PID-‘ and save it in a new column:

ID Name PID values
24256d23-51f9-506e-8002-173dace95c66 Unknown_AccountsWithoutPID
72050ca4-1ceb-556d-b6b8-4a1012e4a274 PID-13243-Platform a-b-c-d - Gen2 Azure 13243
19171113-4f4e-5dc0-90ba-1e18d949c117 Dep-ClientTech
a564b913-a828-583d-bffa-fde53459b4a5 Azure Cloud Infrastructure