我有个情况:
postStr = """{
"zoneId":"0",
"id":["a","b","c","d","f","g"],
"currencycode":["USD"],
}"""
postData = json.loads(postStr, object_pairs_hook=OrderedDict)
我有一个数据帧:
df = {
'id':['a','b','c','d','f','g','h','i','j','k'],
'B':['c','d','e','d','d','c','s','e','s','q'],
'S':['f','g','h','j','e','j','t','r','p','p']
}
df1 = pd.DataFrame(df)
现在我想要一个数据frme,如果id在字典中,那么B对应的列就变成XX
输出:
df = {
'id':['a','b','c','d','f','g','h','i','j','k'],
'B' :['XX','XX','XX','XX','XX','c','s','e','s','q'],
'S' :['f','g','h','j','e','j','t','r','p','p']
}
df1 = pd.DataFrame(df)
请帮忙
我认为需要^{} 和^{} :
如果想要更动态的解决方案-在DataFrame和dictionary中使用^{} 作为列名,并在循环中设置值:
相关问题 更多 >
编程相关推荐