TypeError: unsupported operand type(s) for +: 'int' and 'str' in basic_stats_reads()

[onurdogan]

Hi,

I am running taxontabletools2 with my taxon_table file and encountered the following error:

TypeError: unsupported operand type(s) for +: 'int' and 'str'

File "/opt/miniconda3/envs/TTT2/lib/python3.12/site-packages/taxontabletools2/taxontabletools_2.0.py", line 3861, in <module>
    basic_stats_reads()
File "/opt/miniconda3/envs/TTT2/lib/python3.12/site-packages/taxontabletools2/taxontabletools_2.0.py", line 648, in basic_stats_reads
    y_values = {i:sum([j for j in df_taxon_table[i].values.tolist() if j != 0]) for i in samples}
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

All sample values in my Excel sheet are integers.

Thank you!

[TillMacher]

I tried to reproduce your error and it seems like at least one of your samples has a non-numeric value in its reads.
Could you try and verify this? Also "nan" values (i.e., empty cells) will cause this error.

[onurdogan]

Hi,

Thank you for your previous response.

I carefully checked my Taxon Table and all read counts in the sample columns are integers.
I also verified that there are no visible strings, "nan" values, or empty cells in the sample columns.

The columns in my Taxon Table are:

Hash, unique ID_y, Kingdom, Phylum, Class, Order, Family, Genus, Species, Similarity, Status, Ambiguous taxa, Flag, Evalue, Seq, NC_S4_L004_R1, RH1_S1_L004_R1, RH2_S2_L004_R1, RH3_S3_L004_R1

Example of the read counts:

NC_S4_L004_R1  RH1_S1_L004_R1  RH2_S2_L004_R1  RH3_S3_L004_R1  
0              13873           9617            10785  
1              123             13846           913  
0              1453            2392            6923  

I also tried the following steps:

• Copying the entire table into a new Excel file using Paste Values
• Checking for hidden empty cells
• Ensuring all sample columns contain numeric values
• Converting sample columns to integers using pandas

Despite these checks, the following error still occurs:

TypeError: unsupported operand type(s) for +: 'int' and 'str'

File "/opt/miniconda3/envs/TTT2/lib/python3.12/site-packages/taxontabletools2/taxontabletools_2.0.py", line 3861, in <module>
    basic_stats_reads()
File "/opt/miniconda3/envs/TTT2/lib/python3.12/site-packages/taxontabletools2/taxontabletools_2.0.py", line 648, in basic_stats_reads
    y_values = {i:sum([j for j in df_taxon_table[i].values.tolist() if j != 0]) for i in samples}
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Thank you for your help.