使用python字典解析HTML表数据(Parsing HTML table data using python dictionary)

我从以下格式的Jive页面获取html

table = <table class="test" style="border: 1px solid #c6c6c6;" width="100%"><thead><tr><th style="background-color: #efefef; width: 13%;">Tag</th><th style="background-color: #efefef; width: 23.7965%;">ID</th><th style="background-color: #efefef; width: 59.2035%;">URL</th></tr></thead><tbody><tr><td style="width: 13%;">3.7.3</td><td style="width: 23.7965%;">1234523232343434545454554</td><td style="width: 59.2035%;"><a class="jive-link-external-small" href="http://google.com" rel="nofollow">http://google.com</a><a class="jive-link-external-small" href="http://test123.com" rel="nofollow">http://test123.com</a><a class="jive-link-external-small" href="http://www.yahoo.com" rel="nofollow">http://www.yahoo.com</a><a class="jive-link-external-small" href="http://www.test.com" rel="nofollow">http://www.test.com</a></td></tr><tr><td style="width: 13%;">3.7.4</td><td style="width: 23.7965%;">4567895454545454545545454</td><td style="width: 59.2035%;"><a class="jive-link-external-small" href="http://foo.com" rel="nofollow">http://foo.com</a><a class="jive-link-external-small" href="http://www.yahoo.com" rel="nofollow">http://www.yahoo.com</a><a class="jive-link-external-small" href="http://svn.com" rel="nofollow">http://svn.com</a><a class="jive-link-external-small" href="http://test.com" rel="nofollow">http://test.com</a></td></tr></tbody></table>

为了将HTML转换为字典，我尝试了下面的代码

table = ET.XML(s) rows = iter(table) headers = [col.text for col in next(rows)] for row in rows: values = [col.text for col in row] out = dict(zip(headers, values))

根据命令行参数的输入，上面的方法没有给出我预期的输出

Tag ID URL 3.7.3 121211 http://yahoo.com 323243 http://url.com

I am getting the html from Jive page in below format

For Converting HTML to a dictionary I tried below code

table = ET.XML(s) rows = iter(table) headers = [col.text for col in next(rows)] for row in rows: values = [col.text for col in row] out = dict(zip(headers, values))

The above approach does not give me expected output as below based on input from command line argument

Tag ID URL 3.7.3 121211 http://yahoo.com 323243 http://url.com

最满意答案

这可以使用Python XML树来实现。

data = response.json() html_doc = data['content']['text'] def find_version(ver): table = ET.XML(html_doc) # headers ths = [th.text for th in table.findall('.//th')] for tr in table.findall('.//tbody/tr'): data = [] # first col data.append(tr[0].text) # second col data.append([x.text for x in tr[1]]) # third col temp = [] for x in tr[2]: if x.tag == 'a': temp.append(x.text) else: temp.append(x[0].text) data.append(temp) # dictionary to print all the available data using applicable keys #out = OrderedDict(zip(ths, data)) out = OrderedDict(zip(ths, data)) #print('out:', out) if out['Release'] == ver: return out # --- main --- res = find_version(ver) if res: ''' for key, val in res.items(): print(key, '-', val) ''' #print (res.values()) f = lambda x: x if isinstance(x, list) else [x] for tup in zip(*res.items()): for a, b, c in zip_longest(*map(f, tup), fillvalue=''): print('{:15}{:15}{:15}'.format(a, b, c)) #for a, b, c in zip_longest(*map(f, tup), fillvalue=''): #print('{:15}'.format(b)) else: print ('Version not found')

将以预期的格式提供输出

This can be achieved using Python XML tree.

Will give you the output in expected format

更多推荐