4.4.1. Using CSV as a tabular data source

4.4.1.1. from CSV text

Sample Code:

Write a table from CSV text

from textwrap import dedent
import pytablewriter


def main():
    writer = pytablewriter.MarkdownTableWriter()
    writer.from_csv(dedent("""\
        "i","f","c","if","ifc","bool","inf","nan","mix_num","time"
        1,1.10,"aa",1.0,"1",True,Infinity,NaN,1,"2017-01-01 00:00:00+09:00"
        2,2.20,"bbb",2.2,"2.2",False,Infinity,NaN,Infinity,"2017-01-02 03:04:05+09:00"
        3,3.33,"cccc",-3.0,"ccc",True,Infinity,NaN,NaN,"2017-01-01 00:00:00+09:00"
        """))
    writer.write_table()

if __name__ == "__main__":
    main()

Output:

| i | f  | c  | if |ifc|bool |  inf   |nan|mix_num |          time           |
|--:|---:|----|---:|---|-----|--------|---|-------:|-------------------------|
|  1|1.10|aa  | 1.0|  1|True |Infinity|NaN|       1|2017-01-01 00:00:00+09:00|
|  2|2.20|bbb | 2.2|2.2|False|Infinity|NaN|Infinity|2017-01-02 03:04:05+09:00|
|  3|3.33|cccc|-3.0|ccc|True |Infinity|NaN|     NaN|2017-01-01 00:00:00+09:00|

4.4.1.2. from a CSV file

Sample Code:

Write a table from a CSV file

import io
from textwrap import dedent

import pytablewriter

def main():
    filename = "sample.csv"
    with io.open(filename, "w", encoding="utf8") as f:
        f.write(dedent("""\
            "i","f","c","if","ifc","bool","inf","nan","mix_num","time"
            1,1.10,"aa",1.0,"1",True,Infinity,NaN,1,"2017-01-01 00:00:00+09:00"
            2,2.20,"bbb",2.2,"2.2",False,Infinity,NaN,Infinity,"2017-01-02 03:04:05+09:00"
            3,3.33,"cccc",-3.0,"ccc",True,Infinity,NaN,NaN,"2017-01-01 00:00:00+09:00"
            """))

    writer = pytablewriter.MarkdownTableWriter()
    writer.from_csv(filename)
    writer.write_table()

if __name__ == "__main__":
    main()