Text-formatted tables of numbers
November 2, 2011
This is a simple Python text formatting project. After searching for this capability for a little while, I decided to write my own as the following requirements seemed to be unique:
- Create a table of numbers from a CSV file
- Control the number of significant figures (significant digits) displayed
- Format numbers with “,” and ” ” like this 123,456.789 123
- Align columns on decimal points–this is best for readability
- Fit the columns automatically based on data and formatting
There are many code snippets that do one part or another of this, but I didn’t find anything that fulfilled all the requirements. So I created couple of simple classes to accomplish the task. One caveat is that the output needs to be displayed in a constant-space font. Some example output:
483,000. | 471.7 | 0.460 6 | 0.000 449 8
966,000. | 943.4 | 0.921 3 | 0.000 899 7
1,449,000. | 1,415. | 1.382 | 0.001 349
1,932,000. | 1,887. | 1.843 | 0.001 799
2,415,000. | 2,358. | 2.303 | 0.002 249
2,898,000. | 2,830. | 2.764 | 0.002 699
3,381,000. | 3,302. | 3.224 | 0.003 149
3,864,000. | 3,773. | 3.685 | 0.003 599
5,796,000. | 5,660. | 5.528 | 0.005 398
7,728,000. | 7,547. | 7.370 | 0.007 197
9,660,000. | 9,434. | 9.213 | 0.008 997
19,320,000. | 18,870. | 18.43 | 0.017 99
38,640,000. | 37,730. | 36.85 | 0.035 99
57,960,000. | 56,600. | 55.28 | 0.053 98
77,280,000. | 75,470. | 73.70 | 0.071 97
96,600,000. | 94,340. | 92.13 | 0.089 97
144,900,000. | 141,500. | 138.2 | 0.134 9
193,200,000. | 188,700. | 184.3 | 0.179 9
289,800,000. | 283,000. | 276.4 | 0.269 9
386,400,000. | 377,300. | 368.5 | 0.359 9
579,600,000. | 566,000. | 552.8 | 0.539 8
772,800,000. | 754,700. | 737.0 | 0.719 7
966,000,000. | 943,400. | 921.3 | 0.899 7
1,159,000,000. | 1,132,000. | 1,106. | 1.080
You can download the code at GitHub: https://github.com/DrSkippy/Text-Format-Table
No comments yet
Skippy Records 