文件应用编程

task6

import csv
title = []
info = []

with open('data6.csv','r',encoding='gbk') as f:
    f_reader = csv.reader(f)
    for line in f_reader:
        info.append(line)
x = info.pop(0)
title.append(x)
title[0].append('四舍五入后数据')
for i in info:
    mypoia = int(float(i[0])+0.5)
    i.append(str(mypoia))

with open('data6_processed.csv','w',encoding='gbk',newline = '') as f:
    f_writer = csv.writer(f)
    f_writer.writerow(title[0])
    f_writer.writerows(info)

print(title[0][0] + ':')
o = []
for i in info:
    o.append(i[0])
print(o)
print(title[0][1] + ':')
p = []
for i in info:
    p.append(i[1])
print(p)import csv
title = []
info = []

with open('data6.csv','r',encoding='gbk') as f:
    f_reader = csv.reader(f)
    for line in f_reader:
        info.append(line)
x = info.pop(0)
title.append(x)
title[0].append('四舍五入后数据')
for i in info:
    mypoia = int(float(i[0])+0.5)
    i.append(str(mypoia))

with open('data6_processed.csv','w',encoding='gbk',newline = '') as f:
    f_writer = csv.writer(f)
    f_writer.writerow(title[0])
    f_writer.writerows(info)

print(title[0][0] + ':')
o = []
for i in info:
    o.append(i[0])
print(o)
print(title[0][1] + ':')
p = []
for i in info:
    p.append(i[1])
print(p)

结果：

 

task7

import csv

title = []
info = []

with open('data7.csv','r',encoding = 'gbk') as f:
    f_reader = csv.reader(f)
    for line in f_reader:
        info.append(line)
x = info.pop(0)
title.append(x)

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


with open('data7_processed.csv','w',encoding = 'gbk',newline='') as f:
    f_writer = csv.writer(f)
    f_writer.writerow(title[0])
    f_writer.writerows(info)
for i in title[0]:
    print('%-10s'%i, end= '')
print()
for i in info:
    for x in i:
        print('%-10s'%x,end= '')
    print()

结果：

 

task8

with open('hamlet.txt','r',encoding= 'utf-8') as f:
    text = f.readlines()
lin = 0
for line in text:
    lin += 1
words = []
for i in text:
    if not i.isspace():
        words.append(i)
words_c = 0
import re
for i in words:
    i = re.split(' |\n|\t|:|,|;',i)
    for word in i:
        if word.isalpha():
            words_c += 1
characters = 0
for i in text:
    for character in i:
        characters += 1
blanks = 0
for i in text:
    for blank in i:
        if blank == ' ':
            blanks += 1
print('hamlet.txt粗略统计：')
print(f'行数：{lin}')
print(f'单词数：{words_c}')
print(f'字符数：{characters}')
print(f'空格数：{blanks}')


lines = []
for number, line in enumerate(text, 1):
    lines.append(f'{number}{line}')
with open('hamlet_with_line_number.txt','w',encoding='utf-8') as f:
    for line in lines:
        f.write(line)

结果：

task9

import datetime


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


with open('data9_id.txt', 'r', encoding='utf-8') as f:
    data0 = f.readlines()
    title = data0.pop(0)

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

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

t = datetime.datetime.now()
y = t.strftime('%Y%m%d')
for i in data1:
    age = str(int(y)-int(i[1][6:14]))
    i.append(age[:2])
    i[1] = i[1][6:10] + '-' + i[1][10:12] + '-' + i[1][12:14]
data2 = sorted(data1, key=lambda x: -int(x[2]))

print('姓名, 出生日期, 年龄')
for i in data2:
    print(', '.join(i))

结果：

 

task10_1

with open('data10_stu.txt','r',encoding='utf-8') as f:
    data = f.readlines()
print('{:*^40}'.format('抽点开始'))
n = int(input('输入随机抽点人数:'))
import random
sum1 = 0
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)

结果：

task10_2

with open('data10_stu.txt','r',encoding='utf-8') as f:
    data = f.readlines()
print('{:*^40}'.format('抽点开始'))
lst1 = []
x = []
while True:
    n = int(input('输入随机抽点人数:'))
    if n == 0:
        print('{:*^40}'.format('抽点结束'))
        break
    else:
        x = []
        import random
        while len(x) < n:
            t = random.randint(0, len(data)-1)
            if (str(t) not in lst1) and (str(t) not in x):
                x.append(t)
                lst1.append(t)

        lst = []
        for i in x:
            print(data[i],end = '\n')
        lst.append(data[i])

        import datetime
        t = datetime.datetime.now()
        y = t.strftime('%Y%m%d')
        with open(f'{y}.txt','w',encoding='utf-8') as f:
            f.writelines(lst)

结果：