
PTA数据结构与算法题目集(中文) 7-37 模拟EXCEL排序 (25 分)
7-37 模拟EXCEL排序 (25 分)
Excel可以对一组纪录按任意指定列排序。现请编写程序实现类似功能。
输入格式:
输入的第一行包含两个正整数N(≤) 和C,其中N是纪录的条数,C是指定排序的列号。之后有 N行,每行包含一条学生纪录。每条学生纪录由学号(6位数字,保证没有重复的学号)、姓名(不超过8位且不包含空格的字符串)、成绩([0, 100]内的整数)组成,相邻属性用1个空格隔开。
输出格式:
在N行中输出按要求排序后的结果,即:当C=1时,按学号递增排序;当C=2时,按姓名的非递减字典序排序;当C=3时,按成绩的非递减排序。当若干学生具有相同姓名或者相同成绩时,则按他们的学号递增排序。
输入样例:
3 1
000007 James 85
000010 Amy 90
000001 Zoe 60
输出样例:
000001 Zoe 60
000007 James 85
000010 Amy 90
题目分析:这道题是利用表排序和排序算法的一道题 排序算法采用快排 但最后有两组数据没通过 查了资料用c++STL中的sort就可以 STL中sort函数不单单使用了快排 而且使用了插入排序和堆排序
#define _CRT_SECURE_NO_WARNINGS
#include<stdio.h>
#include<string.h>
#include<malloc.h> struct Student
{
int Id;
char Name[];
int Score;
}students[];
int Table[];
void Swap(int i, int j)
{
int tmp = Table[i];
Table[i] = Table[j];
Table[j] = tmp;
}
void Quick_Sort_1(int start,int end)
{
if (start >= end - )
return;
int tmp = (start + end) / ;
//三元取中值
if (students[Table[start]].Id > students[Table[end - ]].Id)
Swap(start, end - );
if (students[Table[start]].Id > students[Table[tmp]].Id)
Swap(start, tmp);
if (students[Table[tmp]].Id > students[Table[end - ]].Id)
Swap(tmp, end - );
Swap(start, tmp);
int i = start + ;
for (int j = start+; j < end; j++)
{
if (students[Table[j]].Id < students[Table[start]].Id)
Swap(i++, j);
}
Swap(start,i-);
Quick_Sort_1(start, i-);
Quick_Sort_1(i, end);
}
void Quick_Sort_2(int start, int end)
{
if (start >= end - )
return;
int tmp = (start + end) / ;
if (strcmp(students[Table[start]].Name, students[Table[end-]].Name)<)
Swap(start, end - );
if (strcmp(students[Table[start]].Name, students[Table[tmp]].Name) < )
Swap(start, tmp);
if (strcmp(students[Table[tmp]].Name, students[Table[end-]].Name) < )
Swap(tmp, end - );
Swap(start, tmp);
int i = start + ;
for (int j = start + ; j < end; i++)
{
if (strcmp(students[Table[j]].Name, students[Table[start]].Name) < )
Swap(i++, j);
else if (!strcmp(students[Table[j]].Name, students[Table[start]].Name))
if (students[Table[j]].Id < students[Table[start]].Id)
Swap(i++, j);
}
Swap(start, i - );
Quick_Sort_2(start, i - );
Quick_Sort_2(i, end);
} void Quick_Sort_3(int start, int end)
{
if (start >= end - )
return;
int tmp = (start + end) / ;
if (students[Table[start]].Score > students[Table[end - ]].Score)
Swap(start, end - );
if (students[Table[start]].Score > students[Table[tmp]].Score)
Swap(start, tmp);
if (students[Table[tmp]].Score > students[Table[end - ]].Score)
Swap(tmp, end - );
Swap(start, tmp);
int i = start + ;
for (int j = start + ; j < end; j++)
{
if (students[Table[j]].Score < students[Table[start]].Score)
Swap(i++, j);
else if (students[Table[j]].Score == students[Table[start]].Score)
if (students[Table[j]].Id < students[Table[start]].Id)
Swap(i++, j);
}
Swap(start, i - );
Quick_Sort_3(start, i - );
Quick_Sort_3(i, end);
}
int main()
{
int N,C;
scanf("%d%d", &N,&C);
int id=, score=;
char name[] = { };
for (int i = ; i < N; i++)
{
Table[i] = i;
scanf("%d%s%d", &id, name, &score);
students[i].Id = id;
strcpy(students[i].Name, name);
students[i].Score = score;
}
switch (C)
{
case :Quick_Sort_1(, N); break;
case :Quick_Sort_2(, N); break;
case :Quick_Sort_3(, N); break;
}
for (int i = ; i < N; i++)
printf("%06d %s %d\n", students[Table[i]].Id,students[Table[i]].Name,students[Table[i]].Score);
return ;
}