1.已经列表L=[{"name':"Amay","age':20,"result":80}
{"name':"Tom","age':32,"result":90} ]
按照下面的输出方式输出 怎么可以值取出来 然后输出。
+---------------------------+-----------+----------+
| name | age | result |
+--------------------------+-----------+----------+
| xxxx | xx | xxxxx |
| xxxx | xx | xxxxx |
+--------------------------+-----------+-----------+
用texttable就好了,很方便的。
import pandas as pd
from texttable import Texttable
data=[{"name":"Amay","age":20,"result":80},
{"name":"Tom","age":32,"result":90}]
df=pd.DataFrame(data,columns=['name','age','result'])
tb=Texttable()
tb.set_cols_align(['l','r','r'])
tb.header(df.columns.get_values())
tb.add_rows(df.values,header=False)
print(tb.draw())
L= [{'name':'Amay', 'age':20, 'result':80}, {'name':'Tom', 'age':32, 'result':90}]
print('+---------------------------+-----------+----------+')
print('| name | age | result |')
print('+---------------------------+-----------+----------+')
for a in L:
print('| {0:^4} | {1} | {2} |'.format(a['name'], a['age'], a['result']))
print('+---------------------------+-----------+----------+')
就简单的格式化输出就行吧。
←如果以下回答对你有帮助,请点击右边的向上箭头及采纳下答案
import pandas as pd
from prettytable import PrettyTable
data=[{"name":"Amay","age":20,"result":80},
{"name":"Tom","age":32,"result":90}]
df=pd.DataFrame(data)
tb = PrettyTable()
tb.add_column('name', df['name'].values)
tb.add_column('age', df['age'].values)
tb.add_column('result', df['result'].values)
print(tb)
输出结果:
+------+-----+--------+
| name | age | result |
+------+-----+--------+
| Amay | 20 | 80 |
| Tom | 32 | 90 |
+------+-----+--------+
很简单,不用太麻烦
>>> L=[{"name":"Amay","age":20,"result":80},
... {"name":"Tom","age":32,"result":90} ]
>>> df = pd.DataFrame(L)
>>> df
age name result
0 20 Amay 80
1 32 Tom 90