Append a number to duplicate values in a list - python

Question

   devices = [
    'SWTEST1-3AA-02',
    'SWTEST1-3AA-02',
    'SWTEST1-2CA-01',
    'SWTEST1-2CA-01',
    'SWTEST1-2AA-02',
    'SWTEST1-2AA-02',
    'SWTEST1-2AA-02'
  ]

The output that I'm looking for is as follows.

[
'SWTEST1-3AA-02',
'SWTEST1-3AA-02-2',
'SWTEST1-2CA-01',
'SWTEST1-2CA-01-2',
'SWTEST1-2AA-02',
'SWTEST1-2AA-02-2',
'SWTEST1-2AA-02-3'
]

I tried with a for loop and a counter but I'm not getting the results I want, any help will be much appreciated.

For loops that I tried:

counter = 1
out = []
for e in devices:
    out.append(f"{e}-{counter}")
    counter += 1
print(out)

out = []

d = {}

for i in devices:
    counter = 1
    d.setdefault(i, -1)
    d[i] += 1

    if d[i] >= 1:
        out.append('{}-{}'.format(i, d[i]))
        counter += 1
    else:
        out.append(i)

print(out)

It would probably be helpful to show what you tried and what didn't work about it. — Jon Kiparsky
– Jon Kiparsky, Commented Apr 28, 2021 at 16:55
Any answer is going to involve loops and counters. Please post what you've tried and what went wrong. — Woodford
– Woodford, Commented Apr 28, 2021 at 16:55
Does this answer your question? Python: Rename duplicates in list with progressive numbers without sorting list — pho
– pho, Commented Apr 28, 2021 at 17:04

Ajax1234 · Accepted Answer · 2021-04-28 16:59:34Z

6

You can use a list comprehension:

devices = ['SWTEST1-3AA-02', 'SWTEST1-3AA-02', 'SWTEST1-2CA-01', 'SWTEST1-2CA-01', 'SWTEST1-2AA-02', 'SWTEST1-2AA-02', 'SWTEST1-2AA-02']
r = [a if not (s:=sum(j == a for j in devices[:i])) else f'{a}-{s+1}'
    for i, a in enumerate(devices)]

Output:

['SWTEST1-3AA-02', 
 'SWTEST1-3AA-02-2', 
 'SWTEST1-2CA-01', 
 'SWTEST1-2CA-01-2', 
 'SWTEST1-2AA-02', 
 'SWTEST1-2AA-02-2', 
 'SWTEST1-2AA-02-3']

answered Apr 28, 2021 at 16:59

Ajax1234

71.7k9 gold badges67 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrej Kesely · Accepted Answer · 2021-04-28 17:00:36Z

1

Another solution:

devices = [
    "SWTEST1-3AA-02",
    "SWTEST1-3AA-02",
    "SWTEST1-2CA-01",
    "SWTEST1-2CA-01",
    "SWTEST1-2AA-02",
    "SWTEST1-2AA-02",
    "SWTEST1-2AA-02",
]

out, cnt = [], {}
for d in devices:
    if d not in cnt:
        cnt[d] = 1
    else:
        cnt[d] += 1
        d = d + "-{}".format(cnt[d])
    out.append(d)

print(out)

Prints:

['SWTEST1-3AA-02', 
 'SWTEST1-3AA-02-2', 
 'SWTEST1-2CA-01', 
 'SWTEST1-2CA-01-2', 
 'SWTEST1-2AA-02', 
 'SWTEST1-2AA-02-2', 
 'SWTEST1-2AA-02-3']

answered Apr 28, 2021 at 17:00

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

1 Comment

Pzrk Over a year ago

This is a similar code that I tried to write, looks like I did couple of steps wrong, thank you!

Jon Kiparsky · Accepted Answer · 2021-04-28 17:04:54Z

0

If you don't care about preserving the original order of the list, something like this would work (and is nice and simple, and works in linear time)

counter = Counter(devices)
result = []
for value, count in counter.items():
    result.append(value)
    for i in range(2, count+1): 
        result.append("{}-{}".format(value, i))

answered Apr 28, 2021 at 17:04

Jon Kiparsky

7,8242 gold badges26 silver badges42 bronze badges

Comments

Gebodal · Accepted Answer · 2021-04-28 17:09:53Z

This should do what you want:

from collections import Counter

result = [(t+(f'-{i+1}' if i>0 else '')) for t,count in Counter(devices).items() for i in range(count)]

If ordering is important, however, this won't work, and you may need something more involved. (By this I mean that the final output will have duplicate values grouped together, rather than in the order they appear in the original list)

If you want to ordering maintained, you want something like:

def number_duplicates(values):
    counter = Counter()

    for v in values:
        counter[v] += 1
        if counter[v]>1:
            yield v+f'-{counter[v]}'
        else:
            yield v

result = list(number_duplicates(devices))

And now the result will have the same ordering of values as the original, but with the duplicate counters appended.

Collectives™ on Stack Overflow

Append a number to duplicate values in a list - python

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related