# Qiime metadata tabulate error **URL:** \ **Category:** User Support\ **Tags:** tabulate, metadata\ **Created:** [September 28, 2019, 11:18pm UTC](https://forum.qiime2.org/t/qiime-metadata-tabulate-error/11723 "2019-09-28T23:18:03Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![amoltej](https://forum.qiime2.org/user_avatar/forum.qiime2.org/amoltej/32/5817_2.png) [@amoltej](https://forum.qiime2.org/u/amoltej)\ **Post date:** [September 28, 2019, 11:18pm UTC](https://forum.qiime2.org/t/qiime-metadata-tabulate-error/11723/1 "2019-09-28T23:18:03Z")
I created txonomy.qza by running qiime feature-classifier classify-sklearn command thne I tried running following command - > qiime metadata tabulate > --m-input-file taxonomy.qza > --o-visualization taxonomy I got following debug information - > Traceback (most recent call last): > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/q2cli/click/type.py", line 170, in \_convert\_metadata > metadata = artifact.view(qiime2.Metadata) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/sdk/result.py", line 277, in view > return self.\_view(view\_type) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/sdk/result.py", line 289, in \_view > result = transformation(self.\_archiver.data\_dir) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/core/transform.py", line 70, in transformation > new\_view = transformer(view) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/core/transform.py", line 213, in wrapped > return transformer(view.file.view(self.\_wrapped\_view\_type)) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/q2\_types/feature\_data/\_transformer.py", line 194, in \_29 > return qiime2.Metadata(df) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/metadata/metadata.py", line 364, in **init** > self.\_dataframe, self.\_columns = self.\_normalize\_dataframe(dataframe) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/metadata/metadata.py", line 372, in \_normalize\_dataframe > metadata\_column = self.\_metadata\_column\_factory(series) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/metadata/metadata.py", line 384, in \_metadata\_column\_factory > column = CategoricalMetadataColumn(series) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/metadata/metadata.py", line 880, in **init** > self.\_series = self._normalize_(series) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/metadata/metadata.py", line 1150, in _normalize_ > return series.apply(normalize, convert\_dtype=False) > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/pandas/core/series.py", line 3591, in apply > mapped = lib.map\_infer(values, f, convert=convert\_dtype) > File "pandas/\_libs/lib.pyx", line 2217, in pandas.\_libs.lib.map\_infer > File "/home/amol2/volume/software/miniconda/miniconda2/envs/qiime2-2019.7/lib/python3.6/site-packages/qiime2/metadata/metadata.py", line 1139, in normalize > "value: %r" % (cls. **name** , series.name, value)) > ValueError: CategoricalMetadataColumn does not support values with leading or trailing whitespace characters. Column 'Taxon' has the following value: 'D\_0\_\_Bacteria;D\_1\_\_Actinobacteria;D\_2\_\_Thermoleophilia;D\_3\_\_Solirubrobacterales;D\_4\_\_67-14;D\_5\_\_uncultured bacterium ' Looking at other posts it looks like a similar problem like [this](https://forum.qiime2.org/t/qiime-taxa-filter-table-error/3947) wonder if it is a bug? I followed steps suggested by @thermokarst and it has worked well, Thanks ---
**Author:** ![Nicholas\_Bokulich](https://forum.qiime2.org/user_avatar/forum.qiime2.org/nicholas_bokulich/32/19937_2.png) [@Nicholas\_Bokulich](https://forum.qiime2.org/u/Nicholas_Bokulich)\ **Post date:** [October 1, 2019, 2:27pm UTC](https://forum.qiime2.org/t/qiime-metadata-tabulate-error/11723/2 "2019-10-01T14:27:37Z")
Thanks @amoltej! Yes this is a bug, as indicated in the topic you linked to, and a bug report has already been issued and linked to in that topic. Glad you were able to work through the workaround provided in that topic! ---
**Author:** ![system](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/3X/2/1/21af5fe23cb6f4579467c66a9ed94e55274ca7bd.svg) [@system](https://forum.qiime2.org/u/system)\ **Post date:** [November 1, 2019, 8:42pm UTC](https://forum.qiime2.org/t/qiime-metadata-tabulate-error/11723/4 "2019-11-01T20:42:49Z")
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.