Creating a copy of a spreadsheet having only unique rows from a given sheet

Let us say we have the following sheet which has the repeated values highlighted in bold. The following script can be used if we want to create a new sheet having rows with the repeated values of the column ID removed.

The value of file1 points to the original file and copy is the path to the new file to be created.



Save the file as create_sheet_unique_rows.py and execute it.

$ python create_sheet_unique_rows.py ID CS10 CS11 CS12 CS13 CS15 CS16 CS17 CS18 CS20 CS21 CS22 CS23 CS24 CS26 CS27 CS28 CS29 There are 17 unique values

The new file created should look as below.