import numpy as np import pandas as pd file_one = pd.read_excel(r"C:\Users\86159\Desktop\0113013127hs.xls",skiprows=1) file_one

= file_one.dropna(how='all') # Remove rows with all missing values file_one = file_one.dropna(thresh=2) # Remove rows with less than 2 non-missing values file_one = file_one.reset_index(drop=True) # Reset the index file_one.head() # Show the first few rows of the data frame