I gang

Fetch web address with python and log results to MySQL database

I have a list of URLs I need fetched via python. The script you build will work like this:

1. Create the database and two tables (in MySQL) via the attached script.

2. Create a python script that takes the file path of the attached CSV and loads the CSV into web_address_lookup.address_input.

3. Create a python script that selects rows from the address_input table WHERE needs_lookup = 1.

3. Iterate through each address, and log back to the address_output table: the address_id, log the http response code to the web_address_lookup.address_output.http_response_code, if the response is a redirect (i.e, http 3xx) log the final URL to the web_address_lookup.address_output.redirected_to_url column, log the HTML returned to [login to view URL] column (discard images and such; this column is a text column on purpose, not a blob -- so images should not be saved), and log the time the lookup was performed to web_address_lookup.address_output.lookup_timestamp.

4. UPDATE web_address_lookup.address_input.needs_lookup to zero.

As part of the acceptance criteria, your script will utilize appropriate batching. For example, you should probably fetch 1,000 (or a configurable number...) of rows from address_input, iterate through them, write the results for the entire batch to address_output, update the address_input.needs_lookup column for the entire batch, and then take the next 1,000 records from the address_input table.

You will deliver to me: the python code that runs the process described above and the MySQL database proving completion of the tasks.

Please note, the sample CSV includes 91,663 rows in it. When I run the process, I will add additional rows to it at various times. As such, the CSV import part of the code needs to be included in the final script (if you use pandas...its probably 3 lines of code or something).

Evner: Python, MySQL, Web Skrabning

Se mere: update mysql database web form godaddy, mysql database web frontend, log mysql database vps, create web forms mysql database, create web interface view mysql database, web form collects data mysql database, web scraper save mysql database, web crawlers mysql database allow, mysql database replication web farm, mysql database server web interface java, storing web scrapped data mysql database, store mac address mysql database, web form display image mysql database, mysql database web interface, display information mysql database web page, mysql database capture email web form, query mysql database remote web page, web service checking valid user mysql database, coursework help programming database web design javascript java php sql python cc c++ mysql tutor

Om arbejdsgiveren:
( 6 bedømmelser ) Austin, United States

Projekt ID: #20854845

Tildelt til:


Hi, I have been doing webscraping along with saving it into database from past 2 years. I have gone through the attachments that you have provided and I would like to work with you on this.

$30 USD in 7 dage
(1 bedømmelse)

9 freelancere byder i gennemsnit $24 på dette job


Using PHP will be fine for you? Hello sir, i have 10 years of exp, i have read the description and ready to start work right now. ..................................

$20 USD på 1 dag
(150 bedømmelser)

Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. selenium, pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written some Flere

$30 USD på 1 dag
(70 bedømmelser)

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin Flere

$20 USD in 7 dage
(40 bedømmelser)

Hi,i'm a data scientist with a BS degree in computer science i will do your task as fast as i can and i will achieve it exactly as you want,don't worry about any thing contact me for discussion

$20 USD in 7 dage
(14 bedømmelser)

Dear Sir, I'm a Web Developer from Russian who is specialized in Python and MySQL. I have read your description with great interest. I have 6+ years of experience in Python. if you hire me, i could satisfy. I hope you Flere

$20 USD in 7 dage
(8 bedømmelser)

Hello, there! I have thoroughly read your job post and I would like to apply for it. I have been working with Python more than 5 years already and have extensive experience in Machine Learning. I'm also experienced in Flere

$30 USD in 3 dage
(2 bedømmelser)

Hello, Thanks For good job posted. yes i can do this work so please give me this project. yes i'm free now so if you want i can start this work today. thanks!!

$20 USD in 7 dage
(0 bedømmelser)

Hi This is how i plan to work on the project, day 1 clarify the requirements with you and create a basic working code. Build on it and share it with you. Day 3 address any issues.

$30 USD in 3 dage
(0 bedømmelser)