实验五

任务六

实验源码

with open('data6.csv','r',encoding='gbk')as f:
    data=list(f.readlines())
data=[i.strip('\n') for i in data ]

import decimal
decimal.getcontext().rounding='ROUND_HALF_UP'
title=[data[0],'四舍五入后的数据']
data_new=[]
data_o=[]
for i in data:
    if not i.isalpha() is True:
        data_o.append(eval(i))
print('原始数据：')
print(data_o)
for i in data:
    if not i.isalpha() is True:
        data_new.append([i])

data_=[]
for i in data:
    if not i.isalpha() is True:
        index=data.index(i)-1
        i=eval(i)
        if i-int(i)>=0.5:
            i=int(i)+1
            data_new[index].append(str(i))
            data_.append(i)
        else:
            i=int(i)
            data_new[index].append(str(i))
            data_.append(i)
print('四舍五入后的数据:')
print(data_)
import csv
with open('data6_processed.csv','w',encoding='gbk',newline='') as f :
    f_writer=csv.writer(f)
    f_writer.writerow(title)
    f_writer.writerows(data_new)

运行结果截图

实验源码

with open(r"C:\Users\scy20030602\OneDrive\文档\Tencent Files\2420994345\FileRecv\实验5数据文件\实验5数据文件\data7.csv",'r',
encoding='gbk') as f:
    data=f.readlines()

data0=[i.strip('\n').split(',') for i in data]
data0.remove(data0[0])

data1=sorted(data0,key=lambda x:(x[2],-int(x[3])))

print(f'{"学号":10s}{"姓名":10s}{"专业":10s}{"分数":10s}')
for h,i,j,k in data1:
    print(f'{h:10s}{i:10s}{j:10s}{k:10s}')

with open(r'C:\Users\28678\Downloads\实验5数据文件\data7_processed.csv','w',
encoding='gbk') as f:
    f.write('学号,姓名,专业,分数\n')
    for i in range(len(data1)):
        f.write(','.join(data1[i])+'\n')

运行结果截图

任务八

实验源码

with open(r"C:\Users\scy20030602\OneDrive\文档\Tencent Files\2420994345\FileRecv\实验5数据文件\实验5数据文件\hamlet.txt",'r') as f:
    data=f.read()

print('hamlet.txt粗略统计:')
print(f'行数:{len(data.splitlines())}')
print(f'单词数:{len(data.split())}')
print(f'字符数:{len(data)}')
print(f'空格数:{data.count(" ")}')

data1=data.splitlines()
data2=[]
for i in range(len(data1)):
    data2.append(f'{i+1} '+data1[i]+'\n')

with open(r'C:\Users\28678\Downloads\实验5数据文件\hamlet_with_line_number.txt',
'w') as f:
    f.writelines(data2)

运行结果截图

任务九

实验源码

def is_valid(id):
    if len(id)==18 and id[:-1].isdigit() and (id[-1].isdigit() or id[-1]=='X'):
        return True
    else:
        return False

with open(r"C:\Users\scy20030602\OneDrive\文档\Tencent Files\2420994345\FileRecv\实验5数据文件\实验5数据文件\data9_id.txt",'r') as f:
    data=f.readlines()

data.remove(data[0])
data0=[i.strip('\n').split(',') for i in data]

data1=[]
for i in data0:
    if is_valid(i[1])==True:
        i[1]=i[1][6:14]
        data1.append(i)

import datetime
t=datetime.datetime.now()
y=t.strftime('%Y%m%d')
for i in data1:
    i.append(str(int(y)-int(i[1][0:8])))

data2=sorted(data1,key=lambda x:-int(x[2]))

print('姓名, 出生日期, 年龄')
for i in data2:
    i[1]=i[1][0:4]+'-'+i[1][4:6]+'-'+i[1][6:8]
    i[2]=i[2][0:2]
    print(', '.join(i))

任务十

with open('data10_stu.txt','r',encoding='utf-8') as f:
    data = f.readlines()
print('{:*^40}'.format('抽点开始'))
n = int(input('输入随机抽点人数:'))
import random
x = []
x2 = ''
counts = 0
while counts < n:
    new = random.randint(0, len(data) - 1)
    if new in x:
        new = random.randint(0, len(data) - 1)
    else:
        counts +=1
        x.append(new)
for i in range(n):
    print(data[x[i]])
    x2 += data[x[i]]
    sum1 += n
with open('20230602.txt','w',encoding='utf-8') as f:
    f.writelines(x2)

运行结果截图

with open('data10_stu.txt','r',encoding='utf-8') as f:
    data = f.readlines()
print('{:*^40}'.format('抽点开始'))
n = int(input('输入随机抽点人数:'))
import random
x = []
sum1 = 0
x2 = ''
while n != 0:
    counts = 0
    while counts < n:
        new = random.randint(0, len(data) - 1)
        if new in x:
            new = random.randint(0, len(data) - 1)
        else:
            counts +=1
            x.append(new)
    for i in range(sum1,sum1+n):
        print(data[x[i]])
        x2 += data[x[i]]
    sum1 += n
    n = int(input('输入随机抽点人数:'))

with open('20230602.txt','w',encoding='utf-8') as f:
    f.writelines(x2)

print('{:*^40}'.format('抽点结束'))