How to calculate avg values of csv file using shell scripting .?

Shell Programming and Scripting
1

hi all i have a reporting work and i want it to be automated using shell scripting kindly let me know how can i make that possibe .

eg data are :

Date,Time,nl45.1,nl45.2,nl45.3,nl45.4,nl46.1,nl46.2,nl46.3,nl46.4,nl46.5,nl47.1,nl47.2,nl47.3,nl47.4,nl47.5,nl48.1,nl48.2,nl48.3,nl48.4,nl49.1,nl49.2,nl49.3,nl50.1,nl50.2,nl50.3,nl50.4,nl50.5*
12-01-2016,00:00,1,1,1,0,,0,1,1,0,0,0,0,1,3,1,1,0,0,0,,0,0,0,,,1,1,0,6,0,*
12-01-2016,00:10,1,0,0,0,,2,1,1,1,0,0,0,0,1,1,1,0,0,0,,0,0,1,,,0,0,0,1,0,*
12-01-2016,00:20,0,0,1,0,,0,0,0,0,0,0,0,1,0,0,1,0,0,0,,0,0,0,,,2,0,0,0,0,*
12-01-2016,00:30,0,0,0,0,,1,0,0,1,0,0,2,2,0,0,0,0,0,0,,0,1,1,,,0,0,0,0,0,*
12-01-2016,00:40,0,0,1,0,,1,0,1,0,0,0,0,0,1,1,0,0,0,0,,0,2,0,,,0,0,0,0,1,*
12-01-2016,00:50,0,0,0,0,,0,0,1,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,,,1,0,0,1,1,*
2

Hello and welcome to the forum.
Please use code tags for code blocks, as you have accepted by the forum rules.

Since this post is similar (if not identical) to

If this is a homework, please refer to the homework section of the forum and follow the guidelines that apply there.

Either way, any attempts from your side yet?

3

In addition to what sea has already said, you need to provide a much clearer description of what you are trying to do. Are you looking for a single number that is the average value of the values all non-time, non-asterisk, non-empty, non-header fields? Are you looking for the average of values in each line? Are you looking for the average of values in each column? Are empty fields to be treated as zero and included in the average(s) or skipped?

At the very least, show us the output you hope to produce (in CODE tags) from the sample input you provided.