php-Python：使用机械化将数据提交到表单后,提取.csv结果

大佬教程收集整理的这篇文章主要介绍了php-Python：使用机械化将数据提交到表单后,提取.csv结果，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

我是第一次使用Python从网络上提取数据.多亏了其他一些帖子以及webpage,我才知道如何使用机械化模块将数据提交到表单.

现在,我坚持寻找如何提取结果.提交表单时会有很多不同的结果,但是如果我可以访问csv文件,那将是完美的.我假设您必须使用re模块,但是如何通过Python下载结果呢？

运行作业后,csv文件位于此处：摘要=>结果=>下载重链表(您只需单击“加载示例”即可查看该网页的工作方式).

import re
import mechanize

br = mechanize.browser()
br.set_handle_robots(false)   # ignore robots
br.set_handle_refresh(false)  # can sometimes hang without this

url = 'http://circe.med.uniroma1.it/proaBC/index.PHP'
response = br.open(url)

br.form = list(br.forms())[1]

# Controls can be found by name
control1 = br.form.find_control("light")

# Text controls can be set as a String
br["light"] = "DIQMTQSPASLSASVGETVTITCRASGNIHNYLAWYQQKQGKSPQLLVYYTTTLADGVPSRFSGSGSGTQYSLKINSLQPEDFGSYYCQHFWSTPRTFGGGTKLEIKRADAAPTVSIFPPSSEQLTSGGASVVCFLNNFYPKDINVKWKIDGSERQNGVLNSWTDQDSKDSTYSMSSTLTLTKDEYERHNSYTCEATHKTSTSPIVKSFNRNEC" 
br["heavy"] = "QVQLKESGPGLVAPSQSLSITCTVSGFSLTGYGVNWVRQPPGKGLEWLGMIWGDGNTDYNSALKSRLSISKDNSKSQVFLKMNSLHTDDTARYYCARERDYRLDYWGQGTTLTVSSASTTPPSVFPLAPGSAAQTNSMVTLGCLVKGYFPEPVTVTWNSGSLSSGVHTFPAVLQSDLYTLSssvTVPSSPRPSETVTCNVAHPASSTKVDKKIVPRDC"

# To submit form
response = br.submit()
content = response.read()
# print content

result = re.findall(r"Prob_Heavy.csv", content)
print result

打印内容时,我感兴趣的行如下所示：

<h2>Results</h2><br>
PreDictions for Heavy Chain:
<a href='u17003I9f1/Prob_Heavy.csv'>Download Heavy Chain Table</a><br>
PreDictions for Light Chain:
<a href='u17003I9f1/Prob_Light.csv'>Download Light Chain Table</a><br>

因此,问题是：如何下载/访问href =’u17003I9f1 / Prob_Heavy.csv’？

解决方法:

这是一个使用BeautifulSoup的快速且肮脏的示例,它请求避免使用正则表达式解析HTMl. sudo pip install bs4(如果您已安装pip但尚未安装BeautifulSoup).

import re
import mechanize
from bs4 import BeautifulSoup as bs
import requests
import time


br = mechanize.browser()
br.set_handle_robots(false)   # ignore robots
br.set_handle_refresh(false)  # can sometimes hang without this

url_base = "http://circe.med.uniroma1.it/proaBC/"
url_index = url_base + "index.PHP"

response = br.open(url_indeX)

br.form = list(br.forms())[1]

# Controls can be found by name
control1 = br.form.find_control("light")

# Text controls can be set as a String
br["light"] = "DIQMTQSPASLSASVGETVTITCRASGNIHNYLAWYQQKQGKSPQLLVYYTTTLADGVPSRFSGSGSGTQYSLKINSLQPEDFGSYYCQHFWSTPRTFGGGTKLEIKRADAAPTVSIFPPSSEQLTSGGASVVCFLNNFYPKDINVKWKIDGSERQNGVLNSWTDQDSKDSTYSMSSTLTLTKDEYERHNSYTCEATHKTSTSPIVKSFNRNEC" 
br["heavy"] = "QVQLKESGPGLVAPSQSLSITCTVSGFSLTGYGVNWVRQPPGKGLEWLGMIWGDGNTDYNSALKSRLSISKDNSKSQVFLKMNSLHTDDTARYYCARERDYRLDYWGQGTTLTVSSASTTPPSVFPLAPGSAAQTNSMVTLGCLVKGYFPEPVTVTWNSGSLSSGVHTFPAVLQSDLYTLSssvTVPSSPRPSETVTCNVAHPASSTKVDKKIVPRDC"

# To submit form
response = br.submit()
content = response.read()
# print content

soup = bs(content)
urls_csv = [x.get("href") for x in soup.findAll("a") if ".csv" in x.get("href")]
for file_path in urls_csv:
    status_code = 404
    retries = 0
    url_csv = url_base + file_path
    file_name = url_csv.split("/")[-1]
    while status_code == 404 and retries < 10:
        print "{} not ready yet".format(file_name)
        req = requests.get(url_csv )
        status_code = req.status_code
        time.sleep(5)
    print "{} ready. Saving.".format(file_name)
    with open(file_name, "wb") as f:
        f.write(req.content)

在REPL中运行脚本：

Prob_Heavy.csv not ready yet
Prob_Heavy.csv not ready yet
Prob_Heavy.csv not ready yet
Prob_Heavy.csv ready. Saving.
Prob_Light.csv not ready yet
Prob_Light.csv ready. Saving.
>>> 
>>> 

大佬总结

以上是大佬教程为你收集整理的php-Python：使用机械化将数据提交到表单后,提取.csv结果全部内容，希望文章能够帮你解决php-Python：使用机械化将数据提交到表单后,提取.csv结果所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。