从熊猫字典中制作数据框字典

Pankaj 发表于 Dev

潘卡伊

我有一个嵌套字典：

    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

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。