Need to write a very simple script to parse a simple semicolon delimited .CSV file and calculate averages of its rows.

Need to write a very simple script to parse a simple semicolon delimited .CSV data file and calculate averages of its rows. I'm running MacOS and would like to run it as command line script under MacOS shell terminal. It should look something like this: #parse_data_and_average file_name.csv

This is sample data from the .csv file:

005d4034-0000-0000-0000-000000000000;2019-05-08T00:36:38.0340266;2019-05-08T00:36:38.0340266;5874;0.464359;5873.21;0.97753
005d4034-0000-0000-0000-000000000000;2019-05-08T00:36:38.0760000;2019-05-08T00:36:38.2273925;5873.98;0.242696;5873.22;0.5
004ad5c8-0000-0000-0000-000000000000;2019-05-08T00:36:38.0831033;2019-05-08T00:36:38.0831033;5874;0.464359;5873.21;0.97753
005d4034-0000-0000-0000-000000000000;2019-05-08T00:36:39.0820000;2019-05-08T00:36:39.2127664;5874;0.467765;5873.23;0.5