使用熊猫数据框架和机械组填写互联网表格

Question

我使用的是mechanicalcoup，我需要使用数据帧中的信息自动填写互联网表单。

该数据帧称为checkdataframe。

br = mechanicalsoup.StatefulBrowser(user_agent='MechanicalSoup')
for row in checkdataframe.codenumber:
if row in '105701':
url = "https://www.internetform.com"
br.open(url)
for column in checkdataframe[['ID', 'name','email']]:
br.select_form('form[action="/internetform.com/info.do"]')
br.form['companycode'] =checkdataframe['ID']  #THIS INFORMATION SHOULD COMING FROM DATAFRAME
br.form['username'] = checkdataframe['name'] #THIS INFORMATION SHOULD COMING FROM DATAFRAME
br.form['emailaddress'] = checkdataframe['email'] #THIS INFORMATION SHOULD COMING FROM DATAFRAME
response = br.submit_selected()
soup = BeautifulSoup(response.text, 'lxml')
table = soup.find('div', attrs = {'class':'row'})
for row in table.findAll('div', attrs = {'class':'col-md-4 col-4'}):
scrapeinfo = {}
scrapeinfo['STATUS'] = row.div
scrapeinfo['NAMEOFITEM'] = row.label
scrapeinfo['PRICE'] = row.div
checkdataframe.append(scrapeinfo)


else:
break

我如何使br.form['companycode']=checkdataframe['ID']而不是起作用

br.form['companycode']='105701'

br.form['username']='myusername'

br.form['emailaddress']='[e-mail]'

我需要将抓取的信息附加到checkdataframe中。我需要帮助。

Answer 1

使用硒进行此活动