使用Python处理CSV文件中的行数据并将其附加到新列中

I have an csv file consisting of a list of company names. The goal is to write a code to generate the direct indeed job listing link for each of these companies using the name alone. The indeed link for the company- "Company XYZ" will be - https://www.indeed.com/q-company-XYZ-jobs.html

确实链接应在列名称确实作业链接下附加到现有文件。

我该怎么办?