How to create a tuple <input,output> where input is text in the column and output as row number?

Question

I have a csv file with Name Mobile Email headers. I want to generate a tuple which has input as a name,email or mobile and output as the corresponding row number. (input,output) tuple.

Answer 1

Refer to this docs

The csv module’s reader and writer objects read and write sequences. Programmers can also read and write data in dictionary form using the DictReader and DictWriter classes.

You can use this CSV module to do the functionality.

import csv
with open('my_file.csv', 'rb') as f:
    file_reader = csv.reader(csvfile)
    for row in file_reader:
        my_tuple= tuple(row)
        print(my_tuple)

For writing in the file you can use .writerow() function

fieldnames = ['Name', 'Mobile','Email']
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
writer.writeheader()
writer.writerow({'Name': x, 'Mobile': y,'Email':z})

x,y,z are variables

Answer 2

Is this what you mean by tuples?

import csv 
with open('file.csv', 'r', newline='') as f:
    reader = csv.DictReader(f)
    for tup in enumerate(reader):
        print(tup)

Output:

(0, OrderedDict([('name', 'abc'), ('email', '[email protected]'), ('phone', '12345678')]))
(1, OrderedDict([('name', 'lmn'), ('email', '[email protected]'), ('phone', '23456789')]))