如何使用python在单个csv单元格中打包多个列表值

Question

我有一定的学历和技能。对于一个候选人来说，学位只有一个价值，而技能有多个价值。 为了为多个候选对象存储这些值，我将这些值分别添加到列表、学位和技能中。但问题是，每一个候选技能都被插入到新行中，我希望它们在单个单元格中以逗号分隔，如预期输出所示。忠告

    Actual Output:
    Deg                              SK
    []                               Sales
    Autonomous College Bhawanipatna  Channel Sales
    
    Expected Output:
    Deg                                SK               
    Autonomous College Bhawanipatna    Sales, Channel Sales
    
    degrees=[]
    skills=[]
    candidates = []
    for candidate in candidates:
      edu = browser.find_elements_by_xpath('//span[@class="pv-skill-category-entity__name-text t-16 t-black t-bold"]')
      for e in edu:
          skill = e.text
          skills.append(skill)
    
    degree = browser.find_element_by_xpath('//span[@class="pv-entity__comma-item"]').text
    degrees.append(degree)
    file = pd.DataFrame(list(zip(degrees, skills)),columns=['Deg', 'SK'])
    file.to_csv('test.csv', index=False)

Answer 1

假设

 skill = e.text

给出一个字符串

您可以按如下方式修改代码：

degrees=[]
skills=[]
edu = browser.find_elements_by_xpath('//span[@class="pv-skill-category-entity__name-text t-16 t-black t-bold"]')
for e in edu:
    skill = e.text
    skills.append(skill)

# This line transform the previous list into a string  that adds a comma in between elements which is inside a list.
skill_value = [', '.join(skills)]

degree = browser.find_element_by_xpath('//span[@class="pv-entity__comma-item"]').text
degrees.append(degree)
file = pd.DataFrame(list(zip(degrees, skill_value)),columns=['Deg', 'SK'])
file.to_csv('test.csv', index=False)