I'm a relative newbie to python 2.7 and would like to seek some advice on how to use the python xlrd module/csv module to manipulate a CSV file. I'm seeking to replace all (r,c) cells with (r+1,c) where C is a specific column: eg Column 10 and r is the row number that will iterate based on the available rows in a csv file. Raw data csv file
Processed into this format
Subsequently, i'd like to delete the redundant rows to look as below. I'm aware of how to delete the rows based on selective filter criteria. Final data format
Any directives will be appreciated.