解å³æ¹æ³ï¼
æ£åæååºå¤ä¸ªå表ï¼ç¶åå©ç¨ Pandas ç DataFrame æ°æ®ç±»ååå
¥ excelï¼å
·ä½æ ¼å¼ä½ èªå·±å®æï¼è¿éç»åºä¸ªåºæ¬ç¤ºä¾ï¼
text = """<td height="20" align="center">1</td>
<td align="center">产å</td>
<td align="center">red</td>
<td align="center">åä»·</td>
<td align="center">ä»·æ ¼</td>
<td align="center">å¤æ³¨</td>
<td height="20" align="center">2</td>
<td align="center">产å</td>
<td align="center">red</td>
<td align="center">åä»·</td>
<td align="center">ä»·æ ¼</td>
<td align="center">å¤æ³¨</td>import pandas as pd
import re
p = re.compile('>(\S+)</td>')
q = p.findall(text)
table = pd.read_excel(r'D:\test.xlsx')
table['your title'] = pd.Series(q)
table.to_excel(r'D:\test.xlsx')
ç»æï¼
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/730e0cf3d7ca7bcb2750ff65b6096b63f624a854?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)