pandas把多个sheet读进一个DataFrame

#!/usr/bin/python

import pandas as pd
import collections

df_dict = pd.read_excel(‘c:\data\machines.xlsx‘, sheet_name=None, index_col=None, na_values=[‘NA‘])

df_dict = collections.OrderedDict(sorted(df_dict.items()))

df = pd.concat(df_dict.values(), ignore_index=True)

print(type(df))

print(df[df[‘ip‘].str.contains(‘192.168.10.‘)])

pandas把多个sheet读进一个DataFrame

原文：https://www.cnblogs.com/donggongdechen/p/10493900.html