This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Sum of the column of the CSV file

I have a CSV file like below and I want to sum the columns 2 and column 3 and write the total at the end of the column as below:

Here is my file:

read,match,not_match
    human_file_0000003,5,2
    human_file_0000004,6,0
    human_file_0000005,6,9
    human_file_0000006,4,0
    human_file_0000007,2,0
    human_file_0000008,5,0
    human_file_0000009,3,0

And I want to output my file like below:

read,match,not_match
        human_file_0000003,5,2
        human_file_0000004,6,0
        human_file_0000005,6,9
        human_file_0000006,4,0
        human_file_0000007,2,0
        human_file_0000008,5,0
        human_file_0000009,3,0
                           31,11

In which you can see column 2 total is 31 and column 3 total is 11. Thanks in advance for your suggestion. I search for it but I can't find any solution for that.

csv sum
• 2,241 views • link
updated by Pierre Lindenbaum Pierre Lindenbaum • written by harry • harry

In that, they add column 2 and column 3. Here I want to separate the sum of the total in column 2 and the separate sum of the total in column 3.

• 0 views • link
written by harry • harry

1 answer

https://stackoverflow.com/a/28905692/58082

• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

Log in to answer this question.

More posts like this
  • command to make a coordinate file from the header
    written by harry • harry
    I have one file which looks like below: As you can see there is a name after and before pipe(|). From that Isolate coordinate and …
  • command for to know the count of matching and not matching
    written by harry • harry
    I have a file in which two-column present one is read and the other is circBase. read circBase hsa_circ_0000160 hsa_circ_0000160 hsa_circ_0000160 hsa_circ_0000160 hsa_circ_0000175 hsa_circ_0000175 hsa_circ_0000175 …
  • How do you add gene annotations from a Diamond Blastx tsv file to a csv file with RNAseq differenti…
    written by kristina.mahan kristina.mahan
    I have a Diamond BLASTx tsv file that has the Gene_Descriptions: ![Diamond BLASTx gene annotations][1] I have a csv file of the RNAseq expression data: …
  • Join two files by matching columns
    written by er.doug.ragnar • er.doug.ragnar
    Hi I am trying to join two files, one has 4 columns the other 3. I want to match the third column of the first …
  • Script for making exon file
    written by harry • harry
    Hi everyone, I have an exon.fasta file which looks like --- >ENSE00002234944 TTAACTTGCCGTCAGCCTTTTCTTTGACCTCTTCTTTCTGTTCATGTGTATTTGCTGTCTCTTAGCCCAGACTTCCCGTGTCCTTTCCACCGGGCCTTTGAGAGGTCACAGGGTCTTGATGCTGTGGTCTTCATCTGCAGGTGTCTGACTTCCAGCAACTGC TGGCCTGTGCCAGGGTGCAAGCTGAGCACTGGAGTGGAGTTTTCCTGTGGAGAGGAGCCATGCCTAGAGTGGGATGGGCCATTGTTCATCTTCTGGCCCCTGTTGTCTGCATGTAACTTAATACCACAACCAGGCATAGGGGAAAGATTGGAGGAAAGATGA GTGAGAGCATCAACTTCTCTCACAACCTAGGCCA >ENSE00001746346 CAGGGCCATCAGGCACCAAAGGGATTCTGCCAGCATAGTGCTCCTGGACCAGTGATACACCCGGCACCCTGTCCTGGACACGCTGTTGGCCTGGATCTGAGCCCTGGTGGAGGTCAAAGCCACCTTTGGTTCTGCCATTGCTGCTGTGTGGAA >ENSE00002312635 CAGGGCCATCAGGCACCAAAGGGATTCTGCCAGCATAGTGCTCCTGGACCAGTGATACACCCGGCACCCTGTCCTGGACACGCTGTTGGCCTGGATCTGAGCCCTGGTGGAGGTCAAAGCCACCTTTGGTTCTGCCATTGCTGCTGTGTGGAAGTTCACTCC TGCCTTTTCCTTTCCCTAGAGCCTCCACCACCCCGAGATCACATTTCTCACTGCCTTTTGTCTGCCCAGTTTCACCAGAAGTAGGCCTCTTCCTGACAGGCAGCTGCACCACTGCCTGGCGCTGTGCCCTTCCTTTGCTCTGCCCGCTGGAGACGGTGTTTG TCATGGGCCTGGTCTGCAGGGATCCTGCTACAAAGGTGAAACCCAGGAGAGTGTGGAGTCCAGAGTGTTGCCAGGACCCAGGCACAGGCATTAGTGCCCGTTGGAGAAAACAGGGGAATCCCGAAGAAATGGTGGGTCCTGGCCATCCGTGAGATCTTCCCA GGGCAGCTCCCCTCTGTGGAATCCAATCTGTCTTCCATCCTGCGTGGCCGAGGGCCAGGCTTCTCACTGGGCCTCTGCAGGAGGCTGCCATTTGTCCTGCCCACCTTCTTAGAAGCGAGACGGAGCAGACCCATCTGCTACTGCCCTTTCTATAATAACTAA AGTTAGCTGCCCTGGACTATTCACCCCCTAGTCTCAATTTAAGAAGATCCCCATGGCCACAGGGCCCCTGCCTGGGGGCTTGTCACCTCCCCCACCTTCTTCCTGAGTCATTCCTGCAGCCTTGCTCCCTAACCTGCCCCACAGCCTTGCCTGGATTTCTAT CTCCCTGGCTTGGTGCCAGTTCCTCCAAGTCGATGGCACCTCCCTCCCTCTCAACCACTTGAGCAAACTCCAAGACATCTTCTACCCCAACACCAGCAATTGTGCCAAGGGCCATTAGGCTCTCAGCATGACTATTTTTAGAGACCCCGTGTCTGTCACTGA AACCTTTTTTGTGGGAGACTATTCCTCCCATCTGCAACAGCTGCCCCTGCTGACTGCCCTTCTCTCCTCCCTCTCATCCCAGAGAAACAGGTCAGCTGGGAGCTTCTGCCCCCACTGCCTAGGGACCAACAGGGGCAGGAGGCAGTCACTGACCCCGAGACG …
  • grep multiple lines form file
    written by harry • harry
    I have one output.txt file in which there are 20000 strings. see below it looks like that. It is genome coordinate file. X:10063445|10067490 X:10063445|10079804 X:10063445|10098579 …
  • How to match elements of a row to elements of a column in rstudio
    written by RVRLibra • RVRLibra
    I want to match the columnname "Name" from dataframe List to the Rowname of dataframe "Volume" and perform calculation on the columns. Can I use …
  • Match the three columns in 2 annotation files and print those lines to a new output file
    written by saamar.rajput saamar.rajput
    I have 2 files, file 1 and file 2 with the same column numbers, column one has the chromosome number, column two has the promoter …
  • counts frequency of values in multiple columns in a text files
    written by Kumar Kumar
    Hi I have a multiple columns text file, I need to count frequency of zero and greater then zero in `[2]`,`[3]`,`[4]`,`[5]` columns distinctly. Program script …
  • counts rows with numbers in columns
    written by Kumar Kumar
    Hi I have a multiple column text file, I need to count rows those have only numbers (1....100) in columns [2], [3], [4], [5], else …