Hi, I'm looking to build a large, ever-evolving database that will be extracting specific data from a website.
I will attach some pictures so that it's clearer to understand. The website I want to scrape data from is: [login to view URL]
They have different links for races on different dates. I'd like to extract the data for every day for the past 5 years, and I'd like the database to also have race data for every day in the future (when it's uploaded on the website), so there's going to be a lot of information on the database.
The specific information that I want from each horse is simply the data from the race categories of the race in which the horse was involved in, which are highlighted on the scraping picture (except for the name of the course). The categories are the course name (Leicester), distance, race type, class, prize money, handicap, ages, runners, non-runners, going.
I will then want to somehow dynamically link all of that data, so that I can use what and when I require it on multiple, ever-growing spreadsheets; ultimately the aim is that when I simply type the information for two columns (date and horse), the rest of the data on the 11 other columns automatically appears.
The spreadsheet picture shows how I'd want this to work: to simply put the date and the name of the horse, and then the spreadsheet/database will automatically fill in the data on the other 11 categories. As an example I've used the first horse that was on the Leicester race on the scraping picture, so that my aim can be seen in a clearer way.
I'd prefer if the spreadsheets with the columns to be on Excel as I'll apply filters to them and also formulas. I'm not at all familiar with SQL or PHP or any other database program, but if I'm able to filter my table content, create new spreadsheets in them, and have formulas which adjust as the tables are filtered then I'd be open to being taught by yourself in how I could use such programs.
I've written a fair bit, but ultimately I think this might be quite a simple task for a professional such as yourself.
Please let me know if you have any questions about anything.
I look forward to hearing from you.
40 pekerja bebas membida secara purata £165 untuk pekerjaan ini
Hi Steven, This is Lin and I am scraping expert, please check my reviews then you will know. Can we discuss more details about this project? Thanks, Lin