Accessing level values (answer codes) in R from Limesurvey export -

-

i'm analysing data limesurvey questionnaire in r. 1 of survey questions asks people country of origin , uses dropdown list of countries. i've created labelset 3-letter iso country code limesurvey answer code , country name label:

labelset iso codes countries

when exporting limesurvey data r, both codes , labels saved r syntax file. codes saved 'level' factor, , label of course used label (abbreviated clarity):

data[, 7] <- as.character(data[, 7]) attributes(data)$variable.labels[7] <- "which country from?" data[, 7] <- factor(data[, 7], levels=c("afg","ala","alb", ..., "zmb","zwe"),labels=c("afghanistan","Åland islands","albania", ..., "zambia","zimbabwe")) names(data)[7] <- "q3_nationality"

however, cannot figure out how access 3-letter iso code in r? great iso code, can feed rworldmap joincountrydata2map() function , plot data on map. (i know can pass country name function, that's more error prone.)

if examine variable, this:

> data$q3_nationality   [1] guyana   249 levels: afghanistan Åland islands albania algeria ... zimbabwe

similarly, levels() gives me:

levels(data$q3_nationality)   [1] "afghanistan"                                    [2] "Åland islands"                                  [3] "albania"                                        [4] "algeria"                                        [5] "american samoa"

no sign of "afg", "ala", "alb" iso answer codes.

trying convert character, gives me full label again:

as.character(levels(data$q3_nationality))   [1] "afghanistan"                                    [2] "Åland islands"                                  [3] "albania"                                        [4] "algeria"                                        [5] "american samoa"

it great if tell me how access these!

i propose dirty solution in way, edit r-syntax-file , set levels labels well. however, if want use full names countries later on printing or plotting, have transform then. can use code syntax file in code, maybe on copy printing.


Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea
Read more

c# - two queries in same method -

-
i trying execute 2 queries in same method gives me exception. can red of exception declaring new command there way use same command? string id="hi"; connection.open(); oledbcommand command1 = new oledbcommand(); command1.connection = connection; string query1 = "select * products category='" + combobox1.text + "' , subcategory = '" + combobox2.text + "' , sizes='" + combobox3.text + "'"; command1.commandtext = query1; oledbdatareader reader = command1.executereader(); while (reader.read()) { id = reader[0].tostring(); } textbox1.text = id; string query = "insert category_in (category_id,amount,amount_in) values ('"+ id+"' ,500,300)"; command1.commandtext = query; command1.executenonquery(); messagebox.show("saved"); connection.close();
Read more