In Progress

Database for HK racing

I would like someone to write python code to screen scrape data from the [url removed, login to view] website. Sorry for the abrupt nature of the instructions below. It was for internal use only.

Hong Kong Racing Database Spec

We want a database for Hong Kong racing. Full data goes back to 2008-2009 season. They generally race two days a week. Do it in sqlite3. It is on python already by default. Please comment all code

1. Need 2 tables in database.

HorseTable

Fields:

RaceID, Place, HorseNumber, HorseName, HorseID, JockeyName, JockeyID, TrainerName, TrainerID, ActualWeight, DeclaredWeight, Draw, FinishTime, WinOdds, Gear, 1stSectPos, 1stSectDist, 2ndSectPos, 2ndSectDist, 3rdSectPos, 3rdSectDist, 4thSectPos, 4thSectDist, 5thSectPos, 5thSectDist, 6thSectPos, 6thSectDist

RaceTable

Fields:

RaceID, RaceNumber, Date, CourseName, Class, Distance, PrizeMoney, Going, CourseDescription, SectTime1, SectTime2, SectTime3, SectTime4, SectTime5, SectTime6

Add anything else to fields you think we might need?

2. Need Python code to setup database (sqlite3 example)

import sqlite3

# set up new database

conn = [url removed, login to view]("D:\\bf_only_soccer\\[url removed, login to view]")

conn.text_factory = str

cur = [url removed, login to view]()

# create new table

[url removed, login to view]("CREATE TABLE main(event_id INT, HL FLOAT, HB FLOAT, AL FLOAT, AB FLOAT)")

# insert string of values 'x' into table

[url removed, login to view]("INSERT INTO main VALUES (?,?,?,?,?);", x)

3. Need Python code to screen scrape all historical data from

[url removed, login to view]

[url removed, login to view]

4. Need Python code that will automatically update database after each new race

Skills: Web Scraping

See more: web scraping python 3, scraping data from web database, draw anything you want, data str, c for int, web hk, str, scraping python, scrape python, racing, python scraping, hb, cur, scraping python table, string float, python scrape web, connect web python, scraping data website python, web scraping table data, web hong kong, python scraping tables, scraping tables python, scraping data tables python, asp insert data, cursor class

About the Employer:
( 4 reviews ) Hove, United Kingdom

Project ID: #5328124

Awarded to:

nekhbet

Hi, I read that you specified Python but if you can't find a Python coder and you would like a PHP solution (with sqlite3 if you prefer) please let me know. Regards Sorin

$147 USD in 3 days
(18 Reviews)
5.3

5 freelancers are bidding on average $205 for this job

mhmhz

Hi I am offering to provide the task as a desktop application in C#, if you interested, let me know. Thanks

$210 USD in 3 days
(16 Reviews)
5.2
ranjitsingh90

PHP coder at your service. Hi, Allow me to work for you, I have considerable amount of experience in web scraping. I will deploy a web program which will automatically scrape data for you. Kindly message me to discuss More

$210 USD in 3 days
(18 Reviews)
5.2
flashsaiful

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$147 USD in 3 days
(19 Reviews)
4.0
NTechcorporate

Hi, Hope you are doing well! We have gone through your requirement and we understand that you are looking for highly skilled, qualified, and experience Python development team for your project. Our developer More

$309 USD in 7 days
(0 Reviews)
0.0