in reply to Re^2: Parsing csv without changing dimension of original file
in thread Parsing csv without changing dimension of original file

Thank you very much for your reply. Here is the original code:

use strict; use warnings; open my $fh, '<', 'kegg_pathway_title.txt' or die $!; my %dict = map { chomp; split ' ', $_, 2 } <$fh>; my $re = join '|', keys %dict; open $fh, '<', 'Orthogroups_3.csv' or die $!; while (<$fh>) { s/($re)/$dict{$1}/g; print; }

I added the line

next if $. < 2;

because it giving me more column than the original csv. My original csv contains 13 columns. After replacing the content using dictionary it gives me many more column and couldn't load in R. You saw my previous code in loading the file in R. Is there anything I need to do to make it loadable in R. The 2nd column of the dict may contain multiple name. In the original csv the cells also contains single/multiple or no entry. Thanks again for helping me. Best Regards Zillur

Replies are listed 'Best First'.
Re^4: Parsing csv without changing dimension of original file
by huck (Prior) on Mar 06, 2017 at 22:21 UTC