Question: Need help with "Compare two Datasets" tool
1
gravatar for aglassing
3.9 years ago by
aglassing10
United States
aglassing10 wrote:

When I execute this function it will only process the first 18 columns of the data sheet and I lose all the rest of the columns of data in the final analysis that it gives me. How do I get it to process and return all the columns of data?


 

Tool name: Compare two Datasets
Tool version: 1.0.2
Tool ID: comp1

 

compare-two-datasets • 1.2k views
ADD COMMENTlink modified 3.9 years ago • written 3.9 years ago by aglassing10
1
gravatar for nitesh.turaga
3.9 years ago by
nitesh.turaga100
United States
nitesh.turaga100 wrote:

Could you maybe give me a sample set of your data? Only the first 5 rows of each dataset, but all the columns. That way, I can test it out and try to debug it.

Edit: The reason I ask is because when I test the tool with a couple of dummy csv files, it seems to work fine for me. 

ADD COMMENTlink modified 3.9 years ago • written 3.9 years ago by nitesh.turaga100
0
gravatar for aglassing
3.9 years ago by
aglassing10
United States
aglassing10 wrote:

 Data set 5

BB 37.B 38.B 39.B 40.B 41.B 42.B 43.B 44.B TT01.B TT02.B TT03.B TT04.B TT05.B RC.B AG.B

mogibacterium pumilum

 

 

 

 

1

1

1

1

 

164

2

5

1

 

 

 

mogibacterium pumilum

1

1

 

3

4

1

1

 

 

 

 

 

 

 

 

4

 

5

corynebacterium vitaeruminis

 

1

 

 

 

 

 

9

 

 

 

 

 

 

270

 

corynebacterium vitaeruminis

 

 

1

 

5

 

 

 

4

 

 

 

 

 

 

 

 

 

streptococcus genomosp. c3

 

 

 

 

 

 

 

 

 

2

 

 

 

 

 

 

streptococcus genomosp. c3

 

 

 

 

 

 

 

 

1

1

5

1

1

 

 

 

 

 

eikenella corrodens

 

 

 

 

 

 

 

 

 

 

 

3

 

 

 

 

eikenella corrodens

 

 

 

 

 

1

 

 

1

 

 

 

 

 

 

 

 

1

 Data set 6

01.B 02.B 03.B 04.B 05.B 08.B 09.B 20.B 21.B 22.B 24.B 27.B 30.B 31.B 32.B 34B 35B 36B

turicibacter spp.

 

 

 

 

 

 

 

 

 

 

 

 

 

1

 

 

 

 

turicibacter spp.

 

1

 

 

 

1

 

 

 

 

 

 

1

 

 

 

corynebacterium macginleyi 2

klebsiella oxytoca 1 1 1 1

enterococcus faecium mother c4 2

I'm not sure if this is the way you need me to post the data, I'm new at using this site, but I'm trying to compare these two datasets and find the common rows. The rows are not in a specific order and there are over 300 rows so comparing these two probably won't work because they don't have any common rows in the these first 5. The problem I have is that when it does return the common rows I lose all the columns past 18 and I'm not sure why it won't return all 36 rows. 

Thanks for your help, let me know if you need any more information from me.

ADD COMMENTlink modified 3.9 years ago by Martin Čech ♦♦ 4.9k • written 3.9 years ago by aglassing10
1

when sharing snippets using some service such as https://gist.github.com/ might help you retain content's readability

ADD REPLYlink written 3.9 years ago by Martin Čech ♦♦ 4.9k
1

Yes, in order for me to use your datasets and try and reproduce the error, please try to maintain content readability. Another way, is to just use a public link on dropbox, where I can just access the snippet in a txt file. 

 

Or if you are on galaxy main, just share via galaxy, https://wiki.galaxyproject.org/Learn/Share

ADD REPLYlink modified 3.9 years ago • written 3.9 years ago by nitesh.turaga100
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 167 users visited in the last hour