实验5

#6

实验内容：

#6
with open('data6.csv','r',encoding='gbk') as f:
    f1=f.readlines()
    f1=list(f1)
l1=[]
l2=[]
title=['原始数据','四舍五入后数据']
info1=f1[1:]
f2=[[str(eval(i)),str(round(eval(i)))] for i in info1]
for i in f2:
    l1.append((i[0]))
    l2.append(eval(i[1]))
with open('data6_processed.csv', 'w', encoding = 'gbk') as f:
    f.write(','.join(title) + '\n')
    for j in f2:
        f.write(','.join(j)+'\n')
print(f'{title[0]}:')
print(l1)
print(f'{title[1]}:')
print(l2)

实验结果：

 

#7

实验内容：

#7
with open ('data7.csv','r',encoding='gbk') as f:
    data=f.readlines()
l=[]
l1=[]
for i in data:
    l.append(list((i).split(',')))
l[-1][-1]+='\n'
l=sorted(l,key=lambda x:x[3],reverse=True)
with open ('data7_processed.csv', 'w', encoding = 'gbk') as f:
    for i in l:
        f.write(','.join(i))
print('    '.join(['学号','姓名','专业','分数']))
for i in l[1:]:
    i[-1]=str(eval(i[-1]))
    print('    '.join(i))

实验结果：

 

 #8

实验内容：

#8
with open ('hamlet.txt','r') as f:
    h=f.read()
lines=h.split('\n')
hs=len(lines)
words=h.split()
dcs=len(words)
zfs=len(h)
kgs=h.count(' ')
print('hamlet.txt粗略统计：')
print(f'行数：{hs}')
print(f'单词数：{dcs}')
print(f'字符数：{zfs}')
print(f'空格数：{kgs}')
c=1
with open('hamlet_with_line_number.txt','w') as f:
    for i in lines:
        f.write(f'{c} {i}+\n')
        c+=1

实验结果：

 

 

#9

实验内容：

#9
def is_valid(x):
    x=list(x)
    if len(x) !=18:
        return False
    for i in x[:-2]:
        if i.isdigit():
            pass
        else:
            return False
            break
    if str(x[-1]) in ['0','1','2','3','4','5','6','7','8','9','X']:
        return True
    else:
        return False

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

with open('data9_id.txt','r') as f:
    data=f.read()
data=data.split('\n')
l=[]
l2=[]
for i in data:
    i=i.split(',')
    l.append(list(i))
for i in l[1:]:
    if is_valid(i[1]) is True:
        p=f'{i[1][6:10]}-{i[1][10:12]}-{i[1][12:14]}'
        age=int(t[0:4])-int(i[1][6:10])
        if int(t[4:8])-int(i[1][10:14])>=0:
            age+=1
        else:
            age-=1
        l2.append([i[0],p,age])
l2=sorted(l2,key=lambda x:x[2],reverse=True)
print('姓名， 出生日期， 年龄')
for i in l2:
    print(f'{i[0]}, {i[1]}, {i[2]}')

实验结果：

 

#10

实验内容：

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

with open ('data10_stu.txt','r') as f:
    stu=f.read()
stu=stu.split('\n')

l=[]
for i in stu:
    l.append(i)
c=[i for i in range(0,len(l))]
n=int(input('输入随机抽点人数：'))
for i in range(n):
    j=random.sample(c,5)

with open (f'{t}.txt','w') as f:
    for i in j:
        print(l[i])
        f.write(l[i]+'\n')

实验结果：