将数据从dict移动到Pandas DataFram

0 0 ID 1 Available Quota 2 Live Weight Pounds 3 Price 4 Date Posted 5 1724 6 GOM COD 7 GOM HADD 8 GOM BB 9 GREYSOLE 10 DABS 11 GOM YT 12 2328 13 445 14 3007 15 850 16 3101 17 1995 18 Package 19 $9,000 20 5/20 21 1578 22 GBE COD 23 GBW COD 24 GB BB 25 GB YT 26 SNE BB 27 SNE YT 28 GOM BB 29 Whake .. ... 45 $1.00 46 $0.45 47 $0.50 48 $0.15 49 $0.20 50 $0.01 51 $0.01 52 5/20 53 310 54 GBE COD 55 GBW COD 56 DABS 57 WHAKE 58 POLL 59 RED 60 SNE BB 61 GOM BB 62 825 63 9033 64 1241 65 3120 66 65234 67 76610 68 1688 69 1195 70 2121 71 7285 72 Package 73 $15,000 74 5/20 [75 rows x 1 columns] <class 'pandas.core.frame.DataFrame'>

<html> <head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>FW: NEFS 2 Available Quota 5/21</title> <link rel="important stylesheet" href=""> <style>div.headerdisplayname {font-weight:bold;}</style></head> <body> <table border=0 cellspacing=0 cellpadding=0 width="100%" class="header-part1"><tr><td>Subject: FW: NEFS 2 Available Quota 5/21</td></tr><tr><td>From: Claire Fitz-Gerald <claire@capecodfishermen.org></td></tr><tr><td>Date: 5/21/2014 10:08 AM</td></tr></table> <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; "><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style></style></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1>Please see the below quota listings.<o:p></o:p><o:p> </o:p>Thanks,<o:p></o:p><o:p> </o:p><div>Claire Fitz-Gerald<o:p></o:p><o:p> </o:p>Cape Cod Commercial Fishermen's Alliance<o:p></o:p>~ Small Boats.  Big Ideas. ~<o:p></o:p></div><o:p> </o:p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>From: David Leveille [mailto:nefs02@gmail.com] Sent: Wednesday, May 21, 2014 8:50 AM To: David Leveille Subject: NEFS 2 Available Quota 5/21<o:p></o:p></div></div><o:p> </o:p>AVAILABLE QUOTA FY 2014<o:p></o:p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="71%" style='width:71.28%'><tr><td width=220 style='width:164.95pt;border:none;border-bottom:solid windowtext 1.0pt;background:#8BCDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt'>ID <o:p></o:p></td><td width=161 style='width:120.75pt;border:none;border-bottom:solid windowtext 1.0pt;background:#8BCDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt'>Available Quota <o:p></o:p></td><td width=189 style='width:141.75pt;border:none;border-bottom:solid windowtext 1.0pt;background:#8BCDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt'>Live Weight Pounds <o:p></o:p></td><td width=126 style='width:94.55pt;border:none;border-bottom:solid windowtext 1.0pt;background:#8BCDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt'>Price <o:p></o:p></td><td width=168 style='width:125.95pt;border:none;border-bottom:solid windowtext 1.0pt;background:#8BCDFF;padding:2.25pt 2.25pt 2.25pt 2.25pt'>Date Posted <o:p></o:p></td></tr><tr><td width=220 style='width:164.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>1724<o:p></o:p></td><td width=161 style='width:120.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>GOM COD GOM HADD GOM BB GREYSOLE DABS GOM YT<o:p></o:p></td><td width=189 style='width:141.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>2328 445 3007 850 3101 1995<o:p></o:p></td><td width=126 style='width:94.55pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>Package<o:p></o:p><o:p> </o:p>$9,000<o:p></o:p></td><td width=168 style='width:125.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>5/20<o:p></o:p></td></tr><tr><td width=220 style='width:164.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>1578<o:p></o:p></td><td width=161 style='width:120.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>GBE COD GBW COD GB BB GB YT SNE BB SNE YT GOM BB Whake POLL RED<o:p></o:p></td><td width=189 style='width:141.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>538 5894 1755 243 490 153 3965 2727 9227 15060<o:p></o:p></td><td width=126 style='width:94.55pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>$1.00 $0.40 $0.20 $1.00 $0.45 $0.50 $0.15 $0.20 $0.01 $0.01<o:p></o:p></td><td width=168 style='width:125.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>5/20<o:p></o:p></td></tr><tr><td width=220 style='width:164.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>310<o:p></o:p></td><td width=161 style='width:120.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>GBE COD GBW COD DABS WHAKE POLL RED SNE BB GOM BB<o:p></o:p></td><td width=189 style='width:141.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>825 9033 1241 3120 65234 76610 1688 1195 2121 7285<o:p></o:p></td><td width=126 style='width:94.55pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>Package<o:p></o:p><o:p> </o:p>$15,000<o:p></o:p></td><td width=168 style='width:125.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>5/20<o:p></o:p></td></tr><tr style='height:23.25pt'><td width=220 style='width:164.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt;height:23.25pt'>347<o:p></o:p></td><td width=161 style='width:120.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt;height:23.25pt'>SNE BB<o:p></o:p></td><td width=189 style='width:141.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt;height:23.25pt'>8,000<o:p></o:p></td><td width=126 style='width:94.55pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt;height:23.25pt'>$0.50<o:p></o:p></td><td width=168 style='width:125.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt;height:23.25pt'>5/7<o:p></o:p></td></tr><tr><td width=220 style='width:164.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>1878A<o:p></o:p></td><td width=161 style='width:120.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>GOM COD GOM HADD SNE BB GOM BB GB BB GREYSOLE GOM YT SNE YT POLL<o:p></o:p></td><td width=189 style='width:141.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>6188 635 3916 7873 6762 3358 9776 271 186550<o:p></o:p></td><td width=126 style='width:94.55pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>$1.95 $1.35 $0.50 $0.50 $0.20 $1.40 $1.20 $0.50 $0.01<o:p></o:p></td><td width=168 style='width:125.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>5/12<o:p></o:p></td></tr><tr><td width=220 style='width:164.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>1878B<o:p></o:p></td><td width=161 style='width:120.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>GBE COD GBW COD GB YT<o:p></o:p></td><td width=189 style='width:141.75pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>1113 12186 850<o:p></o:p></td><td width=126 style='width:94.55pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>Package $10,000<o:p></o:p></td><td width=168 style='width:125.95pt;border:solid windowtext 1.0pt;background:white;padding:2.25pt 2.25pt 2.25pt 2.25pt'>5/12<o:p></o:p></td></tr></table><o:p> </o:p><o:p> </o:p>David Leveille<o:p></o:p>II Northeast Fishery Sector Inc.<o:p></o:p>10 Witham Street<o:p></o:p>Gloucester, MA. 01930<o:p></o:p>Cell 978 375 3509<o:p></o:p>Fax 978 281 1555<o:p></o:p>Web <a href="http://nefs2.com/">http://nefs2.com/</a><o:p></o:p><o:p> </o:p><div class=MsoNormal align=center style='text-align:center'></body></html> </body> </html>

from bs4 import BeautifulSoup import os import re import numpy as np import pandas as pd import cx_Oracle import lxml import html5lib path = 'C:\\EVERYTHING FROM Z DRIVE\\blub' def readhtml(path): df = pd.pandas.read_html(io =path) print(df) if __name__ == "__main__": readhtml('path')

1条回答

网友

1楼 · 发布于 2024-05-16 00:11:51

def readhtml(path):
    df=pd.pandas.read_html(io =path)
    print df


if __name__=="__main__":
    readhtml('C:\Users\xxx\samples.html')

下面是用于测试的html示例

此程序创建的输出是

^{pr2}$

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=windows-1252"> <meta name=ProgId content=Excel.Sheet> <meta name=Generator content="Microsoft Excel 14"> <link rel=File-List href="samples_files/filelist.xml"> <style id="sample_14456_Styles"> <! table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} .xl1514456 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;} .xl6514456 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:#3E4349; font-size:9.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;} > </style> </head> <body> <! [if !excel]>  <![endif] > <! The following information was generated by Microsoft Excel's Publish as Web Page wizard. > <! If the same item is republished from Excel, all information between the DIV tags will be replaced. > <! -> <! START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD > <! -> <div id="sample_14456" align=center x:publishsource="Excel"> <table border=0 cellpadding=0 cellspacing=0 width=256 style='border-collapse: collapse;table-layout:fixed;width:192pt'> <col width=64 span=4 style='width:48pt'> <tr height=19 style='height:14.4pt'> <td height=19 class=xl6514456 width=64 style='height:14.4pt;width:48pt'>ID</td> <td class=xl1514456 width=64 style='width:48pt'>H1</td> <td class=xl1514456 width=64 style='width:48pt'>H2</td> <td class=xl1514456 width=64 style='width:48pt'>H3</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 align=right style='height:14.4pt'>1</td> <td class=xl1514456>X1</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 style='height:14.4pt'></td> <td class=xl1514456>X2</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 style='height:14.4pt'></td> <td class=xl1514456>X3</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 style='height:14.4pt'></td> <td class=xl1514456>X4</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 align=right style='height:14.4pt'>2</td> <td class=xl1514456>X5</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 style='height:14.4pt'></td> <td class=xl1514456>X6</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 style='height:14.4pt'></td> <td class=xl1514456>X7</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 style='height:14.4pt'></td> <td class=xl1514456>X8</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 style='height:14.4pt'></td> <td class=xl1514456>X9</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 style='height:14.4pt'></td> <td class=xl1514456>X10</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <tr height=19 style='height:14.4pt'> <td height=19 class=xl1514456 align=right style='height:14.4pt'>2</td> <td class=xl1514456>X11</td> <td class=xl1514456>Y1</td> <td class=xl1514456>Y2</td> </tr> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> </tr> <![endif]> </table> </div> <! -> <! END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD > <! -> </body> </html> ；

和13；

相关问题更多 >

编程相关推荐

热门问题

热门文章