api - 如何将 pandas.DataFrame 转换为 gviz_api.DataTable

Question

我有一个 pandas.DataFrame 对象，我想将其转换为 gviz_api.DataTable，然后我将在我的 google 图表中使用它。

有没有简单的方法来做到这一点？

Answer 1

我不知道有什么直接的方法可以将 pandas 数据框转换为 gviz 数据表。

这是我的做法:-

from gviz_data_table import Table   # using https://bitbucket.org/charlie_x/gviz-data-table though you should probably use the official google one.
import numpy as np
import pandas as pd

df = pd.DataFrame({
    "time" : [1,2,3,4,5],
    "temp" : np.random.rand(5)
})

table = Table()
table.add_column('temp', float, 'Temp')
table.add_column('time', float, 'Time')

for row in df.iterrows():
    table.append(row[1].tolist())

table.rows

[OrderedDict([('temp', <gviz_data_table.cell.Cell object at 0x104a64aa0>), ('time', <gviz_data_table.cell.Cell object at 0x104a64a50>)]),
 OrderedDict([('temp', <gviz_data_table.cell.Cell object at 0x104a64af0>), ('time', <gviz_data_table.cell.Cell object at 0x104a64b40>)]),
 OrderedDict([('temp', <gviz_data_table.cell.Cell object at 0x104a64b90>), ('time', <gviz_data_table.cell.Cell object at 0x104a64be0>)]),
 OrderedDict([('temp', <gviz_data_table.cell.Cell object at 0x104a64c30>), ('time', <gviz_data_table.cell.Cell object at 0x104a64c80>)]),
 OrderedDict([('temp', <gviz_data_table.cell.Cell object at 0x104a64cd0>), ('time', <gviz_data_table.cell.Cell object at 0x104a64d20>)])]