Transverse data
1
0
Entering edit mode
15 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
EXCEL Unix • 439 views
ADD COMMENT
0
Entering edit mode
ADD COMMENT

Login before adding your answer.

Traffic: 3290 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6