基于
this post
import pandas as pd
inp = [{'c1':10,'cols':{'c2':20,'c3':'str1'}, 'c4':'41'}, {'c1':11,'cols':{'c2':20,'c3':'str2'},'c4':'42'}, {'c1':12,'cols':{'c2':20,'c3':'str3'},'c4':'43'}]
df = pd.DataFrame(inp)
pd.io.json.json_normalize(df.to_dict('records'))
上面的脚本效果很好。
对…稍作改变
inp
inp=[{'c1':10,'cols':{'c2':5,'c3':NaT}, 'c4':'41'}, {'c1':11,'cols':{'c2':Timestamp('2014-06-03 21:19:26'),'c3':'str2'},'c4':'42'}, {'c1':12,'cols':{'c2':20,'c3':'str3'},'c4':'43'}]
df = pd.DataFrame(inp)
pd.io.json.json_normalize(df.to_dict('records'))
我只是换衣服
str1
NaT
和
20
Timestamp('2014-06-03 21:19:26')
,脚本运行不正常,错误如下:
NameError: name 'NaT' is not defined
NameError: name 'Timestamp' is not defined
作为
纳特
在实际数据中很常见,什么问题导致错误?