我一直在写一本有多张纸的excel书。例如,我有学生名单,为每个学生和多个科目的学生和学生所承担的独特数字和他们的出席情况如下:
单张编号1- 18CS45
参加会议的人:总百分比( |------------|-------|----------|-------|---------| ):1US22CS001
单号2- 18CS56
参加会议的人:总百分比( |------------|-------|----------|-------|---------| ):1US22CS001
我想根据USN从第1页和第2页中提取数据行,并将其保存为每个学生和每个学生的CSV。如何使用python openpyxl或csv包来实现这一目标
发布于 2022-06-07 08:31:24
有一种使用函数的基本方法,你可以试一试。我也解释了代码的每一部分。
)。
import csv
def pull_data(sheet1, sheet2, usn_number):
# Open the first sheet
with open(sheet1, 'r') as sheet1_file:
sheet1_reader = csv.reader(sheet1_file)
# Open the second sheet
with open(sheet2, 'r') as sheet2_file:
sheet2_reader = csv.reader(sheet2_file)
# Open the csv file
with open('data.csv', 'w') as csv_file:
csv_writer = csv.writer(csv_file)
# Loop through the first sheet
for row in sheet1_reader:
# Check if the usn number is in the first sheet
if usn_number in row:
# If it is, add the row to the csv file
csv_writer.writerow(row)
# Loop through the second sheet
for row in sheet2_reader:
# Check if the usn number is in the second sheet
if usn_number in row:
# If it is, add the row to the csv file
csv_writer.writerow(row)
pull_data('sheet1.csv', 'sheet2.csv', 'USN_NUMBER')https://stackoverflow.com/questions/72528040
复制相似问题