使用Selenium从csv自动填写表单

2024-09-27 21:26:58 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在抓取这个网站:

https://login.aviva.com.sg/directinsurance/homeinsurance.htm

我想从一个csv文件中填充所有表单元素(我们称之为“profil”)。当我试图用一个独特的“profil”填写表格时,一切都很顺利。但当我在不同的配置文件上循环时,我遇到了多个问题:

  • 有时我无法从邮政编码中“获取”完整地址(见下文),因此无法获得最终报价

  • 司机是令人耳目一新,但我没有引述不同的人在profil。 我有一种profil类型:

              profil = [["MRS     ","Corinne","SIMON","F","M","600     ","No, for myself and my family","72603190","2017-H1","CO      ","Ridout Road","10","91 - 124","27 - 38","099197","S4553141D","1958","5","1"],
    
              ["MS      ","Corinne","MOREAU","F","D","610     ","Yes, for myself","63856280","2017-H1","CO      ","Stevens","10","38 - 208","24 - 40","099198","S9186686B","1999","10","1"],
    
              ["MDM     ","Corinne","DUBOIS","F","W","620     ","Yes,for my family","71852991","2017-H1","CO      ","Stevens","10","38 - 208","24 - 40","099200","S2243858A","1974","2","1"]
    
        ]`
    

这是我制作的python代码:

^{pr2}$

在司机。关门()

import pandas as pd

premium_df = pd.DataFrame(premiums)


premium_df.to_csv("premium.csv", index=False)

Tags: csvdfformyh1familyyespd

热门问题