import csv
reader1 = csv.reader(open('files/北京高档酒店价格分析.csv'))
reader2 = csv.DictReader(open('files/北京高档酒店价格分析.csv'))
for x in reader2:
score = eval(f"{x['卫生评分']} + {x['服务评分']} + {x['设施评分']} + {x['位置评分']}") / 4
print(x['\ufeff酒店名称'], score)
import csv
writer = csv.writer(open('files/学生信息.csv', 'w', newline=''))
writer.writerow(['姓名', '性别', '年龄', '分数'])
writer.writerows([
['小明', '男', 18, 90],
['小花', '女', 20, 88]
])
writer2 = csv.DictWriter(
open('files/学生信息2.csv', 'w', newline='', encoding='utf-8'),
['姓名', '性别', '年龄', '分数']
)
writer2.writeheader()
writer2.writerow({'姓名': '小明', '年龄': 18, '分数': 90, '性别': '男'})
writer2.writerows([
{'姓名': '小花', '年龄': 20, '分数': 88, '性别': '女'},
{'姓名': '张三', '年龄': 28, '分数': 76, '性别': '男'}
])
from PyPDF2 import PdfFileReader, PdfFileWriter
reader = PdfFileReader(open('files/美食分享.pdf', 'rb'))
page_num = reader.numPages
print(page_num)
page1 = reader.getPage(0)
page2 = reader.getPage(1)
writer = PdfFileWriter()
writer.addPage(page1)
writer.addBlankPage()
writer.write(open('files/new.pdf', 'wb'))
from PyPDF2 import PdfFileWriter, PdfFileReader
reader1 = PdfFileReader(open('files/存储引擎的讲解.pdf', 'rb'))
reader2 = PdfFileReader(open('files/美食分享.pdf', 'rb'))
page_num1 = reader1.numPages
page_num2 = reader2.numPages
min_page = min(page_num1, page_num2)
empty = PdfFileWriter()
for index in range(min_page):
empty.addPage(reader1.getPage(index))
empty.addPage(reader2.getPage(index))
if page_num1 > min_page:
reader = reader1
max_page = page_num1
else:
reader = reader2
max_page = page_num2
for index in range(min_page, max_page):
empty.addPage(reader.getPage(index))
empty.write(open('files/合并.pdf', 'wb'))
from PyPDF2 import PdfFileReader, PdfFileWriter
water_reader = PdfFileReader(open('files/watermark.pdf', 'rb'))
file_reader = PdfFileReader(open('files/存储引擎的讲解.pdf', 'rb'))
water_page = water_reader.getPage(0)
page1 = file_reader.getPage(0)
page1.mergePage(water_page)
writer = PdfFileWriter()
writer.addPage(page1)
writer.write(open('files/new_存储引擎的讲解.pdf', 'wb'))
from reportlab.pdfgen import canvas
from reportlab.pdfbase import pdfmetrics
from reportlab.pdfbase.ttfonts import TTFont
pdfmetrics.registerFont(TTFont('font1', 'files/bb.ttf'))
pdfmetrics.registerFont(TTFont('font2', 'files/dd.ttf'))
pdf = canvas.Canvas('files/water.pdf')
pdf.setFont('font1', 30)
pdf.setFillColorRGB(1, 0, 0, 0.5)
pdf.rotate(45)
pdf.drawString(30, 20, 'YuTing')
pdf.setFont('font2', 50)
pdf.setFillColorRGB(123/255, 104/255, 238/255, 0.5)
pdf.rotate(90)
pdf.drawString(300, 200, '余婷')
pdf.save()