I would like someone to write python code to screen scrape data from the [login to view URL] 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 = [login to view URL]("D:\\bf_only_soccer\\[login to view URL]")
conn.text_factory = str
cur = [login to view URL]()
# create new table
[login to view URL]("CREATE TABLE main(event_id INT, HL FLOAT, HB FLOAT, AL FLOAT, AB FLOAT)")
# insert string of values 'x' into table
[login to view URL]("INSERT INTO main VALUES (?,?,?,?,?);", x)
3. Need Python code to screen scrape all historical data from
[login to view URL]
[login to view URL]
4. Need Python code that will automatically update database after each new race
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 en 3 días
5,0 (18 comentarios)
5,3
5,3
5 freelancers están ofertando un promedio de $205 USD por este trabajo
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 things further.
Thanks
Ranjit Singh