利用pandas解决问题：Firstly, input an integer � N, which represents a total of � N students. Then enter � N lines, each containing the student's name, class, exam 1 score, and exam 2 score. Count the average and total scores of each exam for each class, and sort the results by class name before outputting them to the console. Output includes class, score1_mean, score1_sum, score2_mean, score2_sum.

可以使用 pandas 来解决这个问题。首先，需要安装 pandas 库，并导入它。

!pip install pandas
import pandas as pd

然后，可以使用以下代码读取输入数据：

n = int(input())   # 输入总共有多少个学生

data = []
for i in range(n):
    line = input().split()
    data.append(line)

df = pd.DataFrame(data, columns=['name', 'class', 'score1', 'score2'])

现在，我们将数据存储在一个名为 `df` 的 pandas 数据框中。接下来，我们需要计算每个班级的平均分和总分，并按班级名称分类。可以使用以下代码实现这一点：

class_scores = df.groupby('class').agg({'score1': ['mean', 'sum'], 'score2': ['mean', 'sum']})
class_scores.columns = ['score1_mean', 'score1_sum', 'score2_mean', 'score2_sum']

最后，我们可以按照班级名称排序并输出结果：

class_scores = class_scores.sort_index()
print(class_scores)

完整代码如下：

!pip install pandas
import pandas as pd

n = int(input())   # 输入总共有多少个学生

data = []
for i in range(n):
    line = input().split()
    data.append(line)

df = pd.DataFrame(data, columns=['name', 'class', 'score1', 'score2'])

class_scores = df.groupby('class').agg({'score1': ['mean', 'sum'], 'score2': ['mean', 'sum']})
class_scores.columns = ['score1_mean', 'score1_sum', 'score2_mean', 'score2_sum']

class_scores = class_scores.sort_index()
print(class_scores)