read specific sheet xlsx pandas code example

Example 1: find data in sheet pandas

import pandas
df = pandas.DataFrame()
df[df.text_column.str.contains('whatever')] #to replace ctrl+f in pandas

Example 2: pandas read excel with two headers

df_dict = pandas.read_excel('ExcelFile.xlsx', header=[0, 1], sheetname=None)