tech

<div>
The code works, thanks a million.
</div>

<div>
<div class="content wysiwyg-content">
<a href="https://www.experts-exchange.com/questions/29166962/Delete-unwanted-records.html?anchorAnswerId=42997133#a42997133" rel="ugc">https://www.experts-exchange.com/questions/29166962/Delete-unwanted-records.html?anchorAnswerId=42997133#a42997133</a> 
 
id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;X &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; year 
45 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1375 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2018 
23 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1514 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2018 
67 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1516 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2017 
32 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1516 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2018 
78 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1502 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2018 
54 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2017 
11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2018 
24 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2015 
98 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2016 
85 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2018 
52 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2016 
 
for above data, the above code generates the following output. 
 
 
id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;X &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;year 
54 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2017 
11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2018 
24 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2015 
98 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2016 
85 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2018 
52 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2016 
 
I wanted to delete the duplicate records from the above output when X and year are same so that the output should be 
 
id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; X &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; year 
54 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2017 
11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2018 
24 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2015 
98 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1908 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2016
</div>
</div>

https://www.experts-exchange.com/questions/29166962/Delete-unwanted-records.html#a42997133

id	   X	        year
45	1375	2018
23	1514	2018
67	1516	2017
32	1516	2018
78	1502	2018
54	1908	2017
11	1908	2018
24	1908	2015
98	1908	2016
85	1908	2018
52	1908	2016 

for above data, the above code generates the following output.


id	X	year
54	1908	2017
11	1908	2018
24	1908	2015
98	1908	2016
85	1908	2018
52	1908	2016

I wanted to delete the duplicate records from the above output when X and year are same so that the output should be

id	    X	        year
54	1908	2017
11	1908	2018
24	1908	2015
98	1908	2016

Delete duplicate records

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.