In [1]:
# import py_entitymatching package
import py_entitymatching as em
import os
/home/xeno/repos/board-game-data-science/venv/lib/python3.5/site-packages/sklearn/cross_validation.py:44: DeprecationWarning: This module was deprecated in version 0.18 in favor of the model_selection module into which all the refactored classes and functions are moved. Also note that the interface of the new CV iterators are different from that of this module. This module will be removed in 0.20.
"This module will be removed in 0.20.", DeprecationWarning)
In [2]:
# specify filepaths for tables A and B.
path_A = 'tableA.csv'
path_B = 'tableB.csv'
In [3]:
# read table A; table A has 'ID' as the key attribute
A = em.read_csv_metadata(path_A, key='id')
# read table B; table B has 'ID' as the key attribute
B = em.read_csv_metadata(path_B, key='id')
Metadata file is not present in the given path; proceeding to read the csv file.
Metadata file is not present in the given path; proceeding to read the csv file.
In [4]:
A # print table A to ensure correctly loaded
Out[4]:
id
name
year
rating
rank
min_players
max_players
min_gameplay_time
max_gameplay_time
min_age
complexity_weight
category
mechanisms
type
BGG_link
store_names
store_prices
links_to_buy
availability
international_store
0
1
Sweet Valley High
1988.0
4.8
11444.0
2.0
4.0
30.0
30.0
8.0
1.00
Memory;Novel-based
Memory;Roll / Spin and Move;Set Collection
Admin: Better Description Needed!
NaN
NaN
NaN
NaN
NaN
NaN
1
2
007 James Bond: You Only Live Twice
1985.0
5.7
NaN
2.0
2.0
20.0
20.0
8.0
1.33
Adventure;Movies / TV / Radio theme;Novel-based
Roll / Spin and Move
007 James Bond Action Episode Games;Characters: James Bond
NaN
NaN
NaN
NaN
NaN
NaN
2
3
Rock Paper Scissors Inc.
2003.0
5.0
NaN
2.0
2.0
10.0
10.0
6.0
1.50
Bluffing;Economic;Print & Play
Rock-Paper-Scissors;Simultaneous Action Selection;Stock Holding
NaN
NaN
NaN
NaN
NaN
NaN
NaN
3
4
VisualEyes
2003.0
5.6
8784.0
2.0
8.0
30.0
30.0
8.0
1.41
Dice;Negotiation;Party Game;Puzzle;Real-time;Word Game
Dice Rolling;Paper-and-Pencil;Voting
NaN
NaN
NaN
NaN
NaN
NaN
NaN
4
5
007 James Bond: Goldfinger
1985.0
6.0
NaN
2.0
2.0
20.0
20.0
8.0
1.50
Adventure;Movies / TV / Radio theme;Novel-based
Area Movement;Roll / Spin and Move
007 James Bond Action Episode Games;Characters: James Bond
NaN
NaN
NaN
NaN
NaN
NaN
5
6
Assembly Line
2003.0
5.0
NaN
2.0
2.0
20.0
20.0
10.0
1.50
Abstract Strategy;Bluffing;Economic;Print & Play
Rock-Paper-Scissors;Simultaneous Action Selection
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6
7
Cronberg
2003.0
6.0
4074.0
2.0
4.0
20.0
20.0
8.0
1.91
City Building;Print & Play
Area Enclosure;Tile Placement
Admin: Better Description Needed!
NaN
NaN
NaN
NaN
NaN
NaN
7
8
Münchhausen
1996.0
5.9
8152.0
3.0
8.0
30.0
30.0
8.0
1.09
Bluffing;Card Game;Fantasy
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
8
9
Lickin' Lizards
1993.0
5.4
NaN
2.0
4.0
20.0
20.0
5.0
NaN
Action / Dexterity;Animals;Children's Game;Real-time
NaN
Animals: Lizards;Animals: Spiders
NaN
NaN
NaN
NaN
NaN
NaN
9
10
Slobberin' Sam
1993.0
2.0
NaN
2.0
4.0
20.0
20.0
NaN
NaN
Action / Dexterity;Animals;Children's Game;Electronic
NaN
3D Games;Animals: Dogs
NaN
NaN
NaN
NaN
NaN
NaN
10
11
The Odd-Ball Scenario
1996.0
5.0
NaN
2.0
6.0
30.0
30.0
NaN
NaN
Expansion for Base-game;Spies/Secret Agents
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
11
12
Husch Husch kleine Hexe
1994.0
5.5
10275.0
2.0
6.0
15.0
15.0
3.0
1.00
Children's Game;Dice;Fantasy;Memory;Racing
Dice Rolling;Memory;Roll / Spin and Move
Witches
NaN
NaN
NaN
NaN
NaN
NaN
12
13
Mad Dash!
1991.0
5.4
NaN
2.0
2.0
10.0
10.0
8.0
1.00
Card Game;Educational;Racing
Hand Management;Pattern Building
NaN
NaN
NaN
NaN
NaN
NaN
NaN
13
14
Batalo
1992.0
6.2
NaN
2.0
2.0
30.0
30.0
6.0
2.00
Abstract Strategy
Area Movement
Tube Games
NaN
NaN
NaN
NaN
NaN
NaN
14
15
Tilez!
1997.0
4.9
NaN
2.0
4.0
30.0
30.0
6.0
1.50
Abstract Strategy
Tile Placement
Polyominoes
NaN
NaN
NaN
NaN
NaN
NaN
15
16
Blaster Bots
2003.0
5.5
NaN
2.0
6.0
30.0
30.0
12.0
NaN
Card Game;Fighting;Science Fiction
Dice Rolling
NaN
NaN
NaN
NaN
NaN
NaN
NaN
16
17
Electronic Dream Phone
1991.0
5.6
10924.0
1.0
4.0
20.0
20.0
9.0
2.33
Children's Game;Deduction;Electronic
Roll / Spin and Move
NaN
NaN
NaN
NaN
NaN
NaN
NaN
17
18
World Cup in the Void
2003.0
NaN
NaN
2.0
2.0
20.0
20.0
NaN
NaN
Card Game;Sports
Simulation;Variable Player Powers
Sports: Football / Soccer
NaN
NaN
NaN
NaN
NaN
NaN
18
19
Sabuca
1999.0
6.0
NaN
2.0
6.0
20.0
20.0
10.0
1.33
Card Game;Word Game
Hand Management
NaN
NaN
NaN
NaN
NaN
NaN
NaN
19
20
Korea: The Forgotten War
2003.0
8.1
1906.0
2.0
2.0
360.0
360.0
16.0
4.21
Korean War;Modern Warfare;Wargame
Dice Rolling;Hex-and-Counter;Simulation
Country: Korea;Operational Combat Series
NaN
NaN
NaN
NaN
NaN
NaN
20
21
Let's Do Lunch!
2000.0
5.3
10659.0
2.0
2.0
20.0
20.0
12.0
1.14
Abstract Strategy;Dice;Prehistoric
Dice Rolling
NaN
NaN
NaN
NaN
NaN
NaN
NaN
21
22
Kung Fu Samurai on Giant Robot Island
2003.0
5.8
6690.0
2.0
6.0
30.0
30.0
13.0
1.50
Card Game;Humor;Movies / TV / Radio theme;Science Fiction
NaN
B-Movies;Samurai
NaN
NaN
NaN
NaN
NaN
NaN
22
23
Grave Robbers II: Skippy's Revenge
2003.0
6.2
4266.0
2.0
6.0
30.0
30.0
13.0
1.28
Card Game;Horror;Humor;Movies / TV / Radio theme;Science Fiction
NaN
Aliens;B-Movies
NaN
NaN
NaN
NaN
NaN
NaN
23
24
Booty
1995.0
3.9
NaN
2.0
4.0
45.0
45.0
13.0
1.50
Abstract Strategy;Maze;Racing
Dice Rolling;Pick-up and Deliver;Tile Placement
NaN
NaN
NaN
NaN
NaN
NaN
NaN
24
25
Lights Camera Action
2003.0
7.5
NaN
2.0
2.0
45.0
45.0
NaN
NaN
Movies / TV / Radio theme;Party Game;Trivia
Co-operative Play;Role Playing
NaN
NaN
NaN
NaN
NaN
NaN
NaN
25
26
Coodju
2001.0
5.1
NaN
4.0
4.0
30.0
30.0
NaN
2.00
Party Game;Word Game
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
26
27
Radar Search
1969.0
4.6
NaN
2.0
2.0
30.0
30.0
6.0
1.20
Bluffing;Deduction;Electronic;Spies/Secret Agents
Point to Point Movement;Secret Unit Deployment;Variable Player Powers
NaN
NaN
NaN
NaN
NaN
NaN
NaN
27
28
Stampin'
1989.0
4.4
NaN
2.0
4.0
60.0
60.0
NaN
NaN
NaN
Auction/Bidding;Roll / Spin and Move;Set Collection
Post Office Stamps and Mail
NaN
NaN
NaN
NaN
NaN
NaN
28
29
Glasnost
1989.0
4.4
NaN
2.0
8.0
90.0
90.0
12.0
2.00
Political
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
29
30
Wall Street Game
1998.0
3.0
NaN
2.0
5.0
60.0
60.0
10.0
NaN
Economic
Roll / Spin and Move;Stock Holding
Admin: Better Description Needed!
NaN
NaN
NaN
NaN
NaN
NaN
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
6961
6962
Melvin the Moon Man
1959.0
NaN
NaN
2.0
6.0
30.0
30.0
NaN
1.00
Science Fiction;Space Exploration
Dice Rolling
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6962
6963
Le Camino
1973.0
6.3
NaN
2.0
4.0
45.0
45.0
NaN
2.00
Abstract Strategy
Tile Placement
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6963
6964
Super Nova: Event Horizon
2000.0
5.0
NaN
2.0
6.0
90.0
90.0
10.0
1.00
Card Game;Economic;Expansion for Base-game;Political;Science Fiction
Hand Management;Point to Point Movement;Trading
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6964
6965
Deadlands: Doomtown Range Wars
2000.0
6.3
5171.0
2.0
8.0
90.0
90.0
10.0
2.20
American West;Collectible Components;Fantasy
NaN
CTGs (Collectible Token Games);From RPG books to board games;The Weird West (BGG Family)
NaN
NaN
NaN
NaN
NaN
NaN
6965
6966
Backscrabbing
1989.0
3.5
NaN
4.0
6.0
90.0
90.0
NaN
3.00
Economic;Industry / Manufacturing;Negotiation
Commodity Speculation;Hand Management;Roll / Spin and Move;Stock Holding;Trading
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6966
6967
Air & Armor
1986.0
7.6
3295.0
2.0
2.0
120.0
120.0
12.0
3.56
Modern Warfare;Wargame
Action Point Allowance System;Hex-and-Counter;Simulation
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6967
6968
Destination Mars
1999.0
5.1
NaN
2.0
2.0
20.0
20.0
8.0
1.33
Card Game;Racing;Science Fiction
Set Collection
Mars
NaN
NaN
NaN
NaN
NaN
NaN
6968
6969
Star Empires
1987.0
5.8
NaN
2.0
6.0
60.0
60.0
12.0
3.00
Card Game;Science Fiction
Set Collection
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6969
6970
Echelons of Fury
1995.0
4.5
12018.0
2.0
2.0
60.0
60.0
12.0
2.20
Card Game;Collectible Components;World War II
Campaign / Battle Card Driven;Hand Management
CCGs (Collectible Card Games)
NaN
NaN
NaN
NaN
NaN
NaN
6970
6971
Force
1977.0
4.4
NaN
2.0
2.0
20.0
20.0
10.0
1.00
Abstract Strategy;Action / Dexterity
Route/Network Building
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6971
6972
Off Course
1986.0
7.0
NaN
1.0
6.0
45.0
45.0
10.0
2.00
Dice;Sports
Card Drafting;Dice Rolling;Modular Board;Paper-and-Pencil
Sports: Golf
NaN
NaN
NaN
NaN
NaN
NaN
6972
6973
Fields of Chivalry
2002.0
5.0
NaN
2.0
4.0
60.0
60.0
12.0
NaN
Dice;Fighting;Medieval
Campaign / Battle Card Driven;Dice Rolling;Rock-Paper-Scissors;Variable Player Powers
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6973
6974
Shipwrecked
2000.0
5.7
6468.0
2.0
4.0
30.0
30.0
12.0
1.48
Card Game
Auction/Bidding
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6974
6975
East & West: Global War in 1948
2000.0
6.6
NaN
2.0
4.0
300.0
300.0
12.0
2.50
Wargame;World War II
Area Movement
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6975
6976
Captain Tsubasa Trading Card Game
2002.0
5.8
NaN
2.0
2.0
60.0
60.0
NaN
NaN
Card Game;Comic Book / Strip;Sports
Role Playing;Variable Player Powers
Anime & Manga;CCGs (Collectible Card Games);Sports: Football / Soccer
NaN
NaN
NaN
NaN
NaN
NaN
6976
6977
Käp'tän Buddel
1989.0
3.0
NaN
2.0
4.0
45.0
45.0
8.0
NaN
Pirates
Action Point Allowance System;Dice Rolling
Abacus wood box
NaN
NaN
NaN
NaN
NaN
NaN
6977
6978
Abaco Zuzzurellone
1995.0
5.6
NaN
2.0
2.0
45.0
45.0
8.0
NaN
Word Game
Paper-and-Pencil
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6978
6979
Top Quark
1996.0
5.7
NaN
2.0
2.0
30.0
30.0
10.0
NaN
Abstract Strategy
Area Movement
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6979
6980
Time Control
2003.0
2.1
12584.0
2.0
4.0
45.0
45.0
12.0
2.50
Real-time;Science Fiction
Auction/Bidding;Hand Management;Simultaneous Action Selection
Time Travel
NaN
NaN
NaN
NaN
NaN
NaN
6980
6981
Murder Mystery Party: A Taste for Wine and Murder
1997.0
6.8
NaN
6.0
8.0
180.0
180.0
16.0
NaN
Deduction;Murder/Mystery;Party Game
Acting
Murder à la carte;Murder Mystery Party Series
NaN
NaN
NaN
NaN
NaN
NaN
6981
6982
Murder à la carte: Pasta Passion & Pistols
1995.0
5.8
NaN
6.0
8.0
180.0
180.0
18.0
2.33
Deduction;Murder/Mystery;Party Game
Acting
Food / Cooking;Murder à la carte
NaN
NaN
NaN
NaN
NaN
NaN
6982
6983
Bosworth
1998.0
5.8
5871.0
2.0
4.0
60.0
60.0
8.0
2.10
Abstract Strategy
Grid Movement
Chess Games
NaN
NaN
NaN
NaN
NaN
NaN
6983
6984
Murder à la carte: Bullets 'N' Barbecue
1994.0
4.9
NaN
6.0
6.0
180.0
180.0
18.0
1.00
Deduction;Murder/Mystery;Party Game
Acting
Murder à la carte
NaN
NaN
NaN
NaN
NaN
NaN
6984
6985
Murder Mystery Party: Murder on the S. S. Titania
1996.0
6.0
NaN
8.0
8.0
240.0
240.0
16.0
NaN
Deduction;Murder/Mystery;Party Game
Acting
Murder Mystery Party Series
NaN
NaN
NaN
NaN
NaN
NaN
6985
6986
Floß geht's!
2003.0
6.7
NaN
2.0
4.0
10.0
10.0
4.0
1.00
Children's Game;Nautical;Racing
Dice Rolling;Modular Board;Pattern Recognition;Roll / Spin and Move
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6986
6987
Doktor Igel
2001.0
5.7
10019.0
2.0
5.0
10.0
10.0
4.0
1.00
Action / Dexterity;Animals;Children's Game;Dice
Co-operative Play;Dice Rolling;Pick-up and Deliver
Animals: Hedgehogs/Porcupines
NaN
NaN
NaN
NaN
NaN
NaN
6987
6988
Fleet Fins
2003.0
6.4
NaN
2.0
4.0
10.0
10.0
4.0
1.00
Action / Dexterity;Animals;Children's Game;Memory;Nautical
Memory
Animals: Fishes;Sports: Fishing / Angling
NaN
NaN
NaN
NaN
NaN
NaN
6988
6989
Audit: The Tax Game
1979.0
NaN
NaN
2.0
6.0
90.0
90.0
NaN
NaN
Economic
Roll / Spin and Move
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6989
6990
Lodz 1914: First Blitzkrieg
1998.0
6.9
NaN
2.0
4.0
360.0
360.0
12.0
4.00
Wargame;World War I
Hex-and-Counter;Simulation
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6990
6991
Hegemony
NaN
5.5
NaN
2.0
4.0
60.0
60.0
10.0
NaN
Abstract Strategy
Dice Rolling
NaN
NaN
NaN
NaN
NaN
NaN
NaN
6991 rows × 20 columns
In [5]:
B # print table A to ensure correctly loaded
Out[5]:
id
name
year
rating
rank
num_players
min_num_players
max_num_players
gameplay_time
min_gameplay_time
...
complexity_weight
category
mechanisms
type
BGG_link
store_names
store_prices
links_to_buy
availability
international_store
0
1
Panzer Exp. #3: Drive to the Rhine - The 2nd Front
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Surplus,Noble Knight Games
$39.95,$59.95
http://www.gamesurplus.com/product_info.php?products_id=3281&utm_source=boardgameprices.com&utm_...
In Stock,In Stock
False,False
1
2
Call of Cthulhu LCG: In the Dread of Night
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Great Boardgames,Amazon.com
CAD 17.95,CAD 113.99
http://www.greatboardgames.ca/call-of-cthulhu-lcg-in-the-dread-of-night.html?utm_source=boardgam...
In Stock,In Stock
True,True
2
3
Dungeons and Dragons: The Legend of Drizzt
2011.0
NaN
NaN
1-5
1.0
5.0
60 minutes
60.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/91872
Miniature Market,Cardhaus,Cool Stuff Inc.,Roll for Crit,Amazon.com,Noble Knight Games,Boardlandi...
$42.89,$42.99,$43.99,$43.99,$38.49,$40.00,$47.99,$51.95,$51.99,Prices from $ 30.00,CAD 66.95,CAD...
http://www.miniaturemarket.com/woc35594.html?utm_source=boardgameprices.com&utm_medium=feed&utm_...
In Stock,In Stock,In Stock,Unavailable,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In ...
False,False,False,False,False,False,False,False,False,False,True,True,True,True,True,True,True,True
3
4
Istanbul: Mocha & Baksheesh
2015.0
NaN
NaN
2-5
2.0
5.0
60 minutes
60.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/172505
Roll for Crit,Cardhaus,Cool Stuff Inc.,Miniature Market,Amazon.com,Time Well Spent Games,Funagai...
$18.99,$19.49,$19.99,$20.09,$13.21,$22.50,$23.99,$24.95,$25.95,$27.47,Prices from $ 18.00,CAD 26...
http://www.rollforcrit.com/product/istanbul-mocha-baksheesh/?utm_source=boardgameprices.com&utm_...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Sto...
False,False,False,False,False,False,False,False,False,False,False,True,True,True,True,True,True,...
4
5
Perfect Alibi
2015.0
NaN
NaN
3-5
3.0
5.0
45 minutes
45.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/184085
Miniature Market,Amazon.com
$30.59,$19.99
http://www.miniaturemarket.com/ltp0555.html?utm_source=boardgameprices.com&utm_medium=feed&utm_c...
In Stock,In Stock
False,False
5
6
Star Realms: Crisis – Fleets & Fortresses
2014.0
NaN
NaN
2-6
2.0
6.0
NaN
NaN
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/166704
Roll for Crit,Miniature Market,Amazon.com,,BoardGameBliss,Great Boardgames,GeekStop Games,Amazon...
$3.99,$3.39,$15.86,Prices from $ 8.00,CAD 4.95,CAD 4.95,CAD 5.99,CAD 6.00,£3.99,£19.99,"EUR 21,89"
http://www.rollforcrit.com/product/star-realms-crisis-fleets-fortresses/?utm_source=boardgamepri...
In Stock,Unavailable,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In ...
False,False,False,False,True,True,True,True,True,True,True
6
7
Nexus Ops
2005.0
NaN
NaN
2-4
2.0
4.0
90 minutes
90.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/15363
Cool Stuff Inc.,BoardGameCo,Noble Knight Games,Amazon.com,Noble Knight Games,Noble Knight Games,...
$44.99,$28.49,$30.00,$39.95,$49.95,$85.00,$31.00,Prices from $ 27.00,CAD 39.99,CAD 55.99,CAD 59....
http://www.coolstuffinc.com/p/137100?utm_source=boardgameprices.com&utm_medium=price-search&utm_...
Unavailable,In Stock,In Stock,In Stock,In Stock,In Stock,Unavailable,In Stock,In Stock,On the Wa...
False,False,False,False,False,False,False,False,True,True,True,True,True,True,True,True,True
7
8
The King is Dead
2015.0
NaN
NaN
2-4
2.0
4.0
50 minutes
50.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/172996
Cardhaus,Cool Stuff Inc.,Amazon.com,Funagain Games,Game Nerdz,Noble Knight Games,,Amazon.com,Gre...
$16.99,$16.99,$13.44,$19.99,$21.88,$21.95,Prices from $ 21.00,CAD 15.24,CAD 22.95,CAD 22.95,£9....
http://www.cardhaus.com/catalog/board_games/the_king_is_dead/339513?utm_source=boardgameprices.c...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Sto...
False,False,False,False,False,False,False,True,True,True,True,True,True
8
9
Pokemon TCG: XY Fates Collide Booster Display (36)
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz
$94.95,$99.97
http://www.amazon.com/Pok%C3%A9mon-TCG-Collide-Booster-Display/dp/B01AAUSKXS%3FSubscriptionId%3D...
In Stock,Unavailable
False,False
9
10
Tide of Iron: Designer Series - Volume One
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Miniature Market,Amazon.com,
$12.00,$14.24,Prices from $ 25.00
http://www.miniaturemarket.com/1agtd04.html?utm_source=boardgameprices.com&utm_medium=feed&utm_c...
In Stock,In Stock,In Stock
False,False,False
10
11
Star Wars: The Card Game - So Be It
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Cardhaus,Amazon.com,Funagain Games
$11.21,$9.95,$14.95
http://www.cardhaus.com/catalog/board_games/star_wars_the_card_game__so_be_it/353453?utm_source=...
In Stock,In Stock,In Stock
False,False,False
11
12
Dead Men Tell No Tales
2015.0
NaN
NaN
2-5
2.0
5.0
75 minutes
75.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/141423
Roll for Crit,Miniature Market,Cool Stuff Inc.,Cardhaus,Amazon.com,Noble Knight Games,,Starlit C...
$28.99,$29.29,$30.49,$30.99,$31.85,$32.00,Prices from $ 1.00,CAD 47.99,CAD 39.95,CAD 39.95,CAD ...
http://www.rollforcrit.com/product/dead-men-tell-no-tales/?utm_source=boardgameprices.com&utm_me...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,Unavailable,Unavailable,...
False,False,False,False,False,False,False,True,True,True,True,True,True,True
12
13
Crown of Roses
2012.0
NaN
NaN
2-4
2.0
4.0
300 minutes
300.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/36480
Cool Stuff Inc.,Amazon.com,Funagain Games,,Amazon.com,HitGames.ca,Shiregames,Amazon.com,Amazon.com
$52.99,$55.99,$62.99,Prices from $ 80.00,CAD 77.99,CAD 80.99,£59.99,£60.80,"EUR 19,95"
http://www.coolstuffinc.com/p/165457?utm_source=boardgameprices.com&utm_medium=price-search&utm_...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,True,True,True,True,True
13
14
Shadows of Brimstone: Trun Hunters Enemy Pack
2015.0
NaN
NaN
1-6
1.0
6.0
NaN
NaN
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/181098
Roll for Crit,Cool Stuff Inc.,Amazon.com,,HitGames.ca,BoardGameBliss,Amazon.com,Amazon.com
$12.99,$12.99,$13.58,Prices from $ 14.00,CAD 23.99,CAD 17.95,CAD 23.96,£15.43
http://www.rollforcrit.com/product/shadows-of-brimstone-trun-hunters-enemy-pack/?utm_source=boar...
In Stock,In Stock,In Stock,In Stock,In Stock,Unavailable,In Stock,In Stock
False,False,False,False,True,True,True,True
14
15
Civilization: Wisdom and Warfare Expansion
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Miniature Market,Cool Stuff Inc.,Amazon.com,,HitGames.ca,Amazon.com,Shiregames,Amazon.com
$27.99,$29.99,$79.99,Prices from $ 199.00,CAD 48.99,CAD 58.59,£26.99,£27.86
http://www.miniaturemarket.com/ffgci03.html?utm_source=boardgameprices.com&utm_medium=feed&utm_c...
Unavailable,Unavailable,In Stock,In Stock,Unavailable,In Stock,Unavailable,In Stock
False,False,False,False,True,True,True,True
15
16
Across the Aller - Last Stand in Northwest Europe, 1945
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games
$74.95
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147594596_A_InventoryID_E_2148...
In Stock
False
16
17
Marbles: Electric Eel Set
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Funagain Games,Amazon.com
$4.00,$15.00
https://www.funagain.com/control/product?product_id=022368&affil=BGPC&utm_source=boardgameprices...
In Stock,In Stock
False,False
17
18
Ticket to Ride: Heart of Africa
2012.0
NaN
NaN
2-5
2.0
5.0
60 minutes
60.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/131188
Cool Stuff Inc.,Roll for Crit,Miniature Market,Game Surplus,Amazon.com,,GeekStop Games,BoardGame...
$18.79,$18.99,$20.00,$18.95,$24.99,Prices from $ 99.00,CAD 26.99,CAD 21.95,CAD 23.95,CAD 26.99,C...
http://www.coolstuffinc.com/p/165402?utm_source=boardgameprices.com&utm_medium=price-search&utm_...
Unavailable,Unavailable,Unavailable,Unavailable,In Stock,In Stock,On the Way,Unavailable,Unavail...
False,False,False,False,False,False,True,True,True,True,True,True,True,True,True
18
19
Copper Country
2015.0
NaN
NaN
2-4
2.0
4.0
60 minutes
60.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/147206
Cardhaus,Amazon.com,Noble Knight Games,Funagain Games,Noble Knight Games,,BoardGameBliss,Amazon....
$38.99,$36.75,$45.00,$47.99,$49.95,Prices from $ 47.00,CAD 51.95,CAD 109.00,£44.99,£44.99,"EUR ...
http://www.cardhaus.com/catalog/board_games/copper_country/307123?utm_source=boardgameprices.com...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False,False,True,True,True,True,True
19
20
Special Agent Meeple Poker Chips (20)
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Miniature Market
$4.00
http://www.miniaturemarket.com/gps-sachips.html?utm_source=boardgameprices.com&utm_medium=feed&u...
In Stock
False
20
21
Summoner Wars: The Filth Faction Deck
2012.0
NaN
NaN
2-4
2.0
4.0
30 minutes
30.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/113225
Roll for Crit,Miniature Market,Cardhaus,Cool Stuff Inc.,Cool Stuff Inc.,Amazon.com
$5.99,$6.49,$6.50,$6.69,$6.69,$9.49
http://www.rollforcrit.com/product/summoner-wars-the-filth-faction-deck/?utm_source=boardgamepri...
In Stock,In Stock,In Stock,In Stock,Unavailable,In Stock
False,False,False,False,False,False
21
22
Advanced Civilization - Assyria Counters
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,
$17.95,Prices from $ 17.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147575381_A_InventoryID_E_2148...
In Stock,In Stock
False,False
22
23
Reaper: Master Series Paint: Clear Green
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Funagain Games,Amazon.com
$3.29,$37.00
https://www.funagain.com/control/product?product_id=035902&affil=BGPC&utm_source=boardgameprices...
In Stock,In Stock
False,False
23
24
Prague: The Empty Triumph
2014.0
NaN
NaN
1-4
1.0
4.0
30 minutes
30.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/39940
Cool Stuff Inc.,Amazon.com,
$62.99,$68.99,Prices from $ 85.00
http://www.coolstuffinc.com/p/203498?utm_source=boardgameprices.com&utm_medium=price-search&utm_...
Unavailable,In Stock,In Stock
False,False,False
24
25
Reaper: Master Series Paint: Flow Improver
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Funagain Games,Amazon.com
$3.29,$12.94
https://www.funagain.com/control/product?product_id=035915&affil=BGPC&utm_source=boardgameprices...
In Stock,In Stock
False,False
25
26
Panic Bundle
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
HitGames.ca
CAD 101.99
http://www.hitgames.ca/panic-bundle.html?utm_source=boardgameprices.com&utm_medium=price-search&...
Unavailable
True
26
27
Cleopatra's Caboose
2010.0
NaN
NaN
3-5
3.0
5.0
105 minutes
105.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/24795
Amazon.com,Time Well Spent Games,Noble Knight Games,Noble Knight Games,
$9.97,$38.95,$45.00,$49.95,Prices from $ 21.00
http://www.amazon.com/Z-Man-Games-Cleopatras-Caboose/dp/B0047UH2T6%3FSubscriptionId%3DAKIAJ4BCA4...
In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False
27
28
Ali Baba
1974.0
NaN
NaN
2-4
2.0
4.0
20 minutes
20.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/10658
Amazon.com,Noble Knight Games,Noble Knight Games,
$0.07,$10.00,$20.00,Prices from $ 22.00
http://www.amazon.com/Force-Will-Earnest-Worker-MPR-056/dp/B013538VAE%3FSubscriptionId%3DAKIAJ4B...
In Stock,In Stock,In Stock,In Stock
False,False,False,False
28
29
Folding Cribbage Travel Board
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Starlit Citadel,Amazon.com,Amazon.com,Amazon.com
CAD 4.99,CAD 14.51,£7.99,"EUR 15,92"
http://www.starlitcitadel.com/games/folding-cribbage-travel-board.html?utm_source=boardgameprice...
In Stock,In Stock,In Stock,In Stock
True,True,True,True
29
30
The Curse of the Black Dice
2015.0
NaN
NaN
2-4
2.0
4.0
20 minutes
20.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/170437
Miniature Market,Amazon.com,Noble Knight Games,,Amazon.com,Starlit Citadel,BoardGameBliss,Amazon...
$34.19,$20.99,$51.95,Prices from $ 51.00,CAD 25.99,CAD 49.99,CAD 62.95,£16.72,£24.99,"EUR 18,99"
http://www.miniaturemarket.com/badcotbd.html?utm_source=boardgameprices.com&utm_medium=feed&utm_...
On the Way,In Stock,In Stock,In Stock,In Stock,Unavailable,Unavailable,In Stock,In Stock,In Stock
False,False,False,False,True,True,True,True,True,True
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
10266
10269
Dwarven Dive
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,
$6.49,Prices from $ 6.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147626704_A_InventoryID_E_2148...
In Stock,In Stock
False,False
10267
10270
Island Fortress: 5-6 Player Expansion
2013.0
NaN
NaN
5-6
5.0
6.0
120 minutes
120.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/113915
Miniature Market,Cardhaus,Amazon.com,Noble Knight Games,,BoardGameBliss,Amazon.com,Amazon.com
$6.00,$11.40,$9.98,$17.95,Prices from $ 15.00,CAD 25.00,CAD 68.70,£66.50
http://www.miniaturemarket.com/gsuh5051.html?utm_source=boardgameprices.com&utm_medium=feed&utm_...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False,True,True,True
10268
10271
Warmachine High Command: Faith & Fortune - Core Set
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Miniature Market,Amazon.com,
$27.89,$22.49,Prices from $ 30.00
http://www.miniaturemarket.com/pip61020.html?utm_source=boardgameprices.com&utm_medium=feed&utm_...
In Stock,In Stock,In Stock
False,False,False
10269
10272
Jaipur
2009.0
NaN
NaN
2
2.0
2.0
30 minutes
30.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/54043
Miniature Market,Cool Stuff Inc.,Cardhaus,Cool Stuff Inc.,Roll for Crit,Amazon.com,Boardlandia,,...
$21.29,$21.29,$21.49,$18.79,$18.99,$15.00,$19.99,Prices from $ 21.00,CAD 27.99,CAD 33.99,CAD 27....
http://www.miniaturemarket.com/asmjai01.html?utm_source=boardgameprices.com&utm_medium=feed&utm_...
In Stock,In Stock,In Stock,Unavailable,Unavailable,In Stock,In Stock,In Stock,On the Way,In Stoc...
False,False,False,False,False,False,False,False,True,True,True,True,True,True,True,True,True,True
10270
10273
Expo 1906 Board Game
2015.0
NaN
NaN
1-4
1.0
4.0
90 minutes
90.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/180193
Miniature Market,Cardhaus,Cool Stuff Inc.,Funagain Games,Noble Knight Games,Game Nerdz,,Great Bo...
$30.60,$35.99,$36.99,$35.99,$39.95,$43.80,Prices from $ 43.00,CAD 48.95,CAD 52.95,CAD 53.94,£34.74
http://www.miniaturemarket.com/gth6143.html?utm_source=boardgameprices.com&utm_medium=feed&utm_c...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False,False,False,True,True,True,True
10271
10274
Dungeon Lords
2009.0
NaN
NaN
2-4
2.0
4.0
90 minutes
90.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/45315
Miniature Market,Roll for Crit,Cardhaus,Cool Stuff Inc.,Amazon.com,BoardGameCo,Noble Knight Game...
$38.99,$41.99,$41.99,$43.99,$27.99,$40.00,$44.00,$45.00,$45.09,$49.95,$49.95,$51.99,$87.99,Price...
http://www.miniaturemarket.com/cge00007.html?utm_source=boardgameprices.com&utm_medium=feed&utm_...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Sto...
False,False,False,False,False,False,False,False,False,False,False,False,False,False,True,True,Tr...
10272
10275
Galaxy Defenders: Elite Alien Army
2014.0
NaN
NaN
1-5
1.0
5.0
120 minutes
120.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/149414
Cardhaus,Miniature Market,Roll for Crit,Cool Stuff Inc.,Game Surplus,Amazon.com,Game Nerdz,Funag...
$13.99,$19.49,$19.99,$19.99,$9.95,$14.52,$21.18,$23.99,Prices from $ 20.00,CAD 22.95,CAD 23.95,C...
http://www.cardhaus.com/catalog/board_games/galaxy_defenders_elite_alien_army/254113?utm_source=...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Sto...
False,False,False,False,False,False,False,False,False,True,True,True,True,True,True,True
10273
10276
Summoner Wars: Jungle Elves Second Summoner Faction Deck
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Roll for Crit,Cool Stuff Inc.,Miniature Market,Cool Stuff Inc.,Amazon.com
$5.99,$6.69,$6.49,$6.69,$7.81
http://www.rollforcrit.com/product/summoner-wars-jungle-elves-second-summoner-faction-deck/?utm_...
In Stock,In Stock,Unavailable,Unavailable,In Stock
False,False,False,False,False
10274
10277
Frank's Zoo Card Game
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Cool Stuff Inc.,Amazon.com
$8.19,$11.99
http://www.coolstuffinc.com/p/135707?utm_source=boardgameprices.com&utm_medium=price-search&utm_...
In Stock,In Stock
False,False
10275
10278
Clash of Cultures: Civilizations
2014.0
NaN
NaN
2-4
2.0
4.0
240 minutes
240.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/146244
Miniature Market,Cool Stuff Inc.,Game Surplus,Amazon.com
$32.49,$33.49,$29.50,$450.00
http://www.miniaturemarket.com/zmg71001.html?utm_source=boardgameprices.com&utm_medium=feed&utm_...
Unavailable,Unavailable,Unavailable,In Stock
False,False,False,False
10276
10279
Star Wars LCG: Jump to Lightspeed Force Pack
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Cool Stuff Inc.,Miniature Market,Amazon.com,Game Nerdz
$11.29,$11.29,$6.28,$11.67
http://www.coolstuffinc.com/p/210720?utm_source=boardgameprices.com&utm_medium=price-search&utm_...
In Stock,In Stock,In Stock,In Stock
False,False,False,False
10277
10280
Claustrophobia: Furor Sanguinis
2014.0
NaN
NaN
2-3
2.0
3.0
45 minutes
45.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/162409
Cardhaus,Miniature Market,Cool Stuff Inc.,Noble Knight Games,Amazon.com,Funagain Games,,GeekStop...
$22.99,$27.99,$29.79,$20.00,$23.08,$34.99,Prices from $ 26.00,CAD 34.99,CAD 38.95,CAD 38.95,CAD ...
http://www.cardhaus.com/catalog/board_games/claustrophobia_furor_sanguinis/301603?utm_source=boa...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,Unavai...
False,False,False,False,False,False,False,True,True,True,True,True,True,True,True
10278
10281
Wings of Glory WWII: Rules and Accessories Plus Late Airplane Packs Combo
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Cool Stuff Inc.
$46.99
http://www.coolstuffinc.com/p/207562?utm_source=boardgameprices.com&utm_medium=price-search&utm_...
Unavailable
False
10279
10282
15" Walnut/Maple Chessboard w/1.75" Squares
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games
$35.95
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147533169_A_InventoryID_E_2148...
In Stock
False
10280
10283
KV47 Recovery & Demolition Walker - Maksim/Marlen/Melor/Mikhail
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Noble Knight Games
$20.47,$37.95
http://www.amazon.com/Dust-Tactics-Recovery-Demolition-Walker/dp/1616616180%3FSubscriptionId%3DA...
In Stock,In Stock
False,False
10281
10284
Myth: Orcneas Master of Masters Boss
2014.0
NaN
NaN
2-5
2.0
5.0
120 minutes
120.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/154250
Cardhaus,Miniature Market,Amazon.com,Noble Knight Games,,BoardGameBliss,Great Boardgames,Amazon....
$16.99,$16.00,$8.49,$21.95,Prices from $ 25.00,CAD 7.95,CAD 21.95,CAD 51.37,£85.32,"EUR 46,23"
http://www.cardhaus.com/catalog/board_games/myth_orcneas_master_of_masters_boss/301453?utm_sourc...
In Stock,Unavailable,In Stock,In Stock,In Stock,Unavailable,Unavailable,In Stock,In Stock,In Stock
False,False,False,False,False,True,True,True,True,True
10282
10285
Mars Attacks: The Miniatures Game
2014.0
NaN
NaN
2
2.0
2.0
120 minutes
120.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/147716
Amazon.com,Game Nerdz,,BoardGameBliss,Amazon.com,Amazon.com,Amazon.com
$47.75,$60.47,Prices from $ 60.00,CAD 63.95,CAD 178.70,£31.22,"EUR 36,57"
http://www.amazon.com/Mars-Attacks-The-Miniatures-Game/dp/B00O2785VI%3FSubscriptionId%3DAKIAJ4BC...
In Stock,In Stock,In Stock,Unavailable,In Stock,In Stock,In Stock
False,False,False,True,True,True,True
10283
10286
Fatal Alliances: The Great War
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Cool Stuff Inc.,Noble Knight Games,Noble Knight Games,Amazon.com,,HitGames.ca
$101.49,$95.00,$113.95,$124.99,Prices from $ 124.00,CAD 144.99
http://www.coolstuffinc.com/p/225335?utm_source=boardgameprices.com&utm_medium=price-search&utm_...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False,True
10284
10287
Forge War: Second Printing
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Time Well Spent Games
$44.99,$52.95
http://www.amazon.com/Cephalofair-Games-CPH0102-Forge-Game/dp/B017XTDL6K%3FSubscriptionId%3DAKIA...
In Stock,In Stock
False,False
10285
10288
Warmachine - Faith & Fortune
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,Amazon.com,
$40.95,$69.28,Prices from $ 11.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147558615_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
10286
10289
Expedite
2012.0
NaN
NaN
2-4
2.0
4.0
30 minutes
30.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/122831
Amazon.com,Noble Knight Games,Game Surplus,
$0.01,$50.00,$32.95,Prices from $ 25.00
http://www.amazon.com/Magic-Gathering-Expedite-Oath-Gatewatch/dp/B01AASV54G%3FSubscriptionId%3DA...
In Stock,In Stock,Unavailable,In Stock
False,False,False,False
10287
10290
Castle: The Detective Card Game
2013.0
NaN
NaN
2-5
2.0
5.0
25 minutes
25.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/131389
HitGames.ca,Amazon.com,Amazon.com
CAD 29.99,CAD 43.99,£9.99
http://www.hitgames.ca/castle-the-detective-card-game.html?utm_source=boardgameprices.com&utm_me...
Unavailable,In Stock,In Stock
True,True,True
10288
10291
Rum & Bones: Bone Devils Heroes Set #1
2015.0
NaN
NaN
2-6
2.0
6.0
NaN
NaN
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/184174
Roll for Crit,Cardhaus,Cool Stuff Inc.,Miniature Market,Game Nerdz,Funagain Games,Amazon.com,,Gr...
$14.99,$15.99,$15.99,$15.99,$15.99,$15.99,$57.64,Prices from $ 14.00,CAD 17.95,CAD 18.95,CAD 18....
http://www.rollforcrit.com/product/rum-bones-bone-devils-heroes-set-1/?utm_source=boardgameprice...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Sto...
False,False,False,False,False,False,False,False,True,True,True,True,True,True
10289
10292
Eagle Kingdoms
1994.0
NaN
NaN
2-6
2.0
6.0
45 minutes
45.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/1148
Amazon.com,Noble Knight Games,
$7.96,$8.00,Prices from $ 11.00
http://www.amazon.com/Douglas-Cuddle-Toys-3747-Colbert/dp/B000Q6QJG2%3FSubscriptionId%3DAKIAJ4BC...
In Stock,In Stock,In Stock
False,False,False
10290
10293
Justine & Co. - Maintenance Contractors #2
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,Noble Knight Games
$33.95,$83.95
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147554464_A_InventoryID_E_2148...
In Stock,In Stock
False,False
10291
10294
Shadowrun Crossfire DBG: Core Boxed Game
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz
$45.83
http://www.gamenerdz.com/shadowrun-crossfire-dbg-core-boxed-game?utm_source=boardgameprices.com&...
Unavailable
False
10292
10295
East is Red, The
NaN
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Noble Knight Games,Noble Knight Games,Noble Knight Games,
$9.99,$18.00,$22.00,$99.95,Prices from $ 15.00
http://www.amazon.com/Paw-Patrol-Ryders-Pup-Pad/dp/B00NJVHB8Q%3FSubscriptionId%3DAKIAJ4BCA4P5VKV...
In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False
10293
10296
Gunship: First Strike!
2013.0
NaN
NaN
2-4
2.0
4.0
30 minutes
30.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/109215
Miniature Market,Cardhaus,Noble Knight Games,Amazon.com,BoardGameCo,Noble Knight Games,,HitGames...
$10.00,$23.20,$15.00,$15.78,$18.21,$29.95,Prices from $ 26.00,CAD 47.99,CAD 126.54,£20.99,"EUR ...
http://www.miniaturemarket.com/epg84350.html?utm_source=boardgameprices.com&utm_medium=feed&utm_...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,Unavailable,In Stock,In Stock,In ...
False,False,False,False,False,False,False,True,True,True,True
10294
10297
Extra Extra
2015.0
NaN
NaN
2-6
2.0
6.0
150 minutes
150.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/128011
Cardhaus,Miniature Market,Roll for Crit,Cool Stuff Inc.,Noble Knight Games,Amazon.com,Boardlandi...
$58.50,$58.50,$58.99,$58.50,$10.95,$32.69,$58.50,$58.50,$58.99,Prices from $ 1.00,CAD 29.97,CAD...
http://www.cardhaus.com/catalog/board_games/extra_extra/330803?utm_source=boardgameprices.com&ut...
In Stock,In Stock,In Stock,Unavailable,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In ...
False,False,False,False,False,False,False,False,False,False,True,True,True,True,True,True
10295
10298
Battles from the Age of Reason #2 - Zorndorf - Frederick vs. the Warriors of Holy Russia
1996.0
NaN
NaN
1-2
1.0
2.0
360 minutes
360.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/11093
Noble Knight Games
$125.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_1761287263_A_InventoryID_E_2148...
In Stock
False
10296 rows × 22 columns
In [6]:
# Attribute equivalence blocking: block A, B using year
ab = em.AttrEquivalenceBlocker()
C0 = ab.block_tables(A, B, 'year', 'year',
l_output_attrs=['name', 'year'],
r_output_attrs=['name', 'year'])
C0
Out[6]:
_id
ltable_id
rtable_id
ltable_name
ltable_year
rtable_name
rtable_year
0
0
1
541
Sweet Valley High
1988.0
Vanity Chase
1988.0
1
1
1
643
Sweet Valley High
1988.0
Free Parking
1988.0
2
2
1
1379
Sweet Valley High
1988.0
Forum Romanum
1988.0
3
3
1
1404
Sweet Valley High
1988.0
Thunder at the Crossroads (2nd Edition)
1988.0
4
4
1
1462
Sweet Valley High
1988.0
Buck Rogers - Battle for the 25th Century
1988.0
5
5
1
1682
Sweet Valley High
1988.0
Babble: Board Game
1988.0
6
6
1
2114
Sweet Valley High
1988.0
Ace of Aces - Wingleader
1988.0
7
7
1
2679
Sweet Valley High
1988.0
Scattergories
1988.0
8
8
1
2748
Sweet Valley High
1988.0
Enemy in Sight
1988.0
9
9
1
2899
Sweet Valley High
1988.0
Great Composers, The
1988.0
10
10
1
2959
Sweet Valley High
1988.0
Tokyo Express
1988.0
11
11
1
3289
Sweet Valley High
1988.0
Body Talk
1988.0
12
12
1
3685
Sweet Valley High
1988.0
Grand Army of the Republic
1988.0
13
13
1
4064
Sweet Valley High
1988.0
Antiques Roadshow - The Game
1988.0
14
14
1
4424
Sweet Valley High
1988.0
Ship Forms
1988.0
15
15
1
5464
Sweet Valley High
1988.0
Win, Lose or Draw
1988.0
16
16
1
5721
Sweet Valley High
1988.0
Bogyman, The
1988.0
17
17
1
7504
Sweet Valley High
1988.0
Double Crossing
1988.0
18
18
1
8070
Sweet Valley High
1988.0
Profits of the Airwaves
1988.0
19
19
1
8722
Sweet Valley High
1988.0
Great Alaskan Clean-Up
1988.0
20
20
1
8790
Sweet Valley High
1988.0
Choices
1988.0
21
21
1
9203
Sweet Valley High
1988.0
Supremacy: Neutron Bombs and Killer Satellites
1988.0
22
22
1
9458
Sweet Valley High
1988.0
DungeonQuest - Catacombs
1988.0
23
23
116
541
Sports Franchise
1988.0
Vanity Chase
1988.0
24
24
116
643
Sports Franchise
1988.0
Free Parking
1988.0
25
25
116
1379
Sports Franchise
1988.0
Forum Romanum
1988.0
26
26
116
1404
Sports Franchise
1988.0
Thunder at the Crossroads (2nd Edition)
1988.0
27
27
116
1462
Sports Franchise
1988.0
Buck Rogers - Battle for the 25th Century
1988.0
28
28
116
1682
Sports Franchise
1988.0
Babble: Board Game
1988.0
29
29
116
2114
Sports Franchise
1988.0
Ace of Aces - Wingleader
1988.0
...
...
...
...
...
...
...
...
251445
251445
6666
8855
Knossos
2009.0
Eureka Stockade (Thick Counter Edition)
2009.0
251446
251446
6666
8932
Knossos
2009.0
Kang-a-Roo (Catch-a-Roo)
2009.0
251447
251447
6666
8949
Knossos
2009.0
Kingsburg: To Forge A Realm
2009.0
251448
251448
6666
8951
Knossos
2009.0
The Looney Bin: The North Wing
2009.0
251449
251449
6666
9005
Knossos
2009.0
RAF: The Battle of Britain 1940
2009.0
251450
251450
6666
9023
Knossos
2009.0
Are You the Traitor?
2009.0
251451
251451
6666
9096
Knossos
2009.0
Baltic Gap Board Game
2009.0
251452
251452
6666
9176
Knossos
2009.0
Last Gamble - The Battle of the Bulge
2009.0
251453
251453
6666
9211
Knossos
2009.0
Mystery Rummy: Escape from Alcatraz
2009.0
251454
251454
6666
9353
Knossos
2009.0
Campaign Manager 2008
2009.0
251455
251455
6666
9412
Knossos
2009.0
Reponds-moi en Images (French)
2009.0
251456
251456
6666
9461
Knossos
2009.0
Triumvirate
2009.0
251457
251457
6666
9470
Knossos
2009.0
7 Ate 9
2009.0
251458
251458
6666
9560
Knossos
2009.0
A Game of Thrones LCG: The Battle Of Blackwater Bay Chapter Pack
2009.0
251459
251459
6666
9598
Knossos
2009.0
Summoner Wars: Guild Dwarves vs. Cave Goblins
2009.0
251460
251460
6666
9634
Knossos
2009.0
The Pillars of the Earth: Builders Duel
2009.0
251461
251461
6666
9745
Knossos
2009.0
Islas Canarias
2009.0
251462
251462
6666
9775
Knossos
2009.0
A Victory Denied Board Game
2009.0
251463
251463
6666
9790
Knossos
2009.0
Cock & Bull
2009.0
251464
251464
6666
9829
Knossos
2009.0
Flea Circus
2009.0
251465
251465
6666
9868
Knossos
2009.0
Filipino Fruit Market
2009.0
251466
251466
6666
9885
Knossos
2009.0
The Resistance
2009.0
251467
251467
6666
9932
Knossos
2009.0
World at War Compendium (1st Printing)
2009.0
251468
251468
6666
9995
Knossos
2009.0
African Park
2009.0
251469
251469
6666
10028
Knossos
2009.0
Know It or Blow It
2009.0
251470
251470
6666
10218
Knossos
2009.0
PitchCar Extension 5: The Cross
2009.0
251471
251471
6666
10221
Knossos
2009.0
I've Never... Bar Cards Game
2009.0
251472
251472
6666
10266
Knossos
2009.0
First Orchard
2009.0
251473
251473
6666
10272
Knossos
2009.0
Jaipur
2009.0
251474
251474
6666
10274
Knossos
2009.0
Dungeon Lords
2009.0
251475 rows × 7 columns
In [7]:
B.loc[B['year'] == 1988]
Out[7]:
id
name
year
rating
rank
num_players
min_num_players
max_num_players
gameplay_time
min_gameplay_time
...
complexity_weight
category
mechanisms
type
BGG_link
store_names
store_prices
links_to_buy
availability
international_store
540
541
Vanity Chase
1988.0
NaN
NaN
2-4
2.0
4.0
45 minutes
45.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/8431
Noble Knight Games,Amazon.com,
$15.00,$52.96,Prices from $ 12.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147578406_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
642
643
Free Parking
1988.0
NaN
NaN
2-4
2.0
4.0
30 minutes
30.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/2115
Noble Knight Games,Amazon.com,
$6.00,$44.85,Prices from $ 3.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147441039_A_InventoryID_E_2147...
In Stock,In Stock,In Stock
False,False,False
1378
1379
Forum Romanum
1988.0
NaN
NaN
2-6
2.0
6.0
45 minutes
45.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/302
Amazon.com,Noble Knight Games,
$22.38,$75.00,Prices from $ 36.00
http://www.amazon.com/Clementoni-Forum-Romanum-Jigsaw-Puzzle/dp/B00B59M47W%3FSubscriptionId%3DAK...
In Stock,In Stock,In Stock
False,False,False
1403
1404
Thunder at the Crossroads (2nd Edition)
1988.0
NaN
NaN
2-4
2.0
4.0
360 minutes
360.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/95318
Noble Knight Games,Noble Knight Games,
$145.00,$195.00,Prices from $ 195.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_-432091363_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
1461
1462
Buck Rogers - Battle for the 25th Century
1988.0
NaN
NaN
2-6
2.0
6.0
120 minutes
120.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/548
Noble Knight Games,Noble Knight Games,Amazon.com,
$65.00,$97.95,$174.99,Prices from $ 55.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_16822_A_InventoryID_E_214840163...
In Stock,In Stock,In Stock,In Stock
False,False,False,False
1681
1682
Babble: Board Game
1988.0
NaN
NaN
2
2.0
2.0
15 minutes
15.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/27283
Noble Knight Games,Amazon.com,,HitGames.ca,Amazon.com,Amazon.com,Amazon.com
$11.95,$22.18,Prices from $ 18.00,CAD 27.99,CAD 106.01,£96.94,"EUR 93,66"
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147348951_A_InventoryID_E_2147...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,True,True,True,True
2113
2114
Ace of Aces - Wingleader
1988.0
NaN
NaN
2
2.0
2.0
20 minutes
20.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/6504
Amazon.com,Noble Knight Games,Noble Knight Games,
-,$32.00,$40.00,Prices from $ 49.00
http://www.amazon.com/Ace-Aces-Wingleader-World-Combat/dp/0917037065%3FSubscriptionId%3DAKIAJ4BC...
In Stock,In Stock,In Stock,In Stock
False,False,False,False
2678
2679
Scattergories
1988.0
NaN
NaN
2-6
2.0
6.0
30 minutes
30.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/2381
Amazon.com,Noble Knight Games,Noble Knight Games,Noble Knight Games,Funagain Games,Noble Knight ...
$10.95,$15.00,$15.00,$18.00,$18.99,$20.00,Prices from $ 3.00,CAD 8.99,CAD 19.99,CAD 23.95,CAD 4...
http://www.amazon.com/Hasbro-A5226-Scattergories-Game/dp/B00D8VHJKC%3FSubscriptionId%3DAKIAJ4BCA...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,Unavai...
False,False,False,False,False,False,False,True,True,True,True,True,True
2747
2748
Enemy in Sight
1988.0
NaN
NaN
2-8
2.0
8.0
120 minutes
120.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/264
Amazon.com,Noble Knight Games,Noble Knight Games,Noble Knight Games,
-,$25.00,$37.95,$55.00,Prices from $ 4.00
http://www.amazon.com/Avalon-Hill-ENEMY-Century-Sailing/dp/B004SY5BGM%3FSubscriptionId%3DAKIAJ4B...
In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False
2898
2899
Great Composers, The
1988.0
NaN
NaN
2-4
2.0
4.0
NaN
NaN
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/19482
Noble Knight Games,Amazon.com,
$8.00,$14.99,Prices from $ 21.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147481698_A_InventoryID_E_2147...
In Stock,In Stock,In Stock
False,False,False
2958
2959
Tokyo Express
1988.0
NaN
NaN
1-2
1.0
2.0
180 minutes
180.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/1681
Amazon.com,Noble Knight Games,
$49.99,$70.00,Prices from $ 3.00
http://www.amazon.com/FIFA-17-PlayStation-4/dp/B01GKH5Q9G%3Fpsc%3D1%26SubscriptionId%3DAKIAJ4BCA...
In Stock,In Stock,In Stock
False,False,False
3288
3289
Body Talk
1988.0
NaN
NaN
4-8
4.0
8.0
45 minutes
45.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/29615
Noble Knight Games,Amazon.com,
$15.00,$34.50,Prices from $ 15.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147566927_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
3684
3685
Grand Army of the Republic
1988.0
NaN
NaN
2-4
2.0
4.0
240 minutes
240.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/8753
Noble Knight Games,Noble Knight Games,Amazon.com,
$10.00,$14.95,$32.97,Prices from $ 43.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_7585_A_InventoryID_E_2147567022...
In Stock,In Stock,In Stock,In Stock
False,False,False,False
4063
4064
Antiques Roadshow - The Game
1988.0
NaN
NaN
2-6
2.0
6.0
NaN
NaN
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/122789
Amazon.com,Noble Knight Games,
$1.00,$10.00,Prices from $ 2.00
http://www.amazon.com/Board-Games-Hasbro-Antiques-Roadshow/dp/B0010KNR4A%3FSubscriptionId%3DAKIA...
In Stock,In Stock,In Stock
False,False,False
4423
4424
Ship Forms
1988.0
NaN
NaN
NaN
NaN
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/56280
Amazon.com,Noble Knight Games,Noble Knight Games,
$9.99,$11.00,$12.00,Prices from $ 12.00
http://www.amazon.com/Stitch-STITCH-cartoon-plush-Ships/dp/B015Z4LGJE%3FSubscriptionId%3DAKIAJ4B...
In Stock,In Stock,In Stock,In Stock
False,False,False,False
5463
5464
Win, Lose or Draw
1988.0
NaN
NaN
3-8
3.0
8.0
45 minutes
45.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/6800
Noble Knight Games,Noble Knight Games,Amazon.com,
$5.00,$9.50,$24.95,Prices from $ 4.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147467594_A_InventoryID_E_2147...
In Stock,In Stock,In Stock,In Stock
False,False,False,False
5720
5721
Bogyman, The
1988.0
NaN
NaN
2-5
2.0
5.0
30 minutes
30.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/18576
Noble Knight Games
$35.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147443732_A_InventoryID_E_2147...
In Stock
False
7502
7504
Double Crossing
1988.0
NaN
NaN
2-6
2.0
6.0
60 minutes
60.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/1654
Noble Knight Games,Noble Knight Games,Amazon.com,
$15.00,$20.00,$39.68,Prices from $ 9.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147435483_A_InventoryID_E_2147...
In Stock,In Stock,In Stock,In Stock
False,False,False,False
8068
8070
Profits of the Airwaves
1988.0
NaN
NaN
4
4.0
4.0
10 minutes
10.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/16248
Noble Knight Games,Noble Knight Games,
$5.00,$7.00,Prices from $ 7.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_6468_A_InventoryID_E_2148271083...
In Stock,In Stock,In Stock
False,False,False
8720
8722
Great Alaskan Clean-Up
1988.0
NaN
NaN
2
2.0
2.0
NaN
NaN
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/11864
Amazon.com,Noble Knight Games,
$10.00,$40.00,Prices from $ 40.00
http://www.amazon.com/LeapFrog-Learning-Game-Platinum-LeapsterGS/dp/B00BP48U6Q%3Fpsc%3D1%26Subsc...
In Stock,In Stock,In Stock
False,False,False
8788
8790
Choices
1988.0
NaN
NaN
3-10
3.0
10.0
NaN
NaN
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/23982
Amazon.com,Funagain Games,
$1.89,$9.95,Prices from $ 2.00
http://www.amazon.com/Yu-Gi-Oh-Painful-DLG1-EN060-Legends-Unlimited/dp/B0028WL5G6%3FSubscription...
In Stock,In Stock,In Stock
False,False,False
9201
9203
Supremacy: Neutron Bombs and Killer Satellites
1988.0
NaN
NaN
2-8
2.0
8.0
120 minutes
120.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/2913
BoardGameCo
$49.99
http://boardgameco.com/product/supremacy-neutron-bombs-and-killer-satellites/?utm_source=boardga...
In Stock
False
9456
9458
DungeonQuest - Catacombs
1988.0
NaN
NaN
1-4
1.0
4.0
90 minutes
90.0
...
NaN
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/1746
Amazon.com,Noble Knight Games,Noble Knight Games,
$17.33,$95.00,$125.00,Prices from $ 195.00
http://www.amazon.com/Sands-Time-Catacombs-Cavern-Soloth/dp/B005IR2F6C%3FSubscriptionId%3DAKIAJ4...
In Stock,In Stock,In Stock,In Stock
False,False,False,False
23 rows × 22 columns
In [8]:
# Overlap blocking over candidata set (C0)
ob = em.OverlapBlocker()
# block using name
C1 = ob.block_candset(C0, 'name', 'name', word_level=True, overlap_size=1)
0% 100%
[##############################] | ETA: 00:00:00
Total time elapsed: 00:00:06
In [9]:
C1 # Our final table of canidates to eventually do matching on.
# This is a combination of blocking first on year and then using name
Out[9]:
_id
ltable_id
rtable_id
ltable_name
ltable_year
rtable_name
rtable_year
97
97
207
1682
Sniper! Special Forces: Sniper! Companion Game #2
1988.0
Babble: Board Game
1988.0
105
105
207
4064
Sniper! Special Forces: Sniper! Companion Game #2
1988.0
Antiques Roadshow - The Game
1988.0
130
130
244
5464
Win Lose or Draw
1988.0
Win, Lose or Draw
1988.0
167
167
270
2114
The Campaigns of Robert E. Lee
1988.0
Ace of Aces - Wingleader
1988.0
173
173
270
3685
The Campaigns of Robert E. Lee
1988.0
Grand Army of the Republic
1988.0
179
179
270
8070
The Campaigns of Robert E. Lee
1988.0
Profits of the Airwaves
1988.0
212
212
340
1682
24 Game
1988.0
Babble: Board Game
1988.0
220
220
340
4064
24 Game
1988.0
Antiques Roadshow - The Game
1988.0
257
257
591
1462
AirLand Battle: Corps Operational Command in Europe
1988.0
Buck Rogers - Battle for the 25th Century
1988.0
305
305
716
2114
The Legend of Zelda
1988.0
Ace of Aces - Wingleader
1988.0
311
311
716
3685
The Legend of Zelda
1988.0
Grand Army of the Republic
1988.0
317
317
716
8070
The Legend of Zelda
1988.0
Profits of the Airwaves
1988.0
442
442
998
1682
ID: The Identity Game
1988.0
Babble: Board Game
1988.0
450
450
998
4064
ID: The Identity Game
1988.0
Antiques Roadshow - The Game
1988.0
466
466
1000
2114
Pop of the Form
1988.0
Ace of Aces - Wingleader
1988.0
472
472
1000
3685
Pop of the Form
1988.0
Grand Army of the Republic
1988.0
478
478
1000
8070
Pop of the Form
1988.0
Profits of the Airwaves
1988.0
604
604
1236
2114
The Chronicles of Narnia
1988.0
Ace of Aces - Wingleader
1988.0
610
610
1236
3685
The Chronicles of Narnia
1988.0
Grand Army of the Republic
1988.0
616
616
1236
8070
The Chronicles of Narnia
1988.0
Profits of the Airwaves
1988.0
624
624
1239
1404
Trivial Pursuit: Entertainment Edition
1988.0
Thunder at the Crossroads (2nd Edition)
1988.0
742
742
1854
2114
Pegasus Bridge: The Beginning of D-Day - June 6 1944
1988.0
Ace of Aces - Wingleader
1988.0
748
748
1854
3685
Pegasus Bridge: The Beginning of D-Day - June 6 1944
1988.0
Grand Army of the Republic
1988.0
754
754
1854
8070
Pegasus Bridge: The Beginning of D-Day - June 6 1944
1988.0
Profits of the Airwaves
1988.0
805
805
1960
541
Vanity Chase
1988.0
Vanity Chase
1988.0
902
902
2081
1682
My Little Pony Game
1988.0
Babble: Board Game
1988.0
910
910
2081
4064
My Little Pony Game
1988.0
Antiques Roadshow - The Game
1988.0
949
949
2137
2114
West of Alamein: ASL Module 5
1988.0
Ace of Aces - Wingleader
1988.0
955
955
2137
3685
West of Alamein: ASL Module 5
1988.0
Grand Army of the Republic
1988.0
961
961
2137
8070
West of Alamein: ASL Module 5
1988.0
Profits of the Airwaves
1988.0
...
...
...
...
...
...
...
...
250704
250704
3461
209
Wings of War: Watch Your Back!
2005.0
Battle of the Little Bighorn
2005.0
250706
250706
3461
513
Wings of War: Watch Your Back!
2005.0
Triumph of Chaos
2005.0
250710
250710
3461
857
Wings of War: Watch Your Back!
2005.0
Barbary Coast War (2nd Edition)
2005.0
250711
250711
3461
897
Wings of War: Watch Your Back!
2005.0
Stratego - The Chronicles of Narnia
2005.0
250722
250722
3461
1501
Wings of War: Watch Your Back!
2005.0
Euphrates & Tigris - Contest of Kings
2005.0
250728
250728
3461
1858
Wings of War: Watch Your Back!
2005.0
Lawrence of Arabia (1st Edition)
2005.0
250734
250734
3461
2190
Wings of War: Watch Your Back!
2005.0
Empire of the Sun
2005.0
250737
250737
3461
2370
Wings of War: Watch Your Back!
2005.0
Battleground Fantasy Warfare: Men of Hawkshold
2005.0
250744
250744
3461
2786
Wings of War: Watch Your Back!
2005.0
Wings of War: Watch Your Back!
2005.0
250747
250747
3461
3101
Wings of War: Watch Your Back!
2005.0
Conquest of the Empire
2005.0
250760
250760
3461
4441
Wings of War: Watch Your Back!
2005.0
Fire in the Sky - The Great Pacific War 1941-1945
2005.0
250762
250762
3461
4489
Wings of War: Watch Your Back!
2005.0
Battles from the Age of Reason #5 - Lobositz - First Battle of the Seven Years War
2005.0
250764
250764
3461
4881
Wings of War: Watch Your Back!
2005.0
Nature of the Beast: City Vs. Suburb
2005.0
250766
250766
3461
5020
Wings of War: Watch Your Back!
2005.0
Lord of the Rings: The Confrontation
2005.0
250771
250771
3461
5614
Wings of War: Watch Your Back!
2005.0
Wings of War: Burning Drachens
2005.0
250773
250773
3461
5773
Wings of War: Watch Your Back!
2005.0
Nature of the Beast: Farm Vs. Forest
2005.0
250778
250778
3461
6273
Wings of War: Watch Your Back!
2005.0
Island of Dread, The
2005.0
250780
250780
3461
6324
Wings of War: Watch Your Back!
2005.0
Queen of the Cupcakes
2005.0
250787
250787
3461
7174
Wings of War: Watch Your Back!
2005.0
Lock 'N Load - Band of Heroes (1st Edition)
2005.0
250789
250789
3461
7258
Wings of War: Watch Your Back!
2005.0
The End of the Triumvirate
2005.0
250794
250794
3461
7562
Wings of War: Watch Your Back!
2005.0
Conquest of the Fallen Lands
2005.0
250809
250809
3461
8913
Wings of War: Watch Your Back!
2005.0
The Settlers of Catan: The Fishermen of Catan
2005.0
250823
250823
3461
10027
Wings of War: Watch Your Back!
2005.0
Second World War at Sea: Bismarck
2005.0
250827
250827
3461
10258
Wings of War: Watch Your Back!
2005.0
Bang! Fistful of Cards
2005.0
250958
250958
3499
536
Winner Spinner
1953.0
Winner Spinner
1953.0
250971
250971
4497
8307
Go to the Head of the Class
1936.0
Go to the Head of the Class (1967 Edition)
1936.0
250980
250980
5238
10117
Easy Money
1935.0
Easy Money
1935.0
250981
250981
6213
1235
Game of Politics
1935.0
All American Football Game (1st Printing)
1935.0
250986
250986
3587
6839
All-Star Baseball
1941.0
All-Star Baseball (1st Printing)
1941.0
250989
250989
4587
7602
Across the Continent
1890.0
Across the Continent
1890.0
5567 rows × 7 columns
In [10]:
# now debug the blocker output
dbg = em.debug_blocker(C1, A, B, output_size=125)
In [11]:
dbg # Look at the debug table for things that match. If we find things that match, that indicates that our blocker
# is dropping things that it shouldn't.
Out[11]:
_id
similarity
ltable_id
rtable_id
ltable_name
ltable_min_age
ltable_category
ltable_mechanisms
ltable_type
ltable_BGG_link
...
rtable_min_age
rtable_category
rtable_mechanisms
rtable_type
rtable_BGG_link
rtable_store_names
rtable_store_prices
rtable_links_to_buy
rtable_availability
rtable_international_store
0
0
0.500000
48
1365
Lord of the Rings Trivia Game
12.0
Adventure;Fantasy;Novel-based;Trivia
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Noble Knight Games,
$16.99,$24.00,Prices from $ 45.00
http://www.amazon.com/Quarriors-LOTR-Lord-Rings-Building/dp/B009KBN12Y%3FSubscriptionId%3DAKIAJ4...
In Stock,In Stock,In Stock
False,False,False
1
1
0.500000
4848
5588
Oskar
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com,
$15.24,$15.99,Prices from $ 1.00
http://www.gamenerdz.com/chimera-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock,In Stock
False,False,False
2
2
0.500000
4848
6191
Oskar
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$19.80,$33.58
http://www.gamenerdz.com/clairvoyance-card-game?utm_source=boardgameprices.com&utm_medium=price-...
In Stock,In Stock
False,False
3
3
0.500000
329
614
Nix
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$23.99,$26.40,Prices from $ 4.00
http://www.amazon.com/Z-Man-Games-ZMG-71270-Babel/dp/B00HTG5210%3FSubscriptionId%3DAKIAJ4BCA4P5V...
In Stock,In Stock,In Stock
False,False,False
4
4
0.500000
329
6503
Nix
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,Amazon.com,
$10.00,$11.40,Prices from $ 8.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147593707_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
5
5
0.500000
4848
647
Oskar
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$11.85,$12.95
http://www.gamenerdz.com/cadaver-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock
False,False
6
6
0.500000
329
1180
Nix
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.69,$8.75,Prices from $ 8.00
http://www.amazon.com/Blink-The-Worlds-Fastest-Game/dp/B0037W5Y2W%3Fpsc%3D1%26SubscriptionId%3DA...
In Stock,In Stock,In Stock
False,False,False
7
7
0.500000
329
6191
Nix
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$19.80,$33.58
http://www.gamenerdz.com/clairvoyance-card-game?utm_source=boardgameprices.com&utm_medium=price-...
In Stock,In Stock
False,False
8
8
0.500000
5821
2784
Split (Revised Edition)
12.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
HitGames.ca
CAD 17.99
http://www.hitgames.ca/canasta-caliente-card-game-revised-edition.html?utm_source=boardgameprice...
In Stock
True
9
9
0.500000
4020
614
Numero
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$23.99,$26.40,Prices from $ 4.00
http://www.amazon.com/Z-Man-Games-ZMG-71270-Babel/dp/B00HTG5210%3FSubscriptionId%3DAKIAJ4BCA4P5V...
In Stock,In Stock,In Stock
False,False,False
10
10
0.500000
329
2280
Nix
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$14.50,$15.12,Prices from $ 24.00
http://www.amazon.com/Z-Man-Games-ZMG-41201-Parade/dp/B00E0JSMGG%3FSubscriptionId%3DAKIAJ4BCA4P5...
In Stock,In Stock,In Stock
False,False,False
11
11
0.500000
4020
647
Numero
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$11.85,$12.95
http://www.gamenerdz.com/cadaver-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock
False,False
12
12
0.500000
4020
6191
Numero
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$19.80,$33.58
http://www.gamenerdz.com/clairvoyance-card-game?utm_source=boardgameprices.com&utm_medium=price-...
In Stock,In Stock
False,False
13
13
0.500000
329
647
Nix
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$11.85,$12.95
http://www.gamenerdz.com/cadaver-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock
False,False
14
14
0.500000
4020
6745
Numero
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.00,$8.51,Prices from $ 11.00
http://www.amazon.com/AEG-5819AEG-Cypher-Game/dp/B00LD170MQ%3FSubscriptionId%3DAKIAJ4BCA4P5VKV33...
In Stock,In Stock,In Stock
False,False,False
15
15
0.500000
4020
5588
Numero
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com,
$15.24,$15.99,Prices from $ 1.00
http://www.gamenerdz.com/chimera-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock,In Stock
False,False,False
16
16
0.500000
4848
614
Oskar
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$23.99,$26.40,Prices from $ 4.00
http://www.amazon.com/Z-Man-Games-ZMG-71270-Babel/dp/B00HTG5210%3FSubscriptionId%3DAKIAJ4BCA4P5V...
In Stock,In Stock,In Stock
False,False,False
17
17
0.500000
4848
2280
Oskar
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$14.50,$15.12,Prices from $ 24.00
http://www.amazon.com/Z-Man-Games-ZMG-41201-Parade/dp/B00E0JSMGG%3FSubscriptionId%3DAKIAJ4BCA4P5...
In Stock,In Stock,In Stock
False,False,False
18
18
0.500000
4020
1180
Numero
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.69,$8.75,Prices from $ 8.00
http://www.amazon.com/Blink-The-Worlds-Fastest-Game/dp/B0037W5Y2W%3Fpsc%3D1%26SubscriptionId%3DA...
In Stock,In Stock,In Stock
False,False,False
19
19
0.500000
329
6745
Nix
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.00,$8.51,Prices from $ 11.00
http://www.amazon.com/AEG-5819AEG-Cypher-Game/dp/B00LD170MQ%3FSubscriptionId%3DAKIAJ4BCA4P5VKV33...
In Stock,In Stock,In Stock
False,False,False
20
20
0.500000
4020
2280
Numero
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$14.50,$15.12,Prices from $ 24.00
http://www.amazon.com/Z-Man-Games-ZMG-41201-Parade/dp/B00E0JSMGG%3FSubscriptionId%3DAKIAJ4BCA4P5...
In Stock,In Stock,In Stock
False,False,False
21
21
0.500000
4848
6745
Oskar
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.00,$8.51,Prices from $ 11.00
http://www.amazon.com/AEG-5819AEG-Cypher-Game/dp/B00LD170MQ%3FSubscriptionId%3DAKIAJ4BCA4P5VKV33...
In Stock,In Stock,In Stock
False,False,False
22
22
0.500000
4848
6503
Oskar
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,Amazon.com,
$10.00,$11.40,Prices from $ 8.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147593707_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
23
23
0.500000
329
5588
Nix
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com,
$15.24,$15.99,Prices from $ 1.00
http://www.gamenerdz.com/chimera-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock,In Stock
False,False,False
24
24
0.500000
4020
6503
Numero
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,Amazon.com,
$10.00,$11.40,Prices from $ 8.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147593707_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
25
25
0.500000
4848
1180
Oskar
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.69,$8.75,Prices from $ 8.00
http://www.amazon.com/Blink-The-Worlds-Fastest-Game/dp/B0037W5Y2W%3Fpsc%3D1%26SubscriptionId%3DA...
In Stock,In Stock,In Stock
False,False,False
26
26
0.470588
4270
3647
World War II: European Theater of Operations 1939-45
12.0
Wargame;World War II
Dice Rolling;Hex-and-Counter
NaN
NaN
...
12 & up
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/2447
Amazon.com,Noble Knight Games,Noble Knight Games,Noble Knight Games,
-,$8.00,$14.00,$95.00,Prices from $ 28.00
http://www.amazon.com/European-Theater-Operations-1939-45-SPI/dp/B00J1NBD9O%3FSubscriptionId%3DA...
In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False
27
27
0.466667
2328
3647
European Theater of Operations
12.0
Wargame;World War II
Area Movement;Dice Rolling;Simulation
NaN
NaN
...
12 & up
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/2447
Amazon.com,Noble Knight Games,Noble Knight Games,Noble Knight Games,
-,$8.00,$14.00,$95.00,Prices from $ 28.00
http://www.amazon.com/European-Theater-Operations-1939-45-SPI/dp/B00J1NBD9O%3FSubscriptionId%3DA...
In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False
28
28
0.454545
4821
3735
The Guns of August
12.0
Wargame;World War I
Hex-and-Counter
NaN
NaN
...
12 & up
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/85857
Amazon.com,BoardGameCo,Noble Knight Games,Noble Knight Games,Noble Knight Games,Noble Knight Gam...
-,$14.99,$35.00,$50.00,$50.00,$70.00,$75.00,$75.00,Prices from $ 9.00
http://www.amazon.com/Avalon-Hill-General-18-Number/dp/B006KY73XM%3FSubscriptionId%3DAKIAJ4BCA4P...
In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False,False,False,False,False
29
29
0.444444
4861
10123
David & Goliath
8.0
Card Game
Trick-taking
NaN
NaN
...
8 & up
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/3269
Game Surplus,Amazon.com,
$8.50,$23.39,Prices from $ 1.00
http://www.gamesurplus.com/product_info.php?products_id=60&utm_source=boardgameprices.com&utm_me...
Unavailable,In Stock,In Stock
False,False,False
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
95
95
0.400000
6895
6503
Blindside
NaN
Card Game
Trick-taking
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,Amazon.com,
$10.00,$11.40,Prices from $ 8.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147593707_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
96
96
0.400000
5984
6191
Zar
6.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$19.80,$33.58
http://www.gamenerdz.com/clairvoyance-card-game?utm_source=boardgameprices.com&utm_medium=price-...
In Stock,In Stock
False,False
97
97
0.400000
5984
614
Zar
6.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$23.99,$26.40,Prices from $ 4.00
http://www.amazon.com/Z-Man-Games-ZMG-71270-Babel/dp/B00HTG5210%3FSubscriptionId%3DAKIAJ4BCA4P5V...
In Stock,In Stock,In Stock
False,False,False
98
98
0.400000
6883
5588
Riverboat Showdown
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com,
$15.24,$15.99,Prices from $ 1.00
http://www.gamenerdz.com/chimera-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock,In Stock
False,False,False
99
99
0.400000
6895
5588
Blindside
NaN
Card Game
Trick-taking
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com,
$15.24,$15.99,Prices from $ 1.00
http://www.gamenerdz.com/chimera-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock,In Stock
False,False,False
100
100
0.400000
5932
2280
Numbters
10.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$14.50,$15.12,Prices from $ 24.00
http://www.amazon.com/Z-Man-Games-ZMG-41201-Parade/dp/B00E0JSMGG%3FSubscriptionId%3DAKIAJ4BCA4P5...
In Stock,In Stock,In Stock
False,False,False
101
101
0.400000
6754
1180
Change!
10.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.69,$8.75,Prices from $ 8.00
http://www.amazon.com/Blink-The-Worlds-Fastest-Game/dp/B0037W5Y2W%3Fpsc%3D1%26SubscriptionId%3DA...
In Stock,In Stock,In Stock
False,False,False
102
102
0.400000
6883
1180
Riverboat Showdown
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.69,$8.75,Prices from $ 8.00
http://www.amazon.com/Blink-The-Worlds-Fastest-Game/dp/B0037W5Y2W%3Fpsc%3D1%26SubscriptionId%3DA...
In Stock,In Stock,In Stock
False,False,False
103
103
0.400000
6895
614
Blindside
NaN
Card Game
Trick-taking
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$23.99,$26.40,Prices from $ 4.00
http://www.amazon.com/Z-Man-Games-ZMG-71270-Babel/dp/B00HTG5210%3FSubscriptionId%3DAKIAJ4BCA4P5V...
In Stock,In Stock,In Stock
False,False,False
104
104
0.400000
6754
614
Change!
10.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$23.99,$26.40,Prices from $ 4.00
http://www.amazon.com/Z-Man-Games-ZMG-71270-Babel/dp/B00HTG5210%3FSubscriptionId%3DAKIAJ4BCA4P5V...
In Stock,In Stock,In Stock
False,False,False
105
105
0.400000
6754
647
Change!
10.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$11.85,$12.95
http://www.gamenerdz.com/cadaver-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock
False,False
106
106
0.400000
5984
5588
Zar
6.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com,
$15.24,$15.99,Prices from $ 1.00
http://www.gamenerdz.com/chimera-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock,In Stock
False,False,False
107
107
0.400000
5932
6503
Numbters
10.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,Amazon.com,
$10.00,$11.40,Prices from $ 8.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147593707_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
108
108
0.400000
6754
6503
Change!
10.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,Amazon.com,
$10.00,$11.40,Prices from $ 8.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147593707_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
109
109
0.400000
6754
6191
Change!
10.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$19.80,$33.58
http://www.gamenerdz.com/clairvoyance-card-game?utm_source=boardgameprices.com&utm_medium=price-...
In Stock,In Stock
False,False
110
110
0.400000
5984
1180
Zar
6.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.69,$8.75,Prices from $ 8.00
http://www.amazon.com/Blink-The-Worlds-Fastest-Game/dp/B0037W5Y2W%3Fpsc%3D1%26SubscriptionId%3DA...
In Stock,In Stock,In Stock
False,False,False
111
111
0.400000
6895
6191
Blindside
NaN
Card Game
Trick-taking
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$19.80,$33.58
http://www.gamenerdz.com/clairvoyance-card-game?utm_source=boardgameprices.com&utm_medium=price-...
In Stock,In Stock
False,False
112
112
0.400000
6883
647
Riverboat Showdown
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$11.85,$12.95
http://www.gamenerdz.com/cadaver-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock
False,False
113
113
0.400000
6883
2280
Riverboat Showdown
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$14.50,$15.12,Prices from $ 24.00
http://www.amazon.com/Z-Man-Games-ZMG-41201-Parade/dp/B00E0JSMGG%3FSubscriptionId%3DAKIAJ4BCA4P5...
In Stock,In Stock,In Stock
False,False,False
114
114
0.400000
6895
647
Blindside
NaN
Card Game
Trick-taking
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$11.85,$12.95
http://www.gamenerdz.com/cadaver-card-game?utm_source=boardgameprices.com&utm_medium=price-searc...
In Stock,In Stock
False,False
115
115
0.400000
6754
2280
Change!
10.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$14.50,$15.12,Prices from $ 24.00
http://www.amazon.com/Z-Man-Games-ZMG-41201-Parade/dp/B00E0JSMGG%3FSubscriptionId%3DAKIAJ4BCA4P5...
In Stock,In Stock,In Stock
False,False,False
116
116
0.400000
6901
2145
The Totally Insane Card Game
NaN
Card Game;Party Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$12.40,$21.95
http://www.gamenerdz.com/the-worst-game-ever-card-game?utm_source=boardgameprices.com&utm_medium...
Unavailable,In Stock
False,False
117
117
0.400000
6883
6503
Riverboat Showdown
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Noble Knight Games,Amazon.com,
$10.00,$11.40,Prices from $ 8.00
http://www.nobleknight.com/ProductDetailSearch.asp_Q_ProductID_E_2147593707_A_InventoryID_E_2148...
In Stock,In Stock,In Stock
False,False,False
118
118
0.400000
6883
6191
Riverboat Showdown
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Game Nerdz,Amazon.com
$19.80,$33.58
http://www.gamenerdz.com/clairvoyance-card-game?utm_source=boardgameprices.com&utm_medium=price-...
In Stock,In Stock
False,False
119
119
0.400000
6895
6745
Blindside
NaN
Card Game
Trick-taking
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.00,$8.51,Prices from $ 11.00
http://www.amazon.com/AEG-5819AEG-Cypher-Game/dp/B00LD170MQ%3FSubscriptionId%3DAKIAJ4BCA4P5VKV33...
In Stock,In Stock,In Stock
False,False,False
120
120
0.400000
6881
9181
Cargo
10.0
Transportation
NaN
NaN
NaN
...
10 & up
NaN
NaN
NaN
http://www.boardgamegeek.com/boardgame/8567
Cardhaus,Noble Knight Games,Noble Knight Games,Amazon.com,
$7.73,$5.00,$7.95,$23.28,Prices from $ 9.00
http://www.cardhaus.com/catalog/board_games/cargo/234222?utm_source=boardgameprices.com&utm_medi...
In Stock,In Stock,In Stock,In Stock,In Stock
False,False,False,False,False
121
121
0.400000
6883
614
Riverboat Showdown
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$23.99,$26.40,Prices from $ 4.00
http://www.amazon.com/Z-Man-Games-ZMG-71270-Babel/dp/B00HTG5210%3FSubscriptionId%3DAKIAJ4BCA4P5V...
In Stock,In Stock,In Stock
False,False,False
122
122
0.400000
6895
1180
Blindside
NaN
Card Game
Trick-taking
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.69,$8.75,Prices from $ 8.00
http://www.amazon.com/Blink-The-Worlds-Fastest-Game/dp/B0037W5Y2W%3Fpsc%3D1%26SubscriptionId%3DA...
In Stock,In Stock,In Stock
False,False,False
123
123
0.400000
6883
6745
Riverboat Showdown
NaN
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$4.00,$8.51,Prices from $ 11.00
http://www.amazon.com/AEG-5819AEG-Cypher-Game/dp/B00LD170MQ%3FSubscriptionId%3DAKIAJ4BCA4P5VKV33...
In Stock,In Stock,In Stock
False,False,False
124
124
0.400000
5984
2280
Zar
6.0
Card Game
NaN
NaN
NaN
...
NaN
NaN
NaN
NaN
NaN
Amazon.com,Game Nerdz,
$14.50,$15.12,Prices from $ 24.00
http://www.amazon.com/Z-Man-Games-ZMG-41201-Parade/dp/B00E0JSMGG%3FSubscriptionId%3DAKIAJ4BCA4P5...
In Stock,In Stock,In Stock
False,False,False
125 rows × 26 columns
In [12]:
dbg[['ltable_name', 'rtable_name']] # Look for name matches in the
# debug table. (We're doing this in addition to the above full debug
# table print out since the rtable_name is hidden away in the collapse
# on the above call.)
# Looking we see no matches so our blocking seems pretty good
Out[12]:
ltable_name
rtable_name
0
Lord of the Rings Trivia Game
Lord of the Rings - Childrens Game
1
Oskar
Chimera Card Game
2
Oskar
Clairvoyance Card Game
3
Nix
Babel Card Game
4
Nix
Duo Card Game
5
Oskar
Cadaver Card Game
6
Nix
Blink Card Game
7
Nix
Clairvoyance Card Game
8
Split (Revised Edition)
Canasta Caliente Card Game (Revised Edition)
9
Numero
Babel Card Game
10
Nix
Parade Card Game
11
Numero
Cadaver Card Game
12
Numero
Clairvoyance Card Game
13
Nix
Cadaver Card Game
14
Numero
Cypher Card Game
15
Numero
Chimera Card Game
16
Oskar
Babel Card Game
17
Oskar
Parade Card Game
18
Numero
Blink Card Game
19
Nix
Cypher Card Game
20
Numero
Parade Card Game
21
Oskar
Cypher Card Game
22
Oskar
Duo Card Game
23
Nix
Chimera Card Game
24
Numero
Duo Card Game
25
Oskar
Blink Card Game
26
World War II: European Theater of Operations 1939-45
World War II - European Theater of Operations
27
European Theater of Operations
World War II - European Theater of Operations
28
The Guns of August
The Guns of August
29
David & Goliath
Clue Card Game
...
...
...
95
Blindside
Duo Card Game
96
Zar
Clairvoyance Card Game
97
Zar
Babel Card Game
98
Riverboat Showdown
Chimera Card Game
99
Blindside
Chimera Card Game
100
Numbters
Parade Card Game
101
Change!
Blink Card Game
102
Riverboat Showdown
Blink Card Game
103
Blindside
Babel Card Game
104
Change!
Babel Card Game
105
Change!
Cadaver Card Game
106
Zar
Chimera Card Game
107
Numbters
Duo Card Game
108
Change!
Duo Card Game
109
Change!
Clairvoyance Card Game
110
Zar
Blink Card Game
111
Blindside
Clairvoyance Card Game
112
Riverboat Showdown
Cadaver Card Game
113
Riverboat Showdown
Parade Card Game
114
Blindside
Cadaver Card Game
115
Change!
Parade Card Game
116
The Totally Insane Card Game
The Worst Game Ever Card Game
117
Riverboat Showdown
Duo Card Game
118
Riverboat Showdown
Clairvoyance Card Game
119
Blindside
Cypher Card Game
120
Cargo
Cargo
121
Riverboat Showdown
Babel Card Game
122
Blindside
Blink Card Game
123
Riverboat Showdown
Cypher Card Game
124
Zar
Parade Card Game
125 rows × 2 columns
In [13]:
# export C0 (the canidate set from just the year blocking)
em.to_csv_metadata(C0, './candidate_set_C0.csv')
File already exists at ./candidate_set_C0.csv; Overwriting it
Metadata file already exists at ./candidate_set_C0.metadata. Overwriting it
Out[13]:
True
In [14]:
# export C1 (the canidate set from blocking on year and name. This is our final set)
em.to_csv_metadata(C1, './candidate_set_C1.csv')
File already exists at ./candidate_set_C1.csv; Overwriting it
Metadata file already exists at ./candidate_set_C1.metadata. Overwriting it
Out[14]:
True
In [15]:
# read back C1 to ensure it saved
C = em.read_csv_metadata('candidate_set_C1.csv', ltable=A, rtable=B)
In [16]:
C
Out[16]:
_id
ltable_id
rtable_id
ltable_name
ltable_year
rtable_name
rtable_year
0
97
207
1682
Sniper! Special Forces: Sniper! Companion Game #2
1988.0
Babble: Board Game
1988.0
1
105
207
4064
Sniper! Special Forces: Sniper! Companion Game #2
1988.0
Antiques Roadshow - The Game
1988.0
2
130
244
5464
Win Lose or Draw
1988.0
Win, Lose or Draw
1988.0
3
167
270
2114
The Campaigns of Robert E. Lee
1988.0
Ace of Aces - Wingleader
1988.0
4
173
270
3685
The Campaigns of Robert E. Lee
1988.0
Grand Army of the Republic
1988.0
5
179
270
8070
The Campaigns of Robert E. Lee
1988.0
Profits of the Airwaves
1988.0
6
212
340
1682
24 Game
1988.0
Babble: Board Game
1988.0
7
220
340
4064
24 Game
1988.0
Antiques Roadshow - The Game
1988.0
8
257
591
1462
AirLand Battle: Corps Operational Command in Europe
1988.0
Buck Rogers - Battle for the 25th Century
1988.0
9
305
716
2114
The Legend of Zelda
1988.0
Ace of Aces - Wingleader
1988.0
10
311
716
3685
The Legend of Zelda
1988.0
Grand Army of the Republic
1988.0
11
317
716
8070
The Legend of Zelda
1988.0
Profits of the Airwaves
1988.0
12
442
998
1682
ID: The Identity Game
1988.0
Babble: Board Game
1988.0
13
450
998
4064
ID: The Identity Game
1988.0
Antiques Roadshow - The Game
1988.0
14
466
1000
2114
Pop of the Form
1988.0
Ace of Aces - Wingleader
1988.0
15
472
1000
3685
Pop of the Form
1988.0
Grand Army of the Republic
1988.0
16
478
1000
8070
Pop of the Form
1988.0
Profits of the Airwaves
1988.0
17
604
1236
2114
The Chronicles of Narnia
1988.0
Ace of Aces - Wingleader
1988.0
18
610
1236
3685
The Chronicles of Narnia
1988.0
Grand Army of the Republic
1988.0
19
616
1236
8070
The Chronicles of Narnia
1988.0
Profits of the Airwaves
1988.0
20
624
1239
1404
Trivial Pursuit: Entertainment Edition
1988.0
Thunder at the Crossroads (2nd Edition)
1988.0
21
742
1854
2114
Pegasus Bridge: The Beginning of D-Day - June 6 1944
1988.0
Ace of Aces - Wingleader
1988.0
22
748
1854
3685
Pegasus Bridge: The Beginning of D-Day - June 6 1944
1988.0
Grand Army of the Republic
1988.0
23
754
1854
8070
Pegasus Bridge: The Beginning of D-Day - June 6 1944
1988.0
Profits of the Airwaves
1988.0
24
805
1960
541
Vanity Chase
1988.0
Vanity Chase
1988.0
25
902
2081
1682
My Little Pony Game
1988.0
Babble: Board Game
1988.0
26
910
2081
4064
My Little Pony Game
1988.0
Antiques Roadshow - The Game
1988.0
27
949
2137
2114
West of Alamein: ASL Module 5
1988.0
Ace of Aces - Wingleader
1988.0
28
955
2137
3685
West of Alamein: ASL Module 5
1988.0
Grand Army of the Republic
1988.0
29
961
2137
8070
West of Alamein: ASL Module 5
1988.0
Profits of the Airwaves
1988.0
...
...
...
...
...
...
...
...
5537
250704
3461
209
Wings of War: Watch Your Back!
2005.0
Battle of the Little Bighorn
2005.0
5538
250706
3461
513
Wings of War: Watch Your Back!
2005.0
Triumph of Chaos
2005.0
5539
250710
3461
857
Wings of War: Watch Your Back!
2005.0
Barbary Coast War (2nd Edition)
2005.0
5540
250711
3461
897
Wings of War: Watch Your Back!
2005.0
Stratego - The Chronicles of Narnia
2005.0
5541
250722
3461
1501
Wings of War: Watch Your Back!
2005.0
Euphrates & Tigris - Contest of Kings
2005.0
5542
250728
3461
1858
Wings of War: Watch Your Back!
2005.0
Lawrence of Arabia (1st Edition)
2005.0
5543
250734
3461
2190
Wings of War: Watch Your Back!
2005.0
Empire of the Sun
2005.0
5544
250737
3461
2370
Wings of War: Watch Your Back!
2005.0
Battleground Fantasy Warfare: Men of Hawkshold
2005.0
5545
250744
3461
2786
Wings of War: Watch Your Back!
2005.0
Wings of War: Watch Your Back!
2005.0
5546
250747
3461
3101
Wings of War: Watch Your Back!
2005.0
Conquest of the Empire
2005.0
5547
250760
3461
4441
Wings of War: Watch Your Back!
2005.0
Fire in the Sky - The Great Pacific War 1941-1945
2005.0
5548
250762
3461
4489
Wings of War: Watch Your Back!
2005.0
Battles from the Age of Reason #5 - Lobositz - First Battle of the Seven Years War
2005.0
5549
250764
3461
4881
Wings of War: Watch Your Back!
2005.0
Nature of the Beast: City Vs. Suburb
2005.0
5550
250766
3461
5020
Wings of War: Watch Your Back!
2005.0
Lord of the Rings: The Confrontation
2005.0
5551
250771
3461
5614
Wings of War: Watch Your Back!
2005.0
Wings of War: Burning Drachens
2005.0
5552
250773
3461
5773
Wings of War: Watch Your Back!
2005.0
Nature of the Beast: Farm Vs. Forest
2005.0
5553
250778
3461
6273
Wings of War: Watch Your Back!
2005.0
Island of Dread, The
2005.0
5554
250780
3461
6324
Wings of War: Watch Your Back!
2005.0
Queen of the Cupcakes
2005.0
5555
250787
3461
7174
Wings of War: Watch Your Back!
2005.0
Lock 'N Load - Band of Heroes (1st Edition)
2005.0
5556
250789
3461
7258
Wings of War: Watch Your Back!
2005.0
The End of the Triumvirate
2005.0
5557
250794
3461
7562
Wings of War: Watch Your Back!
2005.0
Conquest of the Fallen Lands
2005.0
5558
250809
3461
8913
Wings of War: Watch Your Back!
2005.0
The Settlers of Catan: The Fishermen of Catan
2005.0
5559
250823
3461
10027
Wings of War: Watch Your Back!
2005.0
Second World War at Sea: Bismarck
2005.0
5560
250827
3461
10258
Wings of War: Watch Your Back!
2005.0
Bang! Fistful of Cards
2005.0
5561
250958
3499
536
Winner Spinner
1953.0
Winner Spinner
1953.0
5562
250971
4497
8307
Go to the Head of the Class
1936.0
Go to the Head of the Class (1967 Edition)
1936.0
5563
250980
5238
10117
Easy Money
1935.0
Easy Money
1935.0
5564
250981
6213
1235
Game of Politics
1935.0
All American Football Game (1st Printing)
1935.0
5565
250986
3587
6839
All-Star Baseball
1941.0
All-Star Baseball (1st Printing)
1941.0
5566
250989
4587
7602
Across the Continent
1890.0
Across the Continent
1890.0
5567 rows × 7 columns
In [17]:
# Take a look at how blocking using just the name works for fun
ob = em.OverlapBlocker()
# block using name
C4 = ob.block_tables(A, B, 'name', 'name',
l_output_attrs=['name', 'year'],
r_output_attrs=['name', 'year'],word_level=True, overlap_size=1,)
C4
0% 100%
[##############################] | ETA: 00:00:00
Total time elapsed: 00:00:07
Out[17]:
_id
ltable_id
rtable_id
ltable_name
ltable_year
rtable_name
rtable_year
0
0
3715
1
kontor player expansion 4 3
2002.0
front 3 rhine panzer drive 2nd exp
NaN
1
1
516
1
liberation national front
1983.0
front 3 rhine panzer drive 2nd exp
NaN
2
2
5509
1
panzer armee afrika
1973.0
front 3 rhine panzer drive 2nd exp
NaN
3
3
3906
1
panzer pranks
1980.0
front 3 rhine panzer drive 2nd exp
NaN
4
4
5641
1
up 3
1972.0
front 3 rhine panzer drive 2nd exp
NaN
5
5
3722
1
russian front
1985.0
front 3 rhine panzer drive 2nd exp
NaN
6
6
2572
1
quiet front all western
1997.0
front 3 rhine panzer drive 2nd exp
NaN
7
7
549
1
panzer grenadier korps afrika
2002.0
front 3 rhine panzer drive 2nd exp
NaN
8
8
6670
1
3 horizons set of duel vast ages
2003.0
front 3 rhine panzer drive 2nd exp
NaN
9
9
4879
1
maze 3 worlds expansion of tyrants card hell heroes
2003.0
front 3 rhine panzer drive 2nd exp
NaN
10
10
145
1
conflict front set battlecards starter russian world
2003.0
front 3 rhine panzer drive 2nd exp
NaN
11
11
1042
1
panzer battles
1979.0
front 3 rhine panzer drive 2nd exp
NaN
12
12
6548
1
3 sekigahara of epoch wargame battle electronics
1983.0
front 3 rhine panzer drive 2nd exp
NaN
13
13
1303
1
front commander tank eastern edition
1997.0
front 3 rhine panzer drive 2nd exp
NaN
14
14
1882
1
baltic drive
2000.0
front 3 rhine panzer drive 2nd exp
NaN
15
15
5419
1
drive 1313 dead end
2002.0
front 3 rhine panzer drive 2nd exp
NaN
16
16
5408
1
spafrancorchamps 3 d formula zandvoort 2 4 circuits
1997.0
front 3 rhine panzer drive 2nd exp
NaN
17
17
4771
1
east ostkrieg armoured front warfare 194445
1980.0
front 3 rhine panzer drive 2nd exp
NaN
18
18
5284
1
mysteries drive hard homicide vincent
1998.0
front 3 rhine panzer drive 2nd exp
NaN
19
19
1573
1
1944 front second
1990.0
front 3 rhine panzer drive 2nd exp
NaN
20
20
6642
1
mall walkers zombies 3
2003.0
front 3 rhine panzer drive 2nd exp
NaN
21
21
2987
1
operation rhine veritable historical asl 1945 study
2003.0
front 3 rhine panzer drive 2nd exp
NaN
22
22
3848
1
drive paris
2000.0
front 3 rhine panzer drive 2nd exp
NaN
23
23
5293
1
series daisy 3 mansion detective of diamond episode mystery haunted
NaN
front 3 rhine panzer drive 2nd exp
NaN
24
24
46
1
errors clerical munchkin 3
2003.0
front 3 rhine panzer drive 2nd exp
NaN
25
25
6448
1
frankfurt drive
1987.0
front 3 rhine panzer drive 2nd exp
NaN
26
26
1801
1
line natos bundeswehr front
1986.0
front 3 rhine panzer drive 2nd exp
NaN
27
27
6836
1
lemlican arms series 3 collection
1990.0
front 3 rhine panzer drive 2nd exp
NaN
28
28
5174
1
set expansion cosmic encounter 3
1978.0
front 3 rhine panzer drive 2nd exp
NaN
29
29
4919
1
3 july june 1863 invasion great 24 gettysburg campaign
1985.0
front 3 rhine panzer drive 2nd exp
NaN
...
...
...
...
...
...
...
...
2120476
2120476
6051
10298
galleons sky of mars
1988.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120477
2120477
4005
10298
damned mordheim city of
1999.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120478
2120478
1963
10298
extinction ecology of game
1970.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120479
2120479
1964
10298
battles carrier
1985.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120480
2120480
1965
10298
2 mechwar
1979.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120481
2120481
6070
10298
tomb lord of dungeoneer lich
2003.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120482
2120482
1982
10298
rise house saud of
1985.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120483
2120483
1985
10298
castagnaro battle of condottieri
1986.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120484
2120484
4035
10298
warriors star wars
1987.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120485
2120485
6084
10298
clue case of jr hidden toys
1996.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120486
2120486
1992
10298
1 expansion battles star fleet
1980.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120487
2120487
1993
10298
expansion battles star 2 fleet
1982.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120488
2120488
1994
10298
expansion battles star 3 fleet
1982.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120489
2120489
4043
10298
quests table round of
1995.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120490
2120490
2001
10298
expansion clash of malta eagles
1994.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120491
2120491
2002
10298
clash expansion sturmovik of eagles
1995.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120492
2120492
6099
10298
bulge battle of
1991.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120493
2120493
6100
10298
of war great zeppelin battles
2002.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120494
2120494
4053
10298
doom of crescendo
1979.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120495
2120495
6103
10298
underearth of dragons
1981.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120496
2120496
2015
10298
versus tyrant of carthage syracuse battles
2003.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120497
2120497
2385
10298
germany us expansion of steam 2 age western
2003.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120498
2120498
2020
10298
age of napoleon
2003.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120499
2120499
2028
10298
rings lord destiny of battle
2003.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120500
2120500
6128
10298
missing case suspect of perry mason game
1959.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120501
2120501
2035
10298
rings minas lord expansion of set incl risk game siege tirith
2003.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120502
2120502
3754
10298
path of game jedis life
2002.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120503
2120503
2041
10298
habsburgs twilight of
2001.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120504
2120504
4092
10298
of history war second world
1985.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120505
2120505
2048
10298
side far commander of master world
2003.0
zorndorf russia of vs warriors holy 2 frederick reason battles age
1996.0
2120506 rows × 7 columns
In [18]:
# We noticed that in the above table that the ltable_name and rtable_names
# were mangled and apparently tokenized. Here we check
B['name'] # check that the name "Panzer Exp. #3: Drive to the Rhine - The 2nd Front "
# is read in since it seems mangled in the above C3 table rtable_name.
# It is in fact read in correctly so it seems to be an issue with the
# output of block_tables()
Out[18]:
0 Panzer Exp. #3: Drive to the Rhine - The 2nd Front
1 Call of Cthulhu LCG: In the Dread of Night
2 Dungeons and Dragons: The Legend of Drizzt
3 Istanbul: Mocha & Baksheesh
4 Perfect Alibi
5 Star Realms: Crisis – Fleets & Fortresses
6 Nexus Ops
7 The King is Dead
8 Pokemon TCG: XY Fates Collide Booster Display (36)
9 Tide of Iron: Designer Series - Volume One
10 Star Wars: The Card Game - So Be It
11 Dead Men Tell No Tales
12 Crown of Roses
13 Shadows of Brimstone: Trun Hunters Enemy Pack
14 Civilization: Wisdom and Warfare Expansion
15 Across the Aller - Last Stand in Northwest Europe, 1945
16 Marbles: Electric Eel Set
17 Ticket to Ride: Heart of Africa
18 Copper Country
19 Special Agent Meeple Poker Chips (20)
20 Summoner Wars: The Filth Faction Deck
21 Advanced Civilization - Assyria Counters
22 Reaper: Master Series Paint: Clear Green
23 Prague: The Empty Triumph
24 Reaper: Master Series Paint: Flow Improver
25 Panic Bundle
26 Cleopatra's Caboose
27 Ali Baba
28 Folding Cribbage Travel Board
29 The Curse of the Black Dice
...
10266 Dwarven Dive
10267 Island Fortress: 5-6 Player Expansion
10268 Warmachine High Command: Faith & Fortune - Core Set
10269 Jaipur
10270 Expo 1906 Board Game
10271 Dungeon Lords
10272 Galaxy Defenders: Elite Alien Army
10273 Summoner Wars: Jungle Elves Second Summoner Faction Deck
10274 Frank's Zoo Card Game
10275 Clash of Cultures: Civilizations
10276 Star Wars LCG: Jump to Lightspeed Force Pack
10277 Claustrophobia: Furor Sanguinis
10278 Wings of Glory WWII: Rules and Accessories Plus Late Airplane Packs Combo
10279 15" Walnut/Maple Chessboard w/1.75" Squares
10280 KV47 Recovery & Demolition Walker - Maksim/Marlen/Melor/Mikhail
10281 Myth: Orcneas Master of Masters Boss
10282 Mars Attacks: The Miniatures Game
10283 Fatal Alliances: The Great War
10284 Forge War: Second Printing
10285 Warmachine - Faith & Fortune
10286 Expedite
10287 Castle: The Detective Card Game
10288 Rum & Bones: Bone Devils Heroes Set #1
10289 Eagle Kingdoms
10290 Justine & Co. - Maintenance Contractors #2
10291 Shadowrun Crossfire DBG: Core Boxed Game
10292 East is Red, The
10293 Gunship: First Strike!
10294 Extra Extra
10295 Battles from the Age of Reason #2 - Zorndorf - Frederick vs. the Warriors of Holy Russia
Name: name, dtype: object
Content source: malnoxon/board-game-data-science
Similar notebooks: