I have a csv file where I need to modify/delete some lines according to my filters then write it again to CSV. Problem is, I need to adjust the numbering in the first column below the deleted line.
What would be the most efficient way to this? Thanks
P.S.: I have cropped out some texts at the top, so when I read this csv file, output datatable has only one column.