Help ·15 Jun 2021, 00:57· edited less than a minute later·3
Hi All,
When I was checking the data, I could see LGA being duplicated in the NigerianStateNames.csv. One LGA has more than one state. Please advice which is the correct value.
They are not duplicates as you can see from the following wikipedia links. They correspond to different regions in Nigeria having the same name, at the exception of Nasarawa, which only exists in Nasarawa State. In Kano State, it is Nassarawa:
'/%3e%3cuse xlink:href='%23a' transform='translate(288.889 -214.211)'/%3e%3cuse xlink:href='%23a' transform='translate(108 342.749)'/%3e%3cuse xlink:href='%23a' transform='translate(469.189 342.749)'/%3e%3c/svg%3e)
Hi can you please specify which LGA had more than one state
Upon value counts on the dataframe: (NigerianState.csv)
Ifelodun 2
Surulere 2
Obi 2
Irepodun 2
Nasarawa 2
Hi!
They are not duplicates as you can see from the following wikipedia links. They correspond to different regions in Nigeria having the same name, at the exception of Nasarawa, which only exists in Nasarawa State. In Kano State, it is Nassarawa:
https://en.wikipedia.org/wiki/Bassa,_Kogi_State
https://en.wikipedia.org/wiki/Bassa,_Plateau_State
https://en.wikipedia.org/wiki/Ifelodun,_Kwara
https://en.wikipedia.org/wiki/Ifelodun,_Osun_State
https://en.wikipedia.org/wiki/Irepodun,_Osun
https://en.wikipedia.org/wiki/Irepodun,_Kwara
https://en.wikipedia.org/wiki/Nasarawa_State
https://en.wikipedia.org/wiki/Kano_State
https://en.wikipedia.org/wiki/Surulere,_Oyo_State
https://en.wikipedia.org/wiki/Surulere
https://en.wikipedia.org/wiki/Obi,_Nigeria
https://en.wikipedia.org/wiki/Obi,_Nasarawa_State