pandas is parsing the entire header row as a single column instead of splitting it into multiple columns

20 hours ago 1
ARTICLE AD BOX

I am trying to read a CSV file into a pandas DataFrame, but pandas is parsing the entire header row as a single column instead of splitting it into multiple columns. I have tried the ascii, utf8 and utf-8-sig encoding.

This file is downloaded from the public domain. URL : https://www.isda.org/protocol/october-2025-benchmark-module-of-the-isda-2021-fallbacks-protocol/adhering-parties ( click: "download latest full list" ) Environment: - Windows, - Python 3.x, - pandas (latest)
Code used:

import pandas as pd file_path = r"C:\\Parties.csv" df = pd.read_csv(file_path, encoding="utf-8-sig") print(df.shape) print(df.columns)

file sample:

"UniqueID,ProtocolName,""Organization Name"",""Organization LEI/CICI"",Country,SubmitDate,AcceptDate,""Adherence Type"",Letter,RevokeDate,RevokeLink,""Option 1"",""Option 2"",""Company Name Update"",""Company Name Change Letter URL""" "PR_2025_02_1147136,""April 2025 Benchmark Module of the ISDA 2021 Fallbacks Protocol"",""Absa Bank Limited"",SLI1CVYMJ21DST0Q8K25,""South Africa"",""Aug 14 2025 08:48 am"",""Aug 14 2025 01:23 pm"",""Single Entity Adherence"",http://www2.isda.org/functional-areas/protocol-management/protocol-adherence-letter/1147136,,,,,," "PR_2025_02_1145547,""April 2025 Benchmark Module of the ISDA 2021 Fallbacks Protocol"",""BSI Finco (Bermuda) Limited"",549300APU0U9X6UT9J31,Canada,""Jul 18 2025 02:47 pm"",""Jul 18 2025 07:14 pm"",""Single Entity Adherence"",http://www2.isda.org/functional-areas/protocol-management/protocol-adherence-letter/1145547,,,,,,"

when i print the columns, the output is

Index(['UniqueID,ProtocolName,"Organization Name","Organization LEI/CICI",Country,SubmitDate,AcceptDate,"Adherence Type",Letter,RevokeDate,RevokeLink,"Option 1","Option 2","Company Name Update","Company Name Change Letter URL"'], dtype='object')
Read Entire Article