can someone remove all duplicate numbers excluding the 1 column and percentage row only. percentage row is on the top and 1st column is entered numbers.

Here's the code:

import xlwt from xlwt import Workbook from decimal import *

#create a workbook wb = Workbook() #create a sheet sheet = wb.add_sheet('Sheet',cell_overwrite_ok=True)

#percentages list percentages = [23.6, 38.2, 50, 61.8, 78.6, 113, 123.6, 138.2, 161.8] #add first row for i in range(len(percentages)): sheet.write(0,i+1,str(percentages[i])+'%')

#user input n = int(input('Enter number of elements: ')) #second row starts from index 1 row=1 #created dictionary to store elements entered in first column of excel sheet storeCol_dict ={} print('Enter numbers: ') for i in range(n): #User input val = float(input())

#Add entered value to first column of the row sheet.write(row,0,str(val)) #after value is written at first column #check if it exists in the dictionary declared above #if yes, then increment row and continue the loop as no need to calculate values again #so that no duplicate rows are there if val in storeCol_dict: row+=1 continue

#add element to dictionary and let's have its value as any number, here it's 1 storeCol_dict[val] = 1; #calculate each percentage prev = "" for j in range(len(percentages)): result = (percentages[j]/100)*val #write result to sheet by rounding to nearest whole number using quantize method current = str(Decimal(result).quantize(Decimal("1"))) if(prev != current): sheet.write(row,j+1,current) prev = current #indentation is corrected here so that this statement comes under first for loop #increment the row by 1 row+=1 #save Workbook as xls` wb.save('percentages.xls')

thanks to anyone who helped!