Python：对html文件进行数据分析

最新推荐文章于 2023-03-25 10:55:47 发布
AllenSun-1990
最新推荐文章于 2023-03-25 10:55:47 发布
阅读量225
点赞数
分类专栏： Python 文章标签： python 数据分析
本文链接：https://blog.csdn.net/xikangsoon/article/details/121134609
版权
Python 专栏收录该内容
15 篇文章 1 订阅
订阅专栏
Python：对html文件进行数据分析
#!/usr/bin/python
# -*- coding: UTF-8 -*-

import pandas as pd
import re

filename1 = 'Current Scheme/PDT_861.html'
colname1 = 'Current Scheme'

filename2 = 'AUDIO_LB_OUT_CHANNEL_LF/PDT_report.html'
colname2 = 'AUDIO_LB_OUT_CHANNEL_LF'

filename3 = 'AUDIO_LB_OUT_CHANNEL_LR/PDT_report.html'
colname3 = 'AUDIO_LB_OUT_CHANNEL_LR'

filename4 = 'AUDIO_LB_OUT_CHANNEL_RF/PDT_report.html'
colname4 = 'AUDIO_LB_OUT_CHANNEL_RF'

filename5 = 'AUDIO_LB_OUT_CHANNEL_RR/PDT_report.html'
colname5 = 'AUDIO_LB_OUT_CHANNEL_RR'

# Sometimes parameter uses " = ", but sometimes it uses "( )"
patterns = r'\'RoutineIdentifier\' = \'(.*?)\'.*? \'status\' = \'(.*?)\'.*?: \'inputSource_1/source\' = \'(.*?)\'.*? \'inputSource_1/peakFrequency_1\' = \'(.*?)\'.*?\'inputSource_1/peakAmplitude_1\' = \'(.*?)\'.*?\'inputSource_1/peakFrequency_2\' = \'(.*?)\'.*?\'inputSource_1/peakAmplitude_2\' [(](.*?)[)].*?\'inputSource_1/peakFrequency_3\' = \'(.*?)\'.*?\'inputSource_1/peakAmplitude_3\' [(](.*?)[)].*?: \'inputSource_1/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_1/peakAmplitude_4\' [(](.*?)[)].*?: \'inputSource_1/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_1/peakAmplitude_5\' [(](.*?)[)].*?: \'inputSource_2/source\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_3/source\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_4/source\' = \'(.*?)\'.*?: \'inputSource_4/peakFrequency_1\' = \'(.*?)\'.*? \'inputSource_4/peakAmplitude_1\' = \'(.*?)\'.*?\'inputSource_4/peakFrequency_2\' = \'(.*?)\'.*?\'inputSource_4/peakAmplitude_2\' = \'(.*?)\'.*\'inputSource_4/peakFrequency_3\' = \'(.*?)\'.*?\'inputSource_4/peakAmplitude_3\' = \'(.*?)\'.*?\'inputSource_4/peakFrequency_4\' = \'(.*?)\'.*\'inputSource_4/peakAmplitude_4\' = \'(.*?)\'.*?\'inputSource_4/peakFrequency_5\' = \'(.*?)\'.*?\'inputSource_4/peakAmplitude_5\' = \'(.*?)\'.*?\'inputSource_5/source\' = \'(.*?)\'.*? \'inputSource_5/peakFrequency_1\' = \'(.*?)\'.*?\'inputSource_5/peakAmplitude_1\' = \'(.*?)\'.*?\'inputSource_5/peakFrequency_2\' = \'(.*?)\'.*?\'inputSource_5/peakAmplitude_2\' = \'(.*?)\'.*?\'inputSource_5/peakFrequency_3\' = \'(.*?)\'.*? \'inputSource_5/peakAmplitude_3\' = \'(.*?)\'.*? \'inputSource_5/peakFrequency_4\' = \'(.*?)\'.*? \'inputSource_5/peakAmplitude_4\' = \'(.*?)\'.*?\'inputSource_5/peakFrequency_5\' = \'(.*?)\'.*? \'inputSource_5/peakAmplitude_5\' = \'(.*?)\'.*? \'inputSource_6/source\' = \'(.*?)\'.*?\'inputSource_6/peakFrequency_1\' = \'(.*?)\'.*? \'inputSource_6/peakAmplitude_1\' = \'(.*?)\'.*? \'inputSource_6/peakFrequency_2\' = \'(.*?)\'.*? \'inputSource_6/peakAmplitude_2\' = \'(.*?)\'.*? \'inputSource_6/peakFrequency_3\' = \'(.*?)\'.*? \'inputSource_6/peakAmplitude_3\' = \'(.*?)\'.*?\'inputSource_6/peakFrequency_4\' = \'(.*?)\'.*?\'inputSource_6/peakAmplitude_4\' = \'(.*?)\'.*? \'inputSource_6/peakFrequency_5\' = \'(.*?)\'.*? \'inputSource_6/peakAmplitude_5\' = \'(.*?)\'.*? \'inputSource_7/source\' = \'(.*?)\'.*? \'inputSource_7/peakFrequency_1\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_1\' = \'(.*?)\'.*? \'inputSource_7/peakFrequency_2\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_2\' = \'(.*?)\'.*?\'inputSource_7/peakFrequency_3\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_3\' = \'(.*?)\'.*? \'inputSource_7/peakFrequency_4\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_4\' = \'(.*?)\'.*? \'inputSource_7/peakFrequency_5\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_5\' = \'(.*?)\'.*?\'inputSource_8/source\' = \'(.*?)\'.*? \'inputSource_8/peakFrequency_1\' = \'(.*?)\'.*?\'inputSource_8/peakAmplitude_1\' = \'(.*?)\'.*? \'inputSource_8/peakFrequency_2\' = \'(.*?)\'.*?\'inputSource_8/peakAmplitude_2\' = \'(.*?)\'.*?\'inputSource_8/peakFrequency_3\' = \'(.*?)\'.*?\'inputSource_8/peakAmplitude_3\' = \'(.*?)\'.*?\'inputSource_8/peakFrequency_4\' = \'(.*?)\'.*? \'inputSource_8/peakAmplitude_4\' = \'(.*?)\'.*?\'inputSource_8/peakFrequency_5\' = \'(.*?)\'.*? \'inputSource_8/peakAmplitude_5\' = \'(.*?)\'.*?\'inputSource_9/source\' = \'(.*?)\'.*?\'inputSource_9/peakFrequency_1\' = \'(.*?)\'.*? \'inputSource_9/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_9/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_9/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_9/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_9/peakAmplitude_3\' = \'(.*?)\'.*? \'inputSource_9/peakFrequency_4\' = \'(.*?)\'.*? \'inputSource_9/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_9/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_9/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_10/source\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_11/source\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_12/source\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_13/source\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_14/source\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_15/source\' = \'(.*?)\'.*?: \'inputSource_15/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_15/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_15/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_3\' = \'(.*?)\'.*? \'inputSource_15/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_15/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_16/source\' = \'(.*?)\'.*?: \'inputSource_16/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_16/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_16/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_16/peakAmplitude_2\' = \'(.*?)\'.*? \'inputSource_16/peakFrequency_3\' = \'(.*?)\'.*? \'inputSource_16/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_16/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_16/peakAmplitude_4\' = \'(.*?)\'.*? \'inputSource_16/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_16/peakAmplitude_5\' = \'(.*?)\'.*?Maximum Current in this testcase: (.*?), Maximum allowed 3Amp in production'

patterns_AUDIO_LB_OUT_CHANNEL_LR = r'\'RoutineIdentifier\' = \'(.*?)\'.*?\'status\' = \'(.*?)\'.*?: \'inputSource_1/source\' = \'(.*?)\'.*? \'inputSource_1/peakFrequency_1\' = \'(.*?)\'.*?\'inputSource_1/peakAmplitude_1\' [(](.*?)[)].*?\'inputSource_1/peakFrequency_2\' = \'(.*?)\'.*?\'inputSource_1/peakAmplitude_2\' [(](.*?)[)].*?\'inputSource_1/peakFrequency_3\' = \'(.*?)\'.*?\'inputSource_1/peakAmplitude_3\' [(](.*?)[)].*?: \'inputSource_1/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_1/peakAmplitude_4\' [(](.*?)[)].*?: \'inputSource_1/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_1/peakAmplitude_5\' [(](.*?)[)].*?: \'inputSource_2/source\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_2/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_2/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_3/source\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_3/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_3/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_4/source\' = \'(.*?)\'.*?: \'inputSource_4/peakFrequency_1\' = \'(.*?)\'.*? \'inputSource_4/peakAmplitude_1\' = \'(.*?)\'.*?\'inputSource_4/peakFrequency_2\' = \'(.*?)\'.*?\'inputSource_4/peakAmplitude_2\' = \'(.*?)\'.*\'inputSource_4/peakFrequency_3\' = \'(.*?)\'.*?\'inputSource_4/peakAmplitude_3\' = \'(.*?)\'.*?\'inputSource_4/peakFrequency_4\' = \'(.*?)\'.*\'inputSource_4/peakAmplitude_4\' = \'(.*?)\'.*?\'inputSource_4/peakFrequency_5\' = \'(.*?)\'.*?\'inputSource_4/peakAmplitude_5\' = \'(.*?)\'.*?\'inputSource_5/source\' = \'(.*?)\'.*? \'inputSource_5/peakFrequency_1\' = \'(.*?)\'.*?\'inputSource_5/peakAmplitude_1\' = \'(.*?)\'.*?\'inputSource_5/peakFrequency_2\' = \'(.*?)\'.*?\'inputSource_5/peakAmplitude_2\' = \'(.*?)\'.*?\'inputSource_5/peakFrequency_3\' = \'(.*?)\'.*? \'inputSource_5/peakAmplitude_3\' = \'(.*?)\'.*? \'inputSource_5/peakFrequency_4\' = \'(.*?)\'.*? \'inputSource_5/peakAmplitude_4\' = \'(.*?)\'.*?\'inputSource_5/peakFrequency_5\' = \'(.*?)\'.*? \'inputSource_5/peakAmplitude_5\' = \'(.*?)\'.*? \'inputSource_6/source\' = \'(.*?)\'.*?\'inputSource_6/peakFrequency_1\' = \'(.*?)\'.*? \'inputSource_6/peakAmplitude_1\' = \'(.*?)\'.*? \'inputSource_6/peakFrequency_2\' = \'(.*?)\'.*? \'inputSource_6/peakAmplitude_2\' = \'(.*?)\'.*? \'inputSource_6/peakFrequency_3\' = \'(.*?)\'.*? \'inputSource_6/peakAmplitude_3\' = \'(.*?)\'.*?\'inputSource_6/peakFrequency_4\' = \'(.*?)\'.*?\'inputSource_6/peakAmplitude_4\' = \'(.*?)\'.*? \'inputSource_6/peakFrequency_5\' = \'(.*?)\'.*? \'inputSource_6/peakAmplitude_5\' = \'(.*?)\'.*? \'inputSource_7/source\' = \'(.*?)\'.*? \'inputSource_7/peakFrequency_1\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_1\' = \'(.*?)\'.*? \'inputSource_7/peakFrequency_2\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_2\' = \'(.*?)\'.*?\'inputSource_7/peakFrequency_3\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_3\' = \'(.*?)\'.*? \'inputSource_7/peakFrequency_4\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_4\' = \'(.*?)\'.*? \'inputSource_7/peakFrequency_5\' = \'(.*?)\'.*? \'inputSource_7/peakAmplitude_5\' = \'(.*?)\'.*?\'inputSource_8/source\' = \'(.*?)\'.*? \'inputSource_8/peakFrequency_1\' = \'(.*?)\'.*?\'inputSource_8/peakAmplitude_1\' = \'(.*?)\'.*? \'inputSource_8/peakFrequency_2\' = \'(.*?)\'.*?\'inputSource_8/peakAmplitude_2\' = \'(.*?)\'.*?\'inputSource_8/peakFrequency_3\' = \'(.*?)\'.*?\'inputSource_8/peakAmplitude_3\' = \'(.*?)\'.*?\'inputSource_8/peakFrequency_4\' = \'(.*?)\'.*? \'inputSource_8/peakAmplitude_4\' = \'(.*?)\'.*?\'inputSource_8/peakFrequency_5\' = \'(.*?)\'.*? \'inputSource_8/peakAmplitude_5\' = \'(.*?)\'.*?\'inputSource_9/source\' = \'(.*?)\'.*?\'inputSource_9/peakFrequency_1\' = \'(.*?)\'.*? \'inputSource_9/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_9/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_9/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_9/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_9/peakAmplitude_3\' = \'(.*?)\'.*? \'inputSource_9/peakFrequency_4\' = \'(.*?)\'.*? \'inputSource_9/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_9/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_9/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_10/source\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_10/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_10/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_11/source\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_11/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_11/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_12/source\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_12/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_12/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_13/source\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_13/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_13/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_14/source\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_14/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_14/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_15/source\' = \'(.*?)\'.*?: \'inputSource_15/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_15/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_2\' = \'(.*?)\'.*?: \'inputSource_15/peakFrequency_3\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_3\' = \'(.*?)\'.*? \'inputSource_15/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_4\' = \'(.*?)\'.*?: \'inputSource_15/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_15/peakAmplitude_5\' = \'(.*?)\'.*?: \'inputSource_16/source\' = \'(.*?)\'.*?: \'inputSource_16/peakFrequency_1\' = \'(.*?)\'.*?: \'inputSource_16/peakAmplitude_1\' = \'(.*?)\'.*?: \'inputSource_16/peakFrequency_2\' = \'(.*?)\'.*?: \'inputSource_16/peakAmplitude_2\' = \'(.*?)\'.*? \'inputSource_16/peakFrequency_3\' = \'(.*?)\'.*? \'inputSource_16/peakAmplitude_3\' = \'(.*?)\'.*?: \'inputSource_16/peakFrequency_4\' = \'(.*?)\'.*?: \'inputSource_16/peakAmplitude_4\' = \'(.*?)\'.*? \'inputSource_16/peakFrequency_5\' = \'(.*?)\'.*?: \'inputSource_16/peakAmplitude_5\' = \'(.*?)\'.*?Maximum Current in this testcase: (.*?), Maximum allowed 3Amp in production'

def insert_html_to_column(html_file, column_name):
	# Returns a DataFrame
    fo = open(html_file, encoding='utf-8')
    info = fo.read()
    fo.close()
    
    #fw = open("info.txt", "w+")
    #fw.write(info)
    #fw.close()

    if column_name == colname3 :
        print("Use patterns_AUDIO_LB_OUT_CHANNEL_LR")
        pattern = re.compile(patterns_AUDIO_LB_OUT_CHANNEL_LR, re.S)
        
    else :
        print("Use default patterns")
        pattern = re.compile(patterns, re.S)

    parameter_list = pattern.findall(info)
    column_data = []

    for paremeter in parameter_list :
        print(len(paremeter))
        column_data = list(paremeter)

    df = pd.read_excel('AudioLoopbackReport.xlsx', 'Response parameter')

    print(column_data)
    print(len(column_data))
    df.insert(len(df.columns), column_name, column_data)
    df.to_excel('AudioLoopbackReport.xlsx', 'Response parameter', index=False)

#insert_html_to_column(filename1, colname1)
#insert_html_to_column(filename2, colname2)
#insert_html_to_column(filename3, colname3)
#insert_html_to_column(filename4, colname4)
insert_html_to_column(filename5, colname5)