Photo by Sergey Shmidt on Unsplash
This post is following of above post.
In the previous post, I read OECD Doctors' consultation data in R. But we don't know what LOCATION is what country. So I will add those information.
First, I load ISO country data from
https://raw.githubusercontent.com/lukes/ISO-3166-Countries-with-Regional-Codes/master/all/all.csv
We only need name(which is contry name), alpha-3(which is equivalnet to LOCATION of df), region and sub-region. So, I use select() function to selct only them.
I change alpha-3 to LOCATION and sub-region to sub_region.
Using inner_join(), I merge df and name_code
And I changed region and sub_region to factor from character.
All right, now I have good data frame:df to analyze.
That's it. Thank you!
Next post is
To read the 1st post,
