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
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.
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.
when sharing snippets using some service such as https://gist.github.com/ might help you retain content's readability
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
