Looping through columns and rows to count specific values
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
I have a file with around 27,000 columns and 40,000 rows. I need to count the number of 0.0s in each column and in each row of the data. I have written the following code to count and print the number of 0.0s within each column:
awk 'a[$1]++; ENDfor(i in a) print a[i]" "i' file_name.txt
I tried to integrate the following code:
awk -F, ' for(i=NF; i>=2; --i) printf "%s ", $i; print $1 ' file_name.txt
in order to create a loop where all the 0.0s were counted and printed however I have been unsuccessful and cannot find anything else that helps me to achieve my goal. It is not necessary for me to create an output file for the final numbers.
awk for loop-device
add a comment |Â
up vote
0
down vote
favorite
I have a file with around 27,000 columns and 40,000 rows. I need to count the number of 0.0s in each column and in each row of the data. I have written the following code to count and print the number of 0.0s within each column:
awk 'a[$1]++; ENDfor(i in a) print a[i]" "i' file_name.txt
I tried to integrate the following code:
awk -F, ' for(i=NF; i>=2; --i) printf "%s ", $i; print $1 ' file_name.txt
in order to create a loop where all the 0.0s were counted and printed however I have been unsuccessful and cannot find anything else that helps me to achieve my goal. It is not necessary for me to create an output file for the final numbers.
awk for loop-device
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a file with around 27,000 columns and 40,000 rows. I need to count the number of 0.0s in each column and in each row of the data. I have written the following code to count and print the number of 0.0s within each column:
awk 'a[$1]++; ENDfor(i in a) print a[i]" "i' file_name.txt
I tried to integrate the following code:
awk -F, ' for(i=NF; i>=2; --i) printf "%s ", $i; print $1 ' file_name.txt
in order to create a loop where all the 0.0s were counted and printed however I have been unsuccessful and cannot find anything else that helps me to achieve my goal. It is not necessary for me to create an output file for the final numbers.
awk for loop-device
I have a file with around 27,000 columns and 40,000 rows. I need to count the number of 0.0s in each column and in each row of the data. I have written the following code to count and print the number of 0.0s within each column:
awk 'a[$1]++; ENDfor(i in a) print a[i]" "i' file_name.txt
I tried to integrate the following code:
awk -F, ' for(i=NF; i>=2; --i) printf "%s ", $i; print $1 ' file_name.txt
in order to create a loop where all the 0.0s were counted and printed however I have been unsuccessful and cannot find anything else that helps me to achieve my goal. It is not necessary for me to create an output file for the final numbers.
awk for loop-device
awk for loop-device
asked 1 min ago
Danielle
83
83
add a comment |Â
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f477405%2flooping-through-columns-and-rows-to-count-specific-values%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password