Entering edit mode
22 months ago
Sidra
•
0
We have transposed our data according to our requirement. that is also attached in this post. now we have duplicate words in each cell of our output file. please suggest me any unix, python, rstudio or excel based tool to remove these duplicates within a single attempt because we have a huge data of 1510 isolates and we cannot delete duplicates one by one from each cell.
DATA:
aminocoumarin aminoglycoside carbapenam cephalosporin cephamycin fluoroquinolone glycylcycline macrolide monobactam nitroimidazole penam peptide phenicol rifamycin tetracycline triclosan
aminocoumarin aminoglycoside carbapenam cephalosporin cephamycin fluoroquinolone glycylcycline macrolide monobactam nitroimidazole penam peptide phenicol rifamycin tetracycline triclosan
aminocoumarin aminoglycoside peptide fluoroquinolone macrolide penam carbapenam cephalosporin cephamycin glycylcycline monobactam phenicol rifamycin tetracycline triclosan nitroimidazole