正则匹配以下python代码码率数据阿拉伯数字之间的空格并替换import osimport subprocessimport openpyxlimport mathfrom openpyxlstyles import Font PatternFill Alignment# 需要处理的视频文件夹video_folder = home115up# 输出Excel文件夹路径excel_folder =

r"import os\nimport subprocess\nimport openpyxl\nimport math\nfrom openpyxl.styles import Font, PatternFill, Alignment\n\n\n# 需要处理的视频文件夹\nvideo_folder = "/home/115/up"\n\n# 输出Excel文件夹路径\nexcel_folder = "/home/115/up/"\n\n# 输出Excel文件名\nexcel_file = "video_info.xlsx"\n\n# 创建Excel文件\nwb = openpyxl.Workbook()\nws = wb.active\nws.title = "Video Info"\n\n# 设置表头样式\nheader_font = Font(bold=True, color="800080") # 紫色\nheader_fill = PatternFill("solid", fgColor="C5E0B4")\nheader_alignment = Alignment(horizontal="center", vertical="center")\nheaders = ["文件名", "文件路径", "格式", "大小", "时长", "分辨率", "码率", "帧率", "音频码率", "音频采样率", "音频语言"]\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# 锁定表头\nws.freeze_panes = 'A2'\n\n# 获取视频文件列表（包括子目录）\nvideo_files = []\nfor root, dirs, files in os.walk(video_folder):\n for file in files:\n if file.endswith(".mp4"):\n video_files.append(os.path.join(root, file))\n\n# 遍历所有视频文件，获取视频信息、音频信息和音频语言，并写入Excel文件\nfor row, video_file in enumerate(video_files, start=2):\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 < 10241024:\n size_str = f"{size / 1024:.2f} KiB"\n elif size < 10241024*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(["mediainfo", "--Inform=Video;%Format%|%Width%x%Height%|%BitRate/String%|%FrameRate%|%Duration/String3%", video_file], stdout=subprocess.PIPE)\n video_output = video_result.stdout.decode().strip()\n audio_result = subprocess.run(["mediainfo", "--Inform=Audio;%BitRate/String%|%SamplingRate/String%|%Language/String%", video_file], stdout=subprocess.PIPE)\n audio_output = audio_result.stdout.decode().strip()\n\n # 解析输出结果\n format, resolution, bitrate, framerate, duration = video_output.split("|")\n audiobitrate, audiosamplingrate, audiolang = audio_output.split("|")\n \n # 时长取整\n duration = duration.split('.')[0]\n h, m, s = duration.split(':')\n duration = f"{h}:{m}:{math.ceil(float(s))}"\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=format)\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=resolution)\n ws.cell(row=row, column=7, value=bitrate)\n ws.cell(row=row, column=8, value=framerate)\n ws.cell(row=row, column=9, value=audiobitrate) # 写入音频码率\n ws.cell(row=row, column=10, value=audiosamplingrate) # 写入音频采样率\n ws.cell(row=row, column=11, value=audiolang) # 写入音频语言\n\n# 自动调整列宽\nfor col in ws.columns:\n max_length = 0\n column = col[0].column_letter\n for cell in col:\n try:\n if len(str(cell.value)) > max_length:\n max_length = len(str(cell.value))\n except:\n pass\n adjusted_width = (max_length + 2)\n ws.column_dimensions[column].width = adjusted_width\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)\nprint(f"视频信息已保存到 {excel_file_path}")"