Python Group Array by Column and Display Unique Values

Question

I have an Array of Arrays with following format:

x = [["Username1","id3"],
["Username1", "id4"],
["Username1", "id4"],
["Username3", "id3"]]

I want to group by the ids and display all the unique usernames How would I get an output that is like:

id3: Username1, Username3

id4: Username1

Edit: Was able to group by second column but I cannot only display unique values. Here is my code:

data={}
for key, group in groupby(sorted(x), key=lambda x: x[1]):
    data[key]=[v[0] for v in group]
print(data)

Andriy Ivaneyko · Accepted Answer · 2016-02-08 18:20:57Z

1

Use dict to create unique keys by id and pythons sets to store values ( so you would store only unique names for that keys):

items = [
    ["Username1","id3"],
    ["Username1", "id4"],
    ["Username1", "id4"],
    ["Username3", "id3"]
]

data = {}
for item in items:
    if data.has_key(item[1]):
        data[item[1]].add(item[0])
    else:
        data[item[1]] = set([item[0]])
print(data)

edited Feb 8, 2016 at 18:20

answered Feb 8, 2016 at 18:14

Andriy Ivaneyko

22.3k7 gold badges70 silver badges89 bronze badges

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

1 Comment

Bijan Over a year ago

How do I remove duplicates? i.e. id4 to only display Username1 once

Community · Accepted Answer · 2017-05-23 11:59:14Z

0

You may use a for loop but using a linq statement might be cleaner for future usage.

https://stackoverflow.com/a/3926105/4564614

has some great ways to incorpurate linq to solve this issue. I think what you are looking for would be grouping by.

Example:

from collections import defaultdict
from operator import attrgetter

   def group_by(iterable, group_func):
       groups = defaultdict(list)
       for item in iterable:
           groups[group_func(item)].append(item)
       return groups

   group_by((x.foo for x in ...), attrgetter('bar'))

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Feb 8, 2016 at 18:18

Aliminator

1996 bronze badges

Collectives™ on Stack Overflow

Python Group Array by Column and Display Unique Values

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related