Python Forum
Removing duplicate list items
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Removing duplicate list items
#1
Hello, I am creating a code that allows the user to paste copied excel cells into a function that will return all the entries with commas, properly capitalized, and without duplicates. My code is below (minus the part that fixes capitalization). I noticed with the way it is, if I type "blacknose dace, blacknose dace" it will still return both. If I paste the excel cells multiple times, it will also fail to remove duplicates. I am a very novice coder and am not sure what to do, any tips?

from collections import OrderedDict #gives us a tool to order the list we create


print ("Type 'I()' to start the historic fish tool. Type 'stop' to end the loop") #instructions
print ("Note: please PASTE the excel data. You may type it, but commas won't be placed.")

def I():   #When we type "I()" the historic fish tool runs, letting us paste excel data to get a non-duplicated,
           #properly capitalized fish species list

    Fish = "Hi"     #just defines the Fish variable so we may start the loop below
    while Fish != "STOP":    #unless you type "stop" in any capitalization, this code will loop, letting the user
                             #put in multiple sites' data throughout the session
        print('')
        Fish = raw_input("Paste excel data: ").upper()     #lets us input our fish species, makes input uppercase
        Fi = Fish.split("\n")   #creates a list based off our fish species
        Fi = Fish.split(",")
        Fi = list (OrderedDict.fromkeys(Fi))   #removes duplicates
        Fi.sort()    #sorts the species alphabetically
        print '[%s]' % ', '.join(map(str, Fi)) #removes quotation marks and prints list
Reply


Messages In This Thread
Removing duplicate list items - by eglaud - Nov-19-2019, 06:38 PM
RE: Removing duplicate list items - by ichabod801 - Nov-19-2019, 06:59 PM
RE: Removing duplicate list items - by eglaud - Nov-19-2019, 07:01 PM
RE: Removing duplicate list items - by eglaud - Nov-22-2019, 06:03 PM
RE: Removing duplicate list items - by ichabod801 - Nov-22-2019, 08:07 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to parse and group hierarchical list items from an unindented string in Python? ann23fr 0 199 Mar-27-2024, 01:16 PM
Last Post: ann23fr
  Why do I have to repeat items in list slices in order to make this work? Pythonica 7 1,354 May-22-2023, 10:39 PM
Last Post: ICanIBB
  Finding combinations of list of items (30 or so) LynnS 1 885 Jan-25-2023, 02:57 PM
Last Post: deanhystad
  For Word, Count in List (Counts.Items()) new_coder_231013 6 2,621 Jul-21-2022, 02:51 PM
Last Post: new_coder_231013
  How to get list of exactly 10 items? Mark17 1 2,539 May-26-2022, 01:37 PM
Last Post: Mark17
  how to assign items from a list to a dictionary CompleteNewb 3 1,593 Mar-19-2022, 01:25 AM
Last Post: deanhystad
  Reading list items without brackets and quotes jesse68 6 4,649 Jan-14-2022, 07:07 PM
Last Post: jesse68
Question How to gather specific second-level items from a list chatguy 2 1,560 Dec-17-2021, 05:05 PM
Last Post: chatguy
  deleting select items from a list Skaperen 13 4,552 Oct-11-2021, 01:02 AM
Last Post: Skaperen
  Getting All Items From A List knight2000 4 2,414 Sep-25-2021, 12:56 AM
Last Post: knight2000

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020