实验五

tack6

with open('data6.csv','r',encoding='gbk') as f:
    data=f.readlines()

k=[]
for i in data:
    k.append(i.strip())

print(f'{k[0]}:\n{k[1:]}')
s=['四舍五入后数据']
for j in k[1:]:
    s.append(str(int(float(j)+0.5)))
print(f'{s[0]}:\n{s[1:]}')
g=[]
for m in range(1,len(k)):
    g.append([k[m],s[m]])
print(g)

with open('data6_processed.csv','w',encoding='gbk') as f:
    for n in g:
        f.write(','.join(n)+'\n')

tack7

with open(r"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'data7_processed.csv','w',
encoding='gbk') as f:
    f.write('学号,姓名,专业,分数\n')
    for i in range(len(data1)):
        f.write(','.join(data1[i])+'\n')

tack8

with open(r"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'hamlet_with_line_number.txt','w') as f:
    f.writelines(data2)

tack9

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"data9_id.txt",'r',encoding='utf-8') 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))

tack10

with open(r"data10_stu.txt",'r',encoding='utf-8') as f:
    data=f.readlines()

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

import random
n=eval(input('输入随机抽点人数：'))
data1=random.sample(data0,n)
for i in data1:
    print(' '.join(i))

import datetime
t=datetime.datetime.now()
fn=t.strftime('%Y%m%d')

with open(r'{}.txt'.format(fn),'w') as f:
    for i in data1:
        i[0]+='\t'
        i[1]+='\t'
        i[2]+='\n'
        f.writelines(i)

 

import datetime
t = datetime.datetime.now()
filename = t.strftime('%Y%m%d') + '.txt'
start='抽取开始'
print(start.center(50,'*'))
with open('data10_stu.txt', 'r', encoding='utf-8') as f:
    data = f.readlines()

def random_selection(n):
    import random
    demo = random.sample(data, n)
    return demo
selection=set()
numbers=[]

while True:
    n = eval(input('输入随机抽点人数：'))
    if n != 0:
        x=random_selection(n)
        for i in x:
            print(i)
            data.remove(i)
            with open(filename,'a',encoding='utf-8') as f :
                f.writelines(i)
    else:
        print('抽取结束'.center(50,'*'))
        break