我有以下文字：text = """<table class="table table-striped">\n <thead>\n <tr>\n <th data-field="placement">Placement</th>\n <th data-field="production">Production</th>\n <th data-field="application">Eng.Vol.</th>\n <th data-field="body">Body No</th>\n <th data-field="eng">Eng No</th>\n <th data-field="eng">Notes</th>\n </tr>\n <tr>\n <td data-field="placement">Front Stabilizer</td>\n <td data-field="production">Oct 16~</td>\n <td data-field="application">1.5 L</td>\n <td data-field="body">HRW18</td>\n <td data-field="eng">L15BY</td>\n <td data-field="note" class="">\n Pos:Left/Right </td>\n </tr>\n <tr>\n <td data-field="placement">Front Stabilizer</td>\n <td data-field="production">Oct 16~</td>\n 此 HTML 文本使用表格標簽正確關閉，并且具有所有必需的標簽。pandas 仍然沒有作為表格來讀取。
1 回答
楊__羊羊
TA貢獻1943條經驗 獲得超7個贊
你的桌子被包裹在里面<thead></thead>。熊貓將所有內容解釋為列是可以理解的。咱們試試吧：
tmp=pd.read_html(text)[0]
pd.DataFrame(tmp.columns.to_frame().values)
輸出：
0 1 2 3 4
-- ---------- ---------------- ---------------- ---------------- ----------------
0 Placement Front Stabilizer Front Stabilizer Front Stabilizer Front Stabilizer
1 Production Oct 16~ Oct 16~ Oct 16~ Oct 16~
2 Eng.Vol. 1.5 L 1.5 L 1.5 L 2.0 L
3 Body No HRW18 HRW18 LHD HRW28 HRW38 RHD
4 Eng No L15BY L15BY L15BY R20A9
5 Notes Pos:Left/Right Pos:Left/Right Pos:Left/Right Pos:Left/Right
添加回答
舉報
0/150
提交
取消