NimbleSET

Compare two lists

Compare two lists with NimbleSET 2.0


animation showing NimbleSET comparing two lists
Download NimbleSET

Exploring Sets with NimbleSET

You have two sets of data, two lists, and you want to compare them. We can demonstrate this problem with the awesome power of a Venn diagram:

The Venn diagram has three interesting areas:

  • the bit on the left ('Left Only')
  • the intersection ('Both')
  • the bit on the right ('Right Only')

NimbleSET lets us instantly split two sets into these three areas. And it does a whole lot more as well. Any time you have two lists... you need NimbleSET!

You can see which items are in one list and not the other. (Left Only icon or Right Only icon)

See which items are in both lists. both

If each list has columns, then you can join them on just the columns they share. Or any pair of columns.

Perform fuzzy matching of terms inside text.

You can sort both lists, remove duplicates from the lists.

Let's go through this in a little more detail.

Imagine our two sets are: 'the beatles' and 'the gospels of the new testament'.

BeatlesGospels
johnmatthew
paulmark
georgeluke
ringojohn

If we want to see what items they have in common, click the 'intersect' button.

That's the button with this icon → both

Result (1 row)
john

To see which items are in the list on the left but not in the list on the right:

Click 'left only' Left Only icon

Result (3 rows)
paul
george
ringo

To see the 'right only' items click 'right only' Right Only icon

Result (3 rows)
matthew
mark
luke

To grab all the items from both lists:

Press 'union' Union icon

Result (8 rows)
john
paul
george
ringo
matthew
mark
luke
john

To find the distinct members of the result set:

Press 'Distinct' (under the 'result')

Result (7 rows)
john
paul
george
ringo
matthew
mark
luke

To sort the results, as you often need to:

Press the sort button Sort icon (under the result)

Result (7 rows)
george
john
luke
mark
matthew
paul
ringo

There are also buttons to:

Swap the lists Swap icon(and their titles)

Invert the list Invert icon(in effect a sort descending),

or to copy the result back up into either the left Copy up to left icon

or right list Copy up to right icon.

You can use it online, no download required, but less features than the free download.

Download NimbleSET

And you know a really great companion for NimbleSET? That's right! NimbleText!