Hi, I'd like to make a table showing the frequency with which numbers occur each month.
My input is a csv file with a row format of:
Date(d/m/y) num1 num2 num3 num4 num5 num6
for the output the horizontal axes is the months 1 - 12, the vertical axes is numbers 1 - 37.
Each intersection (row/column) will contain the total occurrences for that number that month.
Much appreciated if someone can point me in the right direction.
Thanks
David
My input is a csv file with a row format of:
Date(d/m/y) num1 num2 num3 num4 num5 num6
for the output the horizontal axes is the months 1 - 12, the vertical axes is numbers 1 - 37.
Each intersection (row/column) will contain the total occurrences for that number that month.
Much appreciated if someone can point me in the right direction.
Thanks
David