python用pandas读取csv表格,Python Pandas - 读取包含多个表的csv文件

I have a single .csv file containing multiple tables.

Using Pandas, what would be the best strategy to get two DataFrame inventory and HPBladeSystemRack from this one file ?

The input .csv looks like this:

Inventory

System Name IP Address System Status

dg-enc05 Normal

dg-enc05_vc_domain Unknown

dg-enc05-oa1 172.20.0.213 Normal

HP BladeSystem Rack

System Name Rack Name Enclosure Name

dg-enc05 BU40

dg-enc05-oa1 BU40 dg-enc05

dg-enc05-oa2 BU40 dg-enc05

The best I've come up with so far is to convert this .csv file into Excel workbook (xlxs), split the tables into sheets and use:

inventory = read_excel('path_to_file.csv', 'sheet1', skiprow=1)

HPBladeSystemRack = read_excel('path_to_file.csv', 'sheet2', skiprow=2)

Howe