python 解析html 表格

<table id ="table"><tr>
      <th width="10%">序号</th>
      <th width="18%">学校</th>
      <th width="18%">学科</th>
      <th width="18%">姓名</th>
      <th width="18%">得分
        <span>（分）</span>
      </th>
      <th>操作</th>
    </tr>
    <!----><tr>
      <td>1</td>
      <td>南京xx</td>
      <td>化学</td>
      <td>李xx</td>
      <td>80</td>
      <td>
        <a class="export-btn" style="cursor:pointer">查看</a>
        <!----><a class="export-btn" style="cursor:pointer">下载</a>
        <!---->
      </td>
    </tr><tr>
      <td>2</td>
      <td>南京xx学校</td>
      <td>化学</td>
      <td>唐tt</td>
      <td>79</td>
      <td>
        <a class="export-btn" style="cursor:pointer">查看</a>
        <!----><a class="export-btn" style="cursor:pointer">下载</a>
        <!---->
      </td>
    </tr>
</table>

解析代码模块

#coding:utf-8
from lxml import etree

 
u = etree.parse('xx.html')

rows = u.xpath('//table[@id="table"]/tr')[1:]
for row in rows:
    id = row.xpath('./td[1]/text()')[0]
    school =  row.xpath('./td[2]/text()')[0]
    name = row.xpath('./td[4]/text()')[0]
    score = row.xpath('./td[5]/text()')[0]
    print ("id:'%s', school:'%s', name:'%s', score:'%s'" %(id,school,name,score))