我有以下數(shù)據(jù)框<style type="text/css">.tg {border-collapse:collapse;border-spacing:0;}.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:black;}.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:black;}.tg .tg-baqh{text-align:center;vertical-align:top}.tg .tg-9hbo{font-weight:bold;vertical-align:top}.tg .tg-yw4l{vertical-align:top}</style><table class="tg"> <tr> <th class="tg-9hbo">JobID</th> <th class="tg-9hbo">JobName</th> <th class="tg-9hbo">JobLink</th> </tr> <tr> <td class="tg-baqh">n/a</td> <td class="tg-baqh">Some job name</td> <td class="tg-yw4l">https://www.particulawebsite.com/jobs-some-job-name.id123465789</td> </tr> <tr> <td class="tg-baqh">n/a</td> <td class="tg-baqh">another job name</td> <td class="tg-yw4l">https://www.particulawebsite.com/jobs-another-job-name.id987654321</td> </tr> <tr> <td class="tg-baqh">n/a</td> <td class="tg-baqh">yet another name</td> <td class="tg-yw4l">https://www.particulawebsite.com/jobs-yet-another-job-name.id987321654</td> </tr></table>我要做的是從JobLink列中復(fù)制id部分,并將其放在JobID中。到目前為止,尚未成功完成此操作,因此是我的問題。
2 回答

溫溫醬
TA貢獻(xiàn)1752條經(jīng)驗(yàn) 獲得超4個(gè)贊
希望這可以幫助!
df['JobID'] = df['JobLink'].map(lambda x: x.split('.')[-1])
這會(huì)將“ JobID”的第一行存儲(chǔ)為“ id123465789”
添加回答
舉報(bào)
0/150
提交
取消