我有以下資料
SFDC,CMN,CMID,SID,MID,C_PG,ACT DCA,customer1,company1,SID1,cherie,cherie,"view_page_modulepicker,explore_more_connect with people" DCA,customer2,company2,SID2,cherie,cherie,"view_manage_opportunities,view_page_pickerp ,view_page_modulepicker" DCA,customer1,company1,SID1,cherie,cherie,"view_manage_opportunities,view_page_modulepicker,explore_more_connect with people" DCA,customer1,company1,SID1,cherie,cherie,"view_page_modulepicker" DCA,customer1,SID1, ,"view_manage_opportunities" DCA,customer4,company1,SID4,cherie,cherie,"view_manage_opportunities,view_page_actionSource" DCA,customer4,company1,SID4,cherie,cherie,"view_manage_opportunities,view_page_homePage,company1,cherieSID,"DCA,any1,customcherieSID “view_manage_opportunities，view_page_capabilities" ...... ......
現在我想找到 ACT 列中第一個元素是“view_manage_opportunities”的行，ACT 列中的第二個元素是“view_page(.*)”
然后交換這兩個元素。所以預期的輸出是
SFDC,CMN,CMID,SID,MID,C_PG,ACT DCA,customer1,company1,SID1,cherie,cherie,"view_page_modulepicker,explore_more_connect with people" DCA,customer2,company2,SID2,cherie,cherie,"view_page_modulepicker,view_modulepicker,view_manage_toopbackopport ,view_page_modulepicker" DCA,customer1,company1,SID1,cherie,cherie,"view_page_modulepicker,view_manage_opportunities,explore_more_connect with people" DCA,customer1,company1,SID1,cherie,cherie,"view_page_modulepicker" DCA,customer1,SID1, ,"view_manage_opportunities" DCA,customer4,company1,SID4,cherie,cherie,"view_page_actionSource,view_manage_opportunities" DCA,customer4,company1,SID4,cherie,cherie,"view_page_homePage,view_manage_opportunities,company1,customercherie,"DCA,company1,customer4 "view_page_capabilities,view_manage_opportunities” ...... ......
任何專家都可以幫助大熊貓解決這個要求嗎？
uj5u.com熱心網友回復：
您可以str.replace在這里使用：
df["ACT"] = df["ACT"].str.replace(r'(view_manage_opportunities),(view_page[^,]*)', r'\2,\1')
在此處查看正則運算式演示。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/369430.html
標籤：熊猫