python - 如何将列表列表转换为第一个元素是索引，第二个是列名的数据框

Question

我们有一个列表列表:

[['130', '2020-12-17 12:02:19', [52.1846976, 21.0525275]], ['213', '2020-12-17 12:02:22', [52.1757618, 21.2319711]]

并希望将其转换为这样的数据框:

    index  2020-12-17 12:02:19          2020-12-17 12:02:22
    130    [52.1846976, 21.0525275]       NaN
    213    NaN                      [52.1757618, 21.2319711]

想不通。

Answer 1

你可以将你的列表变成一个字典列表，然后将索引显式地提供给构造器:

In [1]: import pandas as pd

In [2]: data = [['130', '2020-12-17 12:02:19', [52.1846976, 21.0525275]], ['213', '2020-12-17 12:02:22', [52.1757618, 21.2319711]]]

In [3]: pd.DataFrame([{col: val} for _, col, val in data], index=[item[0] for item in data])
Out[3]:
          2020-12-17 12:02:19       2020-12-17 12:02:22
130  [52.1846976, 21.0525275]                       NaN
213                       NaN  [52.1757618, 21.2319711]