Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with Google      Sign In   
  • Create Account

Submit your paper to J Biol Methods today!
Photo
- - - - -

Question regarding listing the shared values across multiple columns


  • Please log in to reply
3 replies to this topic

#1 mohsamir1984

mohsamir1984

    member

  • Active Members
  • Pip
  • 11 posts
0
Neutral

Posted 18 December 2018 - 02:36 PM

Dear All, 

I have a set of 20 column, each contains number value. I would like to have a function in excel or in r or somewhere else to extract the shared values among all the columns. 

Several of the online Venn tools can visualize and list among up to 6 columns. 

 

Any tool? 

 

Thanks 



#2 bob1

bob1

    Thelymitra pulchella

  • Global Moderators
  • PipPipPipPipPipPipPipPipPipPip
  • 6,668 posts
565
Excellent

Posted 19 December 2018 - 07:01 AM

I doubt that excel will do this. R has a command:

unique()

 that identifies and extracts all the unique values. You could use this in a logical vector to do something like 

duplicates <- data != unique(x, ...)

It is hard to test this sort of thing without a dataset to work on. I very strongly recommend asking on stackoverflow.com too - if you can show some sort of working and a basic data set then they are usually very responsive (within minutes) and know much more about r and similar programs than me.



#3 mohsamir1984

mohsamir1984

    member

  • Active Members
  • Pip
  • 11 posts
0
Neutral

Posted 19 December 2018 - 12:47 PM

Thank you anyhow on your effort and advice. Could you just comment on what is the )X, .. ,,, what is X actually refers to ?



#4 bob1

bob1

    Thelymitra pulchella

  • Global Moderators
  • PipPipPipPipPipPipPipPipPipPip
  • 6,668 posts
565
Excellent

Posted 19 December 2018 - 02:47 PM

Sorry, x should have read data - the name of your data frame that you have read into R.

 

If you are using R I would recommend checking out the documentation for the command by typing into your console:

?unique

This should give you and explanation of how to use the command.






Home - About - Terms of Service - Privacy - Contact Us

©1999-2013 Protocol Online, All rights reserved.