| User: editor -- 2011-02-28 << 727 729 >> |
| Hits: 1893 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| How to calculate the percentage of the number in the column1? |
| Input Sample: |
38,27,96
39,55,39
42,66,18 |
| Output Sample: |
38,27,96,23.60%
39,55,39,29.32%
42,66,18,33.33%
|
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
|
1. ctrl-o open source text/csv file
2. ctrl-h open 'replace' window
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:
3. click 'replace', done.
4. ctrl-s save to file. |
Screenshot 1: Replace_Window
|
|
Similar Examples: |
How to calculate the average of numbers of one column? (85%)
How to calculate the average of the numbers in the same column? (84%)
How to calculate the sum of the numbers in the same column? (76%)
How to calculate sum value of every column? (68%)
How to calculate the absolute average value of every 2 columns? (67%)
How to calculate the average of all numbers that preceded by dollar sign? (63%)
How to count the number of non-empty columns? (62%)
How to calculate the summary of all numbers in multiple files? (60%)
|
|
Check Demo of Text data calculation |
| Keywords: |
| 110 calculate tag calculation calcu calculat 100 csv data calc replace with data data replace unit number pattern number with number replace number file number replace pattern |