我在一个列表里面有一个列表，需要放到一个dataFram中

Question

[[[12, 71.2989367, -156.7286143, Samuel Simmonds Memorial Hospital, 4], [4, 64.8311569, -147.7399471, Fairbanks Memorial Hospital, 4].1, [6, 64.4993412, -165.3776787, Norton Sound Regional Hospital, 4].2, [5, 61.56316029999999, -149.2576383, Mat-Su Regional Medical Center, 4]]

需要将其转换为数据帧上的内容：

ID  Lat           Long            Name                         Level

12, 71.2989367, -156.7286143, Samuel Simmonds Memorial Hospital, 4
4, 64.8311569, -147.7399471, Fairbanks Memorial Hospital, 4
6, 64.4993412, -165.3776787, Norton Sound Regional Hospital, 4

Answer 1

常规的DataFrame构造函数应该做到这一点，但请记住，您的数据有一些错误.是一个3级嵌套列表（因此您需要使用[0]访问它）

import pandas as pd

data = [[
    [12, 71.2989367, -156.7286143, "Samuel Simmonds Memorial Hospital", 4],
    [4, 64.8311569, -147.7399471, "Fairbanks Memorial Hospital", 4],
    [6, 64.4993412, -165.3776787, "Norton Sound Regional Hospital", 4],
    [5, 61.56316029999999, -149.2576383, "Mat-Su Regional Medical Center", 4]
]]

df = pd.DataFrame(data[0], columns=["ID","Lat","Long","Name","Level"])

print(df)

输出：

   ID        Lat        Long                               Name  Level
0  12  71.298937 -156.728614  Samuel Simmonds Memorial Hospital      4
1   4  64.831157 -147.739947        Fairbanks Memorial Hospital      4
2   6  64.499341 -165.377679     Norton Sound Regional Hospital      4
3   5  61.563160 -149.257638     Mat-Su Regional Medical Center      4