I have a CSV with census population data and a shapefile with census tracts, a classic example where you would use a table join. For four of the files that i joined, there has been no problem besides poor data quality from the Japanese government (sigh). However for one of my files, the join is not completed, and only the data from one province is properly joined, with the tracts in other provinces not being assigned any new attributes
The problem is not mismatched key-values, as I can manually find the data when searching individual key codes, nor is it a datatype error, as both fields on the CSV and SHP are strings. see photos for more context
Here is a view of the attribute table of the shapefile (2005 Kanto Census tracts) and the CSV (2005 full) As you can see, key codes match up about 1-1 between the two files (with a few exceptions because the Japanese government sucks at making and distributing census data)
On the right is what the features should look like, but instead most of them look like the feature on the left, without any of the population attributes on the bottom
Here is what the log looks like when I run the join. Most of the features are unable to be joined.
Running MacOS Catalina 10.15.7 (19H2026)
Does anyone have any ideas on how to more easily access demographic data for Japan? The datasets given by the government are some of the worst I have ever worked with, but I can't find any other place with age data at the same resolution...
I have been stuck on this for so long.