Betfair CSV file calculations and cleaning

CSV file calculations. See file format:

<[url removed, login to view]>

## Deliverables

I need 1 (or it might be easier to braek it into 2 programs/macros to perform data cleaning and some calculations on CSV files which are all in the same format that represent Betfair results.

Most of the calculations and data cleaning are very simple and straight [url removed, login to view] CSV file consists of 2 weeks of races. I need to work and perform calculations on a race by race basis??"the program should scan down, identify a race and all the runners in it, and do calculations for only those runners, adding a new column with the result next to each runner, and so on for the next race.

Download any one of the files from here:

<[url removed, login to view]>

All the files are in the same format, so one program or macro will work on all of them. Specific details are included in zip attachment.

PHP

项目ID： #3964336

关于项目