Entering edit mode
2.9 years ago
mumdooh
•
0
I am still learning python language. I have a table in csv format with n columns where the header is Tax_id and every column contains species names like this
9606 9606.1 508771
0 root root root
1 cellular organisms cellular organisms cellular organisms
2 Eukaryota Eukaryota Eukaryota
3 Opisthokonta Opisthokonta Sar
4 Metazoa Metazoa Alveolata
5 Eumetazoa Eumetazoa Apicomplexa
6 Bilateria Bilateria Conoidasida
7 Deuterostomia Deuterostomia Coccidia
8 Chordata Chordata Eucoccidiorida
9 Craniata Craniata Eimeriorina
I am struggling to write a python code that counts each species with their occurrence only for columns that contains species named "Metazoa".
#to return something like
Eumetazoa 2
Bilateria 2
Craniata 2