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:
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')