CSV contains two lists with two different formats

[dwaam]

Hi,

There is an issue with the CSV export for resource code-list: Header: Change,Country,Location,Name,NameWoDiacritics,Subdivision,Status,Function,Date,IATA,Coordinates,Remarks for around 61K lines

then a new header appears at line 61396 Change,Country,Location,Name,NameWoDiacritics,Subdivision,Function,Status,Date,IATA,Coordinates,Remarks

Same data but two header are switched.

Is there a way to fix that please?

I see that it is directly the data file which is corrupted: https://raw.githubusercontent.com/datasets/un-locode/refs/heads/main/data/code-list.csv

Thank

[sabas]

Good catch! @gradedSystem please check Thanks

[gradedSystem]

@sabas should be fixed with the latest PR https://github.com/datasets/un-locode/pull/35

[dwaam]

Hi, Thanks for the PR, but I don't think the data is fixed. The second header is removed, but the problem is that two columns are switched, so all the next data should have the two columns switched back no?

[gradedSystem]

Hi @dwaam can you give me an example, cause i didnt seem to get it

[dwaam]

Of course

As you can see here: ,ZW,ZVS,Zvishavane,Zvishavane,MI,RL,--3-----,1207,,2020S 03002E, You have status RL then function --3-----. Then, those two columns are switched ,AO,FBY,Farta Bay,Farta Bay,,1-------,RQ,0901,,1237S 01312E, You have 1------- function, then RQ status

[gradedSystem]

ok now i think i understood @dwaam

[gradedSystem]

@dwaam I added function to fix this issue raised a PR waiting for an approve

[dwaam]

Alright thanks, yep, now the data seems all good in the csv thanks ;)