introduction to pandas#
import pandas as pd
---------------------------------------------------------------------------
ModuleNotFoundError Traceback (most recent call last)
Cell In[1], line 1
----> 1 import pandas as pd
ModuleNotFoundError: No module named 'pandas'
This is the script I used to import my data using the MET API. I am including it here as plain text so that the code won’t execute when I run and publish the notebook.
import requests
import json
url = "https://collectionapi.metmuseum.org/public/collection/v1/search"
params = {'q': 'woman'}
r = requests.get(url, params=params)
parsed = r.json()
ids = parsed['objectIDs']
objects = []
for i in ids[:500]:
url = f"https://collectionapi.metmuseum.org/public/collection/v1/objects/{i}"
r = requests.get(url)
parsed = r.json()
objects.append(parsed)
with open("woman_500.json", "w") as f:
json.dump(objects, f)
# import the above script
df = pd.read_csv('https://bit.ly/664-met-woman')
df
| Unnamed: 0 | objectID | isHighlight | accessionNumber | accessionYear | isPublicDomain | primaryImage | primaryImageSmall | additionalImages | constituents | ... | rightsAndReproduction | linkResource | metadataDate | repository | objectURL | tags | objectWikidata_URL | isTimelineWork | GalleryNumber | message | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 483873.0 | 0.0 | 1984.613.2 | 1984.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 161817, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-10-11T04:53:25.173Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q20189686 | 0.0 | NaN | NaN |
| 1 | 1 | 207162.0 | 0.0 | 1982.60.281 | 1982.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | [] | [{'constituentID': 38388, 'role': 'Manufactory... | ... | NaN | NaN | 2023-02-07T04:46:51.34Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q116307111 | 0.0 | 543 | NaN |
| 2 | 2 | 247582.0 | 0.0 | 06.1169 | 1906.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | ['https://images.metmuseum.org/CRDImages/gr/or... | [{'constituentID': 49108, 'role': 'Artist', 'n... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q116289687 | 0.0 | 159 | NaN |
| 3 | 3 | 283274.0 | 0.0 | 2005.100.206 | 1999.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 162092, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-01-05T04:58:47.817Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Still Life', 'AAT_URL': 'http://voc... | NaN | 0.0 | NaN | NaN |
| 4 | 4 | 483877.0 | 0.0 | 1984.613.6 | 1984.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 161817, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-08-31T04:53:19.483Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q19923391 | 1.0 | NaN | NaN |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 495 | 495 | 202972.0 | 0.0 | 63.197 | 1963.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | ['https://images.metmuseum.org/CRDImages/es/or... | [{'constituentID': 163601, 'role': 'Artist', '... | ... | NaN | NaN | 2023-11-15T21:02:33.593Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Male Nudes', 'AAT_URL': 'http://voc... | NaN | 0.0 | 620 | NaN |
| 496 | 496 | 338096.0 | 0.0 | 66.93.2 | 1966.0 | 1.0 | https://images.metmuseum.org/CRDImages/dp/orig... | https://images.metmuseum.org/CRDImages/dp/web-... | [] | [{'constituentID': 72767, 'role': 'Artist', 'n... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Soldiers', 'AAT_URL': 'http://vocab... | https://www.wikidata.org/wiki/Q97324515 | 0.0 | NaN | NaN |
| 497 | 497 | 252375.0 | 0.0 | 26.31.453 | 1926.0 | 0.0 | NaN | NaN | [] | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | NaN | https://www.wikidata.org/wiki/Q116404118 | 0.0 | 152 | NaN |
| 498 | 498 | 545150.0 | 0.0 | 25.3.253 | 1925.0 | 1.0 | https://images.metmuseum.org/CRDImages/eg/orig... | https://images.metmuseum.org/CRDImages/eg/web-... | ['https://images.metmuseum.org/CRDImages/eg/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | NaN | https://www.wikidata.org/wiki/Q116245135 | 1.0 | 105 | NaN |
| 499 | 499 | 207191.0 | 0.0 | 1982.60.311, .312 | 1982.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | [] | [{'constituentID': 164832, 'role': 'Manufactor... | ... | NaN | NaN | 2024-08-14T04:52:51.407Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Men', 'AAT_URL': 'http://vocab.gett... | https://www.wikidata.org/wiki/Q116310232 | 0.0 | 538 | NaN |
500 rows × 59 columns
viewing data#
overview information:
df.info(),df.head(),df.tail()attributes:
df.shape,df.columns()selecting columns:
df['column_name'],df.column_nameseeing values:
df['column_name'].valuesslicing rows:
df['0:3']statistics:
df.describe()
df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 500 entries, 0 to 499
Data columns (total 59 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 Unnamed: 0 500 non-null int64
1 objectID 492 non-null float64
2 isHighlight 492 non-null float64
3 accessionNumber 492 non-null object
4 accessionYear 489 non-null float64
5 isPublicDomain 492 non-null float64
6 primaryImage 415 non-null object
7 primaryImageSmall 415 non-null object
8 additionalImages 492 non-null object
9 constituents 129 non-null object
10 department 492 non-null object
11 objectName 491 non-null object
12 title 492 non-null object
13 culture 283 non-null object
14 period 348 non-null object
15 dynasty 66 non-null object
16 reign 26 non-null object
17 portfolio 0 non-null float64
18 artistRole 129 non-null object
19 artistPrefix 7 non-null object
20 artistDisplayName 129 non-null object
21 artistDisplayBio 122 non-null object
22 artistSuffix 1 non-null object
23 artistAlphaSort 129 non-null object
24 artistNationality 120 non-null object
25 artistBeginDate 123 non-null object
26 artistEndDate 123 non-null object
27 artistGender 11 non-null object
28 artistWikidata_URL 118 non-null object
29 artistULAN_URL 120 non-null object
30 objectDate 491 non-null object
31 objectBeginDate 492 non-null float64
32 objectEndDate 492 non-null float64
33 medium 492 non-null object
34 dimensions 492 non-null object
35 measurements 456 non-null object
36 creditLine 492 non-null object
37 geographyType 99 non-null object
38 city 7 non-null object
39 state 2 non-null object
40 county 0 non-null float64
41 country 88 non-null object
42 region 38 non-null object
43 subregion 38 non-null object
44 locale 23 non-null object
45 locus 13 non-null object
46 excavation 26 non-null object
47 river 0 non-null float64
48 classification 394 non-null object
49 rightsAndReproduction 26 non-null object
50 linkResource 0 non-null float64
51 metadataDate 492 non-null object
52 repository 492 non-null object
53 objectURL 492 non-null object
54 tags 422 non-null object
55 objectWikidata_URL 458 non-null object
56 isTimelineWork 492 non-null float64
57 GalleryNumber 443 non-null object
58 message 8 non-null object
dtypes: float64(11), int64(1), object(47)
memory usage: 230.6+ KB
df.shape
(500, 42)
df.columns
Index(['Unnamed: 0', 'objectID', 'isHighlight', 'accessionNumber',
'accessionYear', 'isPublicDomain', 'primaryImage', 'primaryImageSmall',
'additionalImages', 'constituents', 'department', 'objectName', 'title',
'culture', 'period', 'dynasty', 'reign', 'portfolio', 'artistRole',
'artistPrefix', 'artistDisplayName', 'artistDisplayBio', 'artistSuffix',
'artistAlphaSort', 'artistNationality', 'artistBeginDate',
'artistEndDate', 'artistGender', 'artistWikidata_URL', 'artistULAN_URL',
'objectDate', 'objectBeginDate', 'objectEndDate', 'medium',
'dimensions', 'measurements', 'creditLine', 'geographyType', 'city',
'state', 'county', 'country', 'region', 'subregion', 'locale', 'locus',
'excavation', 'river', 'classification', 'rightsAndReproduction',
'linkResource', 'metadataDate', 'repository', 'objectURL', 'tags',
'objectWikidata_URL', 'isTimelineWork', 'GalleryNumber', 'message'],
dtype='object')
df = df.drop('Unnamed: 0', axis=1)
df.columns
Index(['objectID', 'isHighlight', 'accessionNumber', 'accessionYear',
'isPublicDomain', 'primaryImage', 'primaryImageSmall',
'additionalImages', 'constituents', 'department', 'objectName', 'title',
'culture', 'period', 'dynasty', 'reign', 'portfolio', 'artistRole',
'artistPrefix', 'artistDisplayName', 'artistDisplayBio', 'artistSuffix',
'artistAlphaSort', 'artistNationality', 'artistBeginDate',
'artistEndDate', 'artistGender', 'artistWikidata_URL', 'artistULAN_URL',
'objectDate', 'objectBeginDate', 'objectEndDate', 'medium',
'dimensions', 'measurements', 'creditLine', 'geographyType', 'city',
'state', 'county', 'country', 'region', 'subregion', 'locale', 'locus',
'excavation', 'river', 'classification', 'rightsAndReproduction',
'linkResource', 'metadataDate', 'repository', 'objectURL', 'tags',
'objectWikidata_URL', 'isTimelineWork', 'GalleryNumber', 'message'],
dtype='object')
unwanted_columns = ['primaryImageSmall', 'portfolio', 'artistRole', 'artistPrefix', 'artistSuffix', 'artistAlphaSort', 'subregion', 'locale', 'locus', 'excavation', 'river', 'classification', 'rightsAndReproduction', 'linkResource', 'metadataDate', 'repository']
for item in unwanted_columns:
df = df.drop(item, axis=1)
df.columns
Index(['objectID', 'isHighlight', 'accessionNumber', 'accessionYear',
'isPublicDomain', 'primaryImage', 'additionalImages', 'constituents',
'department', 'objectName', 'title', 'culture', 'period', 'dynasty',
'reign', 'artistDisplayName', 'artistDisplayBio', 'artistNationality',
'artistBeginDate', 'artistEndDate', 'artistGender',
'artistWikidata_URL', 'artistULAN_URL', 'objectDate', 'objectBeginDate',
'objectEndDate', 'medium', 'dimensions', 'measurements', 'creditLine',
'geographyType', 'city', 'state', 'county', 'country', 'region',
'objectURL', 'tags', 'objectWikidata_URL', 'isTimelineWork',
'GalleryNumber', 'message'],
dtype='object')
df['title']
0 Woman
1 Woman
2 Terracotta lekythos (oil flask)
3 Woman
4 Woman
...
495 Abduction of a Sabine Woman
496 Susannah and the Elders before Daniel
497 Terracotta alabastron (perfume vase) in the fo...
498 Sa Amulet
499 The Thrown Kiss
Name: title, Length: 500, dtype: object
type(df['title'])
pandas.core.series.Series
df['medium']
0 Oil and charcoal on canvas
1 Hard-paste porcelain
2 Terracotta
3 Gelatin silver print
4 Oil paint with collage of cut and printed pape...
...
495 Bronze; on non-contemporary marble pedestal (r...
496 Pen and brown ink, brush and brown wash, highl...
497 Terracotta
498 Silver, electrum
499 Hard-paste porcelain
Name: medium, Length: 500, dtype: object
df['medium'].values
array(['Oil and charcoal on canvas', 'Hard-paste porcelain', 'Terracotta',
'Gelatin silver print',
'Oil paint with collage of cut and printed paper on board', nan,
'Pastel on flocked paper', 'Oil on paper, mounted on cardboard',
'Lithograph',
'Gelatin silver print in original frame of glass, tape, cardboard, string',
nan, 'Stained wood', 'Bronze', 'Charcoal over graphite on paper',
nan,
'Polychromed terracotta head and wooden limbs; body of wire wrapped in tow; various fabrics and lace',
'Soft-paste porcelain', 'Ivory', 'Hard-paste biscuit porcelain',
'Hard-paste porcelain', 'Hard-paste porcelain',
'Hard-paste porcelain',
'Pastel on light green wove paper, now discolored to warm gray, affixed to original pulpboard mount',
'Bronze', nan, 'Travertine (Egyptian alabaster), steatite',
'Cartonnage, paint', 'Marble, Pentelic', 'Oil on canvas',
'Walnut, polychromy and gilding', 'Oil on canvas', 'Bronze',
'Bronze', 'Terracotta',
'Limestone, organic material, paint, malachite', 'Oil on canvas',
'Plaster, oil, and tar with sand on canvas', 'Tempera on wood',
'Linen, paint (tempera)', 'Oil on canvas', 'Chalcedony, blue',
'Limestone, paint', 'Oil on canvas', 'Marble', 'Terracotta',
'Bronze', 'Oil on wood', 'Terracotta', 'Marble, Pentelic',
'Wood, gesso, paint', 'Limestone', 'Bronze',
'Cartonnage, plaster, paint, plant fibers', 'Oil on canvas',
'Oil on canvas', 'Terracotta', 'Oil on canvas', 'Marble', 'Marble',
'Algerian onyx-marble, bronze, gilt bronze, enamel, and amethyst eyes; white marble socle',
'Terracotta', 'Lithographs on wove paper', 'Lithograph',
'Lithograph',
'Stonepaste; polychrome painted under transparent glaze',
'Oil with sand on canvas', 'Oil on canvas',
'Hematite, silver mount', 'Ivory', 'Oil on canvas',
'Oil on canvas',
'Travertine (Egyptian alabaster), blue glass, obsidian, unidentified stone',
'Marble', 'Amber', 'Encaustic on limewood with gold leaf',
'Oil on canvas', 'Faience', 'Pottery',
'Black, red and white chalk', 'Oil on canvas', 'Oil on canvas',
'Algerian onyx-marble, bronze, and enamel; white marble socle',
'Oil on canvas', 'Oil on wood', 'Silver', 'Drypoint', 'Bronze',
'Human remains, linen, plaster, paint, mummification material',
'Ivory', 'Oil on oak panel', 'Plaster, paint, glass', 'Boxwood',
'Terracotta', 'Terracotta', 'Limestone, paint traces',
'Oil on canvas', 'Granodiorite', 'Oil on canvas', 'Terracotta',
'Terracotta', 'Faience', 'Terracotta', 'Bone', 'Pentelic Marble',
'Alabaster', 'Gold, gold filigree and enamel', 'Terracotta',
'Drypoint and aquatint, printed in color from three plates; fourth state of four (Mathews & Shapiro)',
'Oil on canvas', 'Mahogany and opals', 'Terracotta', 'Terracotta',
'Terracotta', 'Bronze', 'Walnut, polychromy and gilding',
'Oil on paperboard mounted on particle board', 'Painted bronze',
'Hard-paste porcelain', 'Hard-paste porcelain',
'Lithographic crayon and watercolor on paper, mounted to cardstock',
'Oil on canvas', 'Hard-paste porcelain, gilt-bronze', 'Gabbro',
'Pastel on light green wove paper, now discolored to warm gray, affixed to original pulpboard mount',
'Oil, water-based paint, and crayon on canvas',
'Hard-paste porcelain', 'Hard-paste porcelain',
'Hard-paste porcelain', 'Hard-paste porcelain', 'Stucco; painted',
'Oil and charcoal on canvas', 'Hard-paste porcelain',
'Hard-paste porcelain', 'Terracotta', 'Terracotta', 'Bronze',
'Terracotta', 'Terracotta', 'Limestone, paint', 'Bronze',
'Terracotta', 'Limestone', 'Sandstone, paint', 'Terracotta',
'Limestone, paint', 'Terracotta', 'Terracotta', 'Marble',
'Terracotta', 'Painted limestone', 'Terracotta', 'Terracotta',
'Wood, gesso, paint', 'Wood, paint', 'Wood, paint', 'Terracotta',
'Wood, paint traces', 'Bronze', 'Limestone, paint',
'Ivory (Hippopotamus), Egyptian blue (traces)', 'Carnelian',
'Faience', 'Wood (tamarisk), reed', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Bronze', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Carnelian', 'Terracotta',
'Commercial color lithograph', 'Light blue faience', 'Faience',
'Bronze', 'Terracotta', 'Terracotta', 'Mud plaster, paint',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Marble', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Limestone', 'Bronze', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Bronze', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta', 'Marble',
'Terracotta', 'Plaster, paint', 'Terracotta', 'Terracotta',
'Marble', 'Terracotta', 'Marble', 'Marble', 'Pottery (Nile clay)',
'Steatite', 'Terracotta', 'Pot-metal glass, vitreous paint',
'Glass', 'Plaster, paint', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta', 'Pottery',
'Terracotta', 'Terracotta', 'Terracotta', 'Wood', 'Faience',
'Faience', 'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Faience', 'Terracotta',
'Red faience', 'Oil on canvas', 'Terracotta', 'Limestone, paint',
'Pottery, paint', 'Pottery, paint', 'Bronze or copper alloy',
'Plaster, paint, gold leaf', 'Terracotta', 'Bronze',
'Plaster, paint', 'Plaster, paint', 'Steatite', 'Oil on canvas',
'Bronze', 'Terracotta', 'Faience',
'Brazilian rosewood; pedestal: lapis lazuli, marble and gilded metal',
'Oil on canvas', 'Hard-paste porcelain', 'Marble',
'Hanging scroll; ink, color, and gold on silk',
'Black chalk highlighted with white chalk (abraded) on green prepared paper.',
'Terracotta', 'Oil on canvas', 'Limestone, paint', 'Oil on canvas',
'Terracotta', 'Bronze', 'Hard-paste porcelain', 'Red wax',
'Bronze', 'Marble', 'Oil on Baltic oak', 'Limestone', 'Terracotta',
'Terracotta', 'Bronze', 'Limestone', 'Marble', 'Marble',
'Pottery, paint', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Marble', 'Marble',
'Terracotta', 'Marble', 'Terracotta', 'Ivory, bronze', 'Faience',
'Limestone, paint', 'Wood, paint', 'Limestone', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Bronze', 'Bronze',
'Glass, blue paste', 'Marble', 'Marble', 'Marble', 'Terracotta',
'Terracotta', 'Terracotta', 'Marble', 'Terracotta', 'Terracotta',
'Greywacke', 'Red Breccia', 'Pale blue faience',
'limestone, paint', 'Bronze or copper alloy', 'Faience', nan,
'Marble', 'Marble', nan, 'Bronze, gold', 'Marble',
'Marble, Pentelic', 'Terracotta', 'Terracotta', 'Silver-gilt',
'Sardonyx', 'Faience', 'Terracotta', 'Marble', 'Marble',
'Terracotta', 'Marble, Pentelic', 'Marble', 'Marble',
'Marble, Pentelic', 'Marble, Pentelic', 'Marble, Pentelic',
'Plaster, paint, glass', 'Terracotta', 'Bronze', 'Terracotta',
'Faience', 'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta',
'Terracotta', 'Terracotta', 'Terracotta', 'Terracotta', 'Bronze',
'Plaster, paint, glass', 'Bronze', 'Terracotta', 'Limestone',
'Bronze', 'Marble', 'Terracotta', 'Faience', 'Faience', 'Bone',
'Oil on canvas', 'Terracotta', 'Bronze', 'Plaster, paint, glass',
'Limestone', 'Copper alloy', 'Oil on wood', 'Steatite, glazed',
'Limestone', 'Marble', 'Terracotta', 'Alabaster (gypsum)', 'Amber',
'Marble', 'Marble', 'Terracotta', 'Marble, Pentelic', 'Bronze',
'Bronze', 'Marble', 'Bronze', 'Bronze', 'Oil on oak panel',
'Terracotta', 'Tin-glazed earthenware', 'Terracotta', 'Bronze',
'Case: Powdered gold (maki-e) on black lacquer with mother-of-pearl, pewter, and ceramic inlays; floral decoration on risers in incised gold; Fastener (ojime): carved red lacquer with design of Chinese sage and pine; Toggle (netsuke): stained ivory carved in the shape of a farm woman and child (signed: Homin)',
nan, 'Phyllitic schist', 'Terracotta', 'Bronze', 'Marble, Island',
'Oil on canvas', 'Earthenware', 'Bronze',
'Earthenware with pigment',
'Pot-metal, white glass, vitreous paint, silver stain',
'Pastel on cream-colored wove paper with red and blue fibers throughout',
'Silk on linen; embroidered', 'Limestone, paint',
'Pastel on buff wove paper, affixed to original pulpboard mount',
'Silk and metal thread tapestry (kesi)', 'Terracotta',
'Pastel and charcoal on light pink wove paper, discolored at the edges',
'Gouache on wove paper', 'Faience', 'Oil on canvas', 'Bronze',
'Oil on canvas', 'Soft-paste porcelain', 'Wood',
'Soft-paste porcelain',
'Painted terracotta; study for a work in pâte-de-verre', 'Pottery',
'Oil on cardboard',
'Oil colors freely mixed with turpentine, with touches of pastel, over graphite underdrawing, on pink paper',
'Oil on canvas', 'Faience (?)', 'Oil on wood', 'Tempera on wood',
'Oil on canvas', 'Gelatin silver print', 'Marble', 'Oil on canvas',
'Bone china ("ivory porcelain") with enamel decoration and gilding',
'Marble', 'Oil on canvas', 'Oil on linden', 'Bronze',
'Oil on canvas', 'Oil on canvas', 'Marble', nan,
'Limestone, paint', 'Glass', 'Terracotta', 'Terracotta', 'Bronze',
'Glass', 'Marble', 'Marble', 'Marble, Pentelic', 'Marble',
'Marble, Island', 'Marble', 'Marble', 'Marble, Parian ?', 'Marble',
'Terracotta', 'Terracotta', 'Terracotta', 'Marble',
'Limestone, ink', 'Tempera on paper', 'Bronze',
'Bronze; on non-contemporary marble pedestal (removed Nov. 2020)',
'Pen and brown ink, brush and brown wash, highlighted with white, over a little black chalk, on gray-green paper. The head of the woman with outstretched arm, to the right of Susanna, is a pentimento that has been pasted onto the sheet. Squared in black chalk',
'Terracotta', 'Silver, electrum', 'Hard-paste porcelain'],
dtype=object)
type(df['medium'].values)
numpy.ndarray
df.title
0 Woman
1 Woman
2 Terracotta lekythos (oil flask)
3 Woman
4 Woman
...
495 Abduction of a Sabine Woman
496 Susannah and the Elders before Daniel
497 Terracotta alabastron (perfume vase) in the fo...
498 Sa Amulet
499 The Thrown Kiss
Name: title, Length: 500, dtype: object
df.title.values
array(['Woman', 'Woman', 'Terracotta lekythos (oil flask)', 'Woman',
'Woman', nan, 'Woman', 'Woman', 'Woman', 'Woman', nan, 'Woman',
'Woman', 'Woman', nan, 'Woman', 'Woman', 'Woman', 'Woman', 'Woman',
'Woman', 'Woman', 'Woman Having Her Hair Combed', 'Standing Woman',
nan,
'Cosmetic Spoon in the Shape of Swimming Woman Holding a Dish',
'Cartonnage of a Woman',
'Marble grave stele of a young woman and servant',
'Woman with a Cat', 'Mourning Woman',
'Young Man and Woman in an Inn', 'Woman Stretching',
'Bronze mirror with a support in the form of a draped woman',
'Terracotta head of a woman', 'Figurine of a Seated Woman',
'A Woman Seated beside a Vase of Flowers (Madame Paul Valpinçon?)',
'Woman Grinding Coffee',
'Portrait of a Woman with a Man at a Casement',
'Shroud of a Woman Wearing a Fringed Tunic', 'Woman with a Pink',
'Chalcedony oval gem', 'Statuette of Taweret',
'Woman with a Parrot', 'Marble stele (grave marker) of a woman',
'Terracotta statuette of a woman',
'Bronze statuette of a young woman', 'Portrait of a Woman',
'Terracotta alabastron (perfume vase) in the form of a woman holding a dove',
'Marble statue of an old woman', 'Estate Figure',
"God's Wife Tagerem, daughter of the priest Imhotep",
'Bronze hydria (water jar)', 'Mummy Mask', 'Woman in an Armchair',
'Woman with a Rake', 'Terracotta statue of a young woman',
'Portrait of a Woman', 'Marble female figure',
'Marble female figure', 'Jewish Woman of Algiers',
'Terracotta statuette of a woman looking into a box mirror',
'Catalogue for an exhibition at the offices of the Toulouse newspaper "Dépêche"',
'Woman', 'Woman', 'Plate Depicting a Woman Playing Tambourine',
'Woman Seated at an Easel', 'Young Woman with a Water Pitcher',
'Amulet Carved in Intaglio (Incised)', 'Head of a Woman',
'Study of a Young Woman', "Woman in a Riding Habit (L'Amazone)",
'Canopic Jar (07.226.1) with a Lid Depicting a Queen (30.8.54)',
'Marble statue of a woman',
'Carved amber bow of a fibula (safety pin)',
'Portrait of a young woman in red', 'Head of an Old Woman',
'Female figure playing a lyre', 'Statuette', 'Seated Woman',
'Young Woman with a Lute', 'Young Woman Seated on a Sofa',
'Woman from the French Colonies', 'The Woman in the Waves',
'Portrait of a Woman',
'Statuette of a Royal (?) Woman with the Cartouches of Necho II on her Arms',
'Spider Woman', 'Woman Getting out of the Bath',
'Mummy with a Painted Mask Depicting a Woman Holding a Goblet',
'Standing Woman', 'A Goldsmith in his Shop',
'Mask of a woman with a large coil of plaited hair',
'Statuette of a nude woman with moveable arms, one missing',
'Terracotta statuette of a seated woman',
'Molded figurine of a woman', 'Nursing woman',
'An Egyptian Peasant Woman and Her Child',
"Fragment from the Head of a Queen's Statue",
'Woman in a Chemise in an Armchair',
'Female figure holding infant', 'Female figure',
'Female Statuette',
'Terracotta plaque with a female figure holding a tympanum',
'Cosmetic spoon', 'Marble Portrait Bust of a Woman with a Scroll',
'Holy Woman',
'Hat Badge: Woman Choosing Between Youth and Old Age',
'Terracotta relief head of a woman', 'Woman Bathing (La Toilette)',
'Young Woman', 'Woman Fixing Her Hair',
'Terracotta statuette of a woman standing',
'Terracotta relief with bust of a woman',
'Terracotta relief head of a woman', 'Bronze statuette of a woman',
'Holy Woman', 'Woman in Profile', 'Woman of Venice II',
'Standing Woman', 'Standing woman', 'Woman in Blue Dress',
'Woman with Arms Crossed', 'Dancing Woman', 'A Royal Woman',
'Woman Combing Her Hair', 'Woman in White', 'Kalmuk Woman',
'Yakut Woman', 'Tartar Woman', 'Tatar Woman', 'Veiled Woman',
'Head of a Woman', 'Samoyed Woman', 'Tatar Woman',
'Terracotta statuette of a woman', 'Terracotta head of a woman',
'Pregnant Woman', 'Terracotta head of a woman',
'Terracotta statuette of a veiled woman', 'Head of a woman',
'Bronze statuette of a woman', 'Terracotta draped woman',
'Woman with Child', 'Upper Half of a Woman from a Pair Statue',
'Terracotta statuette of an emaciated woman', 'Head of a Woman',
'Terracotta statuette of a woman', 'Terracotta head of a woman',
'Marble head of a young woman from a funerary statue',
'Terracotta statuette of a woman',
'Relief Showing a Seated Woman Smelling the Blossom of a Water Lily',
'Terracotta figure of a woman',
'Terracotta statuette of a standing woman',
'Anthropoid Coffin of a Woman',
'Figure of a Woman of Nubian Descent', 'Figure of a woman',
'Terracotta seated veiled woman', 'Statuette of a Woman',
'Statuette of a woman ?',
'Relief Fragment Depicting a Kneeling Woman', 'Head of a woman',
'Carnelian oval', 'Head of a woman', 'Chair for a Woman',
'Terracotta head of a woman', 'Terracotta head of a woman',
'Terracotta head of a woman', 'Terracotta head of a young woman',
'Terracotta head of a woman', 'Terracotta head of a woman',
'Terracotta head of a woman',
'Terracotta statuette of a draped woman',
'Terracotta head of a woman',
'Terracotta statuette of a seated woman',
'Terracotta statuette of a woman', 'Bronze plaque of a woman',
'Terracotta statuette of a woman', 'Terracotta head of a woman',
'Terracotta statuette of a nude woman',
'Terracotta head of a woman',
'Terracotta statuette of a draped woman',
'Terracotta bust of a woman',
'Fragmentary terracotta statuette of a woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a woman', 'Carnelian oval',
'Fragment of a terracotta relief', 'Proclamation',
'Amulet: Woman Playing Lyre', 'Woman with a lyre',
'Bronze statuette of a woman', 'Fragmentary head of a woman',
'Terracotta statuette of a woman',
'Wall painting with a standing woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a woman',
'Terracotta head of an old woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a woman',
'Terracotta head of a veiled woman',
'Terracotta head of a woman wearing a stephane',
'Terracotta statuette of a draped woman',
'Terracotta statuette of a seated woman',
'Terracotta head of a woman',
'Terracotta statuette of a nude woman',
'Terracotta statuette of a draped woman',
'Terracotta statuette of a draped woman', 'Marble head of a woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a draped woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a draped woman',
'Terracotta statuette of a draped woman',
'Terracotta statuette of a draped woman',
'Group statue of man and woman', 'Bronze statuette of a woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a veiled woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a woman', 'Terracotta head of a woman',
'Terracotta head of a woman',
'Terracotta statuette of a nude woman',
'Terracotta head of a veiled woman', 'Bronze plaque of a woman',
'Terracotta statuette of a seated woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a woman',
'Terracotta statuette of a draped woman', 'Terracotta statuette',
'Terracotta statuette of a standing woman',
'Terracotta statuette of woman with bird face',
'Terracotta head of a veiled woman', 'Terracotta head of a woman',
'Terracotta statuette of a woman', 'Marble head of a woman',
'Terracotta statuette of a woman',
'Mask of a woman with an austere hairstyle',
'Terracotta statuette of a seated woman',
'Terracotta statuette of a nude woman',
'Marble head of an elderly woman',
'Terracotta statuette of a nude woman', 'Marble statue of a woman',
'Marble portrait head of a woman', 'Figurine of a Seated Woman',
'Group statuette of two men and a woman', 'Terracotta female head',
'Woman Dispensing Poison from the Legend of Saint Germain of Paris',
'Glass portrait head of a woman',
'Mask of a woman with corkscrew locks and bang',
'Terracotta statuette of a standing woman',
'Terracotta head of a woman wearing a high headdress',
'Terracotta relief with bust of a woman',
'Terracotta statuette of a woman seated on a rock',
'Terracotta statuette of a woman reclining on a couch',
'Terracotta relief with the head and neck of a woman',
'Head from a figurine of a Woman',
'Terracotta relief with head of a woman',
'Terracotta statuette of a woman leaning on a pillar',
'Terracotta statuette of a woman leaning on a pillar',
'Head of a woman from a spoon',
'Figurine of a Woman with Her Baby',
'Figurine of a Woman with Her Baby',
'Terracotta statuette of a seated woman',
'Terracotta statuette of a seated woman',
'Terracotta relief with the head of a woman',
'Terracotta head of a woman with a veil',
'Fragment of a terracotta statuette of an old woman',
'Terracotta statuette of a draped, standing woman',
'Terracotta head of an old woman',
'Figurine of a Woman with Her Baby',
'Terracotta statuette of a woman wearing a hat and holding a fan',
'Woman Carrying a Child on Her Back and Leading an Animal',
'A Woman Reading', 'Terracotta statuette of a seated woman',
'Statuette of a standing woman',
'Jar in the Form of a Woman Playing a Lyre',
'Fragments of a vase in the form of a woman holding a basket',
'Mirror with a Handle in the Shape of a Young Woman',
'Mask of a woman with cosmetic lines and gilding',
'Terracotta head of an old woman', 'Bronze head of a goddess',
'Mask of a woman with ball earrings, corkscrew locks and bang',
'Mask of a woman with an ornate curled bang and loop earrings',
'Design Amulet, Woman Suckling a Child on Back, Device showing Geometricized Monkeys',
'A Woman Ironing', 'Fragmentary bronze statuette of a woman',
'Terracotta head of a woman',
'Statuette of a worn or aged woman, probably a goddess',
'Kneeling Black woman', 'Spanish Roma Woman', 'Kazan Tartar Woman',
'Marble statue of Tyche-Fortuna restored with the portrait head of a woman',
'Woman in a Black Kimono', 'Head of a Young Woman',
'Terracotta statuette of a woman holding a bird',
'Woman with Mimosa',
'Relief Depicting the Purification of Queen Kiya (?)',
'The Sewing Woman', 'Woman in a Bonnet',
'Woman Leaning on Her Hands', 'Oriental Woman',
'Seated woman representing Astrology',
'Bronze statuette (of a woman?)', 'Marble head of an old woman',
'Fish Market', 'Limestone funerary monument of a woman',
"Terracotta fragment of a woman's head",
'Terracotta mask of woman to hips', 'Woman Taken Unawares',
"Relief, woman's head", 'Marble stele (grave marker) of a woman',
'Marble head of a woman', "Jug in the shape of a woman's head",
'Fragmentary terracotta statuette of a woman with a kithara',
'Fragment of a terracotta relief of a woman and child',
'Terracotta female head', 'Terracotta female head',
'Terracotta female head',
'Terracotta nude female statuette, perhaps Aphrodite',
'Marble head of the so-called Barberini Suppliant',
'Marble female figure', 'Two terracotta busts',
'Marble female herm',
'Terracotta statuette of a draped figure, probably female',
'Female Figurine', 'Head of a female figure with large wig',
'Ostracon', 'Mummy face mask', 'Limestone head of a female votary',
'Terracotta female head', 'Fragment of a terracotta female figure',
'Terracotta standing human figure', 'Terracotta female head',
'Bronze perfume dipper', 'Bronze statuette of a goddess',
'Glass ring stone', 'Marble female figure', 'Marble female figure',
'Marble female figure', 'Terracotta female head',
'Terracotta female figure',
'Terracotta statuette of a veiled dancer', 'Marble female figure',
'Fragmentary terracotta female statuette, perhaps Artemis',
'Terracotta protome of a goddess', 'Upper part of statuette',
'Family group', 'Nude female holding monkeys',
'Servant Grinding Grain', 'Mirror',
'Nude female figure holding a vase on her head', nan,
'Marble portrait of a young woman',
'Marble portrait bust of a woman', nan, 'Bronze ring',
'Marble portrait of a young woman', 'Marble head of a woman',
'Terracotta statuette of a woman',
'Terracotta statuette of an enthroned woman',
'Cup with cover and stand (one of a pair)',
'Sardonyx cameo of a goddess flanked by attendants',
'Faience statuette of a woman',
'Terracotta relief bust of a woman',
'Marble portrait bust of a woman',
'Marble portrait head of a woman', 'Terracotta protome of a woman',
'Marble head of a woman', 'Marble bust of a woman',
'Marble portrait bust of a woman', 'Marble statuette of a woman',
'Marble statue of a woman', 'Marble grave stele of a woman',
'Mask of a woman with radiating waves of hair',
'Terracotta head of a wreathed woman',
'Bronze relief of the head of a woman',
'Terracotta statuette of a woman',
'Faience statuette of a woman holding two vases',
'Terracotta statuette of the upper part of a woman',
'Terracotta statuette of a woman with tympanum',
'Terracotta alabastron (perfume vase) in the form of a woman',
'Terracotta statuette of a woman',
'Terracotta head of a woman from a statue',
'Terracotta statuette of a woman',
'Terracotta statuette of a woman',
'Terracotta statuette of woman playing a tympanon',
'Bronze box mirror',
'Mask of a woman with her hair rolled back at the forehead and temples',
'Bronze relief of a veiled woman riding a sea-goat',
'Terracotta statuette of a woman',
'Limestone relief with the figure of a woman',
'Bronze statuette of a woman holding a bird',
'Marble head of a woman wearing diadem and veil',
'Terracotta statuette of a woman',
'Fragment of a faience statuette of a woman holding a vase on her head',
'Fragment of a faience statuette of a woman holding a vase on her head',
'Bone statuette of a draped woman', 'Portrait of a Young Woman',
'Terracotta antefix (roof tile)', 'Seated Torso of a Woman',
'Mask of a woman with her hair in a small knot',
'Mesu Smelling a Lotus', 'Statuette of a Woman',
'Young Woman Peeling Apples',
'Design Amulet, Back in the Form of a Woman Suckling a Child, Device showing Two Lizards Head-to-tail',
'Limestone statuette of a nursing mother',
'Fragmentary marble head of a girl',
'Two fragments of a terracotta plaque',
'Figure of a reclining woman', 'Pendant: woman carrying a child',
'Head of a Woman', 'Marble sarcophagus fragment',
'Terracotta woman baking cakes in an oven',
'Marble head of a woman from a grave marker',
'Standing Torso of a Woman', 'Woman Riding Two Brahman Bulls',
'Bust of a young woman', 'Torso of a Woman',
'Head of a Woman (Fernande)', 'Portrait of a Woman',
'Column Surround with Pensive Woman',
'Jug with Finely-Dressed Woman',
'Terracotta woman pounding food in a mortar', 'Bronze box mirror',
'Case (Inrō) with Design of Grasshopper on Stalk of Flowering Lily',
nan, 'Mirror Handle: Standing Woman',
'Terracotta head of a woman, possibly Artemis',
'Bronze statuette of a woman, perhaps a Hesperid',
'Marble head of a woman, perhaps a queen', 'Portrait of a Woman',
'Vase with Pre-Raphaelite woman', 'Woman at Her Toilet',
'Woman with a hoe', 'Head of a Woman', 'Woman with a Towel',
"Fragment of Woman's Trousering", 'Group of two women and a child',
'Woman Drying Her Foot',
"Woman's robe with peonies and shou medallions",
'Terracotta alabastron in the form of a woman',
'Woman Drying Her Arm', 'Seated Peasant Woman with Goats',
'Gilt faience fragment of an oinochoe (jug)',
'Portrait of a Woman', 'Woman Arranging her Hair',
'Portrait of a Woman', 'Friar carrying a woman',
'Statuette of a Woman', 'Peasant Woman with Child',
'Young woman holding libation cup', 'Head of a woman',
'Woman before a Mirror', 'Woman on a Sofa',
'Woman Playing a Guitar', 'Head of a Woman',
'Portrait of a Young Woman', 'Portrait of a Woman',
'Portrait of a Young Woman',
'Screaming woman with blood on her hands',
'Marble portrait of Livia', 'A Woman with a Dog',
'Figure of Japanese woman', 'Portrait of a young woman',
'Head of a Woman', 'Portrait of a Woman',
'Woman Arranging her Hair', 'Head of a Young Woman',
'Young Woman (La Servante)',
'Lower part of a marble seated statue of Hygieia', nan,
'Relief from the tomb of Queen Neferu: female attendant carrying a sunshade (see 26.3.353-1)',
'Glass plaque fragment',
'Terracotta female figure in three-legged chair',
'Terracotta plank-shaped figurine', 'Bronze female figure',
'Glass plaque fragment depicting a trophy and captives',
'Marble female figure', 'Upper part of a marble female figure',
'Marble statue of a seated muse', 'Marble statue of a girl',
'Marble head of a girl from a small statue',
'Marble portrait, probably of Matidia, niece of the emperor Trajan and mother of Sabina, wife of the emperor Hadrian',
'Marble portrait of a young girl', 'Marble head of a goddess',
'Marble portrait of Matidia Minor', 'Terracotta female figure',
'Terracotta female figure', 'Terracotta female figure',
'Marble head of a veiled goddess',
'Drawing of a Ramesside King and Two Standing Figures',
"Menna's Daughter Offering to her Parents, Tomb of Menna",
'Bronze mirror', 'Abduction of a Sabine Woman',
'Susannah and the Elders before Daniel',
'Terracotta alabastron (perfume vase) in the form of a woman',
'Sa Amulet', 'The Thrown Kiss'], dtype=object)
df.describe()
| objectID | isHighlight | accessionYear | isPublicDomain | objectBeginDate | objectEndDate | county | isTimelineWork | |
|---|---|---|---|---|---|---|---|---|
| count | 492.000000 | 492.000000 | 489.000000 | 492.000000 | 492.000000 | 492.000000 | 0.0 | 492.000000 |
| mean | 338124.420732 | 0.075203 | 1935.578732 | 0.845528 | 25.123984 | 117.554878 | NaN | 0.126016 |
| std | 150547.306742 | 0.263987 | 37.739216 | 0.361768 | 1319.632348 | 1242.360185 | NaN | 0.332205 |
| min | 10112.000000 | 0.000000 | 1871.000000 | 0.000000 | -7000.000000 | -4000.000000 | NaN | 0.000000 |
| 25% | 247556.750000 | 0.000000 | 1910.000000 | 1.000000 | -550.000000 | -485.000000 | NaN | 0.000000 |
| 50% | 253507.000000 | 0.000000 | 1926.000000 | 1.000000 | -299.000000 | -200.000000 | NaN | 0.000000 |
| 75% | 469534.000000 | 0.000000 | 1966.000000 | 1.000000 | 1539.500000 | 1547.000000 | NaN | 0.000000 |
| max | 897321.000000 | 1.000000 | 2023.000000 | 1.000000 | 2005.000000 | 2005.000000 | NaN | 1.000000 |
df[100:105]
| objectID | isHighlight | accessionNumber | accessionYear | isPublicDomain | primaryImage | additionalImages | constituents | department | objectName | ... | state | county | country | region | objectURL | tags | objectWikidata_URL | isTimelineWork | GalleryNumber | message | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | 555761.0 | 0.0 | 32.1.131a–d | 1932.0 | 0.0 | NaN | [] | NaN | Egyptian Art | Statuette, woman | ... | NaN | NaN | Egypt | Memphite Region | https://www.metmuseum.org/art/collection/searc... | NaN | https://www.wikidata.org/wiki/Q116431161 | 0.0 | 109 | NaN |
| 101 | 254747.0 | 0.0 | 53.5.22 | 1953.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | [] | NaN | Greek and Roman Art | Pinax, woman | ... | NaN | NaN | NaN | NaN | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Human Figures', 'AAT_URL': 'http://... | https://www.wikidata.org/wiki/Q116291744 | 0.0 | 152 | NaN |
| 102 | 546047.0 | 0.0 | 51.172.2 | 1951.0 | 1.0 | https://images.metmuseum.org/CRDImages/eg/orig... | ['https://images.metmuseum.org/CRDImages/eg/or... | NaN | Egyptian Art | Cosmetic, spoon, woman | ... | NaN | NaN | NaN | Upper Egypt | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q116282230 | 0.0 | 117 | NaN |
| 103 | 468716.0 | 1.0 | 66.25 | 1966.0 | 1.0 | https://images.metmuseum.org/CRDImages/cl/orig... | ['https://images.metmuseum.org/CRDImages/cl/or... | NaN | The Cloisters | Bust | ... | NaN | NaN | NaN | NaN | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29385473 | 1.0 | 301 | NaN |
| 104 | 466235.0 | 0.0 | 1991.84 | 1991.0 | 1.0 | https://images.metmuseum.org/CRDImages/md/orig... | ['https://images.metmuseum.org/CRDImages/md/or... | [{'constituentID': 164122, 'role': 'Artist', '... | Medieval Art | Statuette | ... | NaN | NaN | NaN | NaN | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q116244152 | 0.0 | 305 | NaN |
5 rows × 42 columns
titles = df['title'].values
len(titles)
500
type(titles)
numpy.ndarray
type(titles[0])
str
sorting data#
Using .value_counts() and.sort_values()
df.value_counts('title')
title
Terracotta statuette of a woman 31
Woman 20
Terracotta head of a woman 18
Portrait of a Woman 9
Terracotta statuette of a draped woman 9
..
Marble head of a goddess 1
Marble head of a girl from a small statue 1
Marble grave stele of a young woman and servant 1
Marble grave stele of a woman 1
Young woman holding libation cup 1
Name: count, Length: 332, dtype: int64
df.value_counts('department')
department
Greek and Roman Art 255
Egyptian Art 88
European Sculpture and Decorative Arts 40
European Paintings 39
Modern and Contemporary Art 24
The American Wing 9
Drawings and Prints 8
Medieval Art 8
Asian Art 7
Robert Lehman Collection 5
Islamic Art 3
Photographs 2
The Cloisters 2
Ancient Near Eastern Art 1
The Michael C. Rockefeller Wing 1
Name: count, dtype: int64
df.value_counts('medium')
medium
Terracotta 164
Marble 43
Bronze 38
Oil on canvas 34
Hard-paste porcelain 15
...
Hard-paste porcelain, gilt-bronze 1
Hard-paste biscuit porcelain 1
Hanging scroll; ink, color, and gold on silk 1
Greywacke 1
limestone, paint 1
Name: count, Length: 128, dtype: int64
df.value_counts('artistDisplayName')
artistDisplayName
Edgar Degas 14
Imperial Porcelain Manufactory, St. Petersburg 8
Pablo Picasso 7
Johannes Vermeer 3
Willem de Kooning 3
..
Giovanni Battista Gaulli (Il Baciccio) 1
Giacomo Ceruti 1
Georges Braque 1
Gaston Lachaise 1
Woman's Liberty Loan Committee 1
Name: count, Length: 90, dtype: int64
df.sort_values('accessionYear')
| objectID | isHighlight | accessionNumber | accessionYear | isPublicDomain | primaryImage | primaryImageSmall | additionalImages | constituents | department | ... | rightsAndReproduction | linkResource | metadataDate | repository | objectURL | tags | objectWikidata_URL | isTimelineWork | GalleryNumber | message | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 367 | 256758.0 | 0.0 | X.125 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | [https://images.metmuseum.org/CRDImages/gr/ori... | None | Greek and Roman Art | ... | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Heads', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q116282960 | 0.0 | 171 | NaN | |||
| 265 | 256831.0 | 0.0 | X.391 | 0.0 | [] | None | Greek and Roman Art | ... | 2023-02-07T04:46:51.34Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | None | https://www.wikidata.org/wiki/Q116406471 | 0.0 | 157 | NaN | |||||
| 313 | 256778.0 | 0.0 | X.248.14 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | [https://images.metmuseum.org/CRDImages/gr/ori... | None | Greek and Roman Art | ... | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Heads', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q116282878 | 0.0 | 168 | NaN | |||
| 467 | 437759.0 | 0.0 | 71.34 | 1871 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | [https://images.metmuseum.org/CRDImages/ep/ori... | [{'constituentID': 108350, 'role': 'Artist', '... | European Paintings | ... | 2024-04-26T04:52:10.83Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Portraits', 'AAT_URL': 'http://voca... | https://www.wikidata.org/wiki/Q19911479 | 0.0 | 612 | NaN | ||
| 247 | 241069.0 | 0.0 | 74.51.1513 | 1874 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | [https://images.metmuseum.org/CRDImages/gr/ori... | None | Greek and Roman Art | ... | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Heads', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q116294128 | 0.0 | 171 | NaN | ||
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 24 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Not a valid object |
| 353 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Not a valid object |
| 356 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Not a valid object |
| 427 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Not a valid object |
| 472 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Not a valid object |
500 rows × 58 columns
filtering data#
Conditional statements
df['title'] == 'Woman'
0 True
1 True
2 False
3 True
4 True
...
495 False
496 False
497 False
498 False
499 False
Name: title, Length: 500, dtype: bool
woman = df['title'] == 'Woman'
df[woman]
| Unnamed: 0 | objectID | isHighlight | accessionNumber | accessionYear | isPublicDomain | primaryImage | primaryImageSmall | additionalImages | constituents | ... | rightsAndReproduction | linkResource | metadataDate | repository | objectURL | tags | objectWikidata_URL | isTimelineWork | GalleryNumber | message | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 483873.0 | 0.0 | 1984.613.2 | 1984.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 161817, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-10-11T04:53:25.173Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q20189686 | 0.0 | NaN | NaN |
| 1 | 1 | 207162.0 | 0.0 | 1982.60.281 | 1982.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | [] | [{'constituentID': 38388, 'role': 'Manufactory... | ... | NaN | NaN | 2023-02-07T04:46:51.34Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q116307111 | 0.0 | 543 | NaN |
| 3 | 3 | 283274.0 | 0.0 | 2005.100.206 | 1999.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 162092, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-01-05T04:58:47.817Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Still Life', 'AAT_URL': 'http://voc... | NaN | 0.0 | NaN | NaN |
| 4 | 4 | 483877.0 | 0.0 | 1984.613.6 | 1984.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 161817, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-08-31T04:53:19.483Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q19923391 | 1.0 | NaN | NaN |
| 6 | 6 | 494305.0 | 0.0 | 2007.247.5 | 2007.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 162129, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-06-11T04:53:38.053Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | NaN | NaN | 1.0 | NaN | NaN |
| 7 | 7 | 481438.0 | 0.0 | 1975.189.6 | 1975.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 161817, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-05-22T04:52:05.35Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q19919792 | 0.0 | NaN | NaN |
| 8 | 8 | 374147.0 | 0.0 | 43.33.754 | 1943.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 97526, 'role': 'Artist', 'n... | ... | NaN | NaN | 2021-06-05T04:45:37.2Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | NaN | 0.0 | NaN | NaN |
| 9 | 9 | 515811.0 | 0.0 | 2002.59 | 2002.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 163031, 'role': 'Artist', '... | ... | © Malick Sidibé | NaN | 2022-12-15T08:50:39.81Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Portraits', 'AAT_URL': 'http://voca... | NaN | 0.0 | NaN | NaN |
| 11 | 11 | 489510.0 | 0.0 | 66.75.2 | 1966.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 161734, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-06-06T04:54:25.483Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | NaN | 0.0 | NaN | NaN |
| 12 | 12 | 492892.0 | 0.0 | 2002.456.122 | 2002.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 162129, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-03-29T10:36:46.263Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Abstraction', 'AAT_URL': 'http://vo... | NaN | 0.0 | NaN | NaN |
| 13 | 13 | 486510.0 | 0.0 | 1994.592 | 1994.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 162129, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-05-11T04:52:16.88Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Abstraction', 'AAT_URL': 'http://vo... | NaN | 0.0 | NaN | NaN |
| 15 | 15 | 204181.0 | 0.0 | 64.164.80 | 1964.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | ['https://images.metmuseum.org/CRDImages/es/or... | [{'constituentID': 34304, 'role': 'Maker', 'na... | ... | NaN | NaN | 2024-01-19T04:57:08.877Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | NaN | 0.0 | NaN | NaN |
| 16 | 16 | 205376.0 | 0.0 | 1971.180.184 | 1971.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | ['https://images.metmuseum.org/CRDImages/es/or... | [{'constituentID': 34736, 'role': 'Factory', '... | ... | NaN | NaN | 2023-10-12T04:55:57.067Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Baskets', 'AAT_URL': 'http://vocab.... | NaN | 0.0 | NaN | NaN |
| 17 | 17 | 193453.0 | 0.0 | 17.190.301 | 1917.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | [] | NaN | ... | NaN | NaN | 2020-11-14T04:40:04.457Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | NaN | 0.0 | NaN | NaN |
| 18 | 18 | 195502.0 | 0.0 | 26.223.20 | 1926.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | [] | NaN | ... | NaN | NaN | 2021-04-30T11:13:27.41Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | NaN | 0.0 | NaN | NaN |
| 19 | 19 | 193045.0 | 0.0 | 14.102.397 | 1914.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | [] | NaN | ... | NaN | NaN | 2024-05-16T04:53:54.097Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | NaN | 0.0 | NaN | NaN |
| 20 | 20 | 200897.0 | 0.0 | 50.211.207 | 1950.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | [] | [{'constituentID': 37893, 'role': 'Factory', '... | ... | NaN | NaN | 2022-10-20T04:55:06.267Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | NaN | 0.0 | NaN | NaN |
| 21 | 21 | 208482.0 | 0.0 | 1995.268.312 | 1995.0 | 1.0 | https://images.metmuseum.org/CRDImages/es/orig... | https://images.metmuseum.org/CRDImages/es/web-... | ['https://images.metmuseum.org/CRDImages/es/or... | [{'constituentID': 35103, 'role': 'Manufactory... | ... | NaN | NaN | 2021-04-06T04:41:04.967Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | NaN | 0.0 | NaN | NaN |
| 62 | 62 | 389226.0 | 0.0 | 1989.1093.1 | 1989.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 102288, 'role': 'Artist', '... | ... | NaN | NaN | 2020-03-24T04:43:37.347Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | NaN | NaN | 0.0 | NaN | NaN |
| 63 | 63 | 839042.0 | 0.0 | 1983.1215.4 | 1983.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 211108, 'role': 'Artist', '... | ... | NaN | NaN | 2022-03-04T10:34:46.977Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | NaN | NaN | 0.0 | NaN | NaN |
20 rows × 59 columns
df[woman].info()
<class 'pandas.core.frame.DataFrame'>
Index: 20 entries, 0 to 63
Data columns (total 59 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 Unnamed: 0 20 non-null int64
1 objectID 20 non-null float64
2 isHighlight 20 non-null float64
3 accessionNumber 20 non-null object
4 accessionYear 20 non-null float64
5 isPublicDomain 20 non-null float64
6 primaryImage 8 non-null object
7 primaryImageSmall 8 non-null object
8 additionalImages 20 non-null object
9 constituents 17 non-null object
10 department 20 non-null object
11 objectName 20 non-null object
12 title 20 non-null object
13 culture 0 non-null object
14 period 0 non-null object
15 dynasty 0 non-null object
16 reign 0 non-null object
17 portfolio 0 non-null float64
18 artistRole 17 non-null object
19 artistPrefix 0 non-null object
20 artistDisplayName 17 non-null object
21 artistDisplayBio 16 non-null object
22 artistSuffix 0 non-null object
23 artistAlphaSort 17 non-null object
24 artistNationality 14 non-null object
25 artistBeginDate 16 non-null object
26 artistEndDate 16 non-null object
27 artistGender 1 non-null object
28 artistWikidata_URL 13 non-null object
29 artistULAN_URL 14 non-null object
30 objectDate 20 non-null object
31 objectBeginDate 20 non-null float64
32 objectEndDate 20 non-null float64
33 medium 20 non-null object
34 dimensions 20 non-null object
35 measurements 18 non-null object
36 creditLine 20 non-null object
37 geographyType 0 non-null object
38 city 0 non-null object
39 state 0 non-null object
40 county 0 non-null float64
41 country 1 non-null object
42 region 0 non-null object
43 subregion 0 non-null object
44 locale 0 non-null object
45 locus 0 non-null object
46 excavation 0 non-null object
47 river 0 non-null float64
48 classification 20 non-null object
49 rightsAndReproduction 9 non-null object
50 linkResource 0 non-null float64
51 metadataDate 20 non-null object
52 repository 20 non-null object
53 objectURL 20 non-null object
54 tags 17 non-null object
55 objectWikidata_URL 4 non-null object
56 isTimelineWork 20 non-null float64
57 GalleryNumber 1 non-null object
58 message 0 non-null object
dtypes: float64(11), int64(1), object(47)
memory usage: 9.4+ KB
highlights = df['isHighlight'] == 1.0
df[highlights]
| Unnamed: 0 | objectID | isHighlight | accessionNumber | accessionYear | isPublicDomain | primaryImage | primaryImageSmall | additionalImages | constituents | ... | rightsAndReproduction | linkResource | metadataDate | repository | objectURL | tags | objectWikidata_URL | isTimelineWork | GalleryNumber | message | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22 | 22 | 436173.0 | 1.0 | 29.100.35 | 1929.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | [] | [{'constituentID': 161821, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q19912688 | 0.0 | 817 | NaN |
| 25 | 25 | 548584.0 | 1.0 | 26.2.47 | 1926.0 | 1.0 | https://images.metmuseum.org/CRDImages/eg/orig... | https://images.metmuseum.org/CRDImages/eg/web-... | ['https://images.metmuseum.org/CRDImages/eg/or... | NaN | ... | NaN | NaN | 2024-10-08T04:54:04.193Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Animals', 'AAT_URL': 'http://vocab.... | https://www.wikidata.org/wiki/Q29385956 | 0.0 | 119 | NaN |
| 27 | 27 | 253505.0 | 1.0 | 36.11.1 | 1936.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | [] | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Men', 'AAT_URL': 'http://vocab.gett... | https://www.wikidata.org/wiki/Q29383875 | 0.0 | 156 | NaN |
| 32 | 32 | 255391.0 | 1.0 | 1972.118.78 | 1972.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | ['https://images.metmuseum.org/CRDImages/gr/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Birds', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29383946 | 1.0 | 156 | NaN |
| 33 | 33 | 251428.0 | 1.0 | 23.160.95 | 1923.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | ['https://images.metmuseum.org/CRDImages/gr/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29383821 | 1.0 | 161 | NaN |
| 35 | 35 | 436121.0 | 1.0 | 29.100.128 | 1929.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | [] | [{'constituentID': 161821, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Pitchers', 'AAT_URL': 'http://vocab... | https://www.wikidata.org/wiki/Q3713914 | 1.0 | 810 | NaN |
| 37 | 37 | 436896.0 | 1.0 | 89.15.19 | 1889.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | ['https://images.metmuseum.org/CRDImages/ep/or... | [{'constituentID': 107934, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Men', 'AAT_URL': 'http://vocab.gett... | https://www.wikidata.org/wiki/Q3937681 | 1.0 | 602 | NaN |
| 42 | 42 | 436002.0 | 1.0 | 29.100.57 | 1929.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | [] | [{'constituentID': 161790, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Female Nudes', 'AAT_URL': 'http://v... | https://www.wikidata.org/wiki/Q8030760 | 1.0 | 811 | NaN |
| 43 | 43 | 254597.0 | 1.0 | 48.11.4 | 1948.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | [] | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29383903 | 0.0 | 158 | NaN |
| 44 | 44 | 253135.0 | 1.0 | 30.117 | 1930.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | [] | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29383855 | 0.0 | 171 | NaN |
| 45 | 45 | 249222.0 | 1.0 | 17.190.2066 | 1917.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | ['https://images.metmuseum.org/CRDImages/gr/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29383793 | 1.0 | 170 | NaN |
| 47 | 47 | 253050.0 | 1.0 | 30.11.6 | 1930.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | [] | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Doves', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29383851 | 0.0 | 152 | NaN |
| 48 | 48 | 248132.0 | 1.0 | 09.39 | 1909.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | ['https://images.metmuseum.org/CRDImages/gr/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29383752 | 1.0 | 162 | NaN |
| 49 | 49 | 544210.0 | 1.0 | 20.3.7 | 1920.0 | 1.0 | https://images.metmuseum.org/CRDImages/eg/orig... | https://images.metmuseum.org/CRDImages/eg/web-... | ['https://images.metmuseum.org/CRDImages/eg/or... | NaN | ... | NaN | NaN | 2024-10-10T04:53:14.647Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Ducks', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29385772 | 1.0 | 105 | NaN |
| 51 | 51 | 252452.0 | 1.0 | 26.50 | 1926.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | ['https://images.metmuseum.org/CRDImages/gr/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | NaN | https://www.wikidata.org/wiki/Q29383837 | 1.0 | 156 | NaN |
| 52 | 52 | 547257.0 | 1.0 | 19.2.6 | 1919.0 | 1.0 | https://images.metmuseum.org/CRDImages/eg/orig... | https://images.metmuseum.org/CRDImages/eg/web-... | ['https://images.metmuseum.org/CRDImages/eg/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Masks', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29385892 | 1.0 | 137 | NaN |
| 57 | 57 | 255275.0 | 1.0 | 68.148 | 1968.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | ['https://images.metmuseum.org/CRDImages/gr/or... | [{'constituentID': 49441, 'role': 'Artist', 'n... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29383939 | 1.0 | 151 | NaN |
| 58 | 58 | 255417.0 | 1.0 | 1972.118.104 | 1972.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | ['https://images.metmuseum.org/CRDImages/gr/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29383951 | 1.0 | 150 | NaN |
| 66 | 66 | 437881.0 | 1.0 | 89.15.21 | 1889.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | [] | [{'constituentID': 108413, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-19T04:54:04.793Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Interiors', 'AAT_URL': 'http://voca... | https://www.wikidata.org/wiki/Q386453 | 1.0 | 614 | NaN |
| 69 | 69 | 437879.0 | 1.0 | 1979.396.1 | 1979.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | ['https://images.metmuseum.org/CRDImages/ep/or... | [{'constituentID': 108413, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-10T04:53:14.647Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Portraits', 'AAT_URL': 'http://voca... | https://www.wikidata.org/wiki/Q958088 | 1.0 | 614 | NaN |
| 71 | 71 | 544689.0 | 1.0 | 30.8.54 | 1930.0 | 1.0 | https://images.metmuseum.org/CRDImages/eg/orig... | https://images.metmuseum.org/CRDImages/eg/web-... | ['https://images.metmuseum.org/CRDImages/eg/or... | NaN | ... | NaN | NaN | 2024-10-23T04:53:13.2Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29385821 | 1.0 | 121 | NaN |
| 73 | 73 | 249223.0 | 1.0 | 17.190.2067 | 1917.0 | 1.0 | https://images.metmuseum.org/CRDImages/gr/orig... | https://images.metmuseum.org/CRDImages/gr/web-... | ['https://images.metmuseum.org/CRDImages/gr/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Couples', 'AAT_URL': 'http://vocab.... | https://www.wikidata.org/wiki/Q29383798 | 1.0 | 170 | NaN |
| 78 | 78 | 459192.0 | 1.0 | 1975.1.763 | 1975.0 | 1.0 | https://images.metmuseum.org/CRDImages/rl/orig... | https://images.metmuseum.org/CRDImages/rl/web-... | ['https://images.metmuseum.org/CRDImages/rl/or... | [{'constituentID': 162693, 'role': 'Artist', '... | ... | NaN | NaN | 2020-09-16T18:35:19.457Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q20185008 | 1.0 | NaN | NaN |
| 80 | 80 | 437160.0 | 1.0 | 1992.103.2 | 1992.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 162143, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Portraits', 'AAT_URL': 'http://voca... | https://www.wikidata.org/wiki/Q19906245 | 1.0 | 824 | NaN |
| 84 | 84 | 546746.0 | 1.0 | 30.8.93 | 1930.0 | 1.0 | https://images.metmuseum.org/CRDImages/eg/orig... | https://images.metmuseum.org/CRDImages/eg/web-... | ['https://images.metmuseum.org/CRDImages/eg/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Cartouches', 'AAT_URL': 'http://voc... | https://www.wikidata.org/wiki/Q29385885 | 1.0 | 127 | NaN |
| 85 | 85 | 371017.0 | 1.0 | 2006.17 | 2006.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 161708, 'role': 'Artist', '... | ... | NaN | NaN | 2022-06-22T05:05:49.633Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Spiders', 'AAT_URL': 'http://vocab.... | NaN | 0.0 | NaN | NaN |
| 89 | 89 | 459052.0 | 1.0 | 1975.1.110 | 1975.0 | 1.0 | https://images.metmuseum.org/CRDImages/rl/orig... | https://images.metmuseum.org/CRDImages/rl/web-... | ['https://images.metmuseum.org/CRDImages/rl/or... | [{'constituentID': 161771, 'role': 'Artist', '... | ... | NaN | NaN | 2023-04-18T04:46:43.39Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Interiors', 'AAT_URL': 'http://voca... | https://www.wikidata.org/wiki/Q2408910 | 1.0 | 953 | NaN |
| 97 | 97 | 500194.0 | 1.0 | 2019.593 | 2019.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 162244, 'role': 'Artist', '... | ... | © 2024 Estate of Pablo Picasso / Artists Right... | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Female Nudes', 'AAT_URL': 'http://v... | https://www.wikidata.org/wiki/Q116412424 | 0.0 | 908 | NaN |
| 103 | 103 | 468716.0 | 1.0 | 66.25 | 1966.0 | 1.0 | https://images.metmuseum.org/CRDImages/cl/orig... | https://images.metmuseum.org/CRDImages/cl/web-... | ['https://images.metmuseum.org/CRDImages/cl/or... | NaN | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29385473 | 1.0 | 301 | NaN |
| 107 | 107 | 337064.0 | 1.0 | 16.2.2 | 1916.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 161757, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-04T04:54:16Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q29384752 | 1.0 | NaN | NaN |
| 109 | 109 | 486209.0 | 1.0 | 1993.217 | 1993.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 161760, 'role': 'Artist', '... | ... | © Estate of Elizabeth Catlett | NaN | 2023-09-26T04:54:33.177Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Female Nudes', 'AAT_URL': 'http://v... | https://www.wikidata.org/wiki/Q96357666 | 1.0 | NaN | NaN |
| 119 | 119 | 494051.0 | 1.0 | 2004.502 | 2004.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 149578, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-01-05T04:58:47.817Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Profiles', 'AAT_URL': 'http://vocab... | NaN | 0.0 | NaN | NaN |
| 120 | 120 | 484524.0 | 1.0 | 1986.356 | 1986.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 145240, 'role': 'Artist', '... | ... | © 2024 Artists Rights Society (ARS), New York | NaN | 2024-07-03T04:53:09.02Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Portraits', 'AAT_URL': 'http://voca... | https://www.wikidata.org/wiki/Q19917516 | 0.0 | NaN | NaN |
| 295 | 295 | 459211.0 | 1.0 | 1975.1.859 | 1975.0 | 1.0 | https://images.metmuseum.org/CRDImages/rl/orig... | https://images.metmuseum.org/CRDImages/rl/web-... | ['https://images.metmuseum.org/CRDImages/rl/or... | [{'constituentID': 161857, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Heads', 'AAT_URL': 'http://vocab.ge... | https://www.wikidata.org/wiki/Q20187871 | 1.0 | NaN | NaN |
| 306 | 306 | 679844.0 | 1.0 | 2015.146 | 2015.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | ['https://images.metmuseum.org/CRDImages/ep/or... | [{'constituentID': 72898, 'role': 'Artist', 'n... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Food', 'AAT_URL': 'http://vocab.get... | https://www.wikidata.org/wiki/Q19913672 | 0.0 | 637 | NaN |
| 410 | 410 | 322114.0 | 1.0 | 86.16.3 | 1886.0 | 1.0 | https://images.metmuseum.org/CRDImages/an/orig... | https://images.metmuseum.org/CRDImages/an/web-... | ['https://images.metmuseum.org/CRDImages/an/or... | NaN | ... | NaN | NaN | 2024-06-27T04:54:21.257Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Female Nudes', 'AAT_URL': 'http://v... | https://www.wikidata.org/wiki/Q29384398 | 1.0 | NaN | NaN |
| 461 | 461 | 271716.0 | 1.0 | 1996.299 | 1996.0 | 0.0 | NaN | NaN | [] | [{'constituentID': 54769, 'role': 'Artist', 'n... | ... | © The Estate of Diane Arbus | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Women', 'AAT_URL': 'http://vocab.ge... | NaN | 0.0 | NaN | NaN |
37 rows × 59 columns
df[highlights].info()
<class 'pandas.core.frame.DataFrame'>
Index: 37 entries, 22 to 461
Data columns (total 59 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 Unnamed: 0 37 non-null int64
1 objectID 37 non-null float64
2 isHighlight 37 non-null float64
3 accessionNumber 37 non-null object
4 accessionYear 37 non-null float64
5 isPublicDomain 37 non-null float64
6 primaryImage 29 non-null object
7 primaryImageSmall 29 non-null object
8 additionalImages 37 non-null object
9 constituents 19 non-null object
10 department 37 non-null object
11 objectName 37 non-null object
12 title 37 non-null object
13 culture 14 non-null object
14 period 18 non-null object
15 dynasty 4 non-null object
16 reign 4 non-null object
17 portfolio 0 non-null float64
18 artistRole 19 non-null object
19 artistPrefix 1 non-null object
20 artistDisplayName 19 non-null object
21 artistDisplayBio 18 non-null object
22 artistSuffix 0 non-null object
23 artistAlphaSort 19 non-null object
24 artistNationality 18 non-null object
25 artistBeginDate 18 non-null object
26 artistEndDate 18 non-null object
27 artistGender 7 non-null object
28 artistWikidata_URL 18 non-null object
29 artistULAN_URL 18 non-null object
30 objectDate 37 non-null object
31 objectBeginDate 37 non-null float64
32 objectEndDate 37 non-null float64
33 medium 37 non-null object
34 dimensions 37 non-null object
35 measurements 37 non-null object
36 creditLine 37 non-null object
37 geographyType 7 non-null object
38 city 1 non-null object
39 state 0 non-null object
40 county 0 non-null float64
41 country 5 non-null object
42 region 4 non-null object
43 subregion 4 non-null object
44 locale 2 non-null object
45 locus 1 non-null object
46 excavation 2 non-null object
47 river 0 non-null float64
48 classification 31 non-null object
49 rightsAndReproduction 5 non-null object
50 linkResource 0 non-null float64
51 metadataDate 37 non-null object
52 repository 37 non-null object
53 objectURL 37 non-null object
54 tags 36 non-null object
55 objectWikidata_URL 34 non-null object
56 isTimelineWork 37 non-null float64
57 GalleryNumber 28 non-null object
58 message 0 non-null object
dtypes: float64(11), int64(1), object(47)
memory usage: 17.3+ KB
courbet = df['artistDisplayName'].str.contains('Courbet', na=False)
df[courbet]
| Unnamed: 0 | objectID | isHighlight | accessionNumber | accessionYear | isPublicDomain | primaryImage | primaryImageSmall | additionalImages | constituents | ... | rightsAndReproduction | linkResource | metadataDate | repository | objectURL | tags | objectWikidata_URL | isTimelineWork | GalleryNumber | message | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42 | 42 | 436002.0 | 1.0 | 29.100.57 | 1929.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | [] | [{'constituentID': 161790, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Female Nudes', 'AAT_URL': 'http://v... | https://www.wikidata.org/wiki/Q8030760 | 1.0 | 811 | NaN |
| 70 | 70 | 436024.0 | 0.0 | 29.100.59 | 1929.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | [] | [{'constituentID': 161790, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Portraits', 'AAT_URL': 'http://voca... | https://www.wikidata.org/wiki/Q19905240 | 1.0 | 812 | NaN |
| 82 | 82 | 436004.0 | 0.0 | 29.100.62 | 1929.0 | 1.0 | https://images.metmuseum.org/CRDImages/ep/orig... | https://images.metmuseum.org/CRDImages/ep/web-... | [] | [{'constituentID': 161790, 'role': 'Artist', '... | ... | NaN | NaN | 2024-10-03T04:53:53.567Z | Metropolitan Museum of Art, New York, NY | https://www.metmuseum.org/art/collection/searc... | [{'term': 'Female Nudes', 'AAT_URL': 'http://v... | https://www.wikidata.org/wiki/Q39013 | 1.0 | 811 | NaN |
3 rows × 59 columns
df[courbet]['title']
42 Woman with a Parrot
70 Woman in a Riding Habit (L'Amazone)
82 The Woman in the Waves
Name: title, dtype: object