Completed

Database for HK racing

This project was successfully completed by nekhbet for $147 USD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
3 days
Total Bids
5
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online