Find Jobs
Hire Freelancers

Fetch web address with python and log results to MySQL database

$10-30 USD

Em Andamento
Publicado há mais de 4 anos

$10-30 USD

Pago na entrega
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).
ID do Projeto: 20854845

Sobre o projeto

7 propostas
Projeto remoto
Ativo há 5 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 em 7 dias
5,0 (1 avaliação)
1,5
1,5
7 freelancers estão ofertando em média $24 USD for esse trabalho
Avatar do Usuário
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 em 1 dia
5,0 (175 avaliações)
6,7
6,7
Avatar do Usuário
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 automation and scraping, scientific scripts. So I think I can help you in your project. Just let me know if you want start job. Regards. Lian
$30 USD em 1 dia
4,9 (91 avaliações)
6,6
6,6
Avatar do Usuário
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. Looking forward to hearing from you. Thanks.
$20 USD em 7 dias
4,8 (40 avaliações)
5,6
5,6
Avatar do Usuário
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 em 7 dias
4,9 (15 avaliações)
3,9
3,9
Avatar do Usuário
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 em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 3 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Austin, United States
5,0
7
Método de pagamento verificado
Membro desde abr. 25, 2017

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.