problem with taxa barplot csv file

I download the csv file and when i open it, all the data is in one column and it is not separated per taxa.

1 Like

Excel has an option data -> columns, depending on how they are delimited, you should choose the symbol where they should be and voila. It should be sorted. https://support.office.com/en-us/article/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

As I recall, I think you have to adjust the first row over 1 space. Ben

Thank you for your help!

The data divided per each column, however my titles were lost. I don’t know what is each column

that’s strange - you mean the first row? Ben

It is better if i show you:

1 Like

Haha, that’s so strange, ok - one more favor, let me see what it looks like before you do text to columns. I think you may need to transpose the data. ben

looks like this:

1 Like

you need to make it only comma seperated. semicolon will split the full taxonomic address so it will mix up the columns. i would suggest transposing it because the taxonomical names are much more longer than sample names, so it would be easier to see what you are looking for.

1 Like

Yeah, the table needs to be transposed (x, y) axes need to be switched.

The problem is that your taxonomy is a little weird - not sure why you have random “___” are they all in one cell?

Ben

The ‘__’ is because the taxonomy is : k_bacteria;…g_steptococcus…

The data is all in the first column and except the titles from each column .

could you upload the csv or taxa barplot qzv?

Yes, that wasn’t why I was perplexed. I am wondering why excel decided to delimit one and not the other. Ben

1 Like

I solve this by trying to open the file in another computer.

1 Like

The answer to all of life’s ills. Ben

1 Like

In my philosophy, the answer to all life’s ills is to not use MS Excel when you don’t need to.

@annsantos it sounds like excel is reading the file as semicolon-delimited instead of comma-delimited. There is likely a way to change how excel is reading these files by default, or even explicitly set the delimiter it should use. But unfortunately this boils down to an issue with excel, not an issue with QIIME 2 (which appears to be writing the CSV properly). Glad you could solve by switching to another computer!

2 Likes

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.