Aggregating data with 2 columns in data.table (r language) -

-

i have table(input):

date         directorname      companyname  rank 2015-08-01   sergey            vino          29 2015-08-02   sergey            vino          42 2015-08-09   sergey            vino          25 2015-08-04   sergey            vino          27 2015-08-05   mike              bolder        29 2015-08-01   mike              bolder        27 2015-08-11   mike              bolder        23 2015-08-09   mike              bolder        30 2015-08-09   jay               bolder        2 2015-08-10   jay               bolder        10 2015-08-11   jay               bolder        31

i want know directorname reached top 30 in rank companyname never reached top 10. output:

    date         directorname      companyname  rank     2015-08-01   sergey            vino          29     2015-08-02   sergey            vino          42     2015-08-09   sergey            vino          25     2015-08-04   sergey            vino          27

thanks help!

we can try in two-step process using data.table. convert 'data.frame' 'data.table' (setdt(df1)), grouped 'companyname' if all 'rank' greater 10 subset data.table (.sd) (in current example gives expected output). in second step, group 'directorname', check if any elements of 'rank' greater 30, subset again.

library(data.table) setdt(df1)[, if(all(rank > 10)) .sd, companyname][, if(any(rank >30)) .sd , directorname]  #   companyname       date directorname rank #1:        vino 2015-08-01       sergey   29 #2:        vino 2015-08-02       sergey   42 #3:        vino 2015-08-09       sergey   25 #4:        vino 2015-08-04       sergey   27

Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati...
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc...
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc...
Read more