prettytable 模块(格式化输出表格)
在python脚本中直接print打印漂亮的表格,可以使用第三方模块prettytable来实现。
0,张三,26,12345678901,IT,root 1,李四,22,13651054608,IT,admin 2,王五,23,13304320533,Teacher,normal
from prettytable import PrettyTable file_path = 'staff_info._bak.txt' info = [] title = ['idx', 'name', 'age', 'phone', 'job', 'permission'] with open(file_path, 'r') as f: for i in f: info.append([x for x in i.strip().split(',')]) pt = PrettyTable(title) #创建一个对象,title为表头 for i in info: #循环添加每一行数据 pt.add_row(i) print(pt) #直接打印即可
+-----+------+-----+-------------+---------+------------+ | idx | name | age | phone | job | permission | +-----+------+-----+-------------+---------+------------+ | 0 | 张三 | 26 | 12345678901 | IT | root | | 1 | 李四 | 22 | 13651054608 | IT | admin | | 2 | 王五 | 23 | 13304320533 | Teacher | normal | +-----+------+-----+-------------+---------+------------+
得到这种类似mysql查询输出的表格。