r - Concatenate Column Strings based on an Integer -

-

i want create strings shown below date first elected, example.

df:

name         party       firstelected bob         liberal      1985 joe         republican   1985 sarah        green       1980 bill       libertarian   1980 tom       conservative   1987

goal:

year            peopleelected 1985   "bob (liberal); joe (republican)" 1980   "sarah (green); bill (libertarian)" 1987   "tom (conservative)"

i assume combination of paste , apply/aggregate can this...but haven't had luck far.

we can use paste/sprintf create format grouped 'firstelected'. convert 'data.frame' 'data.table' (setdt(df1)), grouped 'firstelected', wrap 'party' parentheses, concatenate 'name' using sprintf, use paste, collapse='; ' create single string.

library(data.table) setdt(df1)[,list(peopleelected=paste(sprintf('%s (%s)',                 name, party), collapse="; ")) , = firstelected] #   firstelected                     peopleelected #1:         1985   bob (liberal); joe (republican) #2:         1980 sarah (green); bill (libertarian) #3:         1987                tom (conservative)

or using single paste

setdt(df1)[, list(peopleelected=paste(name, ' (', party, ')',            sep='', collapse='; ')) , by=firstelected]

Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

c# - Get rid of xmlns attribute when adding node to existing xml -

-
i have xml-file: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:d>some content</d> </a> </root> i need add new node in specific place, code is: var doc = xdocument.load(file); xnamespace ns2 = "namespace"; doc.element(ns2 + "root").element(ns2 + "a").element(ns2 + "c").addafterself( new xelement(ns2+"new", new xelement("new1", new xelement("new2","some content"), new xelement("new3", "some content")))); the output is: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:new> <new1 xmlns=""> <new2>some content</new2> ...
Read more