I am given a .txt file and it contains two columns of multiple numbers separated by some spaces. The first column is an identification number while the following number in that row is a GPA. I need to find the average GPA for each identification number. An example is
1A 4.00
1A 3.79
1B 3.9
2A 4.0
2A 3.9
I need to categorize the averages by 1A, 1B, 2A, etc. I know how to input the text file but I am lost from there. I then need to categorize the GPA average from a certain GPA and up, such as all GPAs above a 3.5. Please help!