3 回答

TA貢獻(xiàn)1982條經(jīng)驗(yàn) 獲得超2個(gè)贊
map與_dict
前任:
d = {'Height':"m",'Weight': "kg",'SBP':'mm','DBP':'mm'}
dataFramesDict = pd.DataFrame({'Date':['2007-05-30','2107-11-30','2207-05-20','2307-05-20'],'Value': [2.4,2.5,2.6,2.7],'Test': ['Height','Weight','SBP','DBP']})
dataFramesDict["Unit"] = dataFramesDict["Test"].map(d)
print(dataFramesDict)
輸出:
Date Test Value Unit
0 2007-05-30 Height 2.4 m
1 2107-11-30 Weight 2.5 kg
2 2207-05-20 SBP 2.6 mm
3 2307-05-20 DBP 2.7 mm

TA貢獻(xiàn)1827條經(jīng)驗(yàn) 獲得超9個(gè)贊
使用 Pandas 替換
df['unit'] = df.Test.replace({'Height':"m",'Weight': "kg",'SBP':'mm','DBP':'mm'})

TA貢獻(xiàn)1875條經(jīng)驗(yàn) 獲得超3個(gè)贊
請(qǐng)嘗試以下代碼。希望能幫助到你:
unitDict = {'Height':'m', 'Weight': 'Kg', 'SBP':'millimeter', 'DBP':'millimeter'}
def checkUnit(data):
if unitDict[data] is not None:
return unitDict[data]
df['Unit']=list(map(checkUnit, df['Test']))
print(df)
添加回答
舉報(bào)