pythonpandas读取csv和另外一个csv进行比较_Python Pandas - 读取包含多个表的csv文件...

DSM..

11

如果您事先知道表名,那么这样的事情:

df = pd.read_csv("jahmyst2.csv", header=None, names=range(3))

table_names = ["Inventory", "HP BladeSystem Rack", "Network Interface"]

groups = df[0].isin(table_names).cumsum()

tables = {g.iloc[0,0]: g.iloc[1:] for k,g in df.groupby(groups)}

应该生成一个字典,其中键作为表名和值作为子表.

>>> list(tables)

['HP BladeSystem Rack', 'Inventory']

>>> for k,v in tables.items():

... print("table:", k)

... print(v)

... print()

...

table: HP BladeSystem Rack

0 1 2

6 System Name Rack Name Enclosure Name

7 dg-enc05 BU40 NaN

8 dg-enc05-oa1 BU40 dg-enc05

9 dg-enc05-oa2 BU40 dg-enc05

table: Inventory

0 1 2

1 System Name IP Address System Status

2 dg-enc05 NaN Normal

3 dg-enc05_vc_domain NaN Unknown

4 dg-enc05-oa1 172.20.0.213 Normal

一旦你有了,你可以将列名设置为第一行等.