job_Id   FirstName    LastName   Address   Email      Date/Time

1    snehil     singh   marathalli  ss@gmail.com      12/10/2011:02:03:20
2    salman     khan    marathalli  ss@gmail.com      12/11/2011:03:10:20
3    Amir       khan    HSR         ar@gmail.com      11/22/2009:09:03:20
4    Rakhesh    kumar   HSR         rakesh@gmail.com  09/15/2010:02:03:55
5    Ram        sharma  marathalli  r@gmail.com       01/10/2014:12:03:20
6    Shyam      shahi   BTM         ss@gmail.com      12/17/2012:01:03:20
7    salman     khan    HSR         ss@gmail.com      11/08/2016:15:03:20
8    Amir       khan    BTM         ar@gmail.com      07/10/2013:04:02:30
9    snehil     singh   Majestic    sne@gmail.com     03/20/2018:02:03:20

job_Id  FullName    Address  Email  Date

1       1           1        1      12/10/2011
2       2           1        1      12/11/2011
3       3           2        2      11/22/2009
4       4           2        3      09/15/2010
5       5           1        4      01/10/2014
6       6           3        1      12/17/2012
7       2           2        1      11/08/2016
8       3           3        2      07/10/2013
9       1           4        5      03/20/2018

with open("input2.csv", 'r',encoding="utf8") as csvfile:
        # creating a csv reader object
        reader = csv.DictReader(csvfile, delimiter=',')

        '''We then restructure the data to be a set of keys with list of values {key_1: [], key_2: []}:'''
        data = {}
        for row in reader:
#         print(row)
            for header, value in row.items():
                try:
                    data[header].append(value)
                except KeyError:
                    data[header] = [value]

        '''Next we want to give each value in each list a unique identifier.'''
        # Loop through all keys
        for key in data.keys():
            values = data[key]

            things = list(sorted(set(values), key=values.index))

            for i, x in enumerate(data[key]):
                data[key][i] = things.index(x) + 1
#                 print(data[key][i])
                NewData=data[key][i]
                print(NewData)

        """Since csv.writerows() takes a list but treats it as a row, we
           need to restructure our
        data so that each row is one value from each list. This can be
         accomplished using zip():"""

        with open("OuputFile.csv", "w") as outfile:
            writer = csv.writer(outfile)
            # Write headers
            writer.writerow(data.keys())
            # Make one row equal to one value from each list
            rows = zip(*data.values())
            # Write rows
            writer.writerows(rows)