针对一个大型Excel文件，需要删除20,000行含有特定值X的第一列的行。博主尝试用Python和xlwt库自动化这一过程，但不知从何开始。建议的解决方案是不直接删除，而是读取原始文件，创建新文件，只将不包含X值的行写入新文件，最后重命名新文件为原始文件。
I have a really large excel file and i need to delete about 20,000 rows, contingent on meeting a simple condition and excel won't let me delete such a complex range when using a filter. The condition is:
If the first column contains the value, X, then I need to be able to delete the entire row.
I'm trying to automate this using python and xlwt, but am not quite sure where to start. Seeking some code snippits to get me started...
Grateful for any help that's out there!
解决方案
Don't delete. Just copy what you need.
read the original file
open a new file
iterate over rows of the original file (if the first column of the row does not contain the value X, add this row to the new file)
close both files
rename the new file into the original file
扫一扫
2157
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
