Create map for all countries

[Tilmon]

Dear @kalashsinghal ,

after completion of 2DegreesInvesting/tiltPlot/issues/128 , please also create the map for all 4 other countries :)

THanks!

[Tilmon]

Hi @kalashsinghal and @AnneSchoenauer we talked about the problem that some of the postcodes from our NUTS-postcode mapper are only possible to be matched to NUTS 2-digit (i.e. country name) (via mappers from this comment).

I reviewed the file that @kalashsinghal provided me, containing 639 companies with only 2-digit NUTS codes. There is not the one reason, but rather multiple different reasons:

• I think in some cases the postcodes are simply wrong
• In other cases postcodes are outdated (I can find them in the internet, but they are e.g. not on Google Maps)
• And in other cases, the postcodes are missing the right format. This is the case for NL, where postcodes consist of 4 numbers and 2 digits e.g. "1034 PX". It seems that our company data often lack the two letters and also, the mapper that you used @kalashsinghal also misses these 2 letters, even though they are in the original EU file.

Now 3 ideas for a way forward:

1. Only 640 companies are affected. This is a very small share, we could ignore it.
2. Check if there are updated postcode company data from Sohail's last webscraping. But this would cause probably a lot of work.
3. Explore at least for NL why the postcodes we have in our database have the wrong structure, are missing the two letters at the end.

I would suggest to either do 1. or 3. I am a bit surprised that the postcode issue for NL still persists, we've been tackling this a long time ago. But I also remember that at some point we paused the work on it because there was no perfect solution... @kalashsinghal just to not miss out a bigger problem, where can I find the dataset with all companies and their corresponding postcodes? Would like to check out our company data...

To not forget it in case this becomes relevant at a later stage: THis is the excel Kalash shared with only the relevant columns and a few comments in the two right-hand side columns with explanations on why the mapping may not have worked (no need to look at it for the sake of this discussion for now). two_letter_NUTS_all_cases_tt_explanations.xlsx

[kalashsinghal]

Hi @Tilmon, Thanks for your insights! You can find all companies with its postcodes in ep_companies.csv file, which can be downloaded using this link.

@AnneSchoenauer Please let us know which option we should follow as next step!