我有一个字典列表,其中包含来自sql查询的classid、dept、coursenum、area和title字段。我想以人类可读的格式输出值。我认为在每个列的顶部都有一个列标题,然后在每一列中都有适当的输出,即:
CLASSID DEPT COURSE NUMBER AREA TITLE
foo bar foo bar foo
yoo hat yoo bar hat(显然使用标准对齐/间距)
我如何在python中做到这一点呢?
发布于 2011-02-23 07:06:41
Standard Python string formatting可能就足够了。
# assume that your data rows are tuples
template = "{0:8}|{1:10}|{2:15}|{3:7}|{4:10}" # column widths: 8, 10, 15, 7, 10
print template.format("CLASSID", "DEPT", "COURSE NUMBER", "AREA", "TITLE") # header
for rec in your_data_source:
print template.format(*rec)或
# assume that your data rows are dicts
template = "{CLASSID:8}|{DEPT:10}|{C_NUM:15}|{AREA:7}|{TITLE:10}" # same, but named
print template.format( # header
CLASSID="CLASSID", DEPT="DEPT", C_NUM="COURSE NUMBER",
AREA="AREA", TITLE="TITLE"
)
for rec in your_data_source:
print template.format(**rec)尝试对齐、填充和精确格式说明符以获得最佳结果。
发布于 2011-02-23 13:25:44
class TablePrinter(object):
"Print a list of dicts as a table"
def __init__(self, fmt, sep=' ', ul=None):
"""
@param fmt: list of tuple(heading, key, width)
heading: str, column label
key: dictionary key to value to print
width: int, column width in chars
@param sep: string, separation between columns
@param ul: string, character to underline column label, or None for no underlining
"""
super(TablePrinter,self).__init__()
self.fmt = str(sep).join('{lb}{0}:{1}{rb}'.format(key, width, lb='{', rb='}') for heading,key,width in fmt)
self.head = {key:heading for heading,key,width in fmt}
self.ul = {key:str(ul)*width for heading,key,width in fmt} if ul else None
self.width = {key:width for heading,key,width in fmt}
def row(self, data):
return self.fmt.format(**{ k:str(data.get(k,''))[:w] for k,w in self.width.iteritems() })
def __call__(self, dataList):
_r = self.row
res = [_r(data) for data in dataList]
res.insert(0, _r(self.head))
if self.ul:
res.insert(1, _r(self.ul))
return '\n'.join(res)在使用中:
data = [
{'classid':'foo', 'dept':'bar', 'coursenum':'foo', 'area':'bar', 'title':'foo'},
{'classid':'yoo', 'dept':'hat', 'coursenum':'yoo', 'area':'bar', 'title':'hat'},
{'classid':'yoo'*9, 'dept':'hat'*9, 'coursenum':'yoo'*9, 'area':'bar'*9, 'title':'hathat'*9}
]
fmt = [
('ClassID', 'classid', 11),
('Dept', 'dept', 8),
('Course Number', 'coursenum', 20),
('Area', 'area', 8),
('Title', 'title', 30)
]
print( TablePrinter(fmt, ul='=')(data) )产生
ClassID Dept Course Number Area Title
=========== ======== ==================== ======== ==============================
foo bar foo bar foo
yoo hat yoo bar hat
yooyooyooyo hathatha yooyooyooyooyooyooyo barbarba hathathathathathathathathathat发布于 2013-05-31 12:19:04
如果你想保持简单,你可以简单地将字符串左对齐到一定数量的字符:
print string1.ljust(20) + string2.ljust(20)https://stackoverflow.com/questions/5084743
复制相似问题