Math

CsvPath Validation Language examples of using math functions in processing CSV/Excel files

Try these examples yourself. They are built into FlightPath Data. You can download FlightPath Data free from Microsoft or Apple or Github

These examples focus on functions to find percents, averages, and sums in CSV and Excel files. Most of the math functions are easy enough to understand from their names. These csvpaths may give you ideas for your own validations and upgrading scripts.

• Averaging across groups

• Sum

• Subtract

• Min and max

• Running median and average

• Percents

• Above average