python - 用pandas的字典词典制作数据框字典

我有一个嵌套的字典：

    Night_interval={
    '2010': {
      Timestamp('2010-07-01 00:00:00'): 29,
      Timestamp('2010-07-02 00:00:00'): 28,
      Timestamp('2010-07-03 00:00:00'): 28,
      Timestamp('2010-07-04 00:00:00'): 29,
      Timestamp('2010-07-05 00:00:00'): 28
            },
    '2011': {
      Timestamp('2010-07-01 00:00:00'): 29,
      Timestamp('2010-07-02 00:00:00'): 28,
      Timestamp('2010-07-03 00:00:00'): 28,
      Timestamp('2010-07-04 00:00:00'): 29,
      Timestamp('2010-07-05 00:00:00'): 28
            },
    '2012': {
      Timestamp('2010-07-01 00:00:00'): 29,
      Timestamp('2010-07-02 00:00:00'): 28,
      Timestamp('2010-07-03 00:00:00'): 28,
      Timestamp('2010-07-04 00:00:00'): 29,
      Timestamp('2010-07-05 00:00:00'): 28
            }
  }

使用此字典，我想创建一个与每个键（即2010，2011和2012）关联的数据帧的字典。我还想将时间戳记作为每个数据框中的索引。我尝试编写以下代码：

Years = ['2010','2011','2012']
for key in Years:
    df_interval[key] = pd.DataFrame(Night_interval[key])

但是，我收到此错误：
ValueError: If using all scalar values, you must pass an index

我找不到我做错了的地方。我将不胜感激任何帮助。

最佳答案

如果需要dict，请使用DataFrame构造函数和列名：

df_interval = {}
Years = ['2010','2011','2012']
for key in Years:
    df_interval[key] = pd.DataFrame({key:Night_interval[key]})

print (df_interval['2012'])
            2012
2010-07-01    29
2010-07-02    28
2010-07-03    28
2010-07-04    29
2010-07-05    28

df_interval = {}
Years = ['2010','2011','2012']
for key in Years:
    df_interval[key] = pd.DataFrame({'a':Night_interval[key]})

print (df_interval['2012'])
             a
2010-07-01  29
2010-07-02  28
2010-07-03  28
2010-07-04  29
2010-07-05  28

或者，如果可能只有一列，请创建dict的Series：

df_interval = {}
Years = ['2010','2011','2012']
for key in Years:
    df_interval[key] = pd.Series(Night_interval[key], name=key)

print (df_interval['2012'])
2010-07-01    29
2010-07-02    28
2010-07-03    28
2010-07-04    29
2010-07-05    28
Name: 2012, dtype: int64