bha ratings
£10-15 GBP / saat
Each week the BHA (British Horse-racing Authority) updates the last 6 performance ratings of 13,500 horses into a csv file/ google sheets (with each horse identified in columns for name etc plus columns for each of the last 6 performances).The data I wish to manipulate is within the 13,500 rows by 6 columns of ratings. A complicating factor is that the 6 data columns mix text (a letter of little interest) and a number (the key data) for each performance (e.g. T:88). I am able (laboriously) to split the text out into columns which I delete and to add a column to identify the best numerical performance (highest performance rating) for each horse. I am then able to add further columns to incorporate a calculation based on the relationship between the individual performances of certain of the horses. SO FAR SO GOOD I HAVE THE SPREADSHEET I WANT. Unfortunately a week later the BHA's new spreadsheet for the past week's 2000+ performance ratings will, inter alia, change all the existing reference points for 13,500 horses into different cells as well as adding new/ deleting old performance data (to give the latest 6 performances only). How, can I create a spreadsheet that manipulates the data as I want but can be updated weekly in line with the next BHA spreadsheet.
Let me know if you have any questions
Proje NO: #30978462
Proje hakkında
Bu iş için 7 freelancer ortalamada £18/saat teklif veriyor
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Daha Fazla
Hello,how are you? I read your job description in detail and feel I can help your project. Because I have much experience for 7+ years in Data Anayze Field. I am very familiar with Python. I think this project is for m Daha Fazla
Hi! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can complete Daha Fazla
I am a Professional with 5 years of experience dealing day in and day out with advance macros. I am new to the platform, which is why I don't have many reviews but rest assured I will provide you with a quality product Daha Fazla
As a Banking professional with over 30 years experience, and a software expert proficient in Java / VBA / Excel / Google Sheets, this is an area of expertise for me. Having done similar projects several times in the pa Daha Fazla