实验5

task6

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_after.csv','w',encoding='gbk',newline='') as f :
    f_writer=csv.writer(f)
    f_writer.writerow(title)
    f_writer.writerows(data_new)

task7

with open('data7.csv','r',encoding='gbk')as f:
    title=[f.readline()]
    data=f.readlines()
def getscore(ls):
    return ls[len(ls)-1]

data=[line.strip('\n').split(',')for line in data]

data.sort(key=lambda x:(x[2],-int(x[3])))


with open('data7_processed.csv', 'w', encoding = 'gbk') as f:
    f.write(','.join(title))
    for item in data:
        f.write(','.join(item) + '\n')
title=title[0].strip('\n').split(',')

print('{:<10}'.format(title[0]),'{:<10}'.format(title[1]),'{:<10}'.format(title[2]),'{:<15}'.format(title[3]))
for i in data:
    print('{:<10}'.format(i[0]), '{:<10}'.format(i[1]), '{:<10}'.format(i[2]), '{:<10}'.format(i[3]))

 

task8

with open('hamlet.txt','r',encoding='utf-8')as f:
    data=f.readlines()
    print('行数：',len(data))

x=''
for line in data:
    x+=line
alpha=0
b=0
for i in x:
    if i.isalpha():
        alpha+=1
    else:
        b+=1

word=len(x.split())
print('字符数：',alpha+b)
print('单词数：',word)
print('空格数：',x.count(' '))
data = [line.strip('\n').split(',') for line in data]
with open('hamlet_with_line_number','w',encoding='utf-8') as f:
    for i,j in enumerate(data,start=1):
        j=j[0]
        f.write("{}{}{}".format(i,' ',j)+'\n')

task9

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

info=[line.strip('\n').split(',')for line in data]
del info[0]

def is_valid(id):
    y=id[:17]
    if (i in ['1','2','3','4','5','6','7','8','9','0','X'] for i in id) and len(id)==18 and y.isdigit() and (id[17]=='X' or id[17].isdigit()):
        return True
    else:
        return False
print('{:<10} {:<10} {:<10} '.format('姓名','出生日期','年龄'))
import datetime
today=datetime.date.today()
valid_ls=[]
for ls in info:
    if is_valid(ls[1]) is True:
        y, m, d = ls[1][6:10], ls[1][10:12], ls[1][12:14]
        birth = y + '-' + m + '-' + d
        ls.append(birth)
        del ls[1]
        birthday=datetime.date(year=int(y),month=int(m),day=int(d))
        age=str(round((today-birthday).days/365))
        ls.append(age)
        valid_ls.append(ls)
def takeThird(elem):
    return elem[2]
valid_ls.sort(key=takeThird,reverse = True)
for ls in valid_ls:
    for i in ls:
        print('{:8}'.format(i),end='    ')
    print()

task10_1

import datetime
t = datetime.datetime.now()
filename = t.strftime('%Y%m%d') + '.txt'
n=eval(input('输入随机抽取人数：'))
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
x=random_selection(n)
for i in x :
    print(i)


with open(filename,'w',encoding='utf-8')as f:
    f.writelines(x)

 

 

task10_2

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