df is a data frame consisting of one variable (iso3 codes) such as USA RUS ARG BGD ITA FRA Some of these iso3 codes are repeated and I would like the corresponding continent name, the countrycode package does not seem to distinguish between North and South America. Thanks. Sincerely, Milu On Thu, Sep 7, 2017 at 9:00 PM, David Winsemius <dwinsemius at comcast.net> wrote:> > > On Sep 7, 2017, at 11:36 AM, Miluji Sb <milujisb at gmail.com> wrote: > > > > Dear all. > > > > Is it possible to convert.identify iso3 country names to the seven > > continent names? > > > > # Asia, Africa, Antarctica, Australia, Europe, South America, and North > > America, > > > > I have tried the following: > > > > ### > > region <- merge(countryExData,df,by.x='ISO3V10',by.y='iso3') > > > > where df is the name of my dataset with iso3 the identification variable > > but there seems to be a a lot of missing values. > > Please provide a sufficient amount of the dataframe named `df` to allow a > properly tested response. > > > > > [[alternative HTML version deleted]] > > And do read the Posting Guide. This is a plain text mailing list. > > > > ______________________________________________ > > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide http://www.R-project.org/ > posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. > > David Winsemius > Alameda, CA, USA > > 'Any technology distinguishable from magic is insufficiently advanced.' > -Gehm's Corollary to Clarke's Third Law > > > > > >[[alternative HTML version deleted]]
> On Sep 7, 2017, at 12:21 PM, Miluji Sb <milujisb at gmail.com> wrote: > > df is a data frame consisting of one variable (iso3 codes) such as > > USA > RUS > ARG > BGD > ITA > FRA > > > Some of these iso3 codes are repeated and I would like the corresponding continent name, the countrycode package does not seem to distinguish between North and South America. Thanks.Well it does actually: There are two different region codes: First load the package that has countryExData. I'm presuming this is: library(rworldmap)> table(countryExData$EPI_regions)Central and Eastern Europ East Asia and the Pacific Europe 19 18 24 Latin America and Caribbe Middle East and North Africa North America 24 19 2 South Asia Sub-Saharan Africa 5 38> table(countryExData$GEO_subregion)Arabian Peninsula Australia + New Zealand Caribbean 5 2 5 Central Africa Central Asia Central Europe 6 5 16 Eastern Africa Eastern Europe Mashriq 7 7 4 Meso America North America Northeast Asia 8 2 5 Northern Africa South America South Asia 5 11 6 South East Asia South Pacific Southern Africa 8 3 10 Western Africa Western Europe Western Indian Ocean 13 19 2 Then create the described dataframe: df<- data.frame(iso3=scan(what="") ) 1: USA 2: RUS 3: ARG 4: BGD 5: ITA 6: FRA 7: Read 6 items> region <- merge(countryExData,df,by.x='ISO3V10',by.y='iso3')$EPI_regions> region[1] "Latin America and Caribbe" "South Asia" "Europe" [4] "Europe" "Central and Eastern Europ" "North America" -- David.> > Sincerely, > > Milu > > On Thu, Sep 7, 2017 at 9:00 PM, David Winsemius <dwinsemius at comcast.net> wrote: > > > On Sep 7, 2017, at 11:36 AM, Miluji Sb <milujisb at gmail.com> wrote: > > > > Dear all. > > > > Is it possible to convert.identify iso3 country names to the seven > > continent names? > > > > # Asia, Africa, Antarctica, Australia, Europe, South America, and North > > America, > > > > I have tried the following: > > > > ### > > region <- merge(countryExData,df,by.x='ISO3V10',by.y='iso3') > > > > where df is the name of my dataset with iso3 the identification variable > > but there seems to be a a lot of missing values. > > Please provide a sufficient amount of the dataframe named `df` to allow a properly tested response. > > > > > [[alternative HTML version deleted]] > > And do read the Posting Guide. This is a plain text mailing list. > > > > ______________________________________________ > > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. > > David Winsemius > Alameda, CA, USA > > 'Any technology distinguishable from magic is insufficiently advanced.' -Gehm's Corollary to Clarke's Third Law > > > > > >David Winsemius Alameda, CA, USA 'Any technology distinguishable from magic is insufficiently advanced.' -Gehm's Corollary to Clarke's Third Law
> On Sep 7, 2017, at 12:56 PM, David Winsemius <dwinsemius at comcast.net> wrote: > > >> On Sep 7, 2017, at 12:21 PM, Miluji Sb <milujisb at gmail.com> wrote: >> >> df is a data frame consisting of one variable (iso3 codes) such as >> >> USA >> RUS >> ARG >> BGD >> ITA >> FRA >> >> >> Some of these iso3 codes are repeated and I would like the corresponding continent name, the countrycode package does not seem to distinguish between North and South America. Thanks. > > Well it does actually: There are two different region codes: > > First load the package that has countryExData. I'm presuming this is: > > library(rworldmap) > >> table(countryExData$EPI_regions) > > Central and Eastern Europ East Asia and the Pacific Europe > 19 18 24 > Latin America and Caribbe Middle East and North Africa North America > 24 19 2 > South Asia Sub-Saharan Africa > 5 38 >> table(countryExData$GEO_subregion) > > Arabian Peninsula Australia + New Zealand Caribbean > 5 2 5 > Central Africa Central Asia Central Europe > 6 5 16 > Eastern Africa Eastern Europe Mashriq > 7 7 4 > Meso America North America Northeast Asia > 8 2 5 > Northern Africa South America South Asia > 5 11 6 > South East Asia South Pacific Southern Africa > 8 3 10 > Western Africa Western Europe Western Indian Ocean > 13 19 2 > > Then create the described dataframe: > > df<- data.frame(iso3=scan(what="") ) > 1: USA > 2: RUS > 3: ARG > 4: BGD > 5: ITA > 6: FRA > 7: > Read 6 items > > >> region <- merge(countryExData,df,by.x='ISO3V10',by.y='iso3')$EPI_regions > >> region > [1] "Latin America and Caribbe" "South Asia" "Europe" > [4] "Europe" "Central and Eastern Europ" "North America"Looking at that one might wonder about the degree of success. The ordering of the matched results was not determined by the order in the second df-object: merge(countryExData,df,by.x='ISO3V10',by.y='iso3') ISO3V10 Country EPI_regions GEO_subregion Population2005 1 ARG Argentina Latin America and Caribbe South America 38747.2 2 BGD Bangladesh South Asia South Asia 141822.3 3 FRA France Europe Western Europe 60495.5 4 ITA Italy Europe Western Europe 58092.7 5 RUS Russia Central and Eastern Europ Eastern Europe 143201.6 6 USA United States North America North America 298212.9 GDP_capita.MRYA landlock landarea density EPI ENVHEALTH ECOSYSTEM ENVHEALTH.1 AIR_E 1 13652.4 0 2736296.0 1.3 81.8 91.1 72.5 91.1 87.3 2 1916.2 0 136248.1 95.0 58.0 53.6 62.4 53.6 95.7 3 28876.5 0 547106.7 17.9 87.8 99.4 76.2 99.4 95.9 snipped -- David.> -- > David. > >> >> Sincerely, >> >> Milu >> >> On Thu, Sep 7, 2017 at 9:00 PM, David Winsemius <dwinsemius at comcast.net> wrote: >> >>> On Sep 7, 2017, at 11:36 AM, Miluji Sb <milujisb at gmail.com> wrote: >>> >>> Dear all. >>> >>> Is it possible to convert.identify iso3 country names to the seven >>> continent names? >>> >>> # Asia, Africa, Antarctica, Australia, Europe, South America, and North >>> America, >>> >>> I have tried the following: >>> >>> ### >>> region <- merge(countryExData,df,by.x='ISO3V10',by.y='iso3') >>> >>> where df is the name of my dataset with iso3 the identification variable >>> but there seems to be a a lot of missing values. >> >> Please provide a sufficient amount of the dataframe named `df` to allow a properly tested response. >> >>> >>> [[alternative HTML version deleted]] >> >> And do read the Posting Guide. This is a plain text mailing list. >>> >>> ______________________________________________ >>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >>> https://stat.ethz.ch/mailman/listinfo/r-help >>> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >>> and provide commented, minimal, self-contained, reproducible code. >> >> David Winsemius >> Alameda, CA, USA >> >> 'Any technology distinguishable from magic is insufficiently advanced.' -Gehm's Corollary to Clarke's Third Law >> >> >> >> >> >> > > David Winsemius > Alameda, CA, USA > > 'Any technology distinguishable from magic is insufficiently advanced.' -Gehm's Corollary to Clarke's Third Law > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.David Winsemius Alameda, CA, USA 'Any technology distinguishable from magic is insufficiently advanced.' -Gehm's Corollary to Clarke's Third Law