Python uses pandas and xlrd to read Excel, feature filtering deletes columns with 0 values over 99%

Using XLRD to read Excel Filter 0 columns with a value greater than 99% and remove Import Xlrd Workbook=xlrd.open_workbook (R "123.xlsx") Table = Workbook.sheet_by_name (' Sheet1 ') Nrows=table.nrows Ncols=table.ncols Del_col=[] For j in Range (Ncols): sum = 0 For Ai in table.col_values (j): if ai = = 0.0: Sum+=1 if float (sum)/nrows>=0.99: Del_col.append (j) print Del_col

Using Pandas to read Excel Filter 0 columns with a value greater than 99% and remove Import Pandas As PD Df1=pd.read_csv (r "123.csv") DF=PD. DataFrame (DF1) nrows=df.shape[0] ncols=df.columns.size del_col=[] For JinchRange (ncols): sum =0 For ai in df.iloc[:,j]: if ai = = 0.0: sum+= 1 if float (sum)/nrows>=0.99: Del_col.append (j) Print Del_col

Python uses pandas and xlrd to read Excel, feature filtering deletes columns with 0 values over 99%