你可以用大熊猫做它像这样:
import pandas as pd
a = {'Job1': {'2017-01-10': [44, 33, 11, 75, 22]},
'Job2': {'2017-01-05': [25, 25, 0, 100, 25], '2017-01-10': [50, 50, 0, 100, 25]},
'Job3': {'2017-01-03': [44, 22, 22, 50, 22], '2017-01-04': [66, 36, 30, 54, 22], '2017-01-06': [88, 52, 36, 59, 22], '2017-01-10': [132, 68, 64, 51, 22], '2017-01-02': [22, 9, 13, 40, 22], '2017-01-08': [110, 52, 58, 47, 22]},
'Job4': {'2017-01-10': [25, 25, 0, 100, 25]}}
df = pd.DataFrame(data=a)
df = df.fillna(' ').T
df
输出:
如果你只想列表的第一个元素:
df = df.applymap(lambda x: x[0] if type(x)==list else x)
df
如果你想将其转换成HTML表格,你可以使用.to_html()方法,像这样:
print df.to_html()
输出:
2017-01-022017-01-032017-01-042017-01-052017-01-062017-01-082017-01-10
Job144Job22550Job322446688110132Job425