我有一個像這樣的熊貓數(shù)據(jù)框：Index | Line Item | Insertion Order | Creative Type_________________________________________________________________________________________________1 | blbl 33 dEs '300x600' Q3 | hello 444 | UNKNOWN2 | QQQ4 Hello trueview Apple | something 68793274 | UNKNOWN3 | A useless string | pre-roll Video <10 tttt 89 CASIO | UNKNOWN4 | Something not in dict | Neither here | UNKNOWN還有這樣的字典： dct = {'RISING STARS': ['300x600', 'Box 300x600', '300x250', 'Box 300x250', 'Classic Skin', 'Main Banner', 'Half Banner', 'Masthead', 'Push Bar', 'Strip', 'In Image', 'Mix formati display rising'],'VIDEO': ['trueview', 'Video Banner', 'Video in Picture', 'Videobox', 'Mid-roll Video', 'Pre-roll+Inread', 'Pre-roll Video <10', 'Pre-roll Video =10', 'Pre-roll Video =15', 'Pre-roll Video =20', 'Pre-roll Video =30' ,'Pre-roll Video >30','Inread / Intext / Outstream','Mix formati video','Post-roll Video','Inread XXX (Landscape/Vertical/Square)', 'Pre-roll Video Sponsored Session' ,'Pre-roll Video Viewmax' ,'Pre-roll Video Takeover']}我想替換我的數(shù)據(jù)幀的創(chuàng)意類型列中的值：如果該列的值Line Item或Insertion Order與字典的值匹配，則該列的相應(yīng)行Creative Type應(yīng)采用字典鍵的名稱。如果沒有匹配，則列廣告素材類型的相應(yīng)行應(yīng)接收值NaN。預(yù)期輸出是：Index | Line Item | Insertion Order | Creative Type_________________________________________________________________________________________________1 | blbl 33 dEs '300x600' Q3 | hello 444 | RISING STARS2 | QQQ4 Hello trueview Apple | something 68793274 | VIDEO3 | A useless string | pre-roll Video <10 tttt 89 CASIO | VIDEO4 | Something not in dict | Neither here | NaN最簡單的方法是什么？（如果可能的話，計(jì)算成本更低）
將字典的值與數(shù)據(jù)幀的兩列的值進(jìn)行匹配，并用字典的鍵替換第三列的值
呼啦一陣風(fēng)
2023-08-22 15:59:12
