%%time
import csv
from urllib.request import urlopen
# import codecs
# from tqdm import tqdm
# from tqdm._tqdm_notebook import tqdm_notebook
import numpy as np
import pandas as pd

#### PANDAS defaults for displays

pd.set_option('display.max_rows', 2000)
pd.set_option('display.max_columns', 500)

##### Setup SPARQL queries

import urllib.parse
from IPython.display import IFrame
baseurl='https://query.wikidata.org/embed.html#'

def wdq(query='',width=800,height=500):
  return IFrame(baseurl+urllib.parse.quote(query), width=width, height=height)

import requests

wikidata_api_url    = 'https://query.wikidata.org/bigdata/namespace/wdq/sparql'
met_api_url         = 'https://collectionapi.metmuseum.org/public/collection/v1/objects/'
crosswalk_sheet_url = 'https://docs.google.com/spreadsheets/d/1WmXW2CjlLidcUXzahQsB3HjUVvECns4xDyIt-Hw-jW8/export?format=csv&id'
met_toah_sheet_url  = 'https://docs.google.com/spreadsheets/d/1Dc6haTQgo6g-iB6RSgI0l5bLs_QqgpuLFEiZc7qGGpk/export?format=csv&id=1Dc6haTQgo6g-iB6RSgI0l5bLs_QqgpuLFEiZc7qGGpk&gid=876595812'

# Use local copy of CSV file for speed
url = 'metmuseum/MetObjects-20190903.csv'

# Read the CSV file into a pandas dataframe
df = pd.read_csv(url,low_memory=False)
CPU times: user 7.19 s, sys: 472 ms, total: 7.66 s
Wall time: 7.67 s
# Make a new shallow/efficient copy of dataframe (data in place) with just highlights
hdf = df[df['Is Highlight'] == True].copy()

hdf['Department'].value_counts()
The Libraries                                262
American Decorative Arts                     175
Islamic Art                                  120
Modern and Contemporary Art                  116
Greek and Roman Art                          115
Egyptian Art                                 114
Photographs                                  113
European Paintings                           109
Musical Instruments                          105
Arts of Africa, Oceania, and the Americas    104
Costume Institute                            102
Robert Lehman Collection                      98
European Sculpture and Decorative Arts        82
Ancient Near Eastern Art                      75
Drawings and Prints                           61
The Cloisters                                 58
Asian Art                                     55
Arms and Armor                                54
Medieval Art                                  54
Name: Department, dtype: int64
## Grab all items in Wikidata with Met Object ID (P3634)

query = '''
SELECT ?item ?metid WHERE { 
  ?item wdt:P3634 ?metid .
}
'''
data = requests.post(wikidata_api_url, data={'query': query, 'format': 'json'}).json()

resultarray = []
for item in data['results']['bindings']:
    resultarray.append({
        'qid':   int(item['item']['value'].replace('http://www.wikidata.org/entity/Q','')),
        'metid': int(item['metid']['value']),
    })

metinwd_df = pd.DataFrame(resultarray)
metinwd_df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 10780 entries, 0 to 10779
Data columns (total 2 columns):
metid    10780 non-null int64
qid      10780 non-null int64
dtypes: int64(2)
memory usage: 168.5 KB
# Find hdf elements not already in Wikidata
# This line of code produces Boolean True/False array
# hdf['Object ID'].isin(df_highlights_byvalues['metid']).head(10)

missing_df = df[~df['Object ID'].isin(metinwd_df['metid'])].copy(deep=False)
present_df = df[df['Object ID'].isin(metinwd_df['metid'])].copy(deep=False)

present_df['Object Number'].count()
10687
# Load TOAH list from spreadsheet from The Met

toah_df = pd.read_csv(met_toah_sheet_url, header=0, usecols=["ObjectID"])
toah_df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 8017 entries, 0 to 8016
Data columns (total 1 columns):
ObjectID    8017 non-null int64
dtypes: int64(1)
memory usage: 62.7 KB
toah_present_df = metinwd_df[metinwd_df['metid'].isin(toah_df['ObjectID'])].copy(deep=False)

toah_present_df['metid'].count()
2255
toah_present_df.sample(5)
metid qid
123 10830 20171076
3118 12668 20173608
3724 472155 20201915
5086 435855 19913628
8540 451400 29385155
toah_missing_ids_df = toah_df[~toah_df['ObjectID'].isin(metinwd_df['metid'])].copy(deep=False)

toah_missing_ids_df['ObjectID'].count()
5774
toah_missing_ids_df.sample(5)
ObjectID
7387 232047
3867 8263
4896 312586
6650 453498
2602 253565
toah_missing_df = df[df['Object ID'].isin(toah_missing_ids_df['ObjectID'])].copy(deep=False)
toah_missing_df['Department'].value_counts()
Asian Art                                    697
Drawings and Prints                          680
Arts of Africa, Oceania, and the Americas    615
European Sculpture and Decorative Arts       599
Greek and Roman Art                          453
American Decorative Arts                     445
Islamic Art                                  414
Photographs                                  338
Medieval Art                                 318
Egyptian Art                                 272
Ancient Near Eastern Art                     227
Costume Institute                            222
Arms and Armor                               130
Modern and Contemporary Art                  117
Musical Instruments                          116
The Cloisters                                 68
Robert Lehman Collection                      12
Name: Department, dtype: int64
toah_missing_df.sample(5)
Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository Tags
75583 2003.573.2 False False 98464 Costume Institute Coat Coat Japanese NaN NaN NaN NaN Designer NaN Yohji Yamamoto Japanese, born Yokohama, 1943 NaN Yamamoto, Yohji Japanese 1943 2043 early 1990s 1990 1995 wool, brass, acrylic NaN Gift of Minori Shironishi, 2003 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN http://www.metmuseum.org/art/collection/search... 9/2/2019 8:00:02 AM Metropolitan Museum of Art, New York, NY NaN
161475 1987.1100.25 False False 265299 Photographs Photograph Fort Peck Dam, Montana NaN NaN NaN NaN NaN Artist NaN Margaret Bourke-White American, Bronx, New York 1904–1971 Darien, Co... NaN Bourke-White, Margaret American 1904 1971 1936 1936 1936 Gelatin silver print 33.1 x 26.6 cm (13 x 10 1/2 in.) Ford Motor Company Collection, Gift of Ford Mo... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN Photographs NaN http://www.metmuseum.org/art/collection/search... 9/2/2019 8:00:02 AM Metropolitan Museum of Art, New York, NY Architecture
198467 50.163 False True 324105 Ancient Near Eastern Art Sculpture Part of a throne with deity on a bull Urartian Iron Age III NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN ca. late 8th–7th century B.C. -725 -600 Bronze, plastic restoration H. 14.6 cm Dodge Fund, 1950 NaN NaN NaN NaN NaN Urartu probably from Toprakkale NaN NaN NaN NaN Metalwork-Sculpture NaN http://www.metmuseum.org/art/collection/search... 9/2/2019 8:00:02 AM Metropolitan Museum of Art, New York, NY Bulls
35507 1988.350a–d False True 41493 Asian Art Handscroll 清 徐揚 等 乾隆南巡圖 (第六卷﹕大運河至蘇州) 卷|The Qianlong ... China Qing dynasty (1644–1911) NaN NaN NaN Artist NaN Xu Yang Chinese, active ca. 1750–after 1776 and assistants XU YANG Chinese 1750 1776 dated 1770 1770 1770 Handscroll; ink and color on silk Image: 27 1/8 in. x 784 1/2 in. (68.8 x 1994 cm) Purchase, The Dillon Fund Gift, 1988 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN Paintings NaN http://www.metmuseum.org/art/collection/search... 9/2/2019 8:00:02 AM Metropolitan Museum of Art, New York, NY Canals|Landscapes|Trees|Crowd|Boats
233312 24.90.1320 False True 365737 Drawings and Prints Print Broadway and City Hall in New York (Brodway-Ga... NaN NaN NaN NaN NaN Artist|Etcher After Axel Klinckowström|Carl Fredrik Akrell Swedish, 1775–1837|Swedish, 1779–1868 NaN Klinckowström, Axel|Akrell, Carl Fredrik Swedish|Swedish 1775 |1779 1837 |1868 1824 1824 1824 Etching and aquatint image: 8 1/16 x 15 1/4 in. (20.5 x 38.7 cm)\r\... Bequest of Charles Allen Munn, 1924 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN Prints NaN http://www.metmuseum.org/art/collection/search... 9/2/2019 8:00:02 AM Metropolitan Museum of Art, New York, NY Human Figures|Animals|Buildings|Streets|Carriages
aa_toah_df = toah_missing_df[toah_missing_df['Department'].str.contains('Asian Art')].copy(deep=False)



aa_toah_df[['Object ID','Artist Display Name','Artist Role','Artist Begin Date']]
Object ID Artist Display Name Artist Role Artist Begin Date
30335 36005 Xia Gui Artist 1195
30410 36081 Ruan Zude Artist 1500
30411 36082 Ruan Zude Artist 1500
30433 36105 Shen Quan Artist 1682
30777 36451 Unidentified Artist Artist NaN
30778 36452 NaN NaN NaN
30783 36457 Unidentified Artist Artist NaN
31565 37248 Utagawa Hiroshige Artist 1797
31711 37395 Chen Hongshou Artist 1598
31720 37404 NaN NaN NaN
31723 37407 NaN NaN NaN
31724 37408 NaN NaN NaN
31731 37415 NaN NaN NaN
31767 37451 NaN NaN NaN
31815 37499 NaN NaN NaN
31873 37558 NaN NaN NaN
31903 37588 NaN NaN NaN
31924 37609 NaN NaN NaN
31929 37614 NaN NaN NaN
31935 37620 NaN NaN NaN
31943 37630 NaN NaN NaN
31944 37631 NaN NaN NaN
31977 37665 NaN NaN NaN
31992 37680 NaN NaN NaN
32068 37756 NaN NaN NaN
32099 37791 NaN NaN NaN
32102 37794 NaN NaN NaN
32105 37797 NaN NaN NaN
32108 37800 NaN NaN NaN
32110 37802 NaN NaN NaN
32114 37806 NaN NaN NaN
32115 37807 NaN NaN NaN
32117 37810 NaN NaN NaN
32120 37813 NaN NaN NaN
32123 37816 NaN NaN NaN
32139 37835 NaN NaN NaN
32153 37849 NaN NaN NaN
32181 37877 Sahib Ram Artist 1778
32215 37911 NaN NaN NaN
32259 37955 NaN NaN NaN
32265 37962 Master of the "Isarda" Bhagavata Purana Artist NaN
32269 37966 NaN NaN NaN
32272 37970 NaN NaN NaN
32273 37971 NaN NaN NaN
32277 37975 NaN NaN NaN
32306 38006 NaN NaN NaN
32307 38007 Bhima|Kesu Ram|Bhopa|Nathu Artist|Artist|Artist|Artist NaN
32309 38009 Nainsukh Artist 1725
32311 38011 NaN NaN NaN
32315 38015 NaN NaN NaN
32319 38021 NaN NaN NaN
32334 38038 NaN NaN NaN
32335 38039 NaN NaN NaN
32337 38041 NaN NaN NaN
32339 38043 Bagta Artist 1751
32340 38044 Chotu Artist NaN
32373 38084 NaN NaN NaN
32381 38093 NaN NaN NaN
32388 38100 NaN NaN NaN
32392 38104 NaN NaN NaN
32398 38111 NaN NaN NaN
32404 38117 NaN NaN NaN
32405 38118 NaN NaN NaN
32406 38119 NaN NaN NaN
32410 38124 NaN NaN NaN
32413 38127 NaN NaN NaN
32421 38135 NaN NaN NaN
32427 38141 NaN NaN NaN
32432 38146 NaN NaN NaN
32438 38152 NaN NaN NaN
32443 38158 NaN NaN NaN
32452 38168 NaN NaN NaN
32458 38174 NaN NaN NaN
32490 38207 NaN NaN NaN
32493 38210 NaN NaN NaN
32504 38221 NaN NaN NaN
32511 38228 NaN NaN NaN
32521 38238 NaN NaN NaN
32522 38239 NaN NaN NaN
32528 38245 NaN NaN NaN
32529 38246 NaN NaN NaN
32535 38252 NaN NaN NaN
32541 38258 NaN NaN NaN
32548 38265 NaN NaN NaN
32586 38304 NaN NaN NaN
32589 38307 NaN NaN NaN
32596 38314 NaN NaN NaN
32599 38317 NaN NaN NaN
32604 38322 NaN NaN NaN
32607 38326 NaN NaN NaN
32608 38327 NaN NaN NaN
32609 38328 NaN NaN NaN
32611 38330 NaN NaN NaN
32616 38335 NaN NaN NaN
32624 38344 NaN NaN NaN
32711 38435 NaN NaN NaN
32727 38452 NaN NaN NaN
32751 38479 NaN NaN NaN
32770 38498 NaN NaN NaN
32783 38511 NaN NaN NaN
32785 38513 NaN NaN NaN
32787 38515 NaN NaN NaN
32788 38516 NaN NaN NaN
32789 38517 Dasoja of Balligrama Artist NaN
32790 38518 NaN NaN NaN
32812 38544 NaN NaN NaN
32826 38558 NaN NaN NaN
32844 38577 NaN NaN NaN
32850 38583 NaN NaN NaN
32851 38584 NaN NaN NaN
32858 38593 NaN NaN NaN
32861 38600 NaN NaN NaN
32865 38606 NaN NaN NaN
32884 38632 NaN NaN NaN
32895 38646 NaN NaN NaN
33019 38777 NaN NaN NaN
33027 38788 NaN NaN NaN
33150 38926 NaN NaN NaN
33169 38945 NaN NaN NaN
33174 38950 NaN NaN NaN
33175 38951 NaN NaN NaN
33176 38952 NaN NaN NaN
33183 38959 NaN NaN NaN
33187 38965 NaN NaN NaN
33196 38974 NaN NaN NaN
33241 39020 NaN NaN NaN
33267 39046 NaN NaN NaN
33268 39047 NaN NaN NaN
33269 39048 NaN NaN NaN
33275 39054 NaN NaN NaN
33281 39060 NaN NaN NaN
33283 39062 NaN NaN NaN
33317 39096 NaN NaN NaN
33321 39100 NaN NaN NaN
33331 39111 NaN NaN NaN
33353 39134 NaN NaN NaN
33370 39154 NaN NaN NaN
33381 39165 NaN NaN NaN
33399 39184 NaN NaN NaN
33403 39188 NaN NaN NaN
33404 39189 NaN NaN NaN
33411 39197 NaN NaN NaN
33412 39198 NaN NaN NaN
33413 39199 NaN NaN NaN
33423 39209 NaN NaN NaN
33424 39210 NaN NaN NaN
33528 39317 NaN NaN NaN
33531 39320 NaN NaN NaN
33535 39325 NaN NaN NaN
33538 39328 NaN NaN NaN
33541 39331 NaN NaN NaN
33565 39357 NaN NaN NaN
33591 39385 NaN NaN NaN
33605 39399 NaN NaN NaN
33612 39407 NaN NaN NaN
33614 39409 NaN NaN NaN
33618 39413 NaN NaN NaN
33630 39425 NaN NaN NaN
33641 39438 NaN NaN NaN
33683 39482 NaN NaN NaN
33687 39486 NaN NaN NaN
33689 39488 Chen Yanqing Artist 1400
33691 39490 NaN NaN NaN
33697 39496 NaN NaN NaN
33698 39497 NaN NaN NaN
33703 39502 NaN NaN NaN
33719 39518 NaN NaN NaN
33721 39520 NaN NaN NaN
33723 39522 NaN NaN NaN
33736 39536 Wen Zhengming Artist 1470
33737 39540 Bada Shanren (Zhu Da) Artist 1626
33738 39542 Dong Yuan Artist 0930
33739 39543 Unidentified Artist Artist NaN
33741 39545 Zhao Cangyun Artist 1267
33746 39550 Wang Meng Artist 1308
33752 39557 Kuncan Artist 1612
33764 39571 NaN NaN NaN
33774 39582 NaN NaN NaN
33781 39589 NaN NaN NaN
33782 39590 NaN NaN NaN
33784 39595 NaN NaN NaN
33805 39616 NaN NaN NaN
33810 39621 NaN NaN NaN
33813 39624 NaN NaN NaN
33814 39625 Zhang Xihuang Artist 1600
33815 39626 Zhu Sansong Artist 1573
33821 39632 NaN NaN NaN
33827 39638 NaN NaN NaN
33841 39654 Wen Zhengming Artist 1470
33845 39658 Nagasawa Rosetsu Artist 1754
33846 39659 Kyūen Ryūchin|Kōshi Ehō|Nankō Sōgen|Zuigan Ryū... Artist|Artist|Artist|Artist|Artist 1414 |1378 |1384
33847 39660 NaN NaN NaN
33851 39664 Ogata Kōrin Artist 1658
33852 39665 Tosa Mitsuyoshi Artist 1539
33856 39669 NaN NaN NaN
33863 39676 NaN NaN NaN
33889 39713 Lan Ying Artist 1585
33906 39730 Unidentified Artist Artist NaN
33912 39736 NaN NaN NaN
33913 39737 NaN NaN NaN
33916 39740 NaN NaN NaN
33934 39761 NaN NaN NaN
33947 39774 NaN NaN NaN
34021 39882 Unidentified Artist Artist NaN
34022 39883 Unidentified Artist Artist NaN
34023 39884 NaN NaN NaN
34024 39885 NaN NaN NaN
34025 39886 NaN NaN NaN
34026 39887 Unidentified Artist Artist NaN
34027 39888 Unidentified Artist Artist NaN
34028 39889 Unidentified Artist Artist NaN
34030 39891 NaN NaN NaN
34034 39895 Li Gonglin Artist 1041
34054 39919 Mi Fu Artist 1051
34065 39932 NaN NaN NaN
34116 40001 NaN NaN NaN
34121 40007 Mi Youren Artist 1074
34133 40019 Wang Shimin Artist 1592
34135 40021 Wang Hui|Wang Hui Artist|Calligrapher 1632 |1632
34178 40067 NaN NaN NaN
34189 40078 Lidi|Unidentified Artist Artist|Artist 1110
34197 40086 Ma Yuan Artist 1190
34201 40090 Liang Kai Artist 1200
34204 40093 Unidentified Artist Artist NaN
34206 40095 NaN NaN NaN
34214 40103 Empress Yang Meizi Artist 1162
34216 40105 Yelü Chucai Artist 1190
34235 40133 Ma Lin Artist 1180
34279 40211 NaN NaN NaN
34349 40284 Zhao Mengjian Artist 1199
34365 40303 Unidentified Artists Artist NaN
34455 40393 Zhou Dongqing Artist 0013
34507 40445 Yi Yuwon Artist 1814
34509 40447 Unidentified Artist Artist NaN
34516 40454 Zhang Yucai Artist NaN
34555 40505 NaN NaN NaN
34559 40509 Zhao Mengfu Artist 1254
34572 40524 NaN NaN NaN
34574 40526 NaN NaN NaN
34633 40598 NaN NaN NaN
34780 40746 NaN NaN NaN
34800 40766 NaN NaN NaN
35171 41154 Ni Zan Artist 1306
35264 41247 NaN NaN NaN
35484 41468 Wu Zhen Artist 1280
35490 41474 Unidentified Artist Artist NaN
35494 41478 Xie Huan Artist 1377
35497 41481 Wang Hui|Wang Shimin Artist|Artist 1632 |1592
35499 41483 Gong Xian Artist 1619
35505 41491 Bada Shanren (Zhu Da) Artist 1626
35507 41493 Xu Yang Artist 1750
35518 41504 Wang Zhen Artist 1867
35741 41747 NaN NaN NaN
35768 41776 NaN NaN NaN
35859 41867 NaN NaN NaN
36046 42059 NaN NaN NaN
36047 42060 NaN NaN NaN
36077 42090 NaN NaN NaN
36089 42102 NaN NaN NaN
36092 42105 Shi Lu Artist 1919
36099 42112 NaN NaN NaN
36101 42114 NaN NaN NaN
36111 42124 NaN NaN NaN
36151 42164 NaN NaN NaN
36152 42165 NaN NaN NaN
36153 42166 NaN NaN NaN
36154 42167 NaN NaN NaN
36155 42168 NaN NaN NaN
36156 42169 NaN NaN NaN
36157 42170 NaN NaN NaN
36158 42171 NaN NaN NaN
36159 42172 NaN NaN NaN
36160 42173 NaN NaN NaN
36161 42174 NaN NaN NaN
36162 42175 NaN NaN NaN
36163 42176 NaN NaN NaN
36164 42177 NaN NaN NaN
36167 42180 NaN NaN NaN
36250 42268 NaN NaN NaN
36264 42282 NaN NaN NaN
36289 42308 NaN NaN NaN
36290 42309 NaN NaN NaN
36291 42310 NaN NaN NaN
36292 42311 NaN NaN NaN
36294 42313 NaN NaN NaN
36298 42317 NaN NaN NaN
36303 42322 NaN NaN NaN
36306 42325 NaN NaN NaN
36308 42328 Lu Guang Artist 1300
36322 42344 Sōami Artist 1485
36327 42350 NaN NaN NaN
36353 42376 NaN NaN NaN
36377 42400 NaN NaN NaN
36379 42403 NaN NaN NaN
36409 42433 Zhang Family Workshop Artist NaN
36418 42442 NaN NaN NaN
36423 42447 NaN NaN NaN
36431 42455 NaN NaN NaN
36437 42461 NaN NaN NaN
36459 42483 NaN NaN NaN
36460 42484 NaN NaN NaN
36464 42488 NaN NaN NaN
36485 42511 NaN NaN NaN
36489 42515 NaN NaN NaN
36500 42526 NaN NaN NaN
36521 42547 NaN NaN NaN
36523 42549 NaN NaN NaN
36602 42718 NaN NaN NaN
36603 42719 NaN NaN NaN
36617 42733 NaN NaN NaN
36628 42744 NaN NaN NaN
37162 43285 NaN NaN NaN
37250 43373 NaN NaN NaN
37261 43385 NaN NaN NaN
37682 43806 NaN NaN NaN
37827 43951 NaN NaN NaN
37899 44023 NaN NaN NaN
37935 44059 NaN NaN NaN
37954 44078 NaN NaN NaN
37981 44105 NaN NaN NaN
38013 44137 NaN NaN NaN
38023 44147 NaN NaN NaN
38025 44149 NaN NaN NaN
38031 44155 NaN NaN NaN
38042 44166 NaN NaN NaN
38129 44274 Hamada Shōji Artist 1894
38144 44291 NaN NaN NaN
38151 44298 NaN NaN NaN
38152 44299 NaN NaN NaN
38153 44300 NaN NaN NaN
38154 44301 NaN NaN NaN
38155 44302 NaN NaN NaN
38175 44322 NaN NaN NaN
38239 44386 NaN NaN NaN
38243 44390 NaN NaN NaN
38367 44515 NaN NaN NaN
38368 44516 NaN NaN NaN
38370 44518 NaN NaN NaN
38372 44520 Isamu Noguchi Artist 1904
38375 44523 NaN NaN NaN
38389 44567 Wu Changshuo Artist 1844
38410 44590 Xia Chang Artist 1388
38424 44604 NaN NaN NaN
38455 44635 NaN NaN NaN
38457 44637 NaN NaN NaN
38458 44638 Ma Yuan Artist 1190
38493 44673 Kano Motonobu Artist 1477
38518 44698 Unidentified Artist Artist NaN
38542 44722 NaN NaN NaN
38553 44733 NaN NaN NaN
38577 44757 NaN NaN NaN
38580 44760 Unidentified Artist Artist NaN
38583 44763 NaN NaN NaN
38584 44764 NaN NaN NaN
38585 44765 NaN NaN NaN
38586 44766 NaN NaN NaN
38587 44767 NaN NaN NaN
38588 44768 NaN NaN NaN
38598 44778 NaN NaN NaN
38601 44781 NaN NaN NaN
38603 44783 NaN NaN NaN
38607 44787 NaN NaN NaN
38608 44788 NaN NaN NaN
38611 44791 NaN NaN NaN
38615 44795 NaN NaN NaN
38617 44797 NaN NaN NaN
38618 44798 NaN NaN NaN
38619 44799 NaN NaN NaN
38620 44800 NaN NaN NaN
38621 44801 NaN NaN NaN
38622 44802 NaN NaN NaN
38623 44803 NaN NaN NaN
38624 44804 NaN NaN NaN
38625 44805 NaN NaN NaN
38648 44828 NaN NaN NaN
38650 44830 NaN NaN NaN
38651 44831 NaN NaN NaN
38653 44833 NaN NaN NaN
38654 44834 NaN NaN NaN
38658 44838 NaN NaN NaN
38661 44841 NaN NaN NaN
38662 44842 NaN NaN NaN
38669 44849 Sugawara Mitsushige Artist 1234
38670 44851 NaN NaN NaN
38671 44852 NaN NaN NaN
38672 44853 NaN NaN NaN
38673 44854 Ukita Ikkei Artist 1795
38676 44857 Gyokuen Bonpō Artist 1348
38679 44860 NaN NaN NaN
38680 44861 Tawaraya Sōtatsu|Hon'ami Kōetsu Artist|Artist 1570 |1558
38682 44863 Okumura Masanobu Artist 1686
38691 44874 NaN NaN NaN
38692 44875 NaN NaN NaN
38694 44877 NaN NaN NaN
38698 44881 NaN NaN NaN
38701 44884 NaN NaN NaN
38715 44898 NaN NaN NaN
38718 44905 NaN NaN NaN
38722 44909 Unidentified Artist Artist NaN
38723 44910 NaN NaN NaN
38724 44911 NaN NaN NaN
38726 44915 NaN NaN NaN
38755 44945 NaN NaN NaN
38870 45080 Shibata Zeshin Artist 1807
38875 45085 Suzuki Harunobu Artist 1725
38913 45190 NaN NaN NaN
38919 45198 NaN NaN NaN
38923 45202 Ryūshū Shūtaku (Myōtaku) Artist 1307
38924 45203 Ryūshū Shūtaku (Myōtaku) Artist 1307
38925 45204 Ryūshū Shūtaku (Myōtaku) Artist 1307
38930 45209 NaN NaN NaN
38935 45214 NaN NaN NaN
38938 45217 Kano Chikanobu Artist 1660
38970 45249 Unidentified Artist Artist NaN
38979 45258 Tosa Mitsunobu Artist 1462
39078 45358 NaN NaN NaN
39086 45366 NaN NaN NaN
39095 45375 NaN NaN NaN
39110 45392 Sakai Hōitsu Artist 1761
39130 45413 NaN NaN NaN
39131 45415 NaN NaN NaN
39164 45449 NaN NaN NaN
39171 45456 Shibata Zeshin|Ogata Kōrin Artist|Artist 1807 |1658
39204 45491 NaN NaN NaN
39205 45492 NaN NaN NaN
39237 45525 NaN NaN NaN
39244 45532 NaN NaN NaN
39249 45537 NaN NaN NaN
39329 45620 NaN NaN NaN
39330 45621 NaN NaN NaN
39343 45634 NaN NaN NaN
39361 45652 Fang Congyi Artist 1301
39368 45659 Wu Boli Artist 1350
39385 45676 Lin Liang Artist 1416
39455 45751 NaN NaN NaN
39517 45815 Lu Zhi Artist 1495
41217 47916 NaN NaN NaN
41870 48741 NaN NaN NaN
42061 48949 Dong Qichang Artist 1555
42062 48950 Dong Qichang Artist 1555
42217 49131 Fan Qi Artist 1616
42224 49138 NaN NaN NaN
42236 49150 Wang Hui Artist 1632
42237 49151 Wang Hui Artist 1632
42243 49158 Wu Li Artist 1632
42257 49173 Shitao (Zhu Ruoji) Artist 1642
42261 49177 Shitao (Zhu Ruoji) Artist 1642
42270 49187 Wang Yuanqi Artist 1642
42272 49189 NaN NaN NaN
42287 49204 NaN NaN NaN
42309 49227 Yuan Jiang Artist 1680
42330 49249 Unidentified Artist Artist NaN
42357 49276 NaN NaN NaN
42363 49282 NaN NaN NaN
42375 49294 NaN NaN NaN
42382 49301 NaN NaN NaN
42460 49380 NaN NaN NaN
42471 49391 NaN NaN NaN
42503 49423 Cornelis Pronk Artist 1691
42518 49438 NaN NaN NaN
42519 49439 NaN NaN NaN
42523 49444 NaN NaN NaN
42598 49519 NaN NaN NaN
42618 49539 NaN NaN NaN
42663 49591 NaN NaN NaN
42671 49599 NaN NaN NaN
42707 49637 Xu Beihong Artist 1895
42736 49670 Fu Baoshi Artist 1904
42871 49805 Zhang Daqian Artist 1899
42878 49812 NaN NaN NaN
42923 49865 NaN NaN NaN
43192 50165 NaN NaN NaN
43195 50170 NaN NaN NaN
43208 50197 NaN NaN NaN
43313 50305 NaN NaN NaN
43319 50313 NaN NaN NaN
43321 50315 NaN NaN NaN
43328 50322 NaN NaN NaN
43334 50328 NaN NaN NaN
43345 50339 NaN NaN NaN
43363 50357 NaN NaN NaN
43435 50444 NaN NaN NaN
43437 50446 NaN NaN NaN
43454 50484 NaN NaN NaN
43457 50487 NaN NaN NaN
43508 50549 Qiao Bin Artist 1481
43721 50781 NaN NaN NaN
43738 50799 NaN NaN NaN
43742 50803 NaN NaN NaN
43819 50897 An Gyeon Artist NaN
43855 50939 NaN NaN NaN
43870 50959 NaN NaN NaN
43950 51042 Su Xuejin Artist 1869
44191 51337 NaN NaN NaN
44432 51584 Qiu Ying Artist 1485
44433 51585 Unidentified Artist Artist NaN
44923 52109 NaN NaN NaN
44940 52163 NaN NaN NaN
44941 52164 NaN NaN NaN
44943 52166 NaN NaN NaN
45001 52251 NaN NaN NaN
45029 52279 NaN NaN NaN
45246 52514 Ogata Kenzan Artist 1663
45348 52618 NaN NaN NaN
45713 53201 NaN NaN NaN
46093 53625 NaN NaN NaN
46098 53630 NaN NaN NaN
46171 53714 NaN NaN NaN
46174 53717 NaN NaN NaN
46240 53832 Nonomura Ninsei Artist 1646
46335 53939 NaN NaN NaN
46347 53952 NaN NaN NaN
46471 54080 NaN NaN NaN
46626 54245 NaN NaN NaN
46723 54383 Utagawa Kunisada Artist 1786
46863 54523 Kubo Shunman Artist 1757
47023 54683 Kubo Shunman Artist 1757
47063 54723 Kubo Shunman Artist 1757
47227 54894 Ryūryūkyo Shinsai Artist 1799
47298 54965 Kubo Shunman Artist 1757
47434 55103 Reisai Artist 1700
47812 55495 Zhao Zhiqian Artist 1829
47817 55500 Yōshū (Hashimoto) Chikanobu Artist 1838
47912 55597 Okumura Masanobu Artist 1686
47935 55621 NaN NaN NaN
48061 55754 Okumura Masanobu Artist 1686
48553 56277 NaN NaN NaN
48579 56382 NaN NaN NaN
48815 56689 Utagawa Hiroshige Artist 1797
48900 56784 NaN NaN NaN
49027 56915 Utagawa Hiroshige Artist 1797
49271 57166 Suzuki Shōnen Artist 1849
49443 57343 NaN NaN NaN
49676 57585 Kōami School Artist 1750
49678 57587 NaN NaN NaN
49682 57594 NaN NaN NaN
49686 57603 NaN NaN NaN
49693 57612 NaN NaN NaN
49900 57870 NaN NaN NaN
49902 57872 NaN NaN NaN
49903 57873 NaN NaN NaN
49904 57874 NaN NaN NaN
49905 57875 NaN NaN NaN
49906 57876 NaN NaN NaN
49907 57877 NaN NaN NaN
49910 57880 NaN NaN NaN
49911 57881 NaN NaN NaN
49912 57882 NaN NaN NaN
49913 57883 NaN NaN NaN
49914 57884 NaN NaN NaN
49915 57885 NaN NaN NaN
49916 57886 NaN NaN NaN
49917 57887 NaN NaN NaN
49918 57888 NaN NaN NaN
49919 57889 NaN NaN NaN
49920 57890 NaN NaN NaN
49921 57891 NaN NaN NaN
49922 57892 NaN NaN NaN
49923 57893 NaN NaN NaN
49924 57894 NaN NaN NaN
49925 57895 NaN NaN NaN
49926 57896 NaN NaN NaN
49927 57897 NaN NaN NaN
49928 57898 NaN NaN NaN
49939 57915 NaN NaN NaN
50084 58075 NaN NaN NaN
50154 58251 NaN NaN NaN
50282 58412 NaN NaN NaN
50481 58628 Nomura Kyūkoku Artist 1800
50599 58768 NaN NaN NaN
50678 58855 NaN NaN NaN
50755 58935 NaN NaN NaN
50756 58936 NaN NaN NaN
51022 59203 NaN NaN NaN
51032 59213 NaN NaN NaN
51092 59273 NaN NaN NaN
51218 59399 NaN NaN NaN
51507 59700 NaN NaN NaN
51790 60002 Shūōsai Artist NaN
51933 60152 NaN NaN NaN
51962 60181 NaN NaN NaN
52109 60329 Ryūsa Artist 1767
52120 60342 NaN NaN NaN
52162 60390 NaN NaN NaN
52195 60443 Unidentified Artist Artist NaN
52212 60467 Musō Soseki Artist 1275
52235 60514 NaN NaN NaN
52379 60662 NaN NaN NaN
52389 60672 NaN NaN NaN
52637 60930 NaN NaN NaN
52753 61053 NaN NaN NaN
52770 61070 NaN NaN NaN
52898 61198 NaN NaN NaN
52944 61245 NaN NaN NaN
53302 61658 NaN NaN NaN
53463 61820 NaN NaN NaN
53575 61946 NaN NaN NaN
53603 61974 NaN NaN NaN
53630 62002 Unidentified Artist Artist NaN
53910 62314 NaN NaN NaN
53911 62315 NaN NaN NaN
53912 62316 NaN NaN NaN
53913 62317 NaN NaN NaN
53914 62318 NaN NaN NaN
53915 62319 NaN NaN NaN
53916 62320 NaN NaN NaN
53917 62321 NaN NaN NaN
53918 62322 NaN NaN NaN
53919 62323 NaN NaN NaN
53920 62324 NaN NaN NaN
53921 62325 NaN NaN NaN
53922 62326 NaN NaN NaN
53970 62374 NaN NaN NaN
54115 62526 NaN NaN NaN
54151 62562 NaN NaN NaN
54473 62898 Chōjirō Artist 1516
54483 62908 NaN NaN NaN
54513 62938 NaN NaN NaN
54673 63103 NaN NaN NaN
54713 63143 Nonomura Ninsei Artist 1646
54915 63358 Utagawa Kuniyasu Artist 1794
55078 63532 NaN NaN NaN
55226 63680 NaN NaN NaN
55623 64086 NaN NaN NaN
55630 64110 Nakamura Takuo Artist 1945
55633 64113 Miyashita Zenji Artist 1939
55635 64116 NaN NaN NaN
55914 64533 NaN NaN NaN
55934 64871 NaN NaN NaN
55938 64881 NaN NaN NaN
55942 64890 NaN NaN NaN
55999 65038 Unidentified Artist Artist NaN
56003 65062 NaN NaN NaN
56025 65100 NaN NaN NaN
56242 65354 NaN NaN NaN
56273 65584 NaN NaN NaN
56275 65586 Tawaraya Sōtatsu Artist 1570
56276 65587 NaN NaN NaN
56289 65605 NaN NaN NaN
56292 65609 NaN NaN NaN
56294 65611 NaN NaN NaN
56353 65686 NaN NaN NaN
58920 68285 NaN NaN NaN
59143 68508 NaN NaN NaN
61072 70499 NaN NaN NaN
61336 70768 NaN NaN NaN
62788 72325 NaN NaN NaN
62804 72381 NaN NaN NaN
62824 72435 Sakiyama Takayuki Artist 1958
62832 72499 NaN NaN NaN
62843 72545 Nainsukh Artist 1725
62851 72589 Stipple Master|Jai Ram Artist|Artist 1680
62865 72606 Unidentified Artist Artist NaN
62870 72629 NaN NaN NaN
62894 72719 NaN NaN NaN
62905 72738 NaN NaN NaN
62906 72739 NaN NaN NaN
62926 72775 Xu Beihong Artist 1895
62968 72828 Tsukioka Yoshitoshi Artist 1839
63266 73134 Unidentified Artist Artist NaN
63276 73146 NaN NaN NaN
63280 73150 NaN NaN NaN
63283 73158 NaN NaN NaN
63291 73167 Kano Takanobu Artist 1571
63295 73175 NaN NaN NaN
63303 73193 Kano Tan'yū Artist 1602
63305 73200 NaN NaN NaN
63310 73210 NaN NaN NaN
63315 73218 NaN NaN NaN
63318 73222 NaN NaN NaN
63354 73261 Chokha Artist 1799
63420 73370 Unidentified Artist Artist NaN
63425 73383 NaN NaN NaN
63446 73404 NaN NaN NaN
63458 73416 Utagawa (Gountei) Sadahide Artist 1807
63678 73646 Gao Cen Artist 1643
63684 73657 Yu Peng Artist 1955
63687 73666 NaN NaN NaN
63968 74363 Ike Taiga Artist 1723
64029 74425 NaN NaN NaN
64038 74448 Unidentified Artist Artist NaN
64066 74501 NaN NaN NaN
64067 74502 NaN NaN NaN
64170 74675 Nainsukh Artist 1725
64259 74883 NaN NaN NaN
64543 75174 NaN NaN NaN
64554 75244 NaN NaN NaN
64593 75372 Kano Einō Artist 1631
64715 75745 Fa Ruozhen Artist 1613
64716 75746 Shibata Zeshin Artist 1807
64726 75822 NaN NaN NaN
64796 75938 NaN NaN NaN
64820 76115 Unidentified Artist Artist NaN
64829 76445 NaN NaN NaN
64922 76769 NaN NaN NaN
64961 76970 Kohei Nawa Artist 1975
65108 77814 Unidentified Artist Artist NaN
aa_toah_df['Artist Display Name'].value_counts()
Unidentified Artist                                               27
Kubo Shunman                                                       4
Nainsukh                                                           3
Okumura Masanobu                                                   3
Utagawa Hiroshige                                                  3
Ryūshū Shūtaku (Myōtaku)                                           3
Ma Yuan                                                            2
Wen Zhengming                                                      2
Ruan Zude                                                          2
Xu Beihong                                                         2
Shitao (Zhu Ruoji)                                                 2
Shibata Zeshin                                                     2
Nonomura Ninsei                                                    2
Bada Shanren (Zhu Da)                                              2
Wang Hui                                                           2
Dong Qichang                                                       2
Kohei Nawa                                                         1
Mi Fu                                                              1
Bagta                                                              1
Kano Motonobu                                                      1
Utagawa (Gountei) Sadahide                                         1
Liang Kai                                                          1
Lu Zhi                                                             1
Lidi|Unidentified Artist                                           1
Lin Liang                                                          1
Kano Chikanobu                                                     1
Chen Yanqing                                                       1
Wu Zhen                                                            1
Wu Boli                                                            1
Wang Hui|Wang Shimin                                               1
Ogata Kenzan                                                       1
Ni Zan                                                             1
Cornelis Pronk                                                     1
Kōami School                                                       1
Tawaraya Sōtatsu                                                   1
Yi Yuwon                                                           1
Zhu Sansong                                                        1
Empress Yang Meizi                                                 1
Utagawa Kunisada                                                   1
Chōjirō                                                            1
Zhao Mengjian                                                      1
Isamu Noguchi                                                      1
Bhima|Kesu Ram|Bhopa|Nathu                                         1
Nomura Kyūkoku                                                     1
Tsukioka Yoshitoshi                                                1
Unidentified Artists                                               1
Wang Shimin                                                        1
Ukita Ikkei                                                        1
Stipple Master|Jai Ram                                             1
Yelü Chucai                                                        1
Fan Qi                                                             1
Fa Ruozhen                                                         1
Lan Ying                                                           1
Miyashita Zenji                                                    1
Chen Hongshou                                                      1
Gyokuen Bonpō                                                      1
Tosa Mitsunobu                                                     1
Master of the "Isarda" Bhagavata Purana                            1
Nagasawa Rosetsu                                                   1
Kuncan                                                             1
Gao Cen                                                            1
Lu Guang                                                           1
Reisai                                                             1
Chokha                                                             1
Wang Yuanqi                                                        1
Wu Changshuo                                                       1
Wang Zhen                                                          1
Gong Xian                                                          1
Mi Youren                                                          1
Sōami                                                              1
Ryūryūkyo Shinsai                                                  1
Zhang Daqian                                                       1
Shi Lu                                                             1
Sakai Hōitsu                                                       1
Wang Hui|Wang Hui                                                  1
Kano Takanobu                                                      1
Sugawara Mitsushige                                                1
Utagawa Kuniyasu                                                   1
Ogata Kōrin                                                        1
Shibata Zeshin|Ogata Kōrin                                         1
Kyūen Ryūchin|Kōshi Ehō|Nankō Sōgen|Zuigan Ryūsei|Chikkō Zengo     1
Zhang Family Workshop                                              1
Kano Tan'yū                                                        1
Zhang Yucai                                                        1
Fang Congyi                                                        1
Yōshū (Hashimoto) Chikanobu                                        1
Qiu Ying                                                           1
Ike Taiga                                                          1
Sakiyama Takayuki                                                  1
Zhang Xihuang                                                      1
An Gyeon                                                           1
Ma Lin                                                             1
Su Xuejin                                                          1
Xia Gui                                                            1
Shen Quan                                                          1
Musō Soseki                                                        1
Fu Baoshi                                                          1
Xie Huan                                                           1
Li Gonglin                                                         1
Zhao Mengfu                                                        1
Dasoja of Balligrama                                               1
Wu Li                                                              1
Dong Yuan                                                          1
Zhou Dongqing                                                      1
Sahib Ram                                                          1
Suzuki Harunobu                                                    1
Yu Peng                                                            1
Tosa Mitsuyoshi                                                    1
Ryūsa                                                              1
Nakamura Takuo                                                     1
Yuan Jiang                                                         1
Hamada Shōji                                                       1
Tawaraya Sōtatsu|Hon'ami Kōetsu                                    1
Qiao Bin                                                           1
Zhao Zhiqian                                                       1
Shūōsai                                                            1
Zhao Cangyun                                                       1
Xia Chang                                                          1
Chotu                                                              1
Xu Yang                                                            1
Wang Meng                                                          1
Kano Einō                                                          1
Suzuki Shōnen                                                      1
Name: Artist Display Name, dtype: int64

Fill in collection (P195) to proper department at The Met

Generate Quickstatements to add this to existing highlighted Costume Institute items in Wikidata

Set reference info to "stated in"->"Metropolitan Museum of Art"

Should look like this:

Q29383383|P195|Q67087093|S248|Q160236

collection_prop = 'P195'
costumeinstitute_qid = 'Q67087093'
statedin_prop = 'S248'
met_qid = 'Q160236'

for index, row in costume_merged_df.iterrows():
    print ('Q{}|{}|{}|{}|{}'.format(row['qid'],collection_prop, costumeinstitute_qid,statedin_prop,met_qid))
Q29383383|P195|Q67087093|S248|Q160236
Q29383386|P195|Q67087093|S248|Q160236
Q29383388|P195|Q67087093|S248|Q160236
Q29383391|P195|Q67087093|S248|Q160236
Q29383393|P195|Q67087093|S248|Q160236
Q29383396|P195|Q67087093|S248|Q160236
Q29383398|P195|Q67087093|S248|Q160236
Q29383401|P195|Q67087093|S248|Q160236
Q29383403|P195|Q67087093|S248|Q160236
Q29383407|P195|Q67087093|S248|Q160236
Q29383409|P195|Q67087093|S248|Q160236
Q29383412|P195|Q67087093|S248|Q160236
Q7979098|P195|Q67087093|S248|Q160236
Q29383416|P195|Q67087093|S248|Q160236
Q29383419|P195|Q67087093|S248|Q160236
Q29383423|P195|Q67087093|S248|Q160236
Q29383426|P195|Q67087093|S248|Q160236
Q29383430|P195|Q67087093|S248|Q160236
Q29383434|P195|Q67087093|S248|Q160236
Q29383437|P195|Q67087093|S248|Q160236
Q29383439|P195|Q67087093|S248|Q160236
Q29383442|P195|Q67087093|S248|Q160236
Q29383446|P195|Q67087093|S248|Q160236
Q29383451|P195|Q67087093|S248|Q160236
Q64160175|P195|Q67087093|S248|Q160236
Q29383454|P195|Q67087093|S248|Q160236
Q4115189|P195|Q67087093|S248|Q160236
Q29003788|P195|Q67087093|S248|Q160236
Q29383456|P195|Q67087093|S248|Q160236
Q29383459|P195|Q67087093|S248|Q160236
Q29383466|P195|Q67087093|S248|Q160236
Q29383470|P195|Q67087093|S248|Q160236
Q29383477|P195|Q67087093|S248|Q160236
Q29383485|P195|Q67087093|S248|Q160236
Q29383492|P195|Q67087093|S248|Q160236
Q29383496|P195|Q67087093|S248|Q160236
Q29383499|P195|Q67087093|S248|Q160236
Q29383502|P195|Q67087093|S248|Q160236
Q29383505|P195|Q67087093|S248|Q160236
Q29383510|P195|Q67087093|S248|Q160236
Q29383513|P195|Q67087093|S248|Q160236
Q30063394|P195|Q67087093|S248|Q160236

Start looping through entries in TOAH

%%time
# Let's separate them out by parsing the | symbols

# Initialize a dict for storage
dict = {'entity':[],'type':[]}


# Loop over all entries to get the different fields for Artist
# Maybe there's a more Pythonic way using apply()
for index, row in aa_toah_df.iterrows():
    # Split each of these on the lines of the pipe | character
    # Use extend vs append so that the elements of the passed list are individual added
    if isinstance(row['Artist Display Name'],str): 
        dict['entity'].extend([x.strip() for x in row['Artist Display Name'].split('|')])
    if isinstance(row['Artist Role'],str): 
        dict['type'].extend([x.strip() for x in row['Artist Role'].split('|')])

# Make a dataframe out of the dict created above
creators_df = pd.DataFrame(
    {
     'entity': dict['entity'],
     'type'  : dict['type']
    }
)

creators_df.describe()

# Make a new dataframe of unique combos of entity-type (eg. Bill Blass:Designer) to aid in reconciliation
uniq_creators_df = creators_df.drop_duplicates()
uniq_creators_df.describe()
CPU times: user 96 ms, sys: 0 ns, total: 96 ms
Wall time: 95.1 ms
uniq_creators_df['type'].value_counts()
Artist          128
Calligrapher      1
Name: type, dtype: int64
uniq_creators_df['entity'].value_counts()
Wang Hui                                   2
Mi Fu                                      1
Zhao Mengfu                                1
Ryūryūkyo Shinsai                          1
Xu Beihong                                 1
Chikkō Zengo                               1
Kano Motonobu                              1
Bagta                                      1
Kohei Nawa                                 1
Zhao Zhiqian                               1
Kano Chikanobu                             1
Lin Liang                                  1
Yōshū (Hashimoto) Chikanobu                1
Wu Zhen                                    1
Wu Boli                                    1
Ma Yuan                                    1
Utagawa Kuniyasu                           1
Shitao (Zhu Ruoji)                         1
Kubo Shunman                               1
Ogata Kenzan                               1
Miyashita Zenji                            1
Cornelis Pronk                             1
Kōshi Ehō                                  1
Kōami School                               1
Tawaraya Sōtatsu                           1
Yi Yuwon                                   1
Wang Zhen                                  1
Bhima                                      1
Chokha                                     1
Mi Youren                                  1
Fu Baoshi                                  1
Liang Kai                                  1
Lu Zhi                                     1
Zhu Sansong                                1
Lan Ying                                   1
Zhao Mengjian                              1
Isamu Noguchi                              1
Nomura Kyūkoku                             1
Tsukioka Yoshitoshi                        1
Ryūshū Shūtaku (Myōtaku)                   1
Unidentified Artists                       1
Wang Shimin                                1
Ukita Ikkei                                1
Yelü Chucai                                1
Fan Qi                                     1
Fa Ruozhen                                 1
Chōjirō                                    1
Kyūen Ryūchin                              1
Bada Shanren (Zhu Da)                      1
Chen Yanqing                               1
Chen Hongshou                              1
Gyokuen Bonpō                              1
Tosa Mitsunobu                             1
Master of the "Isarda" Bhagavata Purana    1
Nagasawa Rosetsu                           1
Gao Cen                                    1
Lu Guang                                   1
Zuigan Ryūsei                              1
Reisai                                     1
Empress Yang Meizi                         1
Wang Yuanqi                                1
Wu Changshuo                               1
Utagawa Kunisada                           1
Li Gonglin                                 1
Dasoja of Balligrama                       1
Shibata Zeshin                             1
Stipple Master                             1
Zhang Daqian                               1
Jai Ram                                    1
Shi Lu                                     1
Sakai Hōitsu                               1
Kano Takanobu                              1
Sugawara Mitsushige                        1
Okumura Masanobu                           1
Lidi                                       1
Ogata Kōrin                                1
Zhang Family Workshop                      1
Wu Li                                      1
Sōami                                      1
Unidentified Artist                        1
Zhang Yucai                                1
Shen Quan                                  1
Wen Zhengming                              1
Fang Congyi                                1
Ni Zan                                     1
Qiu Ying                                   1
Ike Taiga                                  1
Sakiyama Takayuki                          1
Nainsukh                                   1
Utagawa Hiroshige                          1
Zhang Xihuang                              1
An Gyeon                                   1
Ma Lin                                     1
Su Xuejin                                  1
Xia Gui                                    1
Bhopa                                      1
Kano Tan'yū                                1
Gong Xian                                  1
Hamada Shōji                               1
Kesu Ram                                   1
Hon'ami Kōetsu                             1
Dong Yuan                                  1
Zhou Dongqing                              1
Sahib Ram                                  1
Suzuki Harunobu                            1
Yu Peng                                    1
Wang Meng                                  1
Tosa Mitsuyoshi                            1
Ryūsa                                      1
Ruan Zude                                  1
Xie Huan                                   1
Nakamura Takuo                             1
Nankō Sōgen                                1
Musō Soseki                                1
Nonomura Ninsei                            1
Dong Qichang                               1
Qiao Bin                                   1
Nathu                                      1
Shūōsai                                    1
Zhao Cangyun                               1
Xia Chang                                  1
Chotu                                      1
Xu Yang                                    1
Kuncan                                     1
Utagawa (Gountei) Sadahide                 1
Kano Einō                                  1
Yuan Jiang                                 1
Suzuki Shōnen                              1
Name: entity, dtype: int64
# All unique Designers from Costume Institute
creators_df[creators_df['type'].
                         str.contains("Artist")]['entity'].value_counts()
Unidentified Artist                        28
Wang Hui                                    4
Kubo Shunman                                4
Okumura Masanobu                            3
Shibata Zeshin                              3
Ryūshū Shūtaku (Myōtaku)                    3
Utagawa Hiroshige                           3
Nainsukh                                    3
Ma Yuan                                     2
Wen Zhengming                               2
Ogata Kōrin                                 2
Bada Shanren (Zhu Da)                       2
Nonomura Ninsei                             2
Shitao (Zhu Ruoji)                          2
Dong Qichang                                2
Ruan Zude                                   2
Wang Shimin                                 2
Xu Beihong                                  2
Tawaraya Sōtatsu                            2
Bagta                                       1
Kano Motonobu                               1
Kohei Nawa                                  1
Chikkō Zengo                                1
Zhao Zhiqian                                1
Kano Chikanobu                              1
Lin Liang                                   1
Mi Fu                                       1
Yōshū (Hashimoto) Chikanobu                 1
Wu Zhen                                     1
Wu Boli                                     1
Liang Kai                                   1
Utagawa Kuniyasu                            1
Ogata Kenzan                                1
Miyashita Zenji                             1
Cornelis Pronk                              1
Kōshi Ehō                                   1
Kōami School                                1
Yi Yuwon                                    1
Ryūryūkyo Shinsai                           1
Wu Changshuo                                1
Lu Zhi                                      1
Chen Hongshou                               1
Zhao Mengjian                               1
Isamu Noguchi                               1
Nomura Kyūkoku                              1
Tsukioka Yoshitoshi                         1
Unidentified Artists                        1
Ukita Ikkei                                 1
Yelü Chucai                                 1
Fan Qi                                      1
Fa Ruozhen                                  1
Chōjirō                                     1
Kyūen Ryūchin                               1
Lan Ying                                    1
Gyokuen Bonpō                               1
Zhu Sansong                                 1
Tosa Mitsunobu                              1
Master of the "Isarda" Bhagavata Purana     1
Nagasawa Rosetsu                            1
Gao Cen                                     1
Lu Guang                                    1
Zuigan Ryūsei                               1
Reisai                                      1
Empress Yang Meizi                          1
Wang Yuanqi                                 1
Bhima                                       1
Utagawa Kunisada                            1
Chen Yanqing                                1
Wang Zhen                                   1
Dasoja of Balligrama                        1
Chokha                                      1
Wu Li                                       1
Musō Soseki                                 1
Kano Tan'yū                                 1
Shen Quan                                   1
Bhopa                                       1
Zhang Daqian                                1
Jai Ram                                     1
Shi Lu                                      1
Sakai Hōitsu                                1
Kano Takanobu                               1
Sugawara Mitsushige                         1
Lidi                                        1
Zhang Family Workshop                       1
Sōami                                       1
Mi Youren                                   1
Stipple Master                              1
Zhang Yucai                                 1
Fang Congyi                                 1
Ni Zan                                      1
Qiu Ying                                    1
Ike Taiga                                   1
Sakiyama Takayuki                           1
Zhang Xihuang                               1
An Gyeon                                    1
Ma Lin                                      1
Su Xuejin                                   1
Xia Gui                                     1
Yuan Jiang                                  1
Kano Einō                                   1
Utagawa (Gountei) Sadahide                  1
Kuncan                                      1
Fu Baoshi                                   1
Li Gonglin                                  1
Zhao Mengfu                                 1
Gong Xian                                   1
Kesu Ram                                    1
Hon'ami Kōetsu                              1
Dong Yuan                                   1
Zhou Dongqing                               1
Sahib Ram                                   1
Suzuki Harunobu                             1
Yu Peng                                     1
Wang Meng                                   1
Tosa Mitsuyoshi                             1
Ryūsa                                       1
Xie Huan                                    1
Nakamura Takuo                              1
Hamada Shōji                                1
Nankō Sōgen                                 1
Qiao Bin                                    1
Nathu                                       1
Shūōsai                                     1
Zhao Cangyun                                1
Xia Chang                                   1
Chotu                                       1
Xu Yang                                     1
Suzuki Shōnen                               1
Name: entity, dtype: int64

Examples of the complexity of dates!

aa_toah_df['Object Date'].value_counts()
19th century                                                                            49
18th century                                                                            29
late 11th century B.C.                                                                  14
12th century                                                                            13
14th century                                                                            12
17th century                                                                             8
15th century                                                                             7
16th century                                                                             7
early 17th century                                                                       7
late 18th–early 19th century                                                             7
11th century                                                                             6
10th–11th century                                                                        6
5th–6th century                                                                          6
late 14th–early 15th century                                                             5
15th–16th century                                                                        5
late 7th century                                                                         5
late 13th–14th century                                                                   5
ca. 500 B.C.–A.D. 300                                                                    5
7th century                                                                              5
14th–15th century                                                                        5
10th century                                                                             5
early 14th century                                                                       5
late 19th century                                                                        5
11th–12th century                                                                        4
second half of the 19th century                                                          4
late 19th–early 20th century                                                             4
early 15th century                                                                       4
9th century                                                                              4
5th century                                                                              4
early 18th century                                                                       4
early 13th century                                                                       4
late 14th century                                                                        4
ca. 15th century                                                                         4
late 18th century                                                                        4
late 16th–early 17th century                                                             4
8th century                                                                              4
18th–19th century                                                                        4
early 12th century                                                                       4
mid-16th century                                                                         3
late 13th century                                                                        3
late 15th century                                                                        3
8th–early 9th century                                                                    3
early 20th century                                                                       3
ca. 1780                                                                                 3
mid-19th century                                                                         3
last quarter of the 10th–first half of the 11th century                                  3
13th–14th century                                                                        3
1st century B.C.–1st century A.D.                                                        3
late 13th–early 14th century                                                             3
7th–9th century                                                                          3
late 16th century                                                                        3
ca. 1840                                                                                 3
ca. 1st century B.C.                                                                     3
12th–13th century                                                                        3
ca. 1695                                                                                 2
late 12th–early 13th century                                                             2
1st–early 3rd century                                                                    2
early 8th century                                                                        2
early 6th century                                                                        2
14th–mid-16th century                                                                    2
ca. 2nd century                                                                          2
ca. 1700                                                                                 2
first half of the 17th century                                                           2
4th century B.C.                                                                         2
late 15th–early 16th century                                                             2
13th–11th century B.C.                                                                   2
1st century                                                                              2
17th–18th century                                                                        2
second half of the 15th century                                                          2
ca. 4th century B.C.                                                                     2
mid-18th century                                                                         2
8th century B.C.                                                                         2
late 17th–early 18th century                                                             2
7th–early 8th century                                                                    2
3rd century                                                                              2
ca. 4th century                                                                          2
ca. 4th–5th century                                                                      2
last quarter of 16th century                                                             2
2001                                                                                     2
ca. 1915–35                                                                              2
8th–9th century                                                                          2
13th century                                                                             2
late 10th–early 11th century                                                             2
late 9th–early 8th century B.C.                                                          2
ca. 1625                                                                                 2
mid-to-late 6th century                                                                  2
2nd–1st century B.C.                                                                     2
Silla Kingdom, 5th century                                                               2
early 19th century                                                                       2
ca. 1350                                                                                 2
ca. 3rd century                                                                          2
end of the 5th century                                                                   2
dated "xinyou" (1561 or 1621?)                                                           2
late 17th century                                                                        2
6th–7th century                                                                          2
late 17th–18th century                                                                   2
20th century                                                                             2
ca. 1770                                                                                 2
ca. 1670–90                                                                              2
ca. 1st century                                                                          2
early 5th century B.C.                                                                   2
13th–12th century B.C.                                                                   1
dated 1240                                                                               1
1856                                                                                     1
ca. 1360–70                                                                              1
dated 1257                                                                               1
dated 1454                                                                               1
late 4th–early 5th century                                                               1
ca. 1712                                                                                 1
ca. 1876                                                                                 1
November 1887                                                                            1
ca. 1858                                                                                 1
second half of the 9th century                                                           1
dated 1630                                                                               1
ca. 1310–20                                                                              1
dated 1438                                                                               1
ca. 500 B.C.–A.D. 100                                                                    1
1666                                                                                     1
dated 1482                                                                               1
13th century B.C.                                                                        1
ca. 1850                                                                                 1
ca. 1622–25                                                                              1
2011                                                                                     1
ca. 130                                                                                  1
second half of the 18th century–first half of the 19th century                           1
ca. 744                                                                                  1
ca. 1200–50                                                                              1
late 12th–13th century                                                                   1
second half of the 18th century                                                          1
ca. 1600                                                                                 1
dated 1716                                                                               1
(right screen) late 16th–early 17th century; (left screen) early to mid-17th century     1
dated 1770                                                                               1
ca. second half of the 11th century                                                      1
1650–75                                                                                  1
dated 1606                                                                               1
1543                                                                                     1
dated 1674 and 1677                                                                      1
1667                                                                                     1
ca. 1450–1500                                                                            1
mid-6th century                                                                          1
6th–8th century                                                                          1
1635–45                                                                                  1
mid-17th century                                                                         1
mid-13th century                                                                         1
ca. 1972                                                                                 1
1000–300 B.C.                                                                            1
second half of the 7th century                                                           1
1813                                                                                     1
9th–10th century                                                                         1
first quarter of the 10th century                                                        1
late 6th century                                                                         1
late 12th century                                                                        1
ca. first half of the 3rd century                                                        1
ca. 1810–18                                                                              1
late 7th–first half of the 8th century                                                   1
dated 1996                                                                               1
1st to mid-2nd century                                                                   1
1691                                                                                     1
late 11th century                                                                        1
4th century                                                                              1
ca. 1660                                                                                 1
dated 1767                                                                               1
mid- 15th century                                                                        1
ca. 1330–32                                                                              1
ca. 1720                                                                                 1
ca. 1800                                                                                 1
1684                                                                                     1
dated 1679                                                                               1
before 1200                                                                              1
ca. 1745–50                                                                              1
early to mid-12th century                                                                1
after 1709                                                                               1
ca. 1833–34                                                                              1
mid-7th century                                                                          1
ca. 1800–10                                                                              1
dated 1673                                                                               1
early 16th century                                                                       1
ca. 1085                                                                                 1
dated 1542                                                                               1
ca. late 7th–first half of  the 8th century                                              1
late 18th–19th century                                                                   1
Dated 1669                                                                               1
last quarter of the 11th century                                                         1
ca. 1679                                                                                 1
late 6th–early 7th century                                                               1
second quarter of the 8th century                                                        1
mid-3rd millennium B.C.                                                                  1
second half of the 11th century                                                          1
second half of the 16th century                                                          1
1965                                                                                     1
ca. 1860–70                                                                              1
ca. 1620                                                                                 1
ca. 1824                                                                                 1
ca. 1650                                                                                 1
ca. 1540                                                                                 1
1690–1700s                                                                               1
ca. late 6th century                                                                     1
5th–3rd century B.C.                                                                     1
1795–99                                                                                  1
dated 1669                                                                               1
3rd century B.C.                                                                         1
3rd–1st century B.C.                                                                     1
dated 1942                                                                               1
1st–2nd century                                                                          1
dated 1291                                                                               1
1885                                                                                     1
7th–8th century                                                                          1
3rd–5th century                                                                          1
1363                                                                                     1
dated 1702                                                                               1
active first half of the19th century                                                     1
ca. 2000 B.C.                                                                            1
first half of the 12th century                                                           1
dated 1662                                                                               1
dated 1919                                                                               1
colophon dated 1641                                                                      1
ca. 10th century                                                                         1
mid-1st century                                                                          1
1764–72                                                                                  1
ca. 1560–65                                                                              1
ca. 1868–90                                                                              1
dated 1774                                                                               1
1000–300 BC                                                                              1
first quarter of the 12th century                                                        1
3rd–2nd century B.C.                                                                     1
last quarter of 10th–first half of 11th century                                          1
ca. 1000                                                                                 1
dated 1760                                                                               1
ca. 1610                                                                                 1
ca. last quarter of the 7th century–early 8th century                                    1
ca. 1340                                                                                 1
dated 1888                                                                               1
late 9th century                                                                         1
6th century                                                                              1
ca. late 13th century                                                                    1
ca. late 9th century                                                                     1
before 1460                                                                              1
dated 1699                                                                               1
dated 1736                                                                               1
ca. 14th century                                                                         1
1986                                                                                     1
9th or 10th century                                                                      1
ca. 1690–1730                                                                            1
second half of the 18th–19th century                                                     1
ca. 764–70                                                                               1
4th–5th century                                                                          1
ca. 1630–40                                                                              1
ca. 100–300                                                                              1
ca. late 17th century                                                                    1
1310s                                                                                    1
11th or early 12th century                                                               1
13th century or later                                                                    1
ca. 1551                                                                                 1
mid- to late 7th century                                                                 1
10th–9th century B.C.                                                                    1
1750                                                                                     1
ca. 1370                                                                                 1
mid- 7th century                                                                         1
9th month, 1861                                                                          1
late 12th–14th century                                                                   1
ca. 13th century                                                                         1
second quarter of the 13th century                                                       1
ca. 15th–16th century                                                                    1
first half of the 18th century                                                           1
ca. 1960                                                                                 1
dated 486                                                                                1
first half of the 14th century                                                           1
1st–2nd century B.C.                                                                     1
2nd century                                                                              1
first half 19th century                                                                  1
one leaf dated 1619                                                                      1
late 6th–7th century                                                                     1
ca. 550–560                                                                              1
Machang phase, ca. 2350–2050 B.C.                                                        1
300 B.C.–200 A.D.                                                                        1
dated 1282                                                                               1
ca. 1736–44                                                                              1
3600–1000 B.C.                                                                           1
dated 1666                                                                               1
late 15th–early 17th century                                                             1
12th–11th century B.C.                                                                   1
before 1056                                                                              1
13th–10th century B.C.                                                                   1
dated 1928                                                                               1
ca. 1369                                                                                 1
A.D. 5–6                                                                                 1
ca. 1095                                                                                 1
dated 489–95                                                                             1
5th–early 6th century                                                                    1
first half of the 16th century                                                           1
12th–14th century                                                                        1
18th–early 19th century                                                                  1
dated 1711                                                                               1
16th–17th century                                                                        1
ca. 11th century                                                                         1
ca. second half of the 12th–early 13th century                                           1
first half of the 19th century                                                           1
late 7th–early 8th century                                                               1
dated 1932                                                                               1
second half of the 3rd century                                                           1
early 2nd century                                                                        1
dated 1947                                                                               1
ca. 1437                                                                                 1
second half of the 17th century                                                          1
ca. 1100                                                                                 1
second half of the 13th century                                                          1
ca. 1725                                                                                 1
1808                                                                                     1
dated by inscription to ca. 600                                                          1
6th–9th century                                                                          1
2nd–3rd century                                                                          1
ca. first half of the 10th century                                                       1
2004                                                                                     1
late 8th–early 9th century                                                               1
ca. 1735                                                                                 1
1816                                                                                     1
equivalent to February / March 1322                                                      1
mid-14th century                                                                         1
1551                                                                                     1
mid-16th–early 17th century                                                              1
ca. 1823                                                                                 1
ca. 1775–80                                                                              1
ca. 1734–37                                                                              1
ca. 2nd–4th century                                                                      1
ca. 1460                                                                                 1
late 16th–17th century                                                                   1
dated 1867                                                                               1
ca. 1400                                                                                 1
ca. first quarter of the 10th century                                                    1
last quarter of the 8th century                                                          1
Name: Object Date, dtype: int64
 

Process Met highlights from Costume Institute missing

aa_toah_df.info()
<class 'pandas.core.frame.DataFrame'>
Int64Index: 697 entries, 30335 to 65108
Data columns (total 44 columns):
Object Number              697 non-null object
Is Highlight               697 non-null bool
Is Public Domain           697 non-null bool
Object ID                  697 non-null int64
Department                 697 non-null object
Object Name                697 non-null object
Title                      353 non-null object
Culture                    697 non-null object
Period                     569 non-null object
Dynasty                    0 non-null object
Reign                      0 non-null object
Portfolio                  0 non-null object
Artist Role                170 non-null object
Artist Prefix              28 non-null object
Artist Display Name        170 non-null object
Artist Display Bio         137 non-null object
Artist Suffix              18 non-null object
Artist Alpha Sort          170 non-null object
Artist Nationality         126 non-null object
Artist Begin Date          134 non-null object
Artist End Date            135 non-null object
Object Date                653 non-null object
Object Begin Date          697 non-null int64
Object End Date            697 non-null int64
Medium                     697 non-null object
Dimensions                 697 non-null object
Credit Line                697 non-null object
Geography Type             0 non-null object
City                       0 non-null object
State                      0 non-null object
County                     0 non-null object
Country                    0 non-null object
Region                     0 non-null object
Subregion                  0 non-null object
Locale                     0 non-null object
Locus                      0 non-null object
Excavation                 0 non-null object
River                      0 non-null object
Classification             697 non-null object
Rights and Reproduction    6 non-null object
Link Resource              697 non-null object
Metadata Date              697 non-null object
Repository                 697 non-null object
Tags                       640 non-null object
dtypes: bool(2), int64(3), object(39)
memory usage: 235.5+ KB
uniqartists_df = artist_df.drop_duplicates()
uniqartists_df.describe()
entity type
count 68 68
unique 65 4
top Gianni Versace Designer
freq 2 45
uniqartists_df['type'].value_counts()
Designer            45
Design House        18
Manufacturer         4
Department Store     1
Name: type, dtype: int64
uniqartists_df['entity'].value_counts()
Alexander McQueen            2
Gianni Versace               2
Salvatore Ferragamo          2
Marc Jacobs                  1
Claire McCardell             1
Yohji Yamamoto               1
Tom Ford                     1
Weeks                        1
House of Patou               1
House of Chanel              1
John Galliano                1
Hugo Boss                    1
Mariano Fortuny              1
André Courrèges              1
Cristobal Balenciaga         1
Nettie Rosenstein            1
Junya Watanabe               1
Jean Paul Gaultier           1
Comme des Garçons            1
Drécoll                      1
House of Paquin              1
House of Worth               1
Charles Frederick Worth      1
Caroline Reboux              1
Giorgio di Sant'Angelo       1
Yeohlee Teng                 1
Valentina                    1
Madame Grès (Alix Barton)    1
Gucci                        1
Christian Lacroix            1
Charles James                1
Ji Eon Kang                  1
Bill Blass                   1
Vivienne Westwood            1
House of Jacques Fath        1
Fortuny                      1
Bonwit Teller & Co.          1
House of Givenchy            1
Yves Saint Laurent           1
Christian Dior               1
Jacques Fath                 1
Halston                      1
Gabrielle Chanel             1
Emanuel Ungaro               1
Townley Frocks               1
PBM                          1
Yves Saint Laurent, Paris    1
Norma Kamali                 1
H. Harris                    1
F. Scholte                   1
Rudi Gernreich               1
House of Balenciaga          1
Elsa Schiaparelli            1
Hubert de Givenchy           1
Rébè                         1
Edward Molyneux              1
Gilbert Adrian               1
House of Dior                1
Louis Vuitton Co.            1
Louiseboulanger              1
Miguel Adrover               1
Giorgio Armani               1
Mme. Jeanne Paquin           1
James Rosenquist             1
Madeleine Vionnet            1
Name: entity, dtype: int64
# Unique Designers
uniqartists_df[uniqartists_df['type'].str.contains("Designer")]['entity'].drop_duplicates().tolist()
['Valentina',
 'Halston',
 'Ji Eon Kang',
 'Vivienne Westwood',
 'Yeohlee Teng',
 'Christian Lacroix',
 'Jean Paul Gaultier',
 'Yohji Yamamoto',
 'Cristobal Balenciaga',
 'James Rosenquist',
 'Jacques Fath',
 'Weeks',
 'Christian Dior',
 'Gianni Versace',
 'Mariano Fortuny',
 'Charles Frederick Worth',
 'Gabrielle Chanel',
 'Claire McCardell',
 'Edward Molyneux',
 'André Courrèges',
 'Hubert de Givenchy',
 'Madame Grès (Alix Barton)',
 'Yves Saint Laurent',
 'Charles James',
 'Rudi Gernreich',
 'Elsa Schiaparelli',
 "Giorgio di Sant'Angelo",
 'Marc Jacobs',
 'Norma Kamali',
 'Gilbert Adrian',
 'H. Harris',
 'F. Scholte',
 'John Galliano',
 'Salvatore Ferragamo',
 'Junya Watanabe',
 'Bill Blass',
 'Louiseboulanger',
 'Madeleine Vionnet',
 'Emanuel Ungaro',
 'Nettie Rosenstein',
 'Mme. Jeanne Paquin',
 'Giorgio Armani',
 'Tom Ford',
 'Alexander McQueen',
 'Miguel Adrover']
# Unique Design Houses
uniqartists_df[uniqartists_df['type'].str.contains("Design House")].drop_duplicates()
entity type
6 House of Patou Design House
10 House of Balenciaga Design House
14 House of Jacques Fath Design House
19 House of Dior Design House
21 Gianni Versace Design House
23 Fortuny Design House
25 House of Worth Design House
27 House of Chanel Design House
33 House of Givenchy Design House
36 Yves Saint Laurent, Paris Design House
40 Caroline Reboux Design House
45 Louis Vuitton Co. Design House
56 Drécoll Design House
65 Salvatore Ferragamo Design House
67 Comme des Garçons Design House
86 House of Paquin Design House
89 Gucci Design House
91 Alexander McQueen Design House
# Unique Manufacturers
uniqartists_df[uniqartists_df['type'].str.contains("Manufacturer")].drop_duplicates()
entity type
12 Hugo Boss Manufacturer
29 Townley Frocks Manufacturer
53 Rébè Manufacturer
70 PBM Manufacturer
costume_missing_hdf['Object Name'].value_counts()
Evening dress       17
Dress               10
Ensemble             9
Ball gown            5
Evening ensemble     4
Suit                 4
Cape                 3
Coat                 1
Chadri               1
Evening suit         1
Jacket               1
Jumpsuit             1
Opera coat           1
Evening blouse       1
Coatdress            1
Sandals              1
Caftan               1
Pantsuit             1
Name: Object Name, dtype: int64

Process missing Costume Institute items

# Load proper crosswalk databases from Google Sheets

# Dict of URLs
met_crosswalk_url = {
    'Designer'     : 'https://docs.google.com/spreadsheets/d/1chojwnGt6dVWJJKBX9x-m_9zfmrL1QZ7I2LsSUABxSA/export?format=csv&id=1chojwnGt6dVWJJKBX9x-m_9zfmrL1QZ7I2LsSUABxSA&gid=2289626',
    'Manufacturer' : 'https://docs.google.com/spreadsheets/d/1chojwnGt6dVWJJKBX9x-m_9zfmrL1QZ7I2LsSUABxSA/export?format=csv&id=1chojwnGt6dVWJJKBX9x-m_9zfmrL1QZ7I2LsSUABxSA&gid=1005846001',
    'Design House' : 'https://docs.google.com/spreadsheets/d/1chojwnGt6dVWJJKBX9x-m_9zfmrL1QZ7I2LsSUABxSA/export?format=csv&id=1chojwnGt6dVWJJKBX9x-m_9zfmrL1QZ7I2LsSUABxSA&gid=1738047805',
    'Object Name'  : 'https://docs.google.com/spreadsheets/d/1WmXW2CjlLidcUXzahQsB3HjUVvECns4xDyIt-Hw-jW8/export?format=csv&id=1WmXW2CjlLidcUXzahQsB3HjUVvECns4xDyIt-Hw-jW8&gid=0',
    'Department Store' : ''
}

met_crosswalk_dfdict = {
    'Designer'     : pd.read_csv(met_crosswalk_url['Designer'], header=0, usecols=["Designer", "QID"]),
    'Manufacturer' : pd.read_csv(met_crosswalk_url['Manufacturer'], header=0, usecols=["Manufacturer", "QID"]),
    'Design House' : pd.read_csv(met_crosswalk_url['Design House'], header=0, usecols=["Design House", "QID"]),
    'Object Name'  : pd.read_csv(met_crosswalk_url['Object Name'], header=0, usecols=["Object Name", "QID", "extrastatement", "extraqualifier"]),
    'Department Store' : None
}

met_crosswalk_qs = {
    'Designer'     : '{}\tP287\t{}',
    'Manufacturer' : '{}\tP176\t{}',
    'Design House' : '{}\tP170\t{}\tP3831\tQ3661311',
    'Object Name'  : '{}\tP31\t{}',
    'Department Store' : ''
}

#test = pd.read_csv(met_crosswalk_designer_url, 
#    header=0,
#    usecols=["Designer", "QID"])
#test.head(5)

# met_crosswalk_dfdict['Design House']
import re

# Format Object Name, captialized from Met, to downcased in the description
#   Also handle if it's semicolon like "Drawing; Photograph" -> "drawing; photograph"

# Original downcase function which was fancy. Probably just need to downcase the whole thing
downcasefunc = lambda s: re.sub(r'; ', r'/', s.lower()) if isinstance(s, str) else 'object'

# Format Artist Display Name, but if it is blank/NaN from the Met, return empty string
# TK - Maybe add " at the Met Museum" if there is no artist?
artistfunc = lambda s: ' by ' + s if isinstance(s, str) else ''

datestring_template = '+{}-00-00T00:00:00Z/9'

for index, row in costume_missing_hdf.iterrows():
    print ('CREATE')

    # Met Object ID
    print ('LAST\tP3634\t"{0}"'.format(row['Object ID']))

    # Label
    print ('LAST\tLen\t"{0}"'.format(row['Title']))

    # Location
    print ('LAST\tP276\t{0}'.format('Q160236'))

    # Collection and inventory number
    print ('LAST\tP195\t{0}\tP217\t"{1}"\tP2868\tQ29188408'.format('Q160236',row['Object Number']))
    print ('LAST\tP217\t"{0}"\tP195\t{1}'.format(row['Object Number'],'Q160236'))

    
    # Add Costume Institute
    # FIX: Should do this by lookup into crosswalk based on "Department" column
    print ('LAST\t{}\t{}\t{}\t{}'.format(collection_prop, costumeinstitute_qid, statedin_prop, met_qid))

    # Commons compatible image - P4765
    # Need to look it up via the API
    # if row['Is Public Domain']: print ('LAST\tP4765\t{0}'.format('INSERTPDIMAGE'))

    
    # Convert Artist Display Name and Artist Role

    # From two strings:
    # Bill Blass|PBM|Bonwit Teller & Co.
    # Designer|Manufacturer|Department Store

    # To one dict with key/value pairs:
    # {'Bill Blass': 'Designer', 'PBM': 'Manufacturer', 'Bonwit Teller & Co.': 'Department Store'}

    artist_dict = {}
    entity_list = []
    type_list   = []
    
    # Split each of these fields via the pipe character
    if isinstance(row['Artist Display Name'],str): 
        entity_list.extend([x.strip() for x in row['Artist Display Name'].split('|')])
    if isinstance(row['Artist Role'],str): 
        type_list.extend([x.strip() for x in row['Artist Role'].split('|')])

    # May want sanity check to make sure the two lists are same length
    artist_dict = {key:value for key, value in zip(entity_list, type_list)}
    
    for entity, type in artist_dict.items():
        # DEBUG DIAGNOSTIC print
        # eg. Cristobal Balenciaga:Designer
        #     House of Balenciaga:Design House
        # print ("{}:{}".format(entity, type))

        # Make code easier to read by using shorter name for the 
        # appropriate crosswalk dataframe, using shallow copy

        if met_crosswalk_dfdict[type] is None:
            continue   # The dict doesn't have anything for this type ie. Department Store
        else:
            cw_df = met_crosswalk_dfdict[type].copy(deep=False)
        
        # Lookup
        entity_q = cw_df[cw_df[type].str.match('^'+re.escape(entity)+'$')][['QID']].iat[0,0]
        if isinstance(entity_q,str):
            # Generate Quickstatement via the string formatting pattern in the dict, 
            # and use LAST as item
            print (met_crosswalk_qs[type].format('LAST',entity_q))        

    # Remove duplicates, like YSL|YSL
    entity_list = list(set(entity_list))  
    
    # Description, using object name, list of designers/manufacturers/etc and (MET accession number)
    print ('LAST\tDen\t"{0}{1} (MET, {2})"'.format(
        downcasefunc(row['Object Name']),  
        ' by '+', '.join(entity_list),
        row['Object Number'])
    )

    # instance of
    type   = 'Object Name'
    entity = row['Object Name']
    # print ('entity: {}'.format(entity))

    cw_df = met_crosswalk_dfdict[type].copy(deep=False)
        
    # Lookup instance info in crosswalk
    entity_q = cw_df[cw_df[type].str.match(u'^'+re.escape(entity)+'$')][['QID']].iat[0,0]
    entity_extrastatement_q = cw_df[cw_df[type].str.match('^'+entity+'$')][['extrastatement']].iat[0,0]

    if isinstance(entity_q,str):
        # Generate Quickstatement via the string formatting pattern in the dict, 
        # and use LAST as item
        print (met_crosswalk_qs[type].format('LAST',entity_q))
        if isinstance(entity_extrastatement_q,str):
            print (met_crosswalk_qs[type].format('LAST',entity_extrastatement_q))

            
            
    # inception
    yearpattern = re.compile('^(ca. |[a-zA-Z/]+ )*([0-9]+)(-[0-9]+)*$')
    seasonpattern = re.compile('^([Ss]pring|[Ss]ummer|[Ff]all|[Ww]inter)')

    foundyear = None
    objectdate = row['Object Date']
    print (objectdate)

    # Start a list to build up the QS
    inceptionlist = []
    inceptionlist.append('{}\t{}\t'.format('LAST','P571'))
    
    yearmatch = yearpattern.search(objectdate)
    if yearmatch:
        if (yearmatch.group(1) == 'ca. '):
            print ('circa!')
            foundyear = yearmatch.group(2)
            # add sourcing circumstances as circa
            # P1480:Q5727902
        elif (yearmatch.group(3)):
            print ('Range: ',yearmatch.group(3))
        else: 
            seasonmatch = seasonpattern.match(yearmatch.group(1))
            if seasonmatch:
                print ('found a season: '+seasonmatch.group(1))

            foundyear = yearmatch.group(2)

        inceptionlist.append(datestring_template.format(foundyear))
        print (''.join(inceptionlist))
CREATE
LAST	P3634	"79142"
LAST	Len	"Evening dress"
LAST	P276	Q160236
LAST	P195	Q160236	P217	"1995.245.1"	P2868	Q29188408
LAST	P217	"1995.245.1"	P195	Q160236
LAST	P195	Q67087093	S248	Q160236
LAST	P287	Q4407601
LAST	Den	"evening dress by Valentina (MET, 1995.245.1)"
LAST	P31	Q2144456
LAST	P31	Q1908472
ca. 1934
circa!
LAST	P571	+1934-00-00T00:00:00Z/9
CREATE
LAST	P3634	"79269"
LAST	Len	"Evening dress"
LAST	P276	Q160236
LAST	P195	Q160236	P217	"1996.480.3"	P2868	Q29188408
LAST	P217	"1996.480.3"	P195	Q160236
LAST	P195	Q67087093	S248	Q160236
LAST	P287	Q456243
LAST	Den	"evening dress by Halston (MET, 1996.480.3)"
LAST	P31	Q2144456
LAST	P31	Q1908472
ca. 1978
circa!
LAST	P571	+1978-00-00T00:00:00Z/9
CREATE
LAST	P3634	"79585"
LAST	Len	"Dress"
LAST	P276	Q160236
LAST	P195	Q160236	P217	"1997.250.6"	P2868	Q29188408
LAST	P217	"1997.250.6"	P195	Q160236
LAST	P195	Q67087093	S248	Q160236
LAST	P287	Q67137189
LAST	Den	"dress by Ji Eon Kang (MET, 1997.250.6)"
LAST	P31	Q200539
spring/summer 1997
found a season: spring
LAST	P571	+1997-00-00T00:00:00Z/9
CREATE
LAST	P3634	"79778"
LAST	Len	""The Souper Dress""
LAST	P276	Q160236
LAST	P195	Q160236	P217	"1995.178.3"	P2868	Q29188408
LAST	P217	"1995.178.3"	P195	Q160236
LAST	P195	Q67087093	S248	Q160236
LAST	Den	"dress by  (MET, 1995.178.3)"
LAST	P31	Q200539
1966–67
CREATE
LAST	P3634	"79884"
LAST	Len	""On Liberty""
LAST	P276	Q160236
LAST	P195	Q160236	P217	"1995.213a–h"	P2868	Q29188408
LAST	P217	"1995.213a–h"	P195	Q160236
LAST	P195	Q67087093	S248	Q160236
LAST	P287	Q158067
LAST	Den	"suit by Vivienne Westwood (MET, 1995.213a–h)"
LAST	P31	Q614806
fall/winter 1994–95
CREATE
LAST	P3634	"80208"
LAST	Len	"Cape"
LAST	P276	Q160236
LAST	P195	Q160236	P217	"1995.72.7"	P2868	Q29188408
LAST	P217	"1995.72.7"	P195	Q160236
LAST	P195	Q67087093	S248	Q160236
LAST	P287	Q8052423
LAST	Den	"cape by Yeohlee Teng (MET, 1995.72.7)"
LAST	P31	Q1034198
fall/winter 1993–94
CREATE
LAST	P3634	"80378"
LAST	Len	"Evening dress"
LAST	P276	Q160236
LAST	P195	Q160236	P217	"1994.278"	P2868	Q29188408
LAST	P217	"1994.278"	P195	Q160236
LAST	P195	Q67087093	S248	Q160236
LAST	P287	Q350844
LAST	P170	Q3173864	P3831	Q3661311
LAST	Den	"evening dress by Christian Lacroix, House of Patou (MET, 1994.278)"
LAST	P31	Q2144456
LAST	P31	Q1908472
spring/summer 1987
found a season: spring
LAST	P571	+1987-00-00T00:00:00Z/9
CREATE
LAST	P3634	"80547"
LAST	Len	"Ensemble"
LAST	P276	Q160236
LAST	P195	Q160236	P217	"1994.578.3a, b"	P2868	Q29188408
LAST	P217	"1994.578.3a, b"	P195	Q160236
LAST	P195	Q67087093	S248	Q160236
LAST	P287	Q242868
LAST	Den	"ensemble by Jean Paul Gaultier (MET, 1994.578.3a, b)"
LAST	P31	Q1497375
1994
---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-214-d1164c13b3a7> in <module>
    132             print ('Range: ',yearmatch.group(3))
    133         else:
--> 134             seasonmatch = seasonpattern.match(yearmatch.group(1))
    135             if seasonmatch:
    136                 print ('found a season: '+seasonmatch.group(1))

TypeError: expected string or bytes-like object
entity_list
['Charles James']
# TEST

type='Designer'
entity='Madame Grès (Alix Barton)'
#met_crosswalk_dfdict[type][met_crosswalk_dfdict[type][type].str.match(entity)]['QID']

cw_df = met_crosswalk_dfdict[type].copy(deep=False)
#cw_df[cw_df[type].str.(entity)][['QID']].iat[0,0]

cw_df[cw_df[type].str.match('^'+re.escape(entity)+'$')][['QID']]
QID
4 Q467847
costume_hlist = costume_present_hdf['Object ID'].tolist()

costume_hstring = ' '.join('"' + str(item) + '"' for item in costume_hlist)
costume_hstring
'"79048" "79091" "79101" "79220" "79893" "80591" "81100" "81105" "81107" "81108" "81110" "81113" "81119" "81123" "81127" "81130" "81132" "81134" "81135" "81136" "81137" "81138" "81139" "81168" "81558" "81754" "81781" "82103" "82426" "82433" "82879" "82880" "83605" "88206" "95534" "96434" "107375" "107620"'
query = '''
SELECT ?item ?metid WHERE { 
  VALUES ?metid { %s } 
  ?item wdt:P3634 ?metid .
}
'''
query = query % hstring

data = requests.post(wikidata_api_url, data={'query': query, 'format': 'json'}).json()

resultarray = []
for item in data['results']['bindings']:
    resultarray.append({
        'qid':   int(item['item']['value'].replace('http://www.wikidata.org/entity/Q','')),
        'metid': int(item['metid']['value']),
    })
costume_missing_hdf[['Object ID','Classification','Object Name','Artist Display Name','Artist Role','Dimensions','Is Public Domain']]
Object ID Classification Object Name Artist Display Name Artist Role Dimensions Is Public Domain
65706 79142 NaN Evening dress Valentina Designer NaN False
65822 79269 NaN Evening dress Halston Designer NaN False
66114 79585 NaN Dress Ji Eon Kang Designer NaN False
66299 79778 NaN Dress NaN NaN NaN False
66378 79884 NaN Suit Vivienne Westwood Designer NaN False
66654 80208 NaN Cape Yeohlee Teng Designer NaN False
66801 80378 NaN Evening dress Christian Lacroix|House of Patou Designer|Design House NaN False
66954 80547 NaN Ensemble Jean Paul Gaultier Designer NaN False
67158 80790 NaN Dress Yohji Yamamoto Designer NaN False
67198 80840 NaN Evening dress Cristobal Balenciaga|House of Balenciaga Designer|Design House NaN False
67264 80911 NaN Ensemble James Rosenquist|Hugo Boss Designer|Manufacturer NaN False
67424 81101 NaN Evening dress Jacques Fath|House of Jacques Fath Designer|Design House NaN False
67425 81102 NaN Ball gown Cristobal Balenciaga|House of Balenciaga Designer|Design House NaN False
67426 81103 NaN Evening dress Weeks Designer NaN False
67427 81104 NaN Ball gown Christian Dior|House of Dior Designer|Design House NaN False
67429 81106 NaN Evening dress Gianni Versace|Gianni Versace Designer|Design House NaN False
67434 81111 NaN Caftan Mariano Fortuny|Fortuny Designer|Design House NaN False
67435 81112 NaN Ball gown Charles Frederick Worth|House of Worth Designer|Design House NaN True
67437 81114 NaN Coat Gabrielle Chanel|House of Chanel Designer|Design House NaN False
67438 81115 NaN Evening dress Claire McCardell|Townley Frocks Designer|Manufacturer NaN False
67439 81116 NaN Evening dress Edward Molyneux Designer NaN False
67441 81118 NaN Coatdress André Courrèges Designer NaN False
67444 81121 NaN Ensemble Hubert de Givenchy|House of Givenchy Designer|Design House NaN False
67445 81122 NaN Evening dress Madame Grès (Alix Barton) Designer NaN False
67447 81124 NaN Evening dress Yves Saint Laurent|Yves Saint Laurent, Paris Designer|Design House NaN False
67448 81125 NaN Suit Charles James Designer NaN False
67451 81128 NaN Chadri NaN NaN NaN False
67454 81131 NaN Suit Gabrielle Chanel|House of Chanel Designer|Design House NaN False
67463 81140 NaN Cape Caroline Reboux Design House NaN False
67464 81141 NaN Ensemble Rudi Gernreich Designer NaN False
67465 81142 NaN Cape Elsa Schiaparelli Designer NaN False
67466 81143 NaN Dress Giorgio di Sant'Angelo Designer NaN False
67686 81387 NaN Ensemble Marc Jacobs|Louis Vuitton Co. Designer|Design House NaN False
67752 81453 NaN Evening ensemble Norma Kamali Designer NaN False
67759 81460 NaN Jacket Christian Dior|House of Dior Designer|Design House NaN False
67766 81468 NaN Evening dress Hubert de Givenchy|House of Givenchy Designer|Design House NaN False
67770 81472 NaN Dress Cristobal Balenciaga|House of Balenciaga Designer|Design House NaN False
67774 81476 NaN Evening dress Rébè|Yves Saint Laurent|House of Dior Manufacturer|Designer|Design House NaN False
67778 81480 NaN Dress Drécoll Design House NaN False
67788 81490 NaN Evening ensemble Gabrielle Chanel|House of Chanel Designer|Design House NaN False
67949 81678 NaN Evening dress Charles James Designer NaN False
67959 81692 NaN Evening ensemble Gilbert Adrian Designer NaN False
68176 82105 NaN Evening dress House of Worth Design House NaN False
68237 82170 NaN Evening suit H. Harris|F. Scholte Designer|Designer NaN False
68308 82419 NaN Ensemble John Galliano|House of Dior Designer|Design House NaN False
68327 82443 NaN Sandals Salvatore Ferragamo|Salvatore Ferragamo Design House|Designer NaN False
68641 82981 NaN Ensemble Comme des Garçons|Junya Watanabe Design House|Designer NaN False
68707 83175 NaN Suit Bill Blass|PBM|Bonwit Teller & Co. Designer|Manufacturer|Department Store NaN False
68711 83179 NaN Evening blouse Elsa Schiaparelli|Bonwit Teller & Co. Designer|Department Store NaN False
68725 83209 NaN Evening dress Louiseboulanger Designer NaN False
68750 83234 NaN Ball gown Christian Dior|House of Dior Designer|Design House NaN False
68758 83242 NaN Pantsuit Yves Saint Laurent|Yves Saint Laurent, Paris Designer|Design House NaN False
68765 83250 NaN Evening dress Gianni Versace|Gianni Versace Designer|Design House NaN False
68774 83259 NaN Evening dress Madeleine Vionnet Designer NaN False
68909 83442 NaN Dress Yves Saint Laurent|Yves Saint Laurent, Paris Designer|Design House NaN False
68910 83443 NaN Ensemble Emanuel Ungaro Designer NaN False
69306 84034 NaN Ensemble Nettie Rosenstein Designer NaN False
71104 87016 NaN Opera coat House of Paquin|Mme. Jeanne Paquin Design House|Designer NaN False
71130 87370 NaN Jumpsuit Giorgio Armani Designer NaN False
71171 87613 NaN Dress Gucci|Tom Ford Design House|Designer NaN False
71387 88645 NaN Dress Alexander McQueen|Alexander McQueen Design House|Designer NaN False
80962 112900 NaN Dress Miguel Adrover Designer NaN False
87259 130481 NaN Evening ensemble Yves Saint Laurent|Yves Saint Laurent, Paris Designer|Design House NaN False
91890 159388 NaN Ball gown Charles James Designer NaN False
# missing_hdf.loc[lambda missing_hdf: missing_hdf['Object ID'] == 342288]
pd_missing_hdf.info()
<class 'pandas.core.frame.DataFrame'>
Int64Index: 46 entries, 18660 to 492602
Data columns (total 44 columns):
Object Number              46 non-null object
Is Highlight               46 non-null bool
Is Public Domain           46 non-null bool
Object ID                  46 non-null int64
Department                 46 non-null object
Object Name                21 non-null object
Title                      46 non-null object
Culture                    21 non-null object
Period                     1 non-null object
Dynasty                    0 non-null object
Reign                      0 non-null object
Portfolio                  0 non-null object
Artist Role                29 non-null object
Artist Prefix              1 non-null object
Artist Display Name        29 non-null object
Artist Display Bio         16 non-null object
Artist Suffix              0 non-null object
Artist Alpha Sort          29 non-null object
Artist Nationality         3 non-null object
Artist Begin Date          20 non-null object
Artist End Date            20 non-null object
Object Date                46 non-null object
Object Begin Date          46 non-null int64
Object End Date            46 non-null int64
Medium                     21 non-null object
Dimensions                 46 non-null object
Credit Line                30 non-null object
Geography Type             0 non-null object
City                       26 non-null object
State                      0 non-null object
County                     7 non-null object
Country                    33 non-null object
Region                     1 non-null object
Subregion                  0 non-null object
Locale                     0 non-null object
Locus                      0 non-null object
Excavation                 0 non-null object
River                      1 non-null object
Classification             21 non-null object
Rights and Reproduction    0 non-null object
Link Resource              46 non-null object
Metadata Date              46 non-null object
Repository                 46 non-null object
Tags                       20 non-null object
dtypes: bool(2), int64(3), object(39)
memory usage: 15.5+ KB
missing_hdf[missing_hdf['Department'].str.contains('Costume')][['Object ID','Classification','Object Name','Artist Display Name','Artist Role','Object Date','Object Begin Date','Object End Date','Dimensions','Tags']]
Object ID Classification Object Name Artist Display Name Artist Role Object Date Object Begin Date Object End Date Dimensions Tags
66997 79142 NaN Evening dress Valentina Designer ca. 1934 1929 1939 NaN Dresses
67113 79269 NaN Evening dress Halston Designer ca. 1978 1973 1983 NaN Dresses
67405 79585 NaN Dress Ji Eon Kang Designer spring/summer 1997 1997 1997 NaN Dresses
67590 79778 NaN Dress NaN NaN 1966–67 1966 1967 NaN Dresses
67669 79884 NaN Suit Vivienne Westwood Designer fall/winter 1994–95 1994 1995 NaN NaN
67945 80208 NaN Cape Yeohlee Teng Designer fall/winter 1993–94 1993 1994 NaN NaN
68092 80378 NaN Evening dress Christian Lacroix|House of Patou Designer|Design House spring/summer 1987 1987 1987 NaN Dresses
68245 80547 NaN Ensemble Jean Paul Gaultier Designer 1994 1994 1994 NaN NaN
68449 80790 NaN Dress Yohji Yamamoto Designer spring/summer 1993 1993 1993 NaN Dresses
68489 80840 NaN Evening dress Cristobal Balenciaga|House of Balenciaga Designer|Design House 1951 1951 1951 NaN Dresses
68555 80911 NaN Ensemble James Rosenquist|Hugo Boss Designer|Manufacturer spring/summer 1998 1998 1998 NaN NaN
68715 81101 NaN Evening dress Jacques Fath|House of Jacques Fath Designer|Design House spring/summer 1947 1947 1947 NaN Dresses
68716 81102 NaN Ball gown Cristobal Balenciaga|House of Balenciaga Designer|Design House spring/summer 1948 1948 1948 NaN Dresses
68717 81103 NaN Evening dress Weeks Designer ca. 1911 1911 1911 NaN Dresses
68718 81104 NaN Ball gown Christian Dior|House of Dior Designer|Design House spring/summer 1953 1953 1953 NaN Dresses
68720 81106 NaN Evening dress Gianni Versace|Gianni Versace Designer|Design House fall/winter 1991–92 1991 1992 NaN Dresses
68725 81111 NaN Caftan Mariano Fortuny|Fortuny Designer|Design House ca. 1930 1925 1935 NaN NaN
68726 81112 NaN Ball gown Charles Frederick Worth|House of Worth Designer|Design House ca. 1872 1867 1877 NaN Dresses
68728 81114 NaN Coat Gabrielle Chanel|House of Chanel Designer|Design House ca. 1927 1922 1932 NaN NaN
68729 81115 NaN Evening dress Claire McCardell|Townley Frocks Designer|Manufacturer 1950 1950 1950 NaN Dresses
68730 81116 NaN Evening dress Edward Molyneux Designer 1926–27 1926 1927 NaN Dresses
68732 81118 NaN Coatdress André Courrèges Designer 1965 1965 1965 NaN Dresses
68735 81121 NaN Ensemble Hubert de Givenchy|House of Givenchy Designer|Design House fall/winter 1963–64 1963 1964 NaN NaN
68736 81122 NaN Evening dress Madame Grès (Alix Barton) Designer 1958 1958 1958 NaN Dresses
68738 81124 NaN Evening dress Yves Saint Laurent|Yves Saint Laurent, Paris Designer|Design House fall/winter 1969–70 1969 1970 NaN Dresses
68739 81125 NaN Suit Charles James Designer 1951 1951 1951 NaN NaN
68742 81128 NaN Chadri NaN NaN 20th century 1900 1972 NaN NaN
68745 81131 NaN Suit Gabrielle Chanel|House of Chanel Designer|Design House 1938 1938 1938 NaN NaN
68754 81140 NaN Cape Caroline Reboux Design House 1920s 1920 1929 NaN NaN
68755 81141 NaN Ensemble Rudi Gernreich Designer 1967 1967 1967 NaN Dresses
68756 81142 NaN Cape Elsa Schiaparelli Designer winter 1938–39 1938 1939 NaN Apollo|Horses|Chariots
68757 81143 NaN Dress Giorgio di Sant'Angelo Designer spring/summer 1971 1971 1971 NaN Dresses
68977 81387 NaN Ensemble Marc Jacobs|Louis Vuitton Co. Designer|Design House fall/winter 1998–99 1998 1999 NaN NaN
69043 81453 NaN Evening ensemble Norma Kamali Designer 1977 1977 1977 NaN NaN
69050 81460 NaN Jacket Christian Dior|House of Dior Designer|Design House spring/summer 1947 1947 1947 NaN NaN
69057 81468 NaN Evening dress Hubert de Givenchy|House of Givenchy Designer|Design House 1968–69 1968 1969 NaN Dresses
69061 81472 NaN Dress Cristobal Balenciaga|House of Balenciaga Designer|Design House 1960–64 1960 1964 NaN Dresses
69065 81476 NaN Evening dress Rébè|Yves Saint Laurent|House of Dior Manufacturer|Designer|Design House spring/summer 1958 1958 1958 NaN Dresses
69069 81480 NaN Dress Drécoll Design House ca. 1924 1919 1929 NaN Dresses
69079 81490 NaN Evening ensemble Gabrielle Chanel|House of Chanel Designer|Design House 1933–35 1933 1935 NaN NaN
69240 81678 NaN Evening dress Charles James Designer 1953 1953 1953 NaN Dresses
69250 81692 NaN Evening ensemble Gilbert Adrian Designer 1945 1945 1945 NaN NaN
69467 82105 NaN Evening dress House of Worth Design House 1925 1925 1925 NaN Dresses
69528 82170 NaN Evening suit H. Harris|F. Scholte Designer|Designer 1938–65 1938 1965 NaN NaN
69599 82419 NaN Ensemble John Galliano|House of Dior Designer|Design House spring/summer 1998 1998 1998 NaN NaN
69618 82443 NaN Sandals Salvatore Ferragamo|Salvatore Ferragamo Design House|Designer 1938 1938 1938 NaN NaN
69620 82446 NaN Corset NaN NaN mid-20th century 1925 1975 NaN NaN
69933 82981 NaN Ensemble Comme des Garçons|Junya Watanabe Design House|Designer fall/winter 2000–2001 2000 2001 NaN Dresses
69999 83175 NaN Suit Bill Blass|PBM|Bonwit Teller & Co. Designer|Manufacturer|Department Store late 1960s 1965 1969 NaN NaN
70003 83179 NaN Evening blouse Elsa Schiaparelli|Bonwit Teller & Co. Designer|Department Store 1940–45 1940 1945 NaN NaN
70017 83209 NaN Evening dress Louiseboulanger Designer 1928 1928 1928 NaN Dresses
70042 83234 NaN Ball gown Christian Dior|House of Dior Designer|Design House fall/winter 1949–50 1949 1950 NaN Dresses
70050 83242 NaN Pantsuit Yves Saint Laurent|Yves Saint Laurent, Paris Designer|Design House spring/summer 1970 1970 1970 NaN NaN
70057 83250 NaN Evening dress Gianni Versace|Gianni Versace Designer|Design House spring/summer 1991 1991 1991 NaN Dresses
70066 83259 NaN Evening dress Madeleine Vionnet Designer spring/summer 1938 1938 1938 NaN Dresses
70201 83442 NaN Dress Yves Saint Laurent|Yves Saint Laurent, Paris Designer|Design House fall/winter 1965–66 1965 1966 NaN Dresses
70202 83443 NaN Ensemble Emanuel Ungaro Designer 1967 1967 1967 NaN NaN
70598 84034 NaN Ensemble Nettie Rosenstein Designer 1945 1945 1945 NaN NaN
72396 87016 NaN Opera coat House of Paquin|Mme. Jeanne Paquin Design House|Designer 1912 1912 1912 NaN NaN
72422 87370 NaN Jumpsuit Giorgio Armani Designer fall/winter 2002–3 2002 2003 NaN NaN
72463 87613 NaN Dress Gucci|Tom Ford Design House|Designer spring/summer 2003 2003 2003 NaN Dresses
72679 88645 NaN Dress Alexander McQueen|Alexander McQueen Design House|Designer spring/summer 2003 2003 2003 NaN Dresses
82254 112900 NaN Dress Miguel Adrover Designer 2000 2000 2000 NaN Dresses
88552 130481 NaN Evening ensemble Yves Saint Laurent|Yves Saint Laurent, Paris Designer|Design House fall/winter 1983–84 1983 1984 NaN NaN
93195 159388 NaN Ball gown Charles James Designer 1955 1955 1955 NaN Dresses
from IPython.display import Image, display
# import requests_cache


imagelist = []
for index, row in pd_missing_hdf.iterrows():
    print (index)
    data = requests.get(met_api_url+str(row['Object ID'])).json()

    if 'primaryImageSmall' in data:
        print (data['objectID'])
        if data['primaryImageSmall']:
            print (data['primaryImageSmall'])
            imagelist.append(data['primaryImageSmall'])

#    if data['additionalImages']:
#        for item in data['additionalImages']:
#            print ('    '+item)
18660
22871
https://images.metmuseum.org/CRDImages/aa/web-large/DP215265.jpg
18992
23205
https://images.metmuseum.org/CRDImages/aa/web-large/LC-29_154_3-001.jpg
100399
187784
https://images.metmuseum.org/CRDImages/es/web-large/DP104584.jpg
108432
196439
https://images.metmuseum.org/CRDImages/es/web-large/DP-14939-002.jpg
191712
310870
https://images.metmuseum.org/CRDImages/ao/web-large/DT1236.jpg
193023
312231
https://images.metmuseum.org/CRDImages/ao/web-large/DT1216.jpg
194432
313780
https://images.metmuseum.org/CRDImages/ao/web-large/DP294667.jpg
194664
314034
https://images.metmuseum.org/CRDImages/ao/web-large/DT1244.jpg
195329
314704
https://images.metmuseum.org/CRDImages/ao/web-large/DT1219.jpg
198389
317792
https://images.metmuseum.org/CRDImages/ao/web-large/DP285728.jpg
199763
320053
https://images.metmuseum.org/CRDImages/ao/web-large/DP351868.jpg
346143
500605
https://images.metmuseum.org/CRDImages/mi/web-large/DP219344.jpg
346175
500637
https://images.metmuseum.org/CRDImages/mi/web-large/DP216549.jpg
346245
500709
https://images.metmuseum.org/CRDImages/mi/web-large/MI89.4.163.jpg
346272
500736
https://images.metmuseum.org/CRDImages/mi/web-large/mi89.4.154.R.jpg
346318
500782
https://images.metmuseum.org/CRDImages/mi/web-large/mi89.4.213.R.jpg
346460
500928
https://images.metmuseum.org/CRDImages/mi/web-large/DP302694.jpg
346638
501109
https://images.metmuseum.org/CRDImages/mi/web-large/DP302664.jpg
346740
501213
https://images.metmuseum.org/CRDImages/mi/web-large/DP158910a.jpg
346754
501227
https://images.metmuseum.org/CRDImages/mi/web-large/DP168365.jpg
347060
501536
https://images.metmuseum.org/CRDImages/mi/web-large/mi89.4.926.AV1.jpg
414523
680379
https://images.metmuseum.org/CRDImages/li/web-large/DP345035.jpg
453534
739518
https://images.metmuseum.org/CRDImages/li/web-large/b1240450_001.jpg
460085
749358
https://images.metmuseum.org/CRDImages/li/web-large/b1714077_01_001.jpg
460088
749368
https://images.metmuseum.org/CRDImages/li/web-large/b1714077_02_001.jpg
464664
755011
https://images.metmuseum.org/CRDImages/li/web-large/b1120569_001.jpg
465169
755786
https://images.metmuseum.org/CRDImages/li/web-large/b1152364_002.jpg
472946
769306
https://images.metmuseum.org/CRDImages/li/web-large/b1374401_002.jpg
484937
787771
https://images.metmuseum.org/CRDImages/li/web-large/b1072822_001.jpg
486224
811179
https://images.metmuseum.org/CRDImages/li/web-large/b1456400_05_001.jpg
486227
811182
https://images.metmuseum.org/CRDImages/li/web-large/b1086151_001.jpg
488053
813854
https://images.metmuseum.org/CRDImages/li/web-large/b1201444_001.jpg
488206
814025
https://images.metmuseum.org/CRDImages/li/web-large/b1960820_001_TP.jpg
489132
815475
https://images.metmuseum.org/CRDImages/li/web-large/b1027020_001.jpg
490481
818177
https://images.metmuseum.org/CRDImages/li/web-large/b1811554_001.jpg
491754
820544
https://images.metmuseum.org/CRDImages/li/web-large/b1346521_05_001.jpg
492344
821397
https://images.metmuseum.org/CRDImages/li/web-large/b1510246_001.jpg
492570
821874
https://images.metmuseum.org/CRDImages/li/web-large/b1511333_001.jpg
492571
821878
https://images.metmuseum.org/CRDImages/li/web-large/b1511333_004.jpg
492572
821879
https://images.metmuseum.org/CRDImages/li/web-large/b1511333_002.jpg
492573
821880
https://images.metmuseum.org/CRDImages/li/web-large/b1511333_003.jpg
492593
821928
https://images.metmuseum.org/CRDImages/li/web-large/b1244108_05_p05.jpg
492595
821930
https://images.metmuseum.org/CRDImages/li/web-large/b1244108_11_p020.jpg
492598
821934
https://images.metmuseum.org/CRDImages/li/web-large/b1243911_168_001.jpg
492599
821935
https://images.metmuseum.org/CRDImages/li/web-large/b1164071_01_001.jpg
492602
821938
https://images.metmuseum.org/CRDImages/li/web-large/b1164071_02_001.jpg
# From https://stackoverflow.com/questions/36006136/how-to-display-images-in-a-row-with-ipython-display/38556650
from IPython.display import HTML
def make_html(image):
     return '<img src="{}" style="display:inline;margin:1px"/>'.format(image)

for imagename in imagelist:
    display(HTML(''.join(make_html(imagename))))
for index, row in missing_hdf.iterrows():
    print ("~",row['Dimensions'])
~ 132 x 102 in. (335.3 x 259.1 cm)
~ Overall: 19 1/16 x 8 3/4 x 6 3/8 in. (48.4 x 22.2 x 16.2 cm); 64 oz. 9 dwt. (2005.6 g)
Plateau: 2 5/16 x 17 1/4 in. (5.9 x 43.8 cm); 67 oz. 2 dwt. (2086.5 g)
~ 13 ft. 7 1/2 in. × 28 ft. 7 in. × 47 ft. 8 5/8 in. (415.3 × 871.2 × 1454.5 cm)
Each window panel: 53 3/4 x 22 3/4 in. (136.5 x 57.8 cm)
~ 72 x 32 1/2 x 54 in. (182.9 x 82.6 x 137.2 cm)
~ 9 1/2 x 37 1/2 x 6 1/4 in. (24.1 x 95.3 x 15.9 cm)
~ sword: L. 39 1/4 in. (99.8 cm); L. of blade 33 in. (83.7 cm); Wt. 2 lb. 8 oz. (1129 g); scabbard: L. 34 5/8 in. (88 cm); Wt. 2 lb. 4 oz. (1023 g)
~ H. 66 1/2 in. (168.9 cm), Wt. 41 lb. (18.6 kg)
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ nan
~ Height: 10 3/8 in. (26.4 cm)
~ Overall (confirmed): H. 38 1/2 x W. 17 1/4 x D. 14 3/8 in. (97.8 x 43.8 x 36.5 cm) [n.b.: fluffiness of skirt skews measurement]
~ Overall (confirmed): 45 5/8 x 22 1/2 x 24 1/8 in., 145 lb. (115.9 x 57.2 x 61.3 cm, 65.7716 kg)
~ 28.3 x 22.7 cm (11 1/8 x 8 15/16 in.)
~ 24.1 x 19.7 cm (9 1/2 x 7 3/4 in.)
~ 10.9 x 8 cm (4 5/16 x 3 1/8 in.)
~ 23.5 x 18.8 cm (9 1/4 x 7 3/8 in.)
~ 32.8 x 24.4 cm (12 15/16 x 9 5/8 in.)
~ 41.8 x 31.8 cm (16 7/16 x 12 1/2 in.)
~ 19.2 x 24.4 cm (7 9/16  x 9 5/8  in.)
~ 11.7 x 8.6 cm (4 5/8 x 3 3/8 in.)
~ 11.3 x 8.9 cm (4 7/16 x 3 1/2 in.)
~ 23.6 x 18.3 cm (9 5/16 x 7 3/16 in.)
~ 29 x 23.5 cm (11 7/16 x 9 1/4 in.)
~ 28.7 x 23.2 cm (11 5/16 x 9 1/8 in.)
~ Image: 7 11/16 × 6 5/16 in. (19.5 × 16.1 cm)
Mount: 7 11/16 × 6 5/16 in. (19.5 × 16.1 cm)
~ 37.5 x 27.9 cm (14 3/4 x 11 in.)
~ 19.4 x 24.6 cm (7 5/8 x 9 11/16 in.)
~ 17.3 x 24 cm (6 13/16 x 9 7/16 in.)
~ 106.4 x 111.4 cm (41 7/8 x 43 7/8 in.)
~ 60 x 46.8 cm (23 5/8 x 18 7/16 in.)
~ 169.5 x 129.5cm (66 3/4 x 51in.)
Frame: 177.2 × 137.2 cm (69 3/4 × 54 in.)
~ 23 x 17 cm (9 1/16 x 6 11/16 in.)
~ 101.6 x 76.2 cm (40 x 30 in.)
~ 23.5 x 33.7 cm (9 1/4 x 13 1/4 in.)
~ 18.7 x 23.9 cm (7 3/8 x 9 7/16 in.)
~ 24.4 x 19.4 cm (9 5/8 x 7 5/8 in.)
~ 104.5 x 135.5cm (41 1/8 x 53 3/8in.)
Frame: 127 × 156.2 cm (50 × 61 1/2 in.)
~ 110 x 185 cm (43 5/16 x 72 13/16 in.)
~ 42.3 x 54.2 cm (16 5/8 x 21 5/16 in.)
~ 194.3 x 204.5 cm (76 1/2 x 80 1/2 in.), framed
~ 185.4 x 221.3 cm (73 x 87 1/8 in.)
~ 61 x 50.8 cm (24 x 20 in.)
~ 68.6 x 101.6cm (27 x 40in.)
Frame: 76.2 × 109.2 cm (30 × 43 in.)
~ 19.6 x 24.3 cm. (7 3/4 x 9 9/16 in.), each
~ 181.9 x 230.5 cm (71 5/8 x 90 3/4 in.)
~ 34 x 25.7 cm (13 3/8 x 10 1/8 in.)
~ 21 x 15 cm (8 1/4 x 5 15/16 in.)
~ 37.9 x 46 cm (14 15/16 x 18 1/8 in.)
~ 47.8 x 38.4 cm (18 13/16 x 15 1/8 in.)
~ 47.8 × 38.4 cm (18 13/16 × 15 1/8 in.)
Frame: 34 5/8 × 29 5/8 in. (87.9 × 75.2 cm)
~ 49.9 × 38.9 cm (19 5/8 × 15 5/16 in.)
Frame: 34 5/8 × 29 5/8 in. (87.9 × 75.2 cm)
~ 39.3 x 48.3 cm (15 1/2 x 19 in.)
~ 32.7 x 43.5 cm (12 7/8 x 17 1/8 in.)
~ Image: 7 1/16 × 10 1/2 in. (18 × 26.6 cm)
~ Image: 24.2 × 31.6 cm (9 1/2 × 12 7/16 in.)
Sheet: 24.9 × 32.3 cm (9 13/16 × 12 11/16 in.)
Mount: 28 × 33.9 cm (11 in. × 13 3/8 in.)
~ Image: 187 x 93.4 cm (73 5/8 x 36 3/4 in.)
Frame: 223.5 x 130.8 cm (88 x 51 1/2 in.)
~ 7.9 x 7.9 cm (3 1/8 x 3 1/8 in.)
~ Frame: 43 1/2 × 33 1/2 in. (110.5 × 85.1 cm)
~ 92.9 x 90.8 cm (36 9/16 x 35 3/4 in.)
~ 8.7 x 11.7 cm (3 7/16 x 4 5/8 in.)
~ 24.8 x 19 cm (9 3/4 x 7 1/2 in.)
~ 210 x 165 cm (82 11/16 x 64 15/16 in.)
~ Frame: 152.4 × 127 cm (60 × 50 in.)
~ 18.9 x 23.7 cm (7 7/16 x 9 5/16 in.)
~ 128.9 x 169.5 cm (50 3/4 x 66 3/4 in.)
~ Image: 43.7 x 53.8 cm (17 3/16 x 21 3/16 in.)
~ Image: 49 x 39.8cm (19 5/16 x 15 11/16in.)
~ 7.8 x 10 cm (3 1/16 x 3 15/16 in.)
~ 127 x 177.8cm (50 x 70in.)
Frame: 154.9 × 221 cm (61 × 87 in.)
~ Dimensions vary from 8.4 x 7.5 cm (3 5/16 x 2 15/16 in.) to 45.7 x 55.9 cm (18 x 22 in.)
~ 47 x 34.3 cm (18 1/2 x 13 1/2 in.)
~ Image: 39.5 x 38.3 cm (15 9/16 x 15 1/16 in.)
Sheet: 50.8 x 40.6 cm (20 x 16 in.)
~ nan
~ Image: 229 x 437 cm (90 3/16 x 172 1/16 in.)

~ Image: 119.1 x 159.7 cm (46 7/8 x 62 7/8 in.)
Frame: 48 × 63 in. (121.9 × 160 cm)
~ H. 5 1/2 x W. 4 1/2 in. (14 x 11.4 cm)
~ H. 33 1/4 x W. 11 x D. 1 1/2 in. (84.5 x 27.9 x 3.8 cm)
~ H. 39 in. (91.9 cm)
~ H. 25 11/16 x W. 38 x D. 7 7/8 in. (65.2 x 96.5 x 20 cm)
~ H. 25 3/16 x W. 7 7/8 x D. 6 1/2 in. (64 x 20 x 16.5 cm)
~ H. 30 1/4 x W. 13 x  D. 9 in. (76.8 x 33 x 22.9 cm)
~ H. 23 x W. 5 1/2 x D. 5 in. (58.4 x 14 x 12.7 cm)
~ H. 75 x W. 24 x D. 6 1/2 in. (190.5 x 61 x 16.5 cm)
~ H. 29 1/2 x W. 21 x D. 16 in. (74.9 x 53.3 x 40.6 cm)
~ H. 55 1/8 x W. 15 x D. 1 1/2 in. (140 x 38.1 x 3.8 cm)
~ H. 55 7/8 x W. 29 1/2 x D. 5 in. (141.9 x 74.9 x 12.7 cm)
~ H. 42 1/2 x W. 23 x D. 7 in. (108 x 58.4 x 17.8 cm)
~ H. 96 in (243.8 cm)
~ H. 29 1/4 x W. 21 1/2 x D. 25 in. (74.3 x 54.6 x 63.5 cm)
~ H. 21 1/2 x W. 25 x D. 22 3/4 in. (54.6 x 63.5 x 57.8 cm)
~ H. 42 x W. 9 x D. 7 in. (106.7 x 22.9 x 17.8 cm)
~ H. 20 3/4 x W. 15 x D. 4 in. (52.7 x 38.1 x 10.2 cm)
~ H. 20 1/2  x  L.93  x  D. 18 1/2  in. (52.1 x 236.2 x 47 cm)
~ H. 29 1/2 x W. 6 x  D. 5 1/4 in.(74.9 x 15.2 x 13.3 cm)
~ H. 48 5/8 x W. 14 7/16 x D. 14 3/8 in. (123.5 x 36.6 x 36.5 cm)
~ H. 23 1/8 x D. 10 1/4 x W. 10 in. (58.8 x 26 x 25.4 cm)
~ H. 10 15/16 x W. 6 x D. 7 1/4 in. (27.9 x 15.2 x 18.4 cm)
~ H. 24 x W. 23 3/4 x D. 6 1/2 in. (61 x 60.3 x 16.5 cm)
~ H. 26 x W. 15 1/2 x D. 19 in. (66 x 39.4 x 48.3 cm)
~ H. 36 1/8 x W. 8 1/2 x D. 8 1/2 in. (91.8 x 21.6 x 21.6 cm)
~ H. 38 3/4 x W. 10 x D. 7 1/2 in. (98.4 x 25.4 x 19.1cm)
~ H. 72 x W. 12 3/4 x D. 9 7/8 in. (182.9 x 32.4 x 25.1cm)
~ H. 18 ft. × W. 39 in. × D. 63 in. (548.6 × 99.1 × 160 cm)
~ H. 24 in. (61 cm)
~ H. 43 1/2 x W. 10 1/4 x D. 8 3/4 in. (110.5 x 26 x 22.2 cm)
~ H. 19 1/4 in. (48.9 cm)
~ H. 35 3/8 x W. 9 x D. 10 3/8in. (89.9 x 22.9 x 26.4cm)
~ H. 16 x W. 3 7/8 x D. 2 1/2 in. (40.6 x 9.9 x 6.4 cm)
~ H. 13 1/2 in (34.3 cm)
~ H. 71 x W. 12 x D. 10 1/2 in. (180.3 x 30.5 x 26.7 cm)
~ H: 4 1/2 in. (11.4 cm)
~ H. 81 1/2 x W. 38 in. (207 x 96.5 cm)
~ H. 11 1/2 in. (29.2 cm)
~ H. 13 1/2 x W. 7 1/2 x D. 6 1/2 in. (34.3 x 19.1 x 16.5 cm)
~ H. 10 1/4 in. (26 cm)
~ H. 11 3/4 in. (29.8cm)
~ H. 60 x W. 67 in. (152.4 x 170.2 cm)
~ H. 8 1/4 in. (21 cm)
~ H. 21 13/16 x W. 4 x D. 4 1/8 in. (55.4 x 10.2 x 10.5 cm)
~ H. 86 3/4 x W. 128 in. (220.3 x 325.1 cm)
~ H. 46 1/2 in. (118 cm), W. 19 1/2 in. (49.5 cm), D. 15 1/2 in. (39.4 cm)
~ 29 1/2 x 47 1/4in. (74.9 x 120cm)
~ Sheet: 25 11/16 x 19 11/16 in. (65.2 x 50 cm)
Plate: 18 1/4 x 14 7/8 in. (46.4 x 37.8 cm)
~ Image: 16 1/2 x 10 1/4 in. (41.9 x 26 cm)
Sheet: 16 1/2 x 25 3/16 in. (41.9 x 64 cm)
~ Sheet: 6 x 6 in. (15.2 x 15.2 cm)
~ 24 1/4 x 39 inches (61.6 x 99 cm)
~ Sheet: 11 5/16 x 7 1/2 in. (28.8 x 19 cm)
~ Sheet: 8 5/16 x 6 1/2 in. (21.1 x 16.5 cm)
~ Sheet: 2 5/8 x 1 7/16 in. (6.7 x 3.7 cm)
~ H. 15 in. (38.1 cm)
Max. Diam. 4 5/16 in. (11 cm)
~ H. 34 in. (86.4 cm)
W. 39 1/2 in. (100.3 cm)
D. 2 3/4 in. (7 cm)
 Estimated weight: 140 lbs.  (Weight extrapolated from dimensions of similar unframed Nishapur stucco.)
~ Apse interior: 30 ft. 2 in. × 24 ft. 7 in. × 27 ft. 8 in. (919.5 × 749.3 × 843.3 cm)
b: (lion capital): 14 1/8 × 20 1/4 × 17 1/4 in. (35.9 × 51.4 × 43.8 cm)
f: (pier with acrobat): 60 × 12 1/4 × 12 1/2 in. (152.4 × 31.1 × 31.8 cm)
~ 43 in. (109.2 cm)
~ Overall: 80 1/4 × 34 1/4 × 18 7/8 in., Weight: 153 lb. (203.8 × 87 × 47.9 cm, 69.4 kg)
Base: 30 1/2 × 34 1/4 × 18 7/8 in., Weight: 83 lb. (77.5 × 87 × 47.9 cm, 37.6 kg)
Top: 49 3/4 × 30 1/2 × 17 in., Weight: 70 lb. (126.4 × 77.5 × 43.2 cm, 31.8 kg)
~ 3 3/8 x 9 x 9 3/8 in. (8.6 x 22.9 x 23.8 cm)
~ 50 1/4 x 33 3/4 x 14 in. (127.6 x 85.7 x 35.6 cm)
~ 18 5/8 x 15 5/8 in. (47.3 x 39.7 cm)
~ 26 7/8 × 17 3/4 in. (68.3 × 45.1 cm)
~ Tea Urn, 1a-c:  H. 14-1/2, D. 11 in. (36.8 x 19.7 cm)
Tray, 2:  H. 5/8 Diam. 17-5/8 in. (44.5 cm)
Creamer, 3:  H. 3, W. 6, D. 3-7/8 in. (7.6 x 15.2 x 9.8 cm)
Sugar Bowl, 4a,b:  H. 6-3/4, W. 6, D. 3-7/8 in. (17.1 x 15.2 x 9.8 cm)
Large Tray, 5: H. 1/2 Diam. 20-3/8 in. (51.4 cm)
~ 12 1/8 x 12 1/2 x 3 1/2 in. (30.8 x 31.8 x 8.9 cm)
~ 3 1/4 × 4 1/4 × 6 1/2 in. (8.3 × 10.8 × 16.5 cm)
~ Various dimensions
~ 17 ft. 3 in. x 26 ft. 3 in. (3.71 x 5.26 x 8 m.)
~ 26 1/2 x 40 x 44 1/2 in. (67.3 x 101.6 x 113 cm)
~ 22 x 25 x 10 in. (55.9 x 63.5 x 25.4 cm)
Weight: 1 lb. (.5 kg)
~ Variable: 112-3/4 x 80 x 81-1/2 in. (286.4 x 203.2 x 207 cm)
~ 89 3/4 x 89 1/4 x 16 1/2 in. (228 x 226.7 x 41.9 cm)
~ Height: 22 in. (55.9 cm)
Width: 22 in. (55.9 cm)
~ Height: 19 in. (48.3 cm)
~ W. 45 1/2 × D. 5 7/8 in. (115.5 × 15 cm)
~ Height: 12 in. (30.5 cm)
Diameter: 6 1/2 in. (16.5 cm)
~ 5 3/8 × 7 × 6 7/16 in. (13.7 × 17.8 × 16.4 cm)
~ 42 1/4 × 9 3/4 × 2 1/2 in. (107.3 × 24.8 × 6.4 cm)
~ L. 34 1/16 x W. 17 15/16 × D. 8 11/16  in (86.5 x 45.5 × 22 cm)
~ L. 21 in. (53.3 cm)
~ 12 3/16 × 4 1/16 × 4 1/8 in. (31 × 10.3 × 10.5 cm)
~ Height: 29 15/16 in. (76 cm)
Width: 8 1/4 in. (21 cm)
~ Height: 18 in. (45.7 cm)
Width: 11 in. (27.9 cm)
Diameter (At widest point): 35 1/2 in. (90.2 cm)
Diameter (Of base): 31 in. (78.7 cm)
~ H. 35 5/16 × W. 34 1/4 × D. 8 1/16 in. (89.7 × 87 × 20.5 cm)
~ L: 54 in. (137.2 cm)
~ H. 22 1/16 × W. 24 × D. 12 3/16 in. (56 × 61 × 31 cm)
~ Height: 25 in. (63.5 cm)
Diameter: 11 in. (27.9 cm)
~ 26 5/8 × 2 1/8 × 1 5/8 in. (67.6 × 5.4 × 4.1 cm)
~ Tsii'edo'a'tl: 17 5/16 × 5 1/4 × 3 3/4 in. (44 × 13.3 × 9.5 cm)
Bow: 3 1/8 × 5/8 × 21 in. (7.9 × 1.6 × 53.3 cm)
~ 19 × 2 3/4 in. (48.3 × 7 cm)
~ 18 3/4 × 1 1/4 × 2 3/8 in. (47.6 × 3.2 × 6 cm)
~ L. longest pipe 45.4 cm (17-7/8 in.); L. shortest pipe 18.1 cm (7-1/8 in.)
~ 45 9/16 × 20 11/16 × 17 in. (115.8 × 52.5 × 43.2 cm)
~ Height: 20 7/8 in. (53 cm)
Width: 21 5/8 in. (55 cm)
Depth: 13 3/4 in. (35 cm)
~ Height: 32 3/8 in. (82.2 cm)
Diameter (Maximum): 24 7/16 in. (62 cm)
Diameter (Drum head): 21 3/4 in. (55.3 cm)
~ 29 7/16 × 9 1/2 × 6 7/8 in. (74.7 × 24.2 × 17.5 cm)
~ 3 5/8 × 64 15/16 × 14 9/16 in. (9.2 × 165 × 37 cm)
~ 38 × 14 3/8 × 4 in. (96.5 × 36.5 × 10.2 cm)
~ 8 × 74 3/4 × 10 in. (20.3 × 189.9 × 25.4 cm)
~ 8 × 57 1/2 × 8 in. (20.3 × 146.1 × 20.3 cm)
~ L. 50 ×  Diam. Largest 4 3/4 -  smallest 1 1/2  in. (127 × 12.1 - 3.8 cm)
~ 49 × 13 1/2 × 12 3/16 in. (124.5 × 34.3 × 31 cm)
~ Sankh: 6 × 6 × 16 3/4 in. (15.2 × 15.2 × 42.5 cm)
Stand: 2 1/4 × 4 3/4 × 5 3/4 in. (5.7 × 12.1 × 14.6 cm)
~ L 9 3/16 × W. 6 5/8 in. (23.4 × 16.9 cm)
~ Height: 7 in. (17.8 cm)
Width (Of base): 4 1/16 in. (10.3 cm)
~ Length:  56.5 cm (22-1/4 in.)
~ 4 vols. in box
~ H: 10 1/4 in. (26 cm)
~ H: 18 1/2 in. (47 cm)
~ H: 13 3/8 in. (34 cm)
~ vols. 1–8; H. 14 5/8 in. (37 cm)
~ 4 nos. in 3 vols.; H. (irregular): 11 in. ( 28 cm)
~ 2 volumes : frontispiece (portrait), illustrations (some color), 93 plates (some color, including map), 2 diagrams; 
Height: 24 13/16 in. (63 cm); 
Width: 18 7/8 in. (48 cm)
~ 140, 4 pages, frontispiece, illustrations, Height: 12 3/16 in. (31 cm)
~ 83 pages, 3 leaves : illustrations, plates ; Height: 8 11/16 in. (22 cm)
~ 176 pages, illustrations ; Height: 12 3/16 in. (31 cm)
~ 8 unnumbered pages, 56 pages, 8 unnumbered leaves of plates : illustrations ; Height: 9 1/16 in. (23 cm)
~ 831 leaves of plates : col. ill. ; Height: 11 13/16 in. (30 cm)
~ cix, 164 pages, [100] leaves of plates : illustrations (some color) ; Height: 11 13/16 in. (30 cm)
~ 1 volume (unpaged) : illustrations ; Height: 9 1/16 in. (23 cm)
~ illustrations ; height: 8 11/16 in. (22 cm)
~ 1 volume (unpaged) : (chiefly illustrations (some folded, some color)) ; 11 × 11 × 1/2 in. (27.9 × 27.9 × 1.3 cm)
~ 22 unnumbered pages : (chiefly illustrations, some color) ; 8 1/2 × 10 7/8 × 3/8 in. (21.6 × 27.6 × 1 cm)
~ 1 portfolio (4 unnumbered pages, 56 leaves of plates) : illustrations (some color) ; 13 × 10 in. (33 × 25.4 cm)
~ 36 in. × 8 ft. 9 1/2 in. (91.4 × 268 cm)
~ xii, 690 pages : illustrations, plates, color frontispiece, 7 color plates ; Height: 11 7/16 in. (29 cm)
~ 2 volumes : samples ; Height: 12 5/8 in. (32 cm) + 2 sheets (contents)
~ 11 7/16 × 13 3/4 in. (29 × 35 cm)
~ 87 pages, [21] leaves of plates : illustrations (some color), facsimiles ; Height: 16 9/16 in. (42 cm)
~ 1 bound volume (80 p. : ill. ; 36 cm.), 1 portfolio (80 folders of col. ill. + "Commentary," 1 paperbound v. ; 36 cm.) : chiefly col. ill. ; in cloth-covered case ; Height: 14 9/16 in. (37 cm)
~ 12 3/4 × 9 13/16 × 5/16 in. (32.4 × 24.9 × 0.8 cm)
~ 1 volume (unpaged) : samples ; Height: 8 1/4 in. (21 cm)
~ 1 volume : frontispiece, illustrations, plates, plans, facsimiles ; Height: 16 15/16 in. (43 cm)
~ 47 pages : illustrations ; Height: 11 in. (28 cm) ; Width: 14 3/16 in. (36 cm)
~ 159 pages; Height: 9 7/16 in. (24 cm)
~ 89 pages : illustrations; Height: 8 11/16 in. (22 cm)
~ volume : illustrations; Height: 9 13/16 in. (25 cm)
~ volume : illustrations; Height: 12 5/8 in. (32 cm)
~ 1 volume (unpaged) : illustrations ; Height: 6 5/16 in. (16 cm)
~ 16 unnumbered pages : illustrations (some color); Height: 9 13/16 in. (25 cm)
~ 1 volume : illustrations, plates ; Height: 15 3/4 in. (40 cm)
~ 1 volume : illustrations, plates ; Height: 15 3/4 in. (40 cm)
~ 8 unnumbered pages : Height: 7 7/8 in. (20 cm)
~ 7 pages, 30 plates ; Height: 16 15/16 in. (43 cm)
~ 50 3/4 × 82 1/2 in. (128.9 × 209.6 cm)
~ [12] pages : illustrations ; Height: 9 7/16 in. (24 cm)
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ 62 items : illustrations, music
~ Illustrations ; Height: 10 1/4 in. (26 cm)
~ 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
~ 2 volumes : 10 folded plates, 3 folded plans ; Height: 6 11/16 in. (17 cm)
~ 9 unnumbered pages, 117 pages ; Height: 10 1/4 in. (26 cm)
~ 2 volumes : frontispiece, 29 plates (18 folded) ; Height: 6 11/16 in. (17 cm)
~ [6], 84, [12] pages : 5 folded plans ; Height: 6 11/16 in. (17 cm)
~ 24, 407 pages, 1 leaf of plates : illustrations ; Height: 6 11/16 in. (17 cm)
~ 62 items : illustrations, music
~ 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
~ 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
~ 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
~ 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
~ 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
~ 2 volumes : 10 folded plates, 3 folded plans ; Height: 6 11/16 in. (17 cm)
~ [8], 244 leaves of plates : chiefly illustrations (engravings), portrait ; Height: 18 1/2 in. (47 cm)
~ volume : illustrations (some color) ; Height: 12 1/16 in. (30.7 cm)
~ volume : illustrations ( some color) ; Height: 13 1/16 in. (33.2 cm)
~ volume : illustrations ; Height: 12 7/8 in. (32.7 cm)
~ volume : illustrations ; Height: 12 11/16 in. (32.3 cm)
~ 207 pages, illustrations (some color), Height: 10 1/4 in. (26 cm)
~ 2 pages, l, ii, [2], 72, 4 pages : illustrations, 71 plates (1 folded) ; Height: 22 13/16 in. (58 cm)
~ 7 pages of leaves, 3-106 pages, 3 leaves : frontispiece, plates ; Height: 8 11/16 in. (22 cm)
~ 45 pages : 1 leaf including color frontispiece, illustrations ; Height: 9 13/16 in. (25 cm)
~ 1 volume : chiefly color illustrations, samples ; Height: 13 3/4 in. (35 cm) - 17 11/16 in. (45 cm)

~ 2 volumes : illustrations (some color) ; Height: 15 3/4 in. (40 cm)
~ 2 pages, leaf, ii, [3]-52 pages, 85 leaves of plates : illustrations, map, 12 plans ; Height: 23 5/8 × 16 9/16 in. (60 cm)
~ 1 sound disc : analog, 33 1/3 rpm; Height: 12 in. (30.5 cm)
~ [4] pages, [15] leaves of plates : color illustrations, plates ; Height: 19 5/16 in. (49 cm) x Width: 16 1/8 in. (41 cm)
~ Height: 10 7/8 in. (27.6 cm)
Width: 8 3/8 in. (21.3 cm)
~ Height: 10 7/8 in. (27.6 cm)
Width: 8 3/8 in. (21.3 cm)
~ Height: 10 7/8 in. (27.6 cm)
Width: 8 3/8 in. (21.3 cm)
~ Height: 10 7/8 in. (27.6 cm)
Width: 8 3/8 in. (21.3 cm)
~ 24 pages : all photographs ; Height: 8 1/4 in. (21 cm) x Width: 11 7/16 in. (29 cm)
~ 84 leaves : chiefly illustrations ; Height: 25 3/16 in. (64 cm)
~ [4], 314 pages, [7] folded leaves of plates : diagrams ; Height: 8 1/4 in. (21 cm)
~ 2 preliminary leaves, 6, [106] pages : 100 plates (some color including frontispiece) ; Height: 22 7/16 in. (57 cm) x Width: 15 3/8 in. (39 cm)
~ 21 leaves of plates : all illustrations ; Height: 13 3/4 in. (35 cm)
~ 1 sheet ; Height: 8 1/4 in. (21 cm) x Width: 5 7/8 in. (15 cm)
~ 85 pages, Height: 9 7/16 in. (24 cm)
~ xix, 100, 37 pages, Height: 10 1/4 in. (26 cm)
~ 101 pages, Height: 9 1/16 in. (23 cm)
~ 241 pages, Height: 9 7/16 in. (24 cm)
~ 111 pages : illustrations ; Height: 9 7/16 in. (24 cm)
~ 51 pages : illustrations ; Height: 9 1/16 in. (23 cm)
~ 66 pages ; Height: 9 7/16 in. (24 cm)
~ 133 pages, [1] folded leaf of plates : illustrations ; Height: 9 7/16 in. (24 cm)
~ 190, [6] pages, 6 leaves of plates : illustrations (some color) ; Height: 9 1/16 in. (23 cm)
~ 9 volumes : illustrations ; Height: 21 5/8 in. (55 cm)
~ 266 pages : illustrations ; Height: 12 3/16 in. (31 cm)
~ 16 volumes ; 50 cm. or smaller + 5 boxes of catalog cards
~ xvii pages, 1 leaves, 380 pages : illustrations, plates ; Height: 13 3/4 in. (35 cm) x Width: 11 in. (28 cm)
~ ca. 375 leaves in various foliations : illustrations, samples ; Height: 11 13/16 in. (30 cm)
~ ca. 375 leaves in various foliations : illustrations, samples ; Height: 11 13/16 in. (30 cm)
~ 1 volume (139 pages) ; Height: 17 5/16 in. (44 cm)
~ 284 leaves
~ 1 volume (unpaged) : illustrations (some color) ; Height: 8 1/4 in. (21 cm) x Width: 9 1/16 in. (23 cm)
~ 57 pages : illustrations ; Height: 12 5/8 in. (32 cm)
~ 31 pages : illustrations ; Height: 9 7/16 in. (24 cm)
~ 120 pages : illustrations ; Height: 9 1/16 in. (23 cm)
~ 28 volumes : illustrations (some color) ; Height: 9 7/16 in. (24 cm) - 15 3/4 in. (40 cm)
~ [64] leaves : illustrations ; Height: 17 11/16 × 15 3/8 in. (45 × 39 cm)
~ xi, 105 pages, [2] pages of plates : illustrations ; Height: 15 3/8 in. (39 cm)
~ [158] plates, 36 pages ; Height: 20 1/2 in. (52 cm)
~ Height: 5 1/8 in. (13 cm)
Width: 3 15/16 in. (10 cm)
~ Height: 5 1/2 in. (14 cm)
Width: 3 15/16 in. (10 cm)
~ Height: 4 3/4 in. (12 cm)
Width: 4 5/16 in. (11 cm)
~ Height: 5 1/8 in. (13 cm)
Width: 3 15/16 in. (10 cm)
~ 1 volume (unpaged) : illustrations ; Height: 5 7/8 in. (15 cm) ; Width: 9 7/16 in. (24 cm)
~ 12 pages : all samples ; Height: 11 7/16 in. (29 cm)
~ 26 leaves : chiefly color illustrations ; Height: 9 1/16 in. (23 cm)
~ volumes : illustrations, plates (some color) ; Height: 16 9/16 in. (42 cm)
~ volumes : illustrations, plates (some color) ; Height: 16 9/16 in. (42 cm)
~ 25 volumes : illustrations, portraits ; Height: 14 3/16 in. (36 cm)
~ 2 volumes : plates, map ; Height: 9 1/16 in. (23 cm)
~ 2 volumes : plates, map ; Height: 9 1/16 in. (23 cm)
~ 46 unnumbered pages :1 illustration ; Height: 11 7/16 in. (29 cm)
~ 1 box (approximately 34 various pieces) : illustrations ; Height: 14 9/16 in. (37 cm) ; Width: 11 13/16 in. (30 cm) Depth: 3 1/8 in. (8 cm)
~ 2 volumes in 1 : illustrations ; Height: 11 in. (28 cm)
from parse import *
import re

#search('{:d}.{:d} x {:d}.{:d} cm',dim)
#print (_[0], _[1], _[2], _[3], )

# dim = '132 x 102 in. (335.3 x 259.1 cm)'
#dim = '132 x 102 in. (335 x 259 cm)'
#search('{:d}.{:d} x {:d}.{:d} cm',dim)
#    print (_[0], _[1], _[2], _[3], )


# dim = '9 1/2 x 37 1/2 x 6 1/4 in. (24.1 x 95.3 x 15.9 cm)'

result = None

# dim ='H. 11 3/4 in. (29.8 cm)'
# result = re.match("(\d+\.\d+) x (\d+\.\d+) cm",dim)

for index, row in missing_hdf.iterrows():

    id  = row['Object ID']
    
    print (id, "|",end =" ")
    if (isinstance(row['Dimensions'], str)):
        dim = row['Dimensions']
    else:
        # print ("-> NaN")
        continue
    
    result = re.match(".*?(\d+(\.\d+)*) [×x] (\d+(\.\d+)*) [×x] (\d+(\.\d+)*) ?cm",dim)
    if result:
        print (dim)
        print (result.groups())
        print ("-> H: {} W: {} D: {}".format(result.groups()[0],result.groups()[2],result.groups()[4]))

    else: 
        result = re.match(".*?(\d+(\.\d+)*) [×x] (\d+(\.\d+)*) ?cm",dim)
        if result:
            print (dim)
            print (result.groups())
            print ("-> H: {} W: {}".format(result.groups()[0],result.groups()[2]))
        else:
            result = re.match(".*?[\(](\d+(\.\d+)*) ?cm",dim)
            if result:
                print (dim)
                print (result.groups())
                typeresult = re.match("^(H\.|Height)",dim)
                if typeresult:
                    print ("-> H: {}".format(result.groups()[0]))
                    continue
                typeresult = re.match("^(L\.|L:|Length)",dim)
                
            else:
                print ("--- Unmatched: {}".format(dim))
                
# Another case
# H. 34 in. (86.4 cm)
# W. 39 1/2 in. (100.3 cm)
# D. 2 3/4 in. (7 cm)

# Various dimensions

# Height: 29 15/16 in. (76 cm)
# Width: 8 1/4 in. (21 cm)

# 2 volumes : plates, map ; Height: 9 1/16 in. (23 cm)
282 | 132 x 102 in. (335.3 x 259.1 cm)
('335.3', '.3', '259.1', '.1')
-> H: 335.3 W: 259.1
3577 | Overall: 19 1/16 x 8 3/4 x 6 3/8 in. (48.4 x 22.2 x 16.2 cm); 64 oz. 9 dwt. (2005.6 g)
Plateau: 2 5/16 x 17 1/4 in. (5.9 x 43.8 cm); 67 oz. 2 dwt. (2086.5 g)
('48.4', '.4', '22.2', '.2', '16.2', '.2')
-> H: 48.4 W: 22.2 D: 16.2
7873 | 13 ft. 7 1/2 in. × 28 ft. 7 in. × 47 ft. 8 5/8 in. (415.3 × 871.2 × 1454.5 cm)
Each window panel: 53 3/4 x 22 3/4 in. (136.5 x 57.8 cm)
('415.3', '.3', '871.2', '.2', '1454.5', '.5')
-> H: 415.3 W: 871.2 D: 1454.5
11494 | 72 x 32 1/2 x 54 in. (182.9 x 82.6 x 137.2 cm)
('182.9', '.9', '82.6', '.6', '137.2', '.2')
-> H: 182.9 W: 82.6 D: 137.2
15590 | 9 1/2 x 37 1/2 x 6 1/4 in. (24.1 x 95.3 x 15.9 cm)
('24.1', '.1', '95.3', '.3', '15.9', '.9')
-> H: 24.1 W: 95.3 D: 15.9
22871 | sword: L. 39 1/4 in. (99.8 cm); L. of blade 33 in. (83.7 cm); Wt. 2 lb. 8 oz. (1129 g); scabbard: L. 34 5/8 in. (88 cm); Wt. 2 lb. 4 oz. (1023 g)
('99.8', '.8')
23205 | H. 66 1/2 in. (168.9 cm), Wt. 41 lb. (18.6 kg)
('168.9', '.9')
-> H: 168.9
79142 | 79269 | 79585 | 79778 | 79884 | 80208 | 80378 | 80547 | 80790 | 80840 | 80911 | 81101 | 81102 | 81103 | 81104 | 81106 | 81111 | 81112 | 81114 | 81115 | 81116 | 81118 | 81121 | 81122 | 81124 | 81125 | 81128 | 81131 | 81140 | 81141 | 81142 | 81143 | 81387 | 81453 | 81460 | 81468 | 81472 | 81476 | 81480 | 81490 | 81678 | 81692 | 82105 | 82170 | 82419 | 82443 | 82446 | 82981 | 83175 | 83179 | 83209 | 83234 | 83242 | 83250 | 83259 | 83442 | 83443 | 84034 | 87016 | 87370 | 87613 | 88645 | 112900 | 130481 | 159388 | 187784 | Height: 10 3/8 in. (26.4 cm)
('26.4', '.4')
-> H: 26.4
196439 | Overall (confirmed): H. 38 1/2 x W. 17 1/4 x D. 14 3/8 in. (97.8 x 43.8 x 36.5 cm) [n.b.: fluffiness of skirt skews measurement]
('97.8', '.8', '43.8', '.8', '36.5', '.5')
-> H: 97.8 W: 43.8 D: 36.5
232038 | Overall (confirmed): 45 5/8 x 22 1/2 x 24 1/8 in., 145 lb. (115.9 x 57.2 x 61.3 cm, 65.7716 kg)
('115.9', '.9', '57.2', '.2', '61.3', '.3')
-> H: 115.9 W: 57.2 D: 61.3
262720 | 28.3 x 22.7 cm (11 1/8 x 8 15/16 in.)
('28.3', '.3', '22.7', '.7')
-> H: 28.3 W: 22.7
264688 | 24.1 x 19.7 cm (9 1/2 x 7 3/4 in.)
('24.1', '.1', '19.7', '.7')
-> H: 24.1 W: 19.7
265047 | 10.9 x 8 cm (4 5/16 x 3 1/8 in.)
('10.9', '.9', '8', None)
-> H: 10.9 W: 8
265132 | 23.5 x 18.8 cm (9 1/4 x 7 3/8 in.)
('23.5', '.5', '18.8', '.8')
-> H: 23.5 W: 18.8
265133 | 32.8 x 24.4 cm (12 15/16 x 9 5/8 in.)
('32.8', '.8', '24.4', '.4')
-> H: 32.8 W: 24.4
265166 | 41.8 x 31.8 cm (16 7/16 x 12 1/2 in.)
('41.8', '.8', '31.8', '.8')
-> H: 41.8 W: 31.8
265447 | 19.2 x 24.4 cm (7 9/16  x 9 5/8  in.)
('19.2', '.2', '24.4', '.4')
-> H: 19.2 W: 24.4
265465 | 11.7 x 8.6 cm (4 5/8 x 3 3/8 in.)
('11.7', '.7', '8.6', '.6')
-> H: 11.7 W: 8.6
265550 | 11.3 x 8.9 cm (4 7/16 x 3 1/2 in.)
('11.3', '.3', '8.9', '.9')
-> H: 11.3 W: 8.9
265553 | 23.6 x 18.3 cm (9 5/16 x 7 3/16 in.)
('23.6', '.6', '18.3', '.3')
-> H: 23.6 W: 18.3
265563 | 29 x 23.5 cm (11 7/16 x 9 1/4 in.)
('29', None, '23.5', '.5')
-> H: 29 W: 23.5
265616 | 28.7 x 23.2 cm (11 5/16 x 9 1/8 in.)
('28.7', '.7', '23.2', '.2')
-> H: 28.7 W: 23.2
265903 | Image: 7 11/16 × 6 5/16 in. (19.5 × 16.1 cm)
Mount: 7 11/16 × 6 5/16 in. (19.5 × 16.1 cm)
('19.5', '.5', '16.1', '.1')
-> H: 19.5 W: 16.1
266102 | 37.5 x 27.9 cm (14 3/4 x 11 in.)
('37.5', '.5', '27.9', '.9')
-> H: 37.5 W: 27.9
266162 | 19.4 x 24.6 cm (7 5/8 x 9 11/16 in.)
('19.4', '.4', '24.6', '.6')
-> H: 19.4 W: 24.6
266199 | 17.3 x 24 cm (6 13/16 x 9 7/16 in.)
('17.3', '.3', '24', None)
-> H: 17.3 W: 24
266262 | 106.4 x 111.4 cm (41 7/8 x 43 7/8 in.)
('106.4', '.4', '111.4', '.4')
-> H: 106.4 W: 111.4
266349 | 60 x 46.8 cm (23 5/8 x 18 7/16 in.)
('60', None, '46.8', '.8')
-> H: 60 W: 46.8
266427 | 169.5 x 129.5cm (66 3/4 x 51in.)
Frame: 177.2 × 137.2 cm (69 3/4 × 54 in.)
('169.5', '.5', '129.5', '.5')
-> H: 169.5 W: 129.5
266537 | 23 x 17 cm (9 1/16 x 6 11/16 in.)
('23', None, '17', None)
-> H: 23 W: 17
266709 | 101.6 x 76.2 cm (40 x 30 in.)
('101.6', '.6', '76.2', '.2')
-> H: 101.6 W: 76.2
266746 | 23.5 x 33.7 cm (9 1/4 x 13 1/4 in.)
('23.5', '.5', '33.7', '.7')
-> H: 23.5 W: 33.7
266784 | 18.7 x 23.9 cm (7 3/8 x 9 7/16 in.)
('18.7', '.7', '23.9', '.9')
-> H: 18.7 W: 23.9
266850 | 24.4 x 19.4 cm (9 5/8 x 7 5/8 in.)
('24.4', '.4', '19.4', '.4')
-> H: 24.4 W: 19.4
266855 | 104.5 x 135.5cm (41 1/8 x 53 3/8in.)
Frame: 127 × 156.2 cm (50 × 61 1/2 in.)
('104.5', '.5', '135.5', '.5')
-> H: 104.5 W: 135.5
266859 | 110 x 185 cm (43 5/16 x 72 13/16 in.)
('110', None, '185', None)
-> H: 110 W: 185
267010 | 42.3 x 54.2 cm (16 5/8 x 21 5/16 in.)
('42.3', '.3', '54.2', '.2')
-> H: 42.3 W: 54.2
267041 | 194.3 x 204.5 cm (76 1/2 x 80 1/2 in.), framed
('194.3', '.3', '204.5', '.5')
-> H: 194.3 W: 204.5
267175 | 185.4 x 221.3 cm (73 x 87 1/8 in.)
('185.4', '.4', '221.3', '.3')
-> H: 185.4 W: 221.3
267193 | 61 x 50.8 cm (24 x 20 in.)
('61', None, '50.8', '.8')
-> H: 61 W: 50.8
267271 | 68.6 x 101.6cm (27 x 40in.)
Frame: 76.2 × 109.2 cm (30 × 43 in.)
('68.6', '.6', '101.6', '.6')
-> H: 68.6 W: 101.6
267362 | 19.6 x 24.3 cm. (7 3/4 x 9 9/16 in.), each
('19.6', '.6', '24.3', '.3')
-> H: 19.6 W: 24.3
267363 | 181.9 x 230.5 cm (71 5/8 x 90 3/4 in.)
('181.9', '.9', '230.5', '.5')
-> H: 181.9 W: 230.5
267748 | 34 x 25.7 cm (13 3/8 x 10 1/8 in.)
('34', None, '25.7', '.7')
-> H: 34 W: 25.7
267757 | 21 x 15 cm (8 1/4 x 5 15/16 in.)
('21', None, '15', None)
-> H: 21 W: 15
267775 | 37.9 x 46 cm (14 15/16 x 18 1/8 in.)
('37.9', '.9', '46', None)
-> H: 37.9 W: 46
267803 | 47.8 x 38.4 cm (18 13/16 x 15 1/8 in.)
('47.8', '.8', '38.4', '.4')
-> H: 47.8 W: 38.4
267838 | 47.8 × 38.4 cm (18 13/16 × 15 1/8 in.)
Frame: 34 5/8 × 29 5/8 in. (87.9 × 75.2 cm)
('47.8', '.8', '38.4', '.4')
-> H: 47.8 W: 38.4
267839 | 49.9 × 38.9 cm (19 5/8 × 15 5/16 in.)
Frame: 34 5/8 × 29 5/8 in. (87.9 × 75.2 cm)
('49.9', '.9', '38.9', '.9')
-> H: 49.9 W: 38.9
267842 | 39.3 x 48.3 cm (15 1/2 x 19 in.)
('39.3', '.3', '48.3', '.3')
-> H: 39.3 W: 48.3
269436 | 32.7 x 43.5 cm (12 7/8 x 17 1/8 in.)
('32.7', '.7', '43.5', '.5')
-> H: 32.7 W: 43.5
271716 | Image: 7 1/16 × 10 1/2 in. (18 × 26.6 cm)
('18', None, '26.6', '.6')
-> H: 18 W: 26.6
271948 | Image: 24.2 × 31.6 cm (9 1/2 × 12 7/16 in.)
Sheet: 24.9 × 32.3 cm (9 13/16 × 12 11/16 in.)
Mount: 28 × 33.9 cm (11 in. × 13 3/8 in.)
('24.2', '.2', '31.6', '.6')
-> H: 24.2 W: 31.6
271954 | Image: 187 x 93.4 cm (73 5/8 x 36 3/4 in.)
Frame: 223.5 x 130.8 cm (88 x 51 1/2 in.)
('187', None, '93.4', '.4')
-> H: 187 W: 93.4
272071 | 7.9 x 7.9 cm (3 1/8 x 3 1/8 in.)
('7.9', '.9', '7.9', '.9')
-> H: 7.9 W: 7.9
281940 | Frame: 43 1/2 × 33 1/2 in. (110.5 × 85.1 cm)
('110.5', '.5', '85.1', '.1')
-> H: 110.5 W: 85.1
281977 | 92.9 x 90.8 cm (36 9/16 x 35 3/4 in.)
('92.9', '.9', '90.8', '.8')
-> H: 92.9 W: 90.8
282515 | 8.7 x 11.7 cm (3 7/16 x 4 5/8 in.)
('8.7', '.7', '11.7', '.7')
-> H: 8.7 W: 11.7
282740 | 24.8 x 19 cm (9 3/4 x 7 1/2 in.)
('24.8', '.8', '19', None)
-> H: 24.8 W: 19
282757 | 210 x 165 cm (82 11/16 x 64 15/16 in.)
('210', None, '165', None)
-> H: 210 W: 165
282774 | Frame: 152.4 × 127 cm (60 × 50 in.)
('152.4', '.4', '127', None)
-> H: 152.4 W: 127
282778 | 18.9 x 23.7 cm (7 7/16 x 9 5/16 in.)
('18.9', '.9', '23.7', '.7')
-> H: 18.9 W: 23.7
282883 | 128.9 x 169.5 cm (50 3/4 x 66 3/4 in.)
('128.9', '.9', '169.5', '.5')
-> H: 128.9 W: 169.5
283236 | Image: 43.7 x 53.8 cm (17 3/16 x 21 3/16 in.)
('43.7', '.7', '53.8', '.8')
-> H: 43.7 W: 53.8
283277 | Image: 49 x 39.8cm (19 5/16 x 15 11/16in.)
('49', None, '39.8', '.8')
-> H: 49 W: 39.8
283720 | 7.8 x 10 cm (3 1/16 x 3 15/16 in.)
('7.8', '.8', '10', None)
-> H: 7.8 W: 10
283742 | 127 x 177.8cm (50 x 70in.)
Frame: 154.9 × 221 cm (61 × 87 in.)
('127', None, '177.8', '.8')
-> H: 127 W: 177.8
284086 | Dimensions vary from 8.4 x 7.5 cm (3 5/16 x 2 15/16 in.) to 45.7 x 55.9 cm (18 x 22 in.)
('8.4', '.4', '7.5', '.5')
-> H: 8.4 W: 7.5
284572 | 47 x 34.3 cm (18 1/2 x 13 1/2 in.)
('47', None, '34.3', '.3')
-> H: 47 W: 34.3
284712 | Image: 39.5 x 38.3 cm (15 9/16 x 15 1/16 in.)
Sheet: 50.8 x 40.6 cm (20 x 16 in.)
('39.5', '.5', '38.3', '.3')
-> H: 39.5 W: 38.3
285142 | 286725 | Image: 229 x 437 cm (90 3/16 x 172 1/16 in.)

('229', None, '437', None)
-> H: 229 W: 437
291951 | Image: 119.1 x 159.7 cm (46 7/8 x 62 7/8 in.)
Frame: 48 × 63 in. (121.9 × 160 cm)
('119.1', '.1', '159.7', '.7')
-> H: 119.1 W: 159.7
309868 | H. 5 1/2 x W. 4 1/2 in. (14 x 11.4 cm)
('14', None, '11.4', '.4')
-> H: 14 W: 11.4
310073 | H. 33 1/4 x W. 11 x D. 1 1/2 in. (84.5 x 27.9 x 3.8 cm)
('84.5', '.5', '27.9', '.9', '3.8', '.8')
-> H: 84.5 W: 27.9 D: 3.8
310453 | H. 39 in. (91.9 cm)
('91.9', '.9')
-> H: 91.9
310454 | H. 25 11/16 x W. 38 x D. 7 7/8 in. (65.2 x 96.5 x 20 cm)
('65.2', '.2', '96.5', '.5', '20', None)
-> H: 65.2 W: 96.5 D: 20
310870 | H. 25 3/16 x W. 7 7/8 x D. 6 1/2 in. (64 x 20 x 16.5 cm)
('64', None, '20', None, '16.5', '.5')
-> H: 64 W: 20 D: 16.5
310950 | H. 30 1/4 x W. 13 x  D. 9 in. (76.8 x 33 x 22.9 cm)
('76.8', '.8', '33', None, '22.9', '.9')
-> H: 76.8 W: 33 D: 22.9
310960 | H. 23 x W. 5 1/2 x D. 5 in. (58.4 x 14 x 12.7 cm)
('58.4', '.4', '14', None, '12.7', '.7')
-> H: 58.4 W: 14 D: 12.7
311159 | H. 75 x W. 24 x D. 6 1/2 in. (190.5 x 61 x 16.5 cm)
('190.5', '.5', '61', None, '16.5', '.5')
-> H: 190.5 W: 61 D: 16.5
311171 | H. 29 1/2 x W. 21 x D. 16 in. (74.9 x 53.3 x 40.6 cm)
('74.9', '.9', '53.3', '.3', '40.6', '.6')
-> H: 74.9 W: 53.3 D: 40.6
311183 | H. 55 1/8 x W. 15 x D. 1 1/2 in. (140 x 38.1 x 3.8 cm)
('140', None, '38.1', '.1', '3.8', '.8')
-> H: 140 W: 38.1 D: 3.8
311237 | H. 55 7/8 x W. 29 1/2 x D. 5 in. (141.9 x 74.9 x 12.7 cm)
('141.9', '.9', '74.9', '.9', '12.7', '.7')
-> H: 141.9 W: 74.9 D: 12.7
311290 | H. 42 1/2 x W. 23 x D. 7 in. (108 x 58.4 x 17.8 cm)
('108', None, '58.4', '.4', '17.8', '.8')
-> H: 108 W: 58.4 D: 17.8
311294 | H. 96 in (243.8 cm)
('243.8', '.8')
-> H: 243.8
311651 | H. 29 1/4 x W. 21 1/2 x D. 25 in. (74.3 x 54.6 x 63.5 cm)
('74.3', '.3', '54.6', '.6', '63.5', '.5')
-> H: 74.3 W: 54.6 D: 63.5
311950 | H. 21 1/2 x W. 25 x D. 22 3/4 in. (54.6 x 63.5 x 57.8 cm)
('54.6', '.6', '63.5', '.5', '57.8', '.8')
-> H: 54.6 W: 63.5 D: 57.8
312119 | H. 42 x W. 9 x D. 7 in. (106.7 x 22.9 x 17.8 cm)
('106.7', '.7', '22.9', '.9', '17.8', '.8')
-> H: 106.7 W: 22.9 D: 17.8
312180 | H. 20 3/4 x W. 15 x D. 4 in. (52.7 x 38.1 x 10.2 cm)
('52.7', '.7', '38.1', '.1', '10.2', '.2')
-> H: 52.7 W: 38.1 D: 10.2
312231 | H. 20 1/2  x  L.93  x  D. 18 1/2  in. (52.1 x 236.2 x 47 cm)
('52.1', '.1', '236.2', '.2', '47', None)
-> H: 52.1 W: 236.2 D: 47
312288 | H. 29 1/2 x W. 6 x  D. 5 1/4 in.(74.9 x 15.2 x 13.3 cm)
('74.9', '.9', '15.2', '.2', '13.3', '.3')
-> H: 74.9 W: 15.2 D: 13.3
312336 | H. 48 5/8 x W. 14 7/16 x D. 14 3/8 in. (123.5 x 36.6 x 36.5 cm)
('123.5', '.5', '36.6', '.6', '36.5', '.5')
-> H: 123.5 W: 36.6 D: 36.5
312342 | H. 23 1/8 x D. 10 1/4 x W. 10 in. (58.8 x 26 x 25.4 cm)
('58.8', '.8', '26', None, '25.4', '.4')
-> H: 58.8 W: 26 D: 25.4
312460 | H. 10 15/16 x W. 6 x D. 7 1/4 in. (27.9 x 15.2 x 18.4 cm)
('27.9', '.9', '15.2', '.2', '18.4', '.4')
-> H: 27.9 W: 15.2 D: 18.4
313313 | H. 24 x W. 23 3/4 x D. 6 1/2 in. (61 x 60.3 x 16.5 cm)
('61', None, '60.3', '.3', '16.5', '.5')
-> H: 61 W: 60.3 D: 16.5
313546 | H. 26 x W. 15 1/2 x D. 19 in. (66 x 39.4 x 48.3 cm)
('66', None, '39.4', '.4', '48.3', '.3')
-> H: 66 W: 39.4 D: 48.3
313629 | H. 36 1/8 x W. 8 1/2 x D. 8 1/2 in. (91.8 x 21.6 x 21.6 cm)
('91.8', '.8', '21.6', '.6', '21.6', '.6')
-> H: 91.8 W: 21.6 D: 21.6
313654 | H. 38 3/4 x W. 10 x D. 7 1/2 in. (98.4 x 25.4 x 19.1cm)
('98.4', '.4', '25.4', '.4', '19.1', '.1')
-> H: 98.4 W: 25.4 D: 19.1
313780 | H. 72 x W. 12 3/4 x D. 9 7/8 in. (182.9 x 32.4 x 25.1cm)
('182.9', '.9', '32.4', '.4', '25.1', '.1')
-> H: 182.9 W: 32.4 D: 25.1
313830 | H. 18 ft. × W. 39 in. × D. 63 in. (548.6 × 99.1 × 160 cm)
('548.6', '.6', '99.1', '.1', '160', None)
-> H: 548.6 W: 99.1 D: 160
314034 | H. 24 in. (61 cm)
('61', None)
-> H: 61
314366 | H. 43 1/2 x W. 10 1/4 x D. 8 3/4 in. (110.5 x 26 x 22.2 cm)
('110.5', '.5', '26', None, '22.2', '.2')
-> H: 110.5 W: 26 D: 22.2
314370 | H. 19 1/4 in. (48.9 cm)
('48.9', '.9')
-> H: 48.9
314704 | H. 35 3/8 x W. 9 x D. 10 3/8in. (89.9 x 22.9 x 26.4cm)
('89.9', '.9', '22.9', '.9', '26.4', '.4')
-> H: 89.9 W: 22.9 D: 26.4
314826 | H. 16 x W. 3 7/8 x D. 2 1/2 in. (40.6 x 9.9 x 6.4 cm)
('40.6', '.6', '9.9', '.9', '6.4', '.4')
-> H: 40.6 W: 9.9 D: 6.4
316007 | H. 13 1/2 in (34.3 cm)
('34.3', '.3')
-> H: 34.3
316008 | H. 71 x W. 12 x D. 10 1/2 in. (180.3 x 30.5 x 26.7 cm)
('180.3', '.3', '30.5', '.5', '26.7', '.7')
-> H: 180.3 W: 30.5 D: 26.7
316145 | H: 4 1/2 in. (11.4 cm)
('11.4', '.4')
317735 | H. 81 1/2 x W. 38 in. (207 x 96.5 cm)
('207', None, '96.5', '.5')
-> H: 207 W: 96.5
317792 | H. 11 1/2 in. (29.2 cm)
('29.2', '.2')
-> H: 29.2
318667 | H. 13 1/2 x W. 7 1/2 x D. 6 1/2 in. (34.3 x 19.1 x 16.5 cm)
('34.3', '.3', '19.1', '.1', '16.5', '.5')
-> H: 34.3 W: 19.1 D: 16.5
318765 | H. 10 1/4 in. (26 cm)
('26', None)
-> H: 26
318899 | H. 11 3/4 in. (29.8cm)
('29.8', '.8')
-> H: 29.8
319033 | H. 60 x W. 67 in. (152.4 x 170.2 cm)
('152.4', '.4', '170.2', '.2')
-> H: 152.4 W: 170.2
319233 | H. 8 1/4 in. (21 cm)
('21', None)
-> H: 21
319458 | H. 21 13/16 x W. 4 x D. 4 1/8 in. (55.4 x 10.2 x 10.5 cm)
('55.4', '.4', '10.2', '.2', '10.5', '.5')
-> H: 55.4 W: 10.2 D: 10.5
319872 | H. 86 3/4 x W. 128 in. (220.3 x 325.1 cm)
('220.3', '.3', '325.1', '.1')
-> H: 220.3 W: 325.1
320053 | H. 46 1/2 in. (118 cm), W. 19 1/2 in. (49.5 cm), D. 15 1/2 in. (39.4 cm)
('118', None)
-> H: 118
336773 | 29 1/2 x 47 1/4in. (74.9 x 120cm)
('74.9', '.9', '120', None)
-> H: 74.9 W: 120
337068 | Sheet: 25 11/16 x 19 11/16 in. (65.2 x 50 cm)
Plate: 18 1/4 x 14 7/8 in. (46.4 x 37.8 cm)
('65.2', '.2', '50', None)
-> H: 65.2 W: 50
337069 | Image: 16 1/2 x 10 1/4 in. (41.9 x 26 cm)
Sheet: 16 1/2 x 25 3/16 in. (41.9 x 64 cm)
('41.9', '.9', '26', None)
-> H: 41.9 W: 26
352328 | Sheet: 6 x 6 in. (15.2 x 15.2 cm)
('15.2', '.2', '15.2', '.2')
-> H: 15.2 W: 15.2
354644 | 24 1/4 x 39 inches (61.6 x 99 cm)
('61.6', '.6', '99', None)
-> H: 61.6 W: 99
360255 | Sheet: 11 5/16 x 7 1/2 in. (28.8 x 19 cm)
('28.8', '.8', '19', None)
-> H: 28.8 W: 19
383125 | Sheet: 8 5/16 x 6 1/2 in. (21.1 x 16.5 cm)
('21.1', '.1', '16.5', '.5')
-> H: 21.1 W: 16.5
413556 | Sheet: 2 5/8 x 1 7/16 in. (6.7 x 3.7 cm)
('6.7', '.7', '3.7', '.7')
-> H: 6.7 W: 3.7
446996 | H. 15 in. (38.1 cm)
Max. Diam. 4 5/16 in. (11 cm)
('38.1', '.1')
-> H: 38.1
449154 | H. 34 in. (86.4 cm)
W. 39 1/2 in. (100.3 cm)
D. 2 3/4 in. (7 cm)
 Estimated weight: 140 lbs.  (Weight extrapolated from dimensions of similar unframed Nishapur stucco.)
('86.4', '.4')
-> H: 86.4
472507 | Apse interior: 30 ft. 2 in. × 24 ft. 7 in. × 27 ft. 8 in. (919.5 × 749.3 × 843.3 cm)
b: (lion capital): 14 1/8 × 20 1/4 × 17 1/4 in. (35.9 × 51.4 × 43.8 cm)
f: (pier with acrobat): 60 × 12 1/4 × 12 1/2 in. (152.4 × 31.1 × 31.8 cm)
('919.5', '.5', '749.3', '.3', '843.3', '.3')
-> H: 919.5 W: 749.3 D: 843.3
481986 | 43 in. (109.2 cm)
('109.2', '.2')
482533 | Overall: 80 1/4 × 34 1/4 × 18 7/8 in., Weight: 153 lb. (203.8 × 87 × 47.9 cm, 69.4 kg)
Base: 30 1/2 × 34 1/4 × 18 7/8 in., Weight: 83 lb. (77.5 × 87 × 47.9 cm, 37.6 kg)
Top: 49 3/4 × 30 1/2 × 17 in., Weight: 70 lb. (126.4 × 77.5 × 43.2 cm, 31.8 kg)
('203.8', '.8', '87', None, '47.9', '.9')
-> H: 203.8 W: 87 D: 47.9
486636 | 3 3/8 x 9 x 9 3/8 in. (8.6 x 22.9 x 23.8 cm)
('8.6', '.6', '22.9', '.9', '23.8', '.8')
-> H: 8.6 W: 22.9 D: 23.8
487424 | 50 1/4 x 33 3/4 x 14 in. (127.6 x 85.7 x 35.6 cm)
('127.6', '.6', '85.7', '.7', '35.6', '.6')
-> H: 127.6 W: 85.7 D: 35.6
488326 | 18 5/8 x 15 5/8 in. (47.3 x 39.7 cm)
('47.3', '.3', '39.7', '.7')
-> H: 47.3 W: 39.7
489972 | 26 7/8 × 17 3/4 in. (68.3 × 45.1 cm)
('68.3', '.3', '45.1', '.1')
-> H: 68.3 W: 45.1
490759 | Tea Urn, 1a-c:  H. 14-1/2, D. 11 in. (36.8 x 19.7 cm)
Tray, 2:  H. 5/8 Diam. 17-5/8 in. (44.5 cm)
Creamer, 3:  H. 3, W. 6, D. 3-7/8 in. (7.6 x 15.2 x 9.8 cm)
Sugar Bowl, 4a,b:  H. 6-3/4, W. 6, D. 3-7/8 in. (17.1 x 15.2 x 9.8 cm)
Large Tray, 5: H. 1/2 Diam. 20-3/8 in. (51.4 cm)
('36.8', '.8', '19.7', '.7')
-> H: 36.8 W: 19.7
490893 | 12 1/8 x 12 1/2 x 3 1/2 in. (30.8 x 31.8 x 8.9 cm)
('30.8', '.8', '31.8', '.8', '8.9', '.9')
-> H: 30.8 W: 31.8 D: 8.9
491299 | 3 1/4 × 4 1/4 × 6 1/2 in. (8.3 × 10.8 × 16.5 cm)
('8.3', '.3', '10.8', '.8', '16.5', '.5')
-> H: 8.3 W: 10.8 D: 16.5
491720 | --- Unmatched: Various dimensions
492332 | --- Unmatched: 17 ft. 3 in. x 26 ft. 3 in. (3.71 x 5.26 x 8 m.)
492747 | 26 1/2 x 40 x 44 1/2 in. (67.3 x 101.6 x 113 cm)
('67.3', '.3', '101.6', '.6', '113', None)
-> H: 67.3 W: 101.6 D: 113
494703 | 22 x 25 x 10 in. (55.9 x 63.5 x 25.4 cm)
Weight: 1 lb. (.5 kg)
('55.9', '.9', '63.5', '.5', '25.4', '.4')
-> H: 55.9 W: 63.5 D: 25.4
494943 | Variable: 112-3/4 x 80 x 81-1/2 in. (286.4 x 203.2 x 207 cm)
('286.4', '.4', '203.2', '.2', '207', None)
-> H: 286.4 W: 203.2 D: 207
495458 | 89 3/4 x 89 1/4 x 16 1/2 in. (228 x 226.7 x 41.9 cm)
('228', None, '226.7', '.7', '41.9', '.9')
-> H: 228 W: 226.7 D: 41.9
500605 | Height: 22 in. (55.9 cm)
Width: 22 in. (55.9 cm)
('55.9', '.9')
-> H: 55.9
500637 | Height: 19 in. (48.3 cm)
('48.3', '.3')
-> H: 48.3
500709 | W. 45 1/2 × D. 5 7/8 in. (115.5 × 15 cm)
('115.5', '.5', '15', None)
-> H: 115.5 W: 15
500736 | Height: 12 in. (30.5 cm)
Diameter: 6 1/2 in. (16.5 cm)
('30.5', '.5')
-> H: 30.5
500782 | 5 3/8 × 7 × 6 7/16 in. (13.7 × 17.8 × 16.4 cm)
('13.7', '.7', '17.8', '.8', '16.4', '.4')
-> H: 13.7 W: 17.8 D: 16.4
500928 | 42 1/4 × 9 3/4 × 2 1/2 in. (107.3 × 24.8 × 6.4 cm)
('107.3', '.3', '24.8', '.8', '6.4', '.4')
-> H: 107.3 W: 24.8 D: 6.4
501109 | L. 34 1/16 x W. 17 15/16 × D. 8 11/16  in (86.5 x 45.5 × 22 cm)
('86.5', '.5', '45.5', '.5', '22', None)
-> H: 86.5 W: 45.5 D: 22
501213 | L. 21 in. (53.3 cm)
('53.3', '.3')
501227 | 12 3/16 × 4 1/16 × 4 1/8 in. (31 × 10.3 × 10.5 cm)
('31', None, '10.3', '.3', '10.5', '.5')
-> H: 31 W: 10.3 D: 10.5
501536 | Height: 29 15/16 in. (76 cm)
Width: 8 1/4 in. (21 cm)
('76', None)
-> H: 76
501876 | Height: 18 in. (45.7 cm)
Width: 11 in. (27.9 cm)
Diameter (At widest point): 35 1/2 in. (90.2 cm)
Diameter (Of base): 31 in. (78.7 cm)
('45.7', '.7')
-> H: 45.7
502040 | H. 35 5/16 × W. 34 1/4 × D. 8 1/16 in. (89.7 × 87 × 20.5 cm)
('89.7', '.7', '87', None, '20.5', '.5')
-> H: 89.7 W: 87 D: 20.5
502048 | L: 54 in. (137.2 cm)
('137.2', '.2')
502064 | H. 22 1/16 × W. 24 × D. 12 3/16 in. (56 × 61 × 31 cm)
('56', None, '61', None, '31', None)
-> H: 56 W: 61 D: 31
502402 | Height: 25 in. (63.5 cm)
Diameter: 11 in. (27.9 cm)
('63.5', '.5')
-> H: 63.5
502625 | 26 5/8 × 2 1/8 × 1 5/8 in. (67.6 × 5.4 × 4.1 cm)
('67.6', '.6', '5.4', '.4', '4.1', '.1')
-> H: 67.6 W: 5.4 D: 4.1
502761 | Tsii'edo'a'tl: 17 5/16 × 5 1/4 × 3 3/4 in. (44 × 13.3 × 9.5 cm)
Bow: 3 1/8 × 5/8 × 21 in. (7.9 × 1.6 × 53.3 cm)
('44', None, '13.3', '.3', '9.5', '.5')
-> H: 44 W: 13.3 D: 9.5
502833 | 19 × 2 3/4 in. (48.3 × 7 cm)
('48.3', '.3', '7', None)
-> H: 48.3 W: 7
502914 | 18 3/4 × 1 1/4 × 2 3/8 in. (47.6 × 3.2 × 6 cm)
('47.6', '.6', '3.2', '.2', '6', None)
-> H: 47.6 W: 3.2 D: 6
503052 | --- Unmatched: L. longest pipe 45.4 cm (17-7/8 in.); L. shortest pipe 18.1 cm (7-1/8 in.)
503060 | 45 9/16 × 20 11/16 × 17 in. (115.8 × 52.5 × 43.2 cm)
('115.8', '.8', '52.5', '.5', '43.2', '.2')
-> H: 115.8 W: 52.5 D: 43.2
503160 | Height: 20 7/8 in. (53 cm)
Width: 21 5/8 in. (55 cm)
Depth: 13 3/4 in. (35 cm)
('53', None)
-> H: 53
503200 | Height: 32 3/8 in. (82.2 cm)
Diameter (Maximum): 24 7/16 in. (62 cm)
Diameter (Drum head): 21 3/4 in. (55.3 cm)
('82.2', '.2')
-> H: 82.2
503204 | 29 7/16 × 9 1/2 × 6 7/8 in. (74.7 × 24.2 × 17.5 cm)
('74.7', '.7', '24.2', '.2', '17.5', '.5')
-> H: 74.7 W: 24.2 D: 17.5
503206 | 3 5/8 × 64 15/16 × 14 9/16 in. (9.2 × 165 × 37 cm)
('9.2', '.2', '165', None, '37', None)
-> H: 9.2 W: 165 D: 37
503282 | 38 × 14 3/8 × 4 in. (96.5 × 36.5 × 10.2 cm)
('96.5', '.5', '36.5', '.5', '10.2', '.2')
-> H: 96.5 W: 36.5 D: 10.2
503340 | 8 × 74 3/4 × 10 in. (20.3 × 189.9 × 25.4 cm)
('20.3', '.3', '189.9', '.9', '25.4', '.4')
-> H: 20.3 W: 189.9 D: 25.4
503442 | 8 × 57 1/2 × 8 in. (20.3 × 146.1 × 20.3 cm)
('20.3', '.3', '146.1', '.1', '20.3', '.3')
-> H: 20.3 W: 146.1 D: 20.3
503519 | --- Unmatched: L. 50 ×  Diam. Largest 4 3/4 -  smallest 1 1/2  in. (127 × 12.1 - 3.8 cm)
503529 | 49 × 13 1/2 × 12 3/16 in. (124.5 × 34.3 × 31 cm)
('124.5', '.5', '34.3', '.3', '31', None)
-> H: 124.5 W: 34.3 D: 31
503672 | Sankh: 6 × 6 × 16 3/4 in. (15.2 × 15.2 × 42.5 cm)
Stand: 2 1/4 × 4 3/4 × 5 3/4 in. (5.7 × 12.1 × 14.6 cm)
('15.2', '.2', '15.2', '.2', '42.5', '.5')
-> H: 15.2 W: 15.2 D: 42.5
503679 | L 9 3/16 × W. 6 5/8 in. (23.4 × 16.9 cm)
('23.4', '.4', '16.9', '.9')
-> H: 23.4 W: 16.9
503936 | Height: 7 in. (17.8 cm)
Width (Of base): 4 1/16 in. (10.3 cm)
('17.8', '.8')
-> H: 17.8
505501 | --- Unmatched: Length:  56.5 cm (22-1/4 in.)
591867 | --- Unmatched: 4 vols. in box
591869 | H: 10 1/4 in. (26 cm)
('26', None)
591870 | H: 18 1/2 in. (47 cm)
('47', None)
591871 | H: 13 3/8 in. (34 cm)
('34', None)
591872 | vols. 1–8; H. 14 5/8 in. (37 cm)
('37', None)
591873 | --- Unmatched: 4 nos. in 3 vols.; H. (irregular): 11 in. ( 28 cm)
680379 | --- Unmatched: 2 volumes : frontispiece (portrait), illustrations (some color), 93 plates (some color, including map), 2 diagrams; 
Height: 24 13/16 in. (63 cm); 
Width: 18 7/8 in. (48 cm)
697342 | 140, 4 pages, frontispiece, illustrations, Height: 12 3/16 in. (31 cm)
('31', None)
697355 | 83 pages, 3 leaves : illustrations, plates ; Height: 8 11/16 in. (22 cm)
('22', None)
697701 | 176 pages, illustrations ; Height: 12 3/16 in. (31 cm)
('31', None)
698851 | 8 unnumbered pages, 56 pages, 8 unnumbered leaves of plates : illustrations ; Height: 9 1/16 in. (23 cm)
('23', None)
699928 | 831 leaves of plates : col. ill. ; Height: 11 13/16 in. (30 cm)
('30', None)
700046 | cix, 164 pages, [100] leaves of plates : illustrations (some color) ; Height: 11 13/16 in. (30 cm)
('30', None)
702543 | 1 volume (unpaged) : illustrations ; Height: 9 1/16 in. (23 cm)
('23', None)
706047 | illustrations ; height: 8 11/16 in. (22 cm)
('22', None)
708838 | 1 volume (unpaged) : (chiefly illustrations (some folded, some color)) ; 11 × 11 × 1/2 in. (27.9 × 27.9 × 1.3 cm)
('27.9', '.9', '27.9', '.9', '1.3', '.3')
-> H: 27.9 W: 27.9 D: 1.3
708839 | 22 unnumbered pages : (chiefly illustrations, some color) ; 8 1/2 × 10 7/8 × 3/8 in. (21.6 × 27.6 × 1 cm)
('21.6', '.6', '27.6', '.6', '1', None)
-> H: 21.6 W: 27.6 D: 1
708840 | 1 portfolio (4 unnumbered pages, 56 leaves of plates) : illustrations (some color) ; 13 × 10 in. (33 × 25.4 cm)
('33', None, '25.4', '.4')
-> H: 33 W: 25.4
717548 | 36 in. × 8 ft. 9 1/2 in. (91.4 × 268 cm)
('91.4', '.4', '268', None)
-> H: 91.4 W: 268
726681 | xii, 690 pages : illustrations, plates, color frontispiece, 7 color plates ; Height: 11 7/16 in. (29 cm)
('29', None)
727404 | 2 volumes : samples ; Height: 12 5/8 in. (32 cm) + 2 sheets (contents)
('32', None)
736324 | 11 7/16 × 13 3/4 in. (29 × 35 cm)
('29', None, '35', None)
-> H: 29 W: 35
736858 | 87 pages, [21] leaves of plates : illustrations (some color), facsimiles ; Height: 16 9/16 in. (42 cm)
('42', None)
737721 | 1 bound volume (80 p. : ill. ; 36 cm.), 1 portfolio (80 folders of col. ill. + "Commentary," 1 paperbound v. ; 36 cm.) : chiefly col. ill. ; in cloth-covered case ; Height: 14 9/16 in. (37 cm)
('37', None)
737907 | 12 3/4 × 9 13/16 × 5/16 in. (32.4 × 24.9 × 0.8 cm)
('32.4', '.4', '24.9', '.9', '0.8', '.8')
-> H: 32.4 W: 24.9 D: 0.8
739510 | 1 volume (unpaged) : samples ; Height: 8 1/4 in. (21 cm)
('21', None)
739518 | 1 volume : frontispiece, illustrations, plates, plans, facsimiles ; Height: 16 15/16 in. (43 cm)
('43', None)
747642 | 47 pages : illustrations ; Height: 11 in. (28 cm) ; Width: 14 3/16 in. (36 cm)
('28', None)
747646 | 159 pages; Height: 9 7/16 in. (24 cm)
('24', None)
747650 | 89 pages : illustrations; Height: 8 11/16 in. (22 cm)
('22', None)
747655 | volume : illustrations; Height: 9 13/16 in. (25 cm)
('25', None)
747661 | volume : illustrations; Height: 12 5/8 in. (32 cm)
('32', None)
747797 | 1 volume (unpaged) : illustrations ; Height: 6 5/16 in. (16 cm)
('16', None)
747798 | 16 unnumbered pages : illustrations (some color); Height: 9 13/16 in. (25 cm)
('25', None)
749358 | 1 volume : illustrations, plates ; Height: 15 3/4 in. (40 cm)
('40', None)
749368 | 1 volume : illustrations, plates ; Height: 15 3/4 in. (40 cm)
('40', None)
749370 | 8 unnumbered pages : Height: 7 7/8 in. (20 cm)
('20', None)
749592 | 7 pages, 30 plates ; Height: 16 15/16 in. (43 cm)
('43', None)
749639 | 50 3/4 × 82 1/2 in. (128.9 × 209.6 cm)
('128.9', '.9', '209.6', '.6')
-> H: 128.9 W: 209.6
751309 | [12] pages : illustrations ; Height: 9 7/16 in. (24 cm)
('24', None)
752562 | --- Unmatched: 62 items : illustrations, music
752566 | --- Unmatched: 62 items : illustrations, music
752567 | --- Unmatched: 62 items : illustrations, music
752568 | --- Unmatched: 62 items : illustrations, music
752570 | --- Unmatched: 62 items : illustrations, music
752572 | --- Unmatched: 62 items : illustrations, music
752574 | --- Unmatched: 62 items : illustrations, music
752582 | --- Unmatched: 62 items : illustrations, music
752586 | --- Unmatched: 62 items : illustrations, music
752589 | --- Unmatched: 62 items : illustrations, music
752591 | --- Unmatched: 62 items : illustrations, music
752596 | --- Unmatched: 62 items : illustrations, music
752597 | --- Unmatched: 62 items : illustrations, music
752598 | --- Unmatched: 62 items : illustrations, music
752599 | --- Unmatched: 62 items : illustrations, music
752600 | --- Unmatched: 62 items : illustrations, music
752602 | --- Unmatched: 62 items : illustrations, music
752603 | --- Unmatched: 62 items : illustrations, music
752605 | --- Unmatched: 62 items : illustrations, music
752606 | --- Unmatched: 62 items : illustrations, music
752607 | --- Unmatched: 62 items : illustrations, music
752609 | --- Unmatched: 62 items : illustrations, music
755011 | Illustrations ; Height: 10 1/4 in. (26 cm)
('26', None)
755772 | 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
('17', None)
755774 | 2 volumes : 10 folded plates, 3 folded plans ; Height: 6 11/16 in. (17 cm)
('17', None)
755777 | 9 unnumbered pages, 117 pages ; Height: 10 1/4 in. (26 cm)
('26', None)
755783 | 2 volumes : frontispiece, 29 plates (18 folded) ; Height: 6 11/16 in. (17 cm)
('17', None)
755786 | [6], 84, [12] pages : 5 folded plans ; Height: 6 11/16 in. (17 cm)
('17', None)
755789 | 24, 407 pages, 1 leaf of plates : illustrations ; Height: 6 11/16 in. (17 cm)
('17', None)
756894 | --- Unmatched: 62 items : illustrations, music
760245 | 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
('17', None)
760247 | 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
('17', None)
760248 | 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
('17', None)
760249 | 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
('17', None)
760250 | 6 volumes : frontispiece, 14 engraved folded plates (including plans) ; Height: 6 11/16 in. (17 cm)
('17', None)
760251 | 2 volumes : 10 folded plates, 3 folded plans ; Height: 6 11/16 in. (17 cm)
('17', None)
769306 | [8], 244 leaves of plates : chiefly illustrations (engravings), portrait ; Height: 18 1/2 in. (47 cm)
('47', None)
769368 | volume : illustrations (some color) ; Height: 12 1/16 in. (30.7 cm)
('30.7', '.7')
769372 | volume : illustrations ( some color) ; Height: 13 1/16 in. (33.2 cm)
('33.2', '.2')
769373 | volume : illustrations ; Height: 12 7/8 in. (32.7 cm)
('32.7', '.7')
769387 | volume : illustrations ; Height: 12 11/16 in. (32.3 cm)
('32.3', '.3')
773144 | 207 pages, illustrations (some color), Height: 10 1/4 in. (26 cm)
('26', None)
787771 | 2 pages, l, ii, [2], 72, 4 pages : illustrations, 71 plates (1 folded) ; Height: 22 13/16 in. (58 cm)
('58', None)
787806 | 7 pages of leaves, 3-106 pages, 3 leaves : frontispiece, plates ; Height: 8 11/16 in. (22 cm)
('22', None)
787807 | 45 pages : 1 leaf including color frontispiece, illustrations ; Height: 9 13/16 in. (25 cm)
('25', None)
811179 | 1 volume : chiefly color illustrations, samples ; Height: 13 3/4 in. (35 cm) - 17 11/16 in. (45 cm)

('35', None)
811180 | 2 volumes : illustrations (some color) ; Height: 15 3/4 in. (40 cm)
('40', None)
811182 | 2 pages, leaf, ii, [3]-52 pages, 85 leaves of plates : illustrations, map, 12 plans ; Height: 23 5/8 × 16 9/16 in. (60 cm)
('60', None)
811186 | 1 sound disc : analog, 33 1/3 rpm; Height: 12 in. (30.5 cm)
('30.5', '.5')
812492 | [4] pages, [15] leaves of plates : color illustrations, plates ; Height: 19 5/16 in. (49 cm) x Width: 16 1/8 in. (41 cm)
('49', None)
813836 | Height: 10 7/8 in. (27.6 cm)
Width: 8 3/8 in. (21.3 cm)
('27.6', '.6')
-> H: 27.6
813837 | Height: 10 7/8 in. (27.6 cm)
Width: 8 3/8 in. (21.3 cm)
('27.6', '.6')
-> H: 27.6
813838 | Height: 10 7/8 in. (27.6 cm)
Width: 8 3/8 in. (21.3 cm)
('27.6', '.6')
-> H: 27.6
813839 | Height: 10 7/8 in. (27.6 cm)
Width: 8 3/8 in. (21.3 cm)
('27.6', '.6')
-> H: 27.6
813852 | 24 pages : all photographs ; Height: 8 1/4 in. (21 cm) x Width: 11 7/16 in. (29 cm)
('21', None)
813854 | 84 leaves : chiefly illustrations ; Height: 25 3/16 in. (64 cm)
('64', None)
813855 | [4], 314 pages, [7] folded leaves of plates : diagrams ; Height: 8 1/4 in. (21 cm)
('21', None)
814025 | 2 preliminary leaves, 6, [106] pages : 100 plates (some color including frontispiece) ; Height: 22 7/16 in. (57 cm) x Width: 15 3/8 in. (39 cm)
('57', None)
815475 | 21 leaves of plates : all illustrations ; Height: 13 3/4 in. (35 cm)
('35', None)
818177 | 1 sheet ; Height: 8 1/4 in. (21 cm) x Width: 5 7/8 in. (15 cm)
('21', None)
818844 | 85 pages, Height: 9 7/16 in. (24 cm)
('24', None)
818847 | xix, 100, 37 pages, Height: 10 1/4 in. (26 cm)
('26', None)
818854 | 101 pages, Height: 9 1/16 in. (23 cm)
('23', None)
818860 | 241 pages, Height: 9 7/16 in. (24 cm)
('24', None)
818874 | 111 pages : illustrations ; Height: 9 7/16 in. (24 cm)
('24', None)
818890 | 51 pages : illustrations ; Height: 9 1/16 in. (23 cm)
('23', None)
818891 | 66 pages ; Height: 9 7/16 in. (24 cm)
('24', None)
818893 | 133 pages, [1] folded leaf of plates : illustrations ; Height: 9 7/16 in. (24 cm)
('24', None)
818895 | 190, [6] pages, 6 leaves of plates : illustrations (some color) ; Height: 9 1/16 in. (23 cm)
('23', None)
820544 | 9 volumes : illustrations ; Height: 21 5/8 in. (55 cm)
('55', None)
820559 | 266 pages : illustrations ; Height: 12 3/16 in. (31 cm)
('31', None)
820668 | --- Unmatched: 16 volumes ; 50 cm. or smaller + 5 boxes of catalog cards
820669 | xvii pages, 1 leaves, 380 pages : illustrations, plates ; Height: 13 3/4 in. (35 cm) x Width: 11 in. (28 cm)
('35', None)
820673 | ca. 375 leaves in various foliations : illustrations, samples ; Height: 11 13/16 in. (30 cm)
('30', None)
820676 | ca. 375 leaves in various foliations : illustrations, samples ; Height: 11 13/16 in. (30 cm)
('30', None)
820677 | 1 volume (139 pages) ; Height: 17 5/16 in. (44 cm)
('44', None)
820680 | --- Unmatched: 284 leaves
820681 | 1 volume (unpaged) : illustrations (some color) ; Height: 8 1/4 in. (21 cm) x Width: 9 1/16 in. (23 cm)
('21', None)
820684 | 57 pages : illustrations ; Height: 12 5/8 in. (32 cm)
('32', None)
820685 | 31 pages : illustrations ; Height: 9 7/16 in. (24 cm)
('24', None)
820686 | 120 pages : illustrations ; Height: 9 1/16 in. (23 cm)
('23', None)
820688 | 28 volumes : illustrations (some color) ; Height: 9 7/16 in. (24 cm) - 15 3/4 in. (40 cm)
('24', None)
821386 | [64] leaves : illustrations ; Height: 17 11/16 × 15 3/8 in. (45 × 39 cm)
('45', None, '39', None)
-> H: 45 W: 39
821397 | xi, 105 pages, [2] pages of plates : illustrations ; Height: 15 3/8 in. (39 cm)
('39', None)
821398 | [158] plates, 36 pages ; Height: 20 1/2 in. (52 cm)
('52', None)
821874 | Height: 5 1/8 in. (13 cm)
Width: 3 15/16 in. (10 cm)
('13', None)
-> H: 13
821878 | Height: 5 1/2 in. (14 cm)
Width: 3 15/16 in. (10 cm)
('14', None)
-> H: 14
821879 | Height: 4 3/4 in. (12 cm)
Width: 4 5/16 in. (11 cm)
('12', None)
-> H: 12
821880 | Height: 5 1/8 in. (13 cm)
Width: 3 15/16 in. (10 cm)
('13', None)
-> H: 13
821881 | 1 volume (unpaged) : illustrations ; Height: 5 7/8 in. (15 cm) ; Width: 9 7/16 in. (24 cm)
('15', None)
821896 | 12 pages : all samples ; Height: 11 7/16 in. (29 cm)
('29', None)
821898 | 26 leaves : chiefly color illustrations ; Height: 9 1/16 in. (23 cm)
('23', None)
821928 | volumes : illustrations, plates (some color) ; Height: 16 9/16 in. (42 cm)
('42', None)
821930 | volumes : illustrations, plates (some color) ; Height: 16 9/16 in. (42 cm)
('42', None)
821934 | 25 volumes : illustrations, portraits ; Height: 14 3/16 in. (36 cm)
('36', None)
821935 | 2 volumes : plates, map ; Height: 9 1/16 in. (23 cm)
('23', None)
821938 | 2 volumes : plates, map ; Height: 9 1/16 in. (23 cm)
('23', None)
823304 | 46 unnumbered pages :1 illustration ; Height: 11 7/16 in. (29 cm)
('29', None)
823364 | 1 box (approximately 34 various pieces) : illustrations ; Height: 14 9/16 in. (37 cm) ; Width: 11 13/16 in. (30 cm) Depth: 3 1/8 in. (8 cm)
('37', None)
824357 | 2 volumes in 1 : illustrations ; Height: 11 in. (28 cm)
('28', None)
for index, row in missing_hdf.iterrows():
    id   = row['Object ID']
    dim  = row['Dimensions']
    name = row['Object Name']
    print (id,name,dim)
    search('{:d} x {:d} in.', dim)
    
282 Window 132 x 102 in. (335.3 x 259.1 cm)
3577 Ewer Overall: 19 1/16 x 8 3/4 x 6 3/8 in. (48.4 x 22.2 x 16.2 cm); 64 oz. 9 dwt. (2005.6 g)
Plateau: 2 5/16 x 17 1/4 in. (5.9 x 43.8 cm); 67 oz. 2 dwt. (2086.5 g)
7873 Windows and Paneling 13 ft. 7 1/2 in. × 28 ft. 7 in. × 47 ft. 8 5/8 in. (415.3 × 871.2 × 1454.5 cm)
Each window panel: 53 3/4 x 22 3/4 in. (136.5 x 57.8 cm)
11494 Sculpture 72 x 32 1/2 x 54 in. (182.9 x 82.6 x 137.2 cm)
15590 Sculpture 9 1/2 x 37 1/2 x 6 1/4 in. (24.1 x 95.3 x 15.9 cm)
22871 Saber with scabbard sword: L. 39 1/4 in. (99.8 cm); L. of blade 33 in. (83.7 cm); Wt. 2 lb. 8 oz. (1129 g); scabbard: L. 34 5/8 in. (88 cm); Wt. 2 lb. 4 oz. (1023 g)
23205 Armor H. 66 1/2 in. (168.9 cm), Wt. 41 lb. (18.6 kg)
79142 Evening dress nan
---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-12-0396c28231bf> in <module>
      5     name = row['Object Name']
      6     print (id,name,dim)
----> 7     search('{:d} x {:d} in.', dim)
      8 

/srv/paws/lib/python3.6/site-packages/parse.py in search(format, string, pos, endpos, extra_types, evaluate_result, case_sensitive)
   1262     '''
   1263     p = Parser(format, extra_types=extra_types, case_sensitive=case_sensitive)
-> 1264     return p.search(string, pos, endpos, evaluate_result=evaluate_result)
   1265 
   1266 

/srv/paws/lib/python3.6/site-packages/parse.py in search(self, string, pos, endpos, evaluate_result)
    800         '''
    801         if endpos is None:
--> 802             endpos = len(string)
    803         m = self._search_re.search(string, pos, endpos)
    804         if m is None:

TypeError: object of type 'float' has no len()