sunchenxi

导航

实验6 文件应用编程-2 

 1 #task1_1
 2 title=['城市', '人口(万)']
 3 info=[['南京', '850'],
 4       ['纽约', '2300'],
 5       ['东京', '3800'],
 6       ['巴黎', '1000']]
 7 with open('city.csv','w',encoding='utf-8')as f:
 8     f.write(','.join(title)+'\n')
 9     for item in info:
10         f.write(','.join(item)+'\n')
11 
12 #task1_2
13 with open('city.csv','r',encoding='utf-8')as f:
14     print(f.read().rstrip('\n'))
15     f.close()
16 
17 #task1_3
18 with open('city.csv','r',encoding='utf-8')as f:
19     data=f.readlines()
20 print('data=')
21 print(data)
22 info=[line.rstrip('\n').split(',') for line in data]
23 print('info=')
24 print(info)

#task2_1
import csv
title=['城市', '人口(万)']
info=[['南京', '850'],
      ['纽约', '2300'],
      ['东京', '3800'],
      ['巴黎', '1000']]
with open('city2.csv','w',encoding='utf-8',newline='') as f:
    f_writer=csv.writer(f)
    f_writer.writerow(title)
    f_writer.writerows(info)

#task2_2
import csv
with open('city2.csv','r',encoding='utf-8') as f:
    f_reader=csv.reader(f)
    for line in f_reader:
        print(line)

#task2_3
import csv
with open('city3.csv','w',encoding='utf-8',newline='') as f:
    title = ['城市', '人口']
    f_writer=csv.DictWriter(f,fieldnames=title)
    f_writer.writeheader()
    f_writer.writerow({'城市':'南京', '人口': '850万'})
    f_writer.writerow({'城市':'纽约', '人口': '2300万'})
    f_writer.writerow({'城市':'东京', '人口': '3800万'})
    f_writer.writerow({'城市': '巴黎', '人口': '1000万'})

#task2_4
import csv
with open('city3.csv','r',encoding='utf-8')as f:
    f_reader=csv.DictReader(f)
    for line in f_reader:
        print(line)

 1 #task3
 2 def is_valid(ID):
 3     if len(ID[1]) == 18 and (set(ID[1]) - set('0123456789X') in set('0123456789X') or set(ID[1]) - set('0123456789X') == set()):
 4         return True
 5     return False
 6 
 7 with open('data3_id.txt','r',encoding='utf-8')as f:
 8     datas=f.readlines()
 9     datas.pop(0)
10     ID_name=[(i[:2],i[3:].strip('\n')) for i in datas]
11     result=list(filter(is_valid,ID_name))
12     result.sort(key=lambda x:int(x[1][6:14]))
13     for i in result:
14         print(f"{i[0]},{i[1][6:10]}-{i[1][10:12]}-{i[1][12:14]}")

 1 #task5_1
 2 with open('data5_1.txt','r',encoding='utf-8')as f:
 3     data=f.readlines()
 4     for i in data:
 5         i.strip("\n")
 6 import random
 7 n=int(input('输入随机抽点人数:'))
 8 sample=random.sample(data,n)
 9 import datetime
10 t=datetime.datetime.now()
11 filename=t.strftime('%Y%m%d')+'txt'
12 with open(filename,'w',encoding='utf-8')as f:
13     for i in sample:
14         print(i)
15         f.write(i+'\n')

 1 #task5_2
 2 with open('data5_1.txt','r',encoding='utf-8')as f:
 3     data=f.readlines()
 4     for i in data:
 5         i.strip("\n")
 6 import datetime
 7 t=datetime.datetime.now()
 8 filename=t.strftime('%Y%m%d')+'txt'
 9 print(f"{'抽点开始':=^40}")
10 import random
11 while True:
12     n=int(input('输入随机抽点人数:'))
13     sample=random.sample(data,n)
14     for i in sample:
15         data.remove(i)
16     with open(filename, 'a+', encoding='utf-8') as f:
17         for i in sample:
18             print(i)
19             f.write(i)
20     if n==0:
21         print(f"{'抽点结束':=^40}")
22         break

 

posted on 2022-05-21 20:30  靠谱一星  阅读(36)  评论(0)    收藏  举报