How to use python to delete a column and rows in excel, that contains certain values

Question

Just trying to get python to open a file, read a file, do value set in which if the data that has a 1.00 and has another value thats over 0.93 in that row/column then it gets deleted, if not then go over row/column to the next row/column, both files are closed, then rename new file into original file

score 1 · Answer 1 · edited Aug 15 '16 at 18:38

1

There is a package named xlrd that you can use to read data from excel file and modify/delete to suit your need.

edited Aug 15 '16 at 18:38

PhilippNagel

70
1
15

answered Jul 03 '14 at 17:23

bhaskarc

9,269
10
65
86

How to use python to delete a column and rows in excel, that contains certain values

1 Answers1