Search Delete using csv.reader in python

Question

I want to search a column and delete from csv file using python. I cannot dataframes as I need to work with large files and can't load it in RAM. How to do it? example csv file-

Home,Contact,Adress
abc,123,xyz 

I need to find and delete Contact for example. I thought to use csv.reader but cannot figure out how to do it

Answer 1

Check this :

import csv

col = 'Contact'

with open('your_csv.csv') as f:
    with open('new_csv.csv', 'w', newline='') as g:
        
        # creating csv reader
        reader = csv.reader(f)

        # getting the 'col' index in the header, we want to delete it in the next lines
        col_index = next(reader).index(col)

        for line in reader:
            del line[col_index]

            # writing to new csv file
            writer = csv.writer(g)
            writer.writerow(line)

Explanation for using newline='' is here.