Python3代码中total_count无法正常打印的问题解决方法

以下 Python3 代码中 total_count 项无法正常打印，该问题可能是由于没有在处理单个文件时自增 total_count 的缘故。/n/npython/nimport os/nimport re/nimport subprocess/nimport openpyxl/nimport math/nfrom openpyxl.styles import Font, PatternFill, Alignment/n/n# 视频格式/nsupported_formats = [/n '.mp4',/n '.avi',/n '.mkv',/n '.wmv',/n '.mov',/n '.flv',/n '.m2ts',/n '.ts',/n '.rm',/n '.rmvb',/n '.vob',/n '.3gp',/n '.webm',/n '.hdmov',/n '.mp4v',/n '.mpv4',/n '.divx',/n '.xvid',/n '.f4v',/n '.mpeg',/n '.asf',/n '.asx',/n '.m2t',/n]/n/n# 输出Excel路径/nexcel_folder = '.'/n/n# 输出Excel文件名/nexcel_file = 'video_info.xlsx'/n/n# 正则表达式匹配码率数据中的空格/npattern = re.compile(r'(/d+)/s+(/d+)')/n/n# 创建Excel文件/nwb = openpyxl.Workbook()/nws = wb.active/nws.title = 'Video Info'/n/n# 锁定表头/nws.freeze_panes = 'A2'/n/n# 设置表头样式/nheader_font = Font(bold=True, color='800080') # 紫色/nheader_fill = PatternFill('solid', fgColor='C5E0B4')/nheader_alignment = Alignment(horizontal='center', vertical='center')/nheaders = [/n '文件名',/n '文件路径',/n '格式',/n '大小',/n '时长',/n '分辨率',/n '码率',/n '帧率',/n '音频码率',/n '音频采样率',/n '音频语言',/n '压缩比率',/n]/nfor col, header in enumerate(headers, start=1):/n cell = ws.cell(row=1, column=col, value=header)/n cell.font = header_font/n cell.fill = header_fill/n cell.alignment = header_alignment/n/n# 处理失败文件个数/nfailed_count = 0/n/n# 总计处理文件数/ntotal_count = 0/n/n# 遍历所有视频文件/nsuccess_count = 0/nrow = 2 # 从第二行开始写入数据/n/ndef process_video(video_file):/n global success_count, row, failed_count, total_count/n try:/n # 获取文件名/n file_name = os.path.basename(video_file)/n/n # 获取文件大小并进行单位换算/n size = os.path.getsize(video_file)/n if size < 1024:/n size_str = f'{size} B'/n elif size < 1024 * 1024:/n size_str = f'{size / 1024:.2f} KiB'/n elif size < 1024 * 1024 * 1024:/n size_str = f'{size / 1024 / 1024:.2f} MiB'/n else:/n size_str = f'{size / 1024 / 1024 / 1024:.2f} GiB'/n/n # 使用mediainfo获取视频信息 / 音频信息/n video_result = subprocess.run(/n [/n 'mediainfo',/n '--Inform=Video;%Format%|%Width%x%Height%|%BitRate/String%|%FrameRate%|%Duration/String3%',/n video_file,/n ],/n stdout=subprocess.PIPE,/n )/n video_output = video_result.stdout.decode().strip()/n audio_result = subprocess.run(/n [/n 'mediainfo',/n '--Inform=Audio;%BitRate/String%|%SamplingRate/String%|%Language/String%',/n video_file,/n ],/n stdout=subprocess.PIPE,/n )/n audio_output = audio_result.stdout.decode().strip()/n/n # 解析输出结果/n video_info = video_output.split('|')/n audio_info = audio_output.split('|')/n/n # 处理多音轨情况/n audio_bitrate = []/n audio_sampling_rate = []/n audio_lang = []/n for i in range(len(audio_info) // 3):/n audio_bitrate.append(audio_info[i * 3])/n audio_sampling_rate.append(audio_info[i * 3 + 1])/n audio_lang.append(audio_info[i * 3 + 2])/n/n # 时长取整/n duration = video_info[4].split('.')[0]/n h, m, s = duration.split(':')/n duration = f'{h}:{m}:{str(s).zfill(2)}'/n/n # 以分钟计算的时长 2/n duration_minutes = int(h) * 60 + int(m) + math.ceil(float(s)) / 60/n/n # 计算压缩比率/n ratio = round(duration_minutes / size * 1000000000, 2)/n/n # 使用正则表达式替换码率数据中第一个数字和第二个数字之间的空格/n bitrate = re.sub(pattern, r'//1//2', video_info[2])/n/n # 写入Excel文件/n ws.cell(row=row, column=1, value=file_name)/n ws.cell(row=row, column=2, value=os.path.dirname(video_file)) # 写入文件夹路径/n ws.cell(row=row, column=3, value=video_info[0])/n ws.cell(row=row, column=4, value=size_str)/n ws.cell(row=row, column=5, value=duration)/n ws.cell(row=row, column=6, value=video_info[1])/n ws.cell(row=row, column=7, value=bitrate)/n ws.cell(row=row, column=8, value=video_info[3])/n ws.cell(row=row, column=9, value=' / '.join(audio_bitrate))/n ws.cell(row=row, column=10, value=' / '.join(audio_sampling_rate))/n ws.cell(row=row, column=11, value=' / '.join(audio_lang))/n ws.cell(row=row, column=12, value=ratio)/n # 打印进度/n success_count += 1/n total_count += 1 # 在处理单个文件时也自增total_count/n print(f'已处理 {success_count}/{total_count} 共计', end='//r')/n/n except Exception as e:/n # 处理失败，跳过并打印文件名和具体错误信息/n failed_count += 1/n print(f'处理文件 {video_file} 时失败：{e}')/n # 将失败的文件写入到err.txt/n with open('err.txt', 'a') as f:/n f.write(f'{video_file}//n')/n return False/n/n return True/n/ndef process_folder(video_folder):/n global total_count/n # 获取视频文件列表（包括子目录）/n video_files = []/n for root, dirs, files in os.walk(video_folder):/n for file in files:/n for format in supported_formats:/n if file.endswith(format):/n video_files.append(os.path.join(root, file))/n break/n for video_file in video_files:/n if process_video(video_file):/n print(f'已处理 {success_count}/{total_count} 共计', end='//r')/n total_count += 1/n/n# 文件路径/npath = input('请输入文件路径：')/nif os.path.isfile(path):/n process_video(path)/n total_count += 1/nelif os.path.isdir(path):/n process_folder(path)/n/n# 调整L列左对齐/nl_col = ws['L']/nfor cell in l_col:/n cell.alignment = Alignment(horizontal='left') # 左对齐/n/n# 固定列宽/nfor col in ws.columns:/n col_letter = col[0].column_letter/n if col_letter not in ['C', 'H']: # 不固定格式、帧率列的宽度/n ws.column_dimensions[col_letter].width = 11/n/n# 保存Excel文件/nif not os.path.exists(excel_folder):/n os.makedirs(excel_folder)/nexcel_file_path = os.path.join(excel_folder, excel_file)/nwb.save(excel_file_path)/n/n# 打印处理失败文件个数和总计处理文件数/nprint(/n f'已完成，处理成功 {success_count} 个文件，处理失败 {failed_count} 个文件，视频信息已保存到 {excel_file_path}'/n)/n/n/n问题原因：/n/n在处理单个文件时，total_count 并没有自增，只有在遍历文件夹时 total_count 才会自增。/n/n解决方法：/n/n在 process_video 函数中，在处理单个文件并成功写入Excel后添加一行代码 total_count += 1 ，使其在处理单个文件时也自增 total_count。/n/npython/n# .../n# 写入Excel文件/n# .../n # 打印进度/n success_count += 1/n total_count += 1 # 在处理单个文件时也自增total_count/n print(f'已处理 {success_count}/{total_count} 共计', end='//r')/n# .../n/n/n修改后的代码:/n/npython/nimport os/nimport re/nimport subprocess/nimport openpyxl/nimport math/nfrom openpyxl.styles import Font, PatternFill, Alignment/n/n# 视频格式/nsupported_formats = [/n '.mp4',/n '.avi',/n '.mkv',/n '.wmv',/n '.mov',/n '.flv',/n '.m2ts',/n '.ts',/n '.rm',/n '.rmvb',/n '.vob',/n '.3gp',/n '.webm',/n '.hdmov',/n '.mp4v',/n '.mpv4',/n '.divx',/n '.xvid',/n '.f4v',/n '.mpeg',/n '.asf',/n '.asx',/n '.m2t',/n]/n/n# 输出Excel路径/nexcel_folder = '.'/n/n# 输出Excel文件名/nexcel_file = 'video_info.xlsx'/n/n# 正则表达式匹配码率数据中的空格/npattern = re.compile(r'(/d+)/s+(/d+)')/n/n# 创建Excel文件/nwb = openpyxl.Workbook()/nws = wb.active/nws.title = 'Video Info'/n/n# 锁定表头/nws.freeze_panes = 'A2'/n/n# 设置表头样式/nheader_font = Font(bold=True, color='800080') # 紫色/nheader_fill = PatternFill('solid', fgColor='C5E0B4')/nheader_alignment = Alignment(horizontal='center', vertical='center')/nheaders = [/n '文件名',/n '文件路径',/n '格式',/n '大小',/n '时长',/n '分辨率',/n '码率',/n '帧率',/n '音频码率',/n '音频采样率',/n '音频语言',/n '压缩比率',/n]/nfor col, header in enumerate(headers, start=1):/n cell = ws.cell(row=1, column=col, value=header)/n cell.font = header_font/n cell.fill = header_fill/n cell.alignment = header_alignment/n/n# 处理失败文件个数/nfailed_count = 0/n/n# 总计处理文件数/ntotal_count = 0/n/n# 遍历所有视频文件/nsuccess_count = 0/nrow = 2 # 从第二行开始写入数据/n/ndef process_video(video_file):/n global success_count, row, failed_count, total_count/n try:/n # 获取文件名/n file_name = os.path.basename(video_file)/n/n # 获取文件大小并进行单位换算/n size = os.path.getsize(video_file)/n if size < 1024:/n size_str = f'{size} B'/n elif size < 1024 * 1024:/n size_str = f'{size / 1024:.2f} KiB'/n elif size < 1024 * 1024 * 1024:/n size_str = f'{size / 1024 / 1024:.2f} MiB'/n else:/n size_str = f'{size / 1024 / 1024 / 1024:.2f} GiB'/n/n # 使用mediainfo获取视频信息 / 音频信息/n video_result = subprocess.run(/n [/n 'mediainfo',/n '--Inform=Video;%Format%|%Width%x%Height%|%BitRate/String%|%FrameRate%|%Duration/String3%',/n video_file,/n ],/n stdout=subprocess.PIPE,/n )/n video_output = video_result.stdout.decode().strip()/n audio_result = subprocess.run(/n [/n 'mediainfo',/n '--Inform=Audio;%BitRate/String%|%SamplingRate/String%|%Language/String%',/n video_file,/n ],/n stdout=subprocess.PIPE,/n )/n audio_output = audio_result.stdout.decode().strip()/n/n # 解析输出结果/n video_info = video_output.split('|')/n audio_info = audio_output.split('|')/n/n # 处理多音轨情况/n audio_bitrate = []/n audio_sampling_rate = []/n audio_lang = []/n for i in range(len(audio_info) // 3):/n audio_bitrate.append(audio_info[i * 3])/n audio_sampling_rate.append(audio_info[i * 3 + 1])/n audio_lang.append(audio_info[i * 3 + 2])/n/n # 时长取整/n duration = video_info[4].split('.')[0]/n h, m, s = duration.split(':')/n duration = f'{h}:{m}:{str(s).zfill(2)}'/n/n # 以分钟计算的时长 2/n duration_minutes = int(h) * 60 + int(m) + math.ceil(float(s)) / 60/n/n # 计算压缩比率/n ratio = round(duration_minutes / size * 1000000000, 2)/n/n # 使用正则表达式替换码率数据中第一个数字和第二个数字之间的空格/n bitrate = re.sub(pattern, r'//1//2', video_info[2])/n/n # 写入Excel文件/n ws.cell(row=row, column=1, value=file_name)/n ws.cell(row=row, column=2, value=os.path.dirname(video_file)) # 写入文件夹路径/n ws.cell(row=row, column=3, value=video_info[0])/n ws.cell(row=row, column=4, value=size_str)/n ws.cell(row=row, column=5, value=duration)/n ws.cell(row=row, column=6, value=video_info[1])/n ws.cell(row=row, column=7, value=bitrate)/n ws.cell(row=row, column=8, value=video_info[3])/n ws.cell(row=row, column=9, value=' / '.join(audio_bitrate))/n ws.cell(row=row, column=10, value=' / '.join(audio_sampling_rate))/n ws.cell(row=row, column=11, value=' / '.join(audio_lang))/n ws.cell(row=row, column=12, value=ratio)/n # 打印进度/n success_count += 1/n total_count += 1 # 在处理单个文件时也自增total_count/n print(f'已处理 {success_count}/{total_count} 共计', end='//r')/n/n except Exception as e:/n # 处理失败，跳过并打印文件名和具体错误信息/n failed_count += 1/n print(f'处理文件 {video_file} 时失败：{e}')/n # 将失败的文件写入到err.txt/n with open('err.txt', 'a') as f:/n f.write(f'{video_file}//n')/n return False/n/n return True/n/ndef process_folder(video_folder):/n global total_count/n # 获取视频文件列表（包括子目录）/n video_files = []/n for root, dirs, files in os.walk(video_folder):/n for file in files:/n for format in supported_formats:/n if file.endswith(format):/n video_files.append(os.path.join(root, file))/n break/n for video_file in video_files:/n if process_video(video_file):/n print(f'已处理 {success_count}/{total_count} 共计', end='//r')/n total_count += 1/n/n# 文件路径/npath = input('请输入文件路径：')/nif os.path.isfile(path):/n process_video(path)/n total_count += 1/nelif os.path.isdir(path):/n process_folder(path)/n/n# 调整L列左对齐/nl_col = ws['L']/nfor cell in l_col:/n cell.alignment = Alignment(horizontal='left') # 左对齐/n/n# 固定列宽/nfor col in ws.columns:/n col_letter = col[0].column_letter/n if col_letter not in ['C', 'H']: # 不固定格式、帧率列的宽度/n ws.column_dimensions[col_letter].width = 11/n/n# 保存Excel文件/nif not os.path.exists(excel_folder):/n os.makedirs(excel_folder)/nexcel_file_path = os.path.join(excel_folder, excel_file)/nwb.save(excel_file_path)/n/n# 打印处理失败文件个数和总计处理文件数/nprint(/n f'已完成，处理成功 {success_count} 个文件，处理失败 {failed_count} 个文件，视频信息已保存到 {excel_file_path}'/n)/n/n/n现在，在处理单个文件时，total_count 会被正确地自增，并在进度打印中显示处理的文件总数。