4.2.1.9.3. Pandas DataFrame

PandasDataFrameWriter class can write a variable definition of Pandas DataFrame to the stream from a matrix of data.

Sample Code

Write a Pandas DataFrame definition

import pytablewriter

def main():
    writer = pytablewriter.PandasDataFrameWriter()
    writer.table_name = "example_table"
    writer.headers = ["int", "float", "str", "bool", "mix", "time"]
    writer.value_matrix = [
        [0,   0.1,      "hoge", True,   0,      "2017-01-01 03:04:05+0900"],
        [2,   "-2.23",  "foo",  False,  None,   "2017-12-23 45:01:23+0900"],
        [3,   0,        "bar",  "true",  "inf", "2017-03-03 33:44:55+0900"],
        [-10, -9.9,     "",     "FALSE", "nan", "2017-01-01 00:00:00+0900"],
    ]

    writer.write_table()

if __name__ == "__main__":
    main()

Output

example_table = pd.DataFrame([
    [0, 0.1, "hoge", True, 0, "2017-01-01 03:04:05+0900"],
    [2, -2.23, "foo", False, None, "2017-12-23 12:34:51+0900"],
    [3, 0, "bar", True, np.inf, "2017-03-03 22:44:55+0900"],
    [-10, -9.9, "", False, np.nan, "2017-01-01 00:00:00+0900"],
], columns=["int", "float", "str", "bool", "mix", "time"])