Transverse data
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
2 answers
• 0 views
•
link
written
by
mohammadhassanj
Sounds like you’ve got a data party going on—too many duplicates crashing it! If you need a quick fix for those pesky repeats, maybe check out this tool that handles duplicates in Excel like a champ. Just saying, it could save you some sanity! Remove Duplicates Excel https://removeduplicatesexcel.net
Log in to answer this question.