In [1]:
import pandas as pd

In [2]:
import matplotlib.pyplot as plt

%matplotlib inline

In [3]:
df = pd.read_csv("moma.csv", encoding="utf-8-sig")

In [4]:
df[['Title']].head()


Out[4]:
Title
0 Ferdinandsbrücke Project, Vienna, Austria , El...
1 City of Music, National Superior Conservatory ...
2 Villa near Vienna Project, Outside Vienna, Aus...
3 The Manhattan Transcripts Project, New York, N...
4 Villa, project, outside Vienna, Austria, Exter...

In [5]:
df.head(10)


Out[5]:
Title Artist ConstituentID ArtistBio Nationality BeginDate EndDate Gender Date Medium ... ThumbnailURL Circumference (cm) Depth (cm) Diameter (cm) Height (cm) Length (cm) Weight (kg) Width (cm) Seat Height (cm) Duration (sec.)
0 Ferdinandsbrücke Project, Vienna, Austria , El... Otto Wagner 6210 (Austrian, 1841–1918) (Austrian) (1841) (1918) (Male) 1896 Ink and cut-and-pasted painted pages on paper ... http://www.moma.org/media/W1siZiIsIjU5NDA1Il0s... NaN NaN NaN 48.6000 NaN NaN 168.9000 NaN NaN
1 City of Music, National Superior Conservatory ... Christian de Portzamparc 7470 (French, born 1944) (French) (1944) (0) (Male) 1987 Paint and colored pencil on print ... http://www.moma.org/media/W1siZiIsIjk3Il0sWyJw... NaN NaN NaN 40.6401 NaN NaN 29.8451 NaN NaN
2 Villa near Vienna Project, Outside Vienna, Aus... Emil Hoppe 7605 (Austrian, 1876–1957) (Austrian) (1876) (1957) (Male) 1903 Graphite, pen, color pencil, ink, and gouache ... ... http://www.moma.org/media/W1siZiIsIjk4Il0sWyJw... NaN NaN NaN 34.3000 NaN NaN 31.8000 NaN NaN
3 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1980 Photographic reproduction with colored synthet... ... http://www.moma.org/media/W1siZiIsIjEyNCJdLFsi... NaN NaN NaN 50.8000 NaN NaN 50.8000 NaN NaN
4 Villa, project, outside Vienna, Austria, Exter... Emil Hoppe 7605 (Austrian, 1876–1957) (Austrian) (1876) (1957) (Male) 1903 Graphite, color pencil, ink, and gouache on tr... ... http://www.moma.org/media/W1siZiIsIjEyNiJdLFsi... NaN NaN NaN 38.4000 NaN NaN 19.1000 NaN NaN
5 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... http://www.moma.org/media/W1siZiIsIjE0OCJdLFsi... NaN NaN NaN 35.6000 NaN NaN 45.7000 NaN NaN
6 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photographs ... http://www.moma.org/media/W1siZiIsIjE0OSJdLFsi... NaN NaN NaN 35.6000 NaN NaN 45.7000 NaN NaN
7 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... http://www.moma.org/media/W1siZiIsIjE0OSJdLFsi... NaN NaN NaN 35.6000 NaN NaN 45.7000 NaN NaN
8 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... http://www.moma.org/media/W1siZiIsIjE1MCJdLFsi... NaN NaN NaN 35.6000 NaN NaN 45.7000 NaN NaN
9 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... http://www.moma.org/media/W1siZiIsIjE1MSJdLFsi... NaN NaN NaN 35.6000 NaN NaN 45.7000 NaN NaN

10 rows × 29 columns


In [6]:
df.columns


Out[6]:
Index(['Title', 'Artist', 'ConstituentID', 'ArtistBio', 'Nationality',
       'BeginDate', 'EndDate', 'Gender', 'Date', 'Medium', 'Dimensions',
       'CreditLine', 'AccessionNumber', 'Classification', 'Department',
       'DateAcquired', 'Cataloged', 'ObjectID', 'URL', 'ThumbnailURL',
       'Circumference (cm)', 'Depth (cm)', 'Diameter (cm)', 'Height (cm)',
       'Length (cm)', 'Weight (kg)', 'Width (cm)', 'Seat Height (cm)',
       'Duration (sec.)'],
      dtype='object')
  • What are the top 5 artists with the most works?
  • How many artists look like they may still be alive?
  • What are the top 10 largest art works? Can you put that in a pretty chart?
  • Where are the female artists?
  • Which year did the MoMA acquire the most artworks? What about the top ten years? Can you put that in a pretty chart?
  • What are some of the most common media used?
  • What are the most common type of classification? Can you chart that?
  • How many modern artists are French?
  • What is the oldest artwork and who gave it to moma?
  • How many different CreditLines are there? Who is the most generous donor? *

In [7]:
#What are the top 5 artists with the most works?
number_of_artists = df['Artist'].value_counts()
number_of_artists.sort_values(ascending=False).head()


Out[7]:
Eugène Atget                5050
Louise Bourgeois            3275
Ludwig Mies van der Rohe    2557
Unknown photographer        1574
Jean Dubuffet               1435
Name: Artist, dtype: int64

In [8]:
df.columns[0] #WEIRD ENCODING
#Title = df.columns[0]


Out[8]:
'Title'

In [14]:
#How many artists look like they may still be alive?
#From the dataset it looks like artists who are dead look something like 1918 - 1999, but artists who are still alive
#are (born...)
is_alive = df['ArtistBio'].str.contains('born')
has_a_title = df['Title'].notnull()
#if alive_artists == True:
#    print(df[Title])
df[is_alive & has_a_title]
df[(df['Title'].str.contains('born')) & (df['Title'].notnull())]


Out[14]:
Title Artist ConstituentID ArtistBio Nationality BeginDate EndDate Gender Date Medium ... Depth (cm) Diameter (cm) Height (cm) Length (cm) Weight (kg) Width (cm) Seat Height (cm) Duration (sec.) Area Weight (lbs)
5847 Ed Osborn, Gitaar Electronica Opera, Ton Homburg 7603, 7604 (Dutch, established 1985) (Dutch, born 1952) (Dutch) (Dutch) (1985) (1952) (0) (0) () (Male) 1993 Offset lithograph ... NaN NaN 41.900000 NaN NaN 59.700000 NaN NaN 2501.430000 NaN
7045 Dearborn Observatory John Rieben 4916 (American, born 1935) (American) (1935) (0) (Male) 1966 Silkscreen ... NaN NaN 126.800000 NaN NaN 89.000000 NaN NaN 11285.200000 NaN
7100 Predlohy pro odborne kresleni typograficke Zdenek Rossmann 8254 (Czech, 1905–1984) (Czech) (1905) (1984) (Male) 1934 Letterpress ... NaN NaN 21.100000 NaN NaN 30.300000 NaN NaN 639.330000 NaN
7413 Informace pro P. T. reditelstvi mestanskych sk... Augustin Tschinkel 5952 (Czech, born 1905) (Czech) (1905) (0) (Male) 1920-1940 Letterpress ... NaN NaN 21.200000 NaN NaN 15.200000 NaN NaN 322.240000 NaN
8704 Dokhlaia luna. Sbornik edinstvennykh futuristo... David Burliuk, Vladimir Burliuk 877, 12001 (Ukrainian, 1882–1967) (1886–1917) (Ukrainian) () (1882) (1886) (1967) (1917) (Male) (Male) 1913 16 lithographed illustrations, 3 letterpress i... ... NaN NaN 19.526300 NaN NaN 15.200000 NaN NaN 296.799760 NaN
8904 Zatychka. Sbornik. Velimir Khlebnikov; David, ... David Burliuk, Vladimir Burliuk 877, 12001 (Ukrainian, 1882–1967) (1886–1917) (Ukrainian) () (1882) (1886) (1967) (1917) (Male) (Male) 1913 Blue construction paper cover; 2 lithographed ... ... NaN NaN 23.336300 NaN NaN 18.000000 NaN NaN 420.053400 NaN
9674 Izbornik stikhov s poslesloviem rechiaria. 190... Pavel Filonov, Kazimir Malevich, Vladimir Maya... 12124, 3710, 11904 (Russian, born Ukraine. 1878–1935) (Russian, 1... () (Russian) (Russian) (0) (1878) (1893) (0) (1935) (1930) (Male) (Male) (Male) 1914 Cover with letterpress illustration by Mayakov... ... NaN NaN 19.600000 NaN NaN 13.800000 NaN NaN 270.480000 NaN
12730 Solntsebunt i rzha. Sbornik stikhov vtoroi Unknown Artist 23390 (Nationality Unknown) (Nationality Unknown) (0) (0) () 1920 NaN ... NaN NaN 16.300000 NaN NaN 10.700000 NaN NaN 174.410000 NaN
13425 Vserossiiskii soiuz poetov. Vtoroi sbornik sti... Gustav Klutsis 12501 (Latvian, 1895–1938) (Latvian) (1895) (1938) (Male) 1922 Cover with letterpress illustration on front ... NaN NaN 18.000000 NaN NaN 12.400000 NaN NaN 223.200000 NaN
14276 Epopeia. Literaturnyi sbornik, nos. 1-4 El Lissitzky 3569 (Russian, 1890–1941) (Russian) (1890) (1941) (Male) 1922-1923 Covers with letterpress lettering on front ... NaN NaN 21.400000 NaN NaN 13.900000 NaN NaN 297.460000 NaN
14277 Epopeia: literaturnyi sbornik (Epopée: Literar... El Lissitzky 3569 (Russian, 1890–1941) (Russian) (1890) (1941) (Male) 1922-1923 Covers with letterpress lettering on front ... NaN NaN 21.431300 NaN NaN 13.970000 NaN NaN 299.395261 NaN
14725 Biznes. Sbornik literaturnogo tsentra konstruk... Aleksandr Rodchenko 4975 (Russian, 1891–1956) (Russian) (1891) (1956) (Male) 1929 Book with letterpress illustration ... NaN NaN 22.500000 NaN NaN 15.100000 NaN NaN 339.750000 NaN
15923 Za chto nas b'iut. Vtoroe izdanie sbornika. Ne... A. Gribatnikov, Nikolai Grigoriev, I. Mikhel's... 23371, 23372, 23373, 23374, 6106 (Russian) () () () () (Russian) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) () (Male) () () () 1913 NaN ... NaN NaN 27.500000 NaN NaN 21.300000 NaN NaN 585.750000 NaN
15947 Trebnikh troikh. Sbornik stikhov i risunkov David Burliuk, Nadezhda Burliuk, Vladimir Burl... 877, 23370, 12001, 11904, 5811 (Ukrainian, 1882–1967) (1886–1917) (Russian, 1... (Ukrainian) () () (Russian) (Russian) (1882) (0) (1886) (1893) (1885) (1967) (0) (1917) (1930) (1953) (Male) (Female) (Male) (Male) (Male) 1913 Illustrated book ... NaN NaN 20.800000 NaN NaN 17.000000 NaN NaN 353.600000 NaN
16153 Vesennee kontragenstvo muz. Sbornik David Burliuk, Vladimir Burliuk, Aristarkh Len... 877, 12001, 23413 (Ukrainian, 1882–1967) (1886–1917) (Russian, 1... (Ukrainian) () (Russian) (1882) (1886) (1882) (1967) (1917) (1943) (Male) (Male) (Male) 1915 NaN ... NaN NaN 27.000000 NaN NaN 19.600000 NaN NaN 529.200000 NaN
16169 Chetyre ptitsy. Sbornik stikhov Aristarkh Lentulov, Georgii Zolotukhin 23413, 23446 (Russian, 1882–1943) (Russian) () (1882) (0) (1943) (0) (Male) (Male) 1916 NaN ... NaN NaN 22.900000 NaN NaN 18.500000 NaN NaN 423.650000 NaN
16254 Peta. Pervyi sbornik Aleksandr Lopukhin, Fedor Platov 23448, 23443 NaN () () (0) (0) (0) (0) (Male) (Male) 1916 NaN ... NaN NaN 22.600000 NaN NaN 14.800000 NaN NaN 334.480000 NaN
17394 Lirika. Vtoroi sbornik. Stikhov Georgii Echeistov 23633 NaN () (0) (0) (Male) 1922 NaN ... NaN NaN 17.000000 NaN NaN 12.600000 NaN NaN 214.200000 NaN
18007 Svetozvony. Pervyi sbornik svetovykh sonat Unknown Artist 23390 (Nationality Unknown) (Nationality Unknown) (0) (0) () 1923 NaN ... NaN NaN 18.300000 NaN NaN 13.300000 NaN NaN 243.390000 NaN
18376 Gosplan literatury. Sbornik literaturnogo tsen... Nikolai Kupreianov 13677 (Russian) (Russian) (0) (0) (Male) 1925 NaN ... NaN NaN 23.000000 NaN NaN 17.700000 NaN NaN 407.100000 NaN
18526 Vtoroi sbornik Tsentrifugi Natalia Goncharova 2229 (Russian, 1881–1962) (Russian) (1881) (1962) (Female) 1916 Cover with letterpress illustration on front ... NaN NaN 29.100000 NaN NaN 21.500000 NaN NaN 625.650000 NaN
20180 Maiakovskii v Rostove. Sbornik Russian Book Collection 23323 NaN () (0) (0) () 1940 NaN ... NaN NaN 19.600000 NaN NaN 13.800000 NaN NaN 270.480000 NaN
20912 Maiakovskomu. Sbornik vospominanii i statei Valerian Dvorakovskii 24082 NaN () (0) (0) (Male) 1940 NaN ... NaN NaN 21.500000 NaN NaN 16.000000 NaN NaN 344.000000 NaN
21002 Vladimir Maiakovskii. Sbornik 1 Leonid Khyzhins'kyi 24076 NaN () (0) (0) (Male) 1940 NaN ... NaN NaN 25.200000 NaN NaN 16.500000 NaN NaN 415.800000 NaN
21059 Pereval. Sbornik. Kniga chetvertaia Unknown Artist 23390 (Nationality Unknown) (Nationality Unknown) (0) (0) () 1926 NaN ... NaN NaN 23.300000 NaN NaN 15.500000 NaN NaN 361.150000 NaN
21294 Teatral'nyi oktiabr'. Sbornik I I. Shlepianov 24286 NaN () (0) (0) () 1926 NaN ... NaN NaN 23.400000 NaN NaN 15.400000 NaN NaN 360.360000 NaN
22990 Literatura fakta. Pervyi sbornik materialov ra... Unknown Artist 23390 (Nationality Unknown) (Nationality Unknown) (0) (0) () 1929 NaN ... NaN NaN 18.500000 NaN NaN 13.000000 NaN NaN 240.500000 NaN
25124 Sbornik novogo iskusstva Volodymyr Bobryts'kyi, Volodymyr Diakov, Vasyl... 23516, 23518, 23519, 23608, 23521, 23609, 12074 (Russian, 1894–1968) () () () () () () () (0) (0) (1894) (0) (0) (0) (0) (0) (0) (1968) (0) (0) (0) (0) (Male) (Male) (Male) () (Male) (Male) (Female) 1919 NaN ... NaN NaN 39.200000 NaN NaN 27.800000 NaN NaN 1089.760000 NaN
26628 Strelets. Sbornik tretii i poslednii Natan Al'tman, Iurii Annenkov, Lev Bruni, Marc... 11947, 12172, 23439, 1055, 23315, 12171, 12945... (Russian, 1889–1971) (Russian, 1889–1974) (Rus... (Russian) (Russian) (Russian) (French) () (Rus... (1889) (1889) (1894) (1887) (1875) (1868) (189... (1971) (1974) (1947) (1985) (1952) (1917) (196... (Male) (Male) (Male) (Male) (Male) (Male) (Mal... 1922 NaN ... NaN NaN 28.600000 NaN NaN 19.300000 NaN NaN 551.980000 NaN
30566 Vesennee kontragenstvo muz. Sbornik Aristarkh Lentulov 23413 (Russian, 1882–1943) (Russian) (1882) (1943) (Male) 1915 NaN ... NaN NaN 25.000000 NaN NaN 18.600000 NaN NaN 465.000000 NaN
43773 Dearborn Street, Chicago Harry Callahan 924 (American, 1912–1999) (American) (1912) (1999) (Male) 1948 Gelatin silver print ... NaN NaN 19.400000 NaN NaN 24.300000 NaN NaN 471.420000 NaN
49214 Cab Accident, High Holborn, London Paul Martin 3795 (British, 1864–1944) (British) (1864) (1944) (Male) 1893-96 Gelatin silver print ... NaN NaN 15.900000 NaN NaN 21.000000 NaN NaN 333.900000 NaN
51913 John Osborne (1 of 2), London Irving Penn 4548 (American, 1917–2009) (American) (1917) (2009) (Male) 1958 Gelatin silver print ... NaN NaN 39.700000 NaN NaN 39.400000 NaN NaN 1564.180000 NaN
54516 Head of a sleeping child, The Newborn II Constantin Brancusi 738 (French, born Romania. 1876–1957) (French) (1876) (1957) (Male) c. 1920 Gelatin silver print ... NaN NaN 29.800000 NaN NaN 39.800000 NaN NaN 1186.040000 NaN
55197 Trees and Pond, Near Sherborn, Massachusetts, ... Eliot Porter 4700 (American, 1901–1990) (American) (1901) (1990) (Male) April 1957 Dye transfer print ... NaN NaN 27.600000 NaN NaN 21.200000 NaN NaN 585.120000 NaN
64333 Sanbornville from the series Eccentric Polygons Frank Stella 5640 (American, born 1936) (American) (1936) (0) (Male) 1974 Lithograph and screenprint ... NaN NaN 33.200000 NaN NaN 46.100000 NaN NaN 1530.520000 NaN
64827 Dilborn Heinrich Nauen 4242 (German, 1880–1941) (German) (1880) (1941) (Male) (c. 1913-22) Etching and drypoint ... NaN NaN 39.200000 NaN NaN 31.800000 NaN NaN 1246.560000 NaN
75512 The Newborn Constantin Brancusi 738 (French, born Romania. 1876–1957) (French) (1876) (1957) (Male) version I, 1920 (close to the marble of 1915) Bronze ... 14.600 NaN 14.600000 NaN 3.6288 21.000000 NaN NaN 306.600000 8.000125
76423 Epopeia. Literaturnyi sbornik, nos. 1-4 El Lissitzky 3569 (Russian, 1890–1941) (Russian) (1890) (1941) (Male) 1922-1923 Covers with letterpress lettering on front ... NaN NaN 21.400000 NaN NaN 13.900000 NaN NaN 297.460000 NaN
77106 Krasnyi bilet. Sbornik pionerskikh rasskazov (... Galina Chichagova 23980 NaN () (0) (0) (Female) 1924 Illustrated book ... NaN NaN 18.000000 NaN NaN 13.100000 NaN NaN 235.800000 NaN
81258 Black Newborn Sherrie Levine 3515 (American, born 1947) (American) (1947) (0) (Female) 1994 Cast and sandblasted glass ... 14.605 NaN 14.605000 NaN NaN 20.320000 NaN NaN 296.773600 NaN
81656 Epopeia. Literaturnyi sbornik, no. 1 El Lissitzky 3569 (Russian, 1890–1941) (Russian) (1890) (1941) (Male) 1922-1923 Covers with letterpress lettering on front ... NaN NaN 21.400000 NaN NaN 13.900000 NaN NaN 297.460000 NaN
81657 Epopeia. Literaturnyi sbornik, no. 2 El Lissitzky 3569 (Russian, 1890–1941) (Russian) (1890) (1941) (Male) 1922-1923 Covers with letterpress lettering on front ... NaN NaN 21.400000 NaN NaN 13.900000 NaN NaN 297.460000 NaN
81658 Epopeia. Literaturnyi sbornik, no. 4 El Lissitzky 3569 (Russian, 1890–1941) (Russian) (1890) (1941) (Male) 1922-1923 Covers with letterpress lettering on front ... NaN NaN 21.400000 NaN NaN 13.900000 NaN NaN 297.460000 NaN
82085 Mark and Denise Holborn. London, England Lee Friedlander 2002 (American, born 1934) (American) (1934) (0) (Male) 1992 Gelatin silver print ... NaN NaN 37.800000 NaN NaN 37.500000 NaN NaN 1417.500000 NaN
82577 Oh my God...and for those really stubborn stai... Damien Hirst 6905 (British, born 1965) (British) (1965) (0) (Male) 2002 One from a portfolio of twenty three etchings ... NaN NaN 91.186200 NaN NaN 69.850100 NaN NaN 6369.365189 NaN
82891 Infant in Newborn Nursery, Bethlehem, Pennsylv... Judith Joy Ross 5030 (American, born 1946) (American) (1946) (0) (Female) 1985 Gelatin silver printing-out-paper print ... NaN NaN 20.320000 NaN NaN 25.400100 NaN NaN 516.130032 NaN
88891 Airborne from Exit 8 Nancy Spero 5564 (American, 1926–2009) (American) (1926) (2009) (Female) 1998 Screenprint with collage additions from a port... ... NaN NaN 66.900000 NaN NaN 52.900000 NaN NaN 3539.010000 NaN
88993 The Highborn Child and the Beggar NaN NaN NaN NaN NaN NaN NaN 1913 3 sheet, monotone printing ... NaN NaN 223.520400 NaN NaN 101.600200 NaN NaN 22709.717344 NaN
97525 Alberto Rossi and his Fiancée, Rossana Teatini... Henri Cartier-Bresson 1000 (French, 1908–2004) (French) (1908) (2004) (Male) 1953 Gelatin silver print ... NaN NaN 24.000000 NaN NaN 18.000000 NaN NaN 432.000000 NaN
99258 Untitled ("This photo, made from one of the pl... U.S. Army Signal Corps 7032 (American) (American) (0) (0) () September 17, 1944 Gelatin silver print ... NaN NaN 20.300000 NaN NaN 25.400000 NaN NaN 515.620000 NaN
122655 Album cover for Urszula Dudziak, Newborn Light Eloise Vega Smith 47171 NaN () (0) (0) (Female) 1974 Lithograph ... NaN NaN 31.750064 NaN NaN 31.115062 NaN NaN 987.905202 NaN

52 rows × 31 columns


In [10]:
#What are the top 10 largest art works? Can you put that in a pretty chart?
#Area of art work = height x width
df['Area'] = df['Height (cm)'] * df['Width (cm)']
big_art = df.sort_values(by=['Area'], ascending=False).head(10)
#big_art.plot(kind='barh')
# df.sort_values(by=['Area'], ascending=False).plot(kind='barh', x=title, y='Area').head(10)
# big_art.plot(kind='barh', x=title, y='Area')

#Why won't it let me use the title? <- Strange characters in Title

In [12]:
big_art.plot(kind='barh', x='Title', y='Area')


Out[12]:
<matplotlib.axes._subplots.AxesSubplot at 0x105258940>

In [13]:
#What is the heaviest artwork? What is that in pounds?
df.sort_values('Weight (kg)', ascending=False).head(1)
df['Weight (lbs)'] = df['Weight (kg)'] * 2.20462
df


Out[13]:
Title Artist ConstituentID ArtistBio Nationality BeginDate EndDate Gender Date Medium ... Depth (cm) Diameter (cm) Height (cm) Length (cm) Weight (kg) Width (cm) Seat Height (cm) Duration (sec.) Area Weight (lbs)
0 Ferdinandsbrücke Project, Vienna, Austria , El... Otto Wagner 6210 (Austrian, 1841–1918) (Austrian) (1841) (1918) (Male) 1896 Ink and cut-and-pasted painted pages on paper ... NaN NaN 48.600000 NaN NaN 168.900000 NaN NaN 8208.540000 NaN
1 City of Music, National Superior Conservatory ... Christian de Portzamparc 7470 (French, born 1944) (French) (1944) (0) (Male) 1987 Paint and colored pencil on print ... NaN NaN 40.640100 NaN NaN 29.845100 NaN NaN 1212.907849 NaN
2 Villa near Vienna Project, Outside Vienna, Aus... Emil Hoppe 7605 (Austrian, 1876–1957) (Austrian) (1876) (1957) (Male) 1903 Graphite, pen, color pencil, ink, and gouache ... ... NaN NaN 34.300000 NaN NaN 31.800000 NaN NaN 1090.740000 NaN
3 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1980 Photographic reproduction with colored synthet... ... NaN NaN 50.800000 NaN NaN 50.800000 NaN NaN 2580.640000 NaN
4 Villa, project, outside Vienna, Austria, Exter... Emil Hoppe 7605 (Austrian, 1876–1957) (Austrian) (1876) (1957) (Male) 1903 Graphite, color pencil, ink, and gouache on tr... ... NaN NaN 38.400000 NaN NaN 19.100000 NaN NaN 733.440000 NaN
5 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
6 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photographs ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
7 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
8 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
9 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
10 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
11 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
12 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
13 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
14 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
15 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
16 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
17 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
18 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
19 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
20 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
21 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
22 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
23 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
24 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
25 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
26 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
27 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
28 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
29 The Manhattan Transcripts Project, New York, N... Bernard Tschumi 7056 (French and Swiss, born Switzerland 1944) () (1944) (0) (Male) 1976-77 Gelatin silver photograph ... NaN NaN 35.600000 NaN NaN 45.700000 NaN NaN 1626.920000 NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
128233 Heartbreakers, with Richard Hell Sur Rodney (Sur) 49721 (Canadian, born 1954) (Canadian) (1954) (0) (Male) 1975–1976 audio cassette ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128234 Love Comix Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) 1983 Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128235 “Ghosts” documentation Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128236 “Bad Seed” trailer Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128237 Club 57 Ross’s Rare Records documentation Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128238 “Boeing Boeing” documentation Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128239 “Trojan Women,” documentation Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128240 “Peter Pan,” documentation Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128241 “Nude Faces of ’85,” documentation Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128242 “The Sound of Muzak,” documentation Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128243 “Ranch Notorious,” documentation Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128244 “New Wave Vaudeville” documentation Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) 1978 Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128245 Club 57 unidentified programs Eric Marciano 49719 (American, born 1959) (American) (1959) (0) (Male) NaN Video ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128246 Dancing Boys Esther Regelson 49722 (American, born 1959) (American) (1959) (0) (Female) c. 1979 Super 8mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128247 Catharsis/Blih-Ah/WMEN Esther Regelson 49722 (American, born 1959) (American) (1959) (0) (Female) 1981–1982 16mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128248 Stop Action Esther Regelson 49722 (American, born 1959) (American) (1959) (0) (Female) 1980–1981 16mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128249 Angela Rebecca Miller 31259 (American, born 1962) (American) (1962) (0) (Female) 1995 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128250 The Ballad of Jack and Rose Rebecca Miller 31259 (American, born 1962) (American) (1962) (0) (Female) 2005 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128251 Maggie’s Plan Rebecca Miller 31259 (American, born 1962) (American) (1962) (0) (Female) 2015 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128252 Terminal Island Stephanie Rothman 49723 (American, born 1936) (American) (1936) (0) (Female) 1973 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128253 Group Marriage Stephanie Rothman 49723 (American, born 1936) (American) (1936) (0) (Female) 1973 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128254 The Working Girls Stephanie Rothman 49723 (American, born 1936) (American) (1936) (0) (Female) 1974 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128255 Association Ukrainienne pour Relations Scienti... A. Strachov 48910 (Russian) (Russian) (0) (0) () 1931 Letterpress ... NaN NaN 28.892558 NaN NaN 20.320041 NaN NaN 587.097948 NaN
128256 Kharkov Architectural Competition project desc... A. Strachov 48910 (Russian) (Russian) (0) (0) () 1931 Letterpress ... NaN NaN 23.812548 NaN NaN 22.225044 NaN NaN 529.234929 NaN
128257 Magazin AKA letterhead František Kalivoda 8251 (Czech, 1913–1971) (Czech) (1913) (1971) (Male) 1938 Letterpress ... NaN NaN 29.527559 NaN NaN 20.955042 NaN NaN 618.751238 NaN
128258 Magazin AKA stationery invoice František Kalivoda 8251 (Czech, 1913–1971) (Czech) (1913) (1971) (Male) 1938 Letterpress ... NaN NaN 29.527559 NaN NaN 20.955042 NaN NaN 618.751238 NaN
128259 Magazin AKA stationery invoice František Kalivoda 8251 (Czech, 1913–1971) (Czech) (1913) (1971) (Male) 1938 Letterpress ... NaN NaN 29.527559 NaN NaN 20.955042 NaN NaN 618.751238 NaN
128260 Magazin AKA stationery postcard František Kalivoda 8251 (Czech, 1913–1971) (Czech) (1913) (1971) (Male) 1938 Letterpress ... NaN NaN 10.477521 NaN NaN 14.922530 NaN NaN 156.351119 NaN
128261 Magazin AKA stationery card František Kalivoda 8251 (Czech, 1913–1971) (Czech) (1913) (1971) (Male) 1938 Letterpress ... NaN NaN 9.683769 NaN NaN 20.955042 NaN NaN 202.923793 NaN
128262 Magazin AKA stationery busniess card František Kalivoda 8251 (Czech, 1913–1971) (Czech) (1913) (1971) (Male) 1938 Letterpress ... NaN NaN 6.985014 NaN NaN 10.477521 NaN NaN 73.185630 NaN

128263 rows × 31 columns


In [17]:
#Where are the artists are female?

is_female = df['Gender'].str.contains('(Female)')
is_not_genderless = df['Gender'].notnull()
df[is_female & is_not_genderless]

#Too many () and NA values and I don't know what the unknowns are


/Users/honjingyi/.virtualenvs/data-analysis/lib/python3.5/site-packages/ipykernel/__main__.py:3: UserWarning: This pattern has match groups. To actually get the groups, use str.extract.
  app.launch_new_instance()
Out[17]:
Title Artist ConstituentID ArtistBio Nationality BeginDate EndDate Gender Date Medium ... Depth (cm) Diameter (cm) Height (cm) Length (cm) Weight (kg) Width (cm) Seat Height (cm) Duration (sec.) Area Weight (lbs)
66 Villa dall'Ava, Paris (Saint-Cloud), France , ... Rem Koolhaas, Madelon Vriesendorp 6956, 6957 (Dutch, born 1944) (Dutch, born 1945) (Dutch) (Dutch) (1944) (1945) (0) (0) (Male) (Female) 1987 Synthetic polymer paint and ink on paper ... NaN NaN 63.500100 NaN NaN 99.060200 NaN NaN 6290.332606 NaN
151 Slow House Project, North Haven, New York, Pla... Diller + Scofidio, Elizabeth Diller, Ricardo S... 8707, 6951, 6952 (American, established 1979) (American, born P... (American) (American) (American) (1979) (1954) (1935) (0) (0) (0) () (Female) (Male) 1989 Computer-generated print on frosted polymer sh... ... 3.8 NaN 121.000000 NaN NaN 92.700000 NaN NaN 11216.700000 NaN
152 The Peak Project, Hong Kong, China (Exterior p... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1991 Synthetic polymer on paper mounted on canvas ... NaN NaN 129.540300 NaN NaN 182.880400 NaN NaN 23690.381880 NaN
154 Egg of Columbus Circle, project, New York, New... Rem Koolhaas, Zoe Zenghelis, Elia Zenghelis, M... 6956, 7559, 7558, 6957 (Dutch, born 1944) (British, born Greece 1937)... (Dutch) (British) (British) (Dutch) (1944) (1937) (1937) (1945) (0) (0) (0) (0) (Male) (Female) (Female) (Female) 1975 Ink and acrylic on paper ... NaN NaN 113.000000 NaN NaN 68.600000 NaN NaN 7751.800000 NaN
161 House, Northern Delaware, Preliminary study of... Venturi and Rauch, Robert Venturi, John Rauch,... 8213, 6132, 8214, 8216 (American, est. 1964–1979) (American, born 192... (American) (American) (American) (American) (1964) (1925) (1930) (1931) (1979) (0) (0) (0) () (Male) (Male) (Female) 1978 Felt-tipped pen on tracing paper ... NaN NaN 30.480100 NaN NaN 59.690100 NaN NaN 1819.360217 NaN
162 Gordon Wu Hall, Princeton University , Princet... Venturi, Rauch and Scott Brown, Robert Venturi... 8215, 6132, 8214, 8216 (American, established 1980) (American, born 1... (American) (American) (American) (American) (1980) (1925) (1930) (1931) (0) (0) (0) (0) () (Male) (Male) (Female) 1981 Felt-tipped pen on tracing paper ... NaN NaN 30.480100 NaN NaN 38.417600 NaN NaN 1170.972290 NaN
163 Gordon Wu Hall, Princeton University , Princet... Venturi, Rauch and Scott Brown, Robert Venturi... 8215, 6132, 8214, 8216 (American, established 1980) (American, born 1... (American) (American) (American) (American) (1980) (1925) (1930) (1931) (0) (0) (0) (0) () (Male) (Male) (Female) 1981 Graphite on tracing paper ... NaN NaN 30.480100 NaN NaN 34.290100 NaN NaN 1045.165677 NaN
164 Lewis Thomas Laboratory for Molecular Biology,... Venturi, Rauch and Scott Brown, Robert Venturi... 8215, 6132, 8214, 8216 (American, established 1980) (American, born 1... (American) (American) (American) (American) (1980) (1925) (1930) (1931) (0) (0) (0) (0) () (Male) (Male) (Female) 1983 Felt-tipped pen on tracing paper ... NaN NaN 30.480100 NaN NaN 71.120100 NaN NaN 2167.747760 NaN
242 Boompjes Tower Slab, project , Rotterdam, The ... Rem Koolhaas, Elia Zenghelis, Zoe Zenghelis, M... 6956, 7558, 7559, 6957 (Dutch, born 1944) (British, born Greece 1937)... (Dutch) (British) (British) (Dutch) (1944) (1937) (1937) (1945) (0) (0) (0) (0) (Male) (Female) (Female) (Female) 1981 Watercolor and ink on paper ... NaN NaN 63.500100 NaN NaN 88.900200 NaN NaN 5645.171590 NaN
295 Parc de la Villette Project, Paris, France, Pl... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Colored pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
296 Parc de la Villette project, Paris, France Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982–1983 See individual records. ... NaN NaN 41.910100 NaN NaN 29.845100 NaN NaN 1250.811126 NaN
297 Parc de la Villette Project, Paris, France, Sc... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Graphite on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
298 Parc de la Villette Project, Paris, France, Cu... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Colored pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
299 Parc de la Villette Project, Paris, France, Plan Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Ten photoelectrostatic prints on polymer sheet... ... 2.9 NaN 42.900000 NaN NaN 30.500000 NaN NaN 1308.450000 NaN
300 Parc de la Villette Project, Paris, France, Co... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Ink on tracing paper ... 3.5 NaN 42.900000 NaN NaN 30.500000 NaN NaN 1308.450000 NaN
301 Parc de la Villette Project, Paris, France, Jo... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Ink on tracing paper ... 2.9 NaN 42.900000 NaN NaN 30.500000 NaN NaN 1308.450000 NaN
302 Parc de la Villette Project, Paris, France, Ba... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Ink on tracing paper ... 2.9 NaN 42.900000 NaN NaN 30.500000 NaN NaN 1308.450000 NaN
303 Parc de la Villette Project, Paris, France, Wa... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Ink on tracing paper ... 2.9 NaN 42.900000 NaN NaN 30.500000 NaN NaN 1308.450000 NaN
304 Parc de la Villette Project, Paris, France, Gr... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Ink on tracing paper ... 2.9 NaN 42.900000 NaN NaN 30.500000 NaN NaN 1308.450000 NaN
305 Parc de la Villette Project, Paris, France, Ex... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Ink on tracing paper ... 2.9 NaN 42.900000 NaN NaN 30.500000 NaN NaN 1308.450000 NaN
306 Parc de la Villette Project, Paris, France, Di... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Ink on tracing paper ... 2.9 NaN 42.900000 NaN NaN 30.500000 NaN NaN 1308.450000 NaN
307 Parc de la Villette Project, Paris, France , C... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Colored pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
308 Parc de la Villette Project, Paris, France, Pl... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Ink on tracing paper ... 2.9 NaN 42.900000 NaN NaN 30.500000 NaN NaN 1308.450000 NaN
309 Parc de la Villette Project, Paris, France, Fi... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Colored pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
310 Parc de la Villette Project, Paris, France, Gr... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Colored pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
311 Parc de la Villette Project, Paris, France, Di... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Colored pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
312 Parc de la Villette Project, Paris, France, Wa... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Color pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
313 Parc de la Villette Project, Paris, France, Pl... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Colored pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
314 Parc de la Villette Project, Paris, France, Pl... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Colored pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
315 Parc de la Villette Project, Paris, France, Jo... Zaha Hadid 6953 (British, born Iraq. 1950–2016) (British) (1950) (2016) (Female) 1982-83 Color pencil on tracing paper ... NaN NaN 29.845100 NaN NaN 41.910100 NaN NaN 1250.811126 NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
128069 Grbavica Jasmila Žbanić 49639 (Bosnian, born 1974) (Bosnian) (1974) (0) (Female) 2006 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128071 Requiem Alice Attie 48289 (American, born 1950) (American) (1950) (0) (Female) 2012 Seven drawings: ink and cut-and-pasted newspap... ... NaN NaN 15.240030 NaN NaN 8.890018 NaN NaN 135.484142 NaN
128072 Requiem Alice Attie 48289 (American, born 1950) (American) (1950) (0) (Female) 2012 Three drawings: ink and cut-and-pasted newspap... ... NaN NaN 17.145034 NaN NaN 9.525019 NaN NaN 163.306778 NaN
128073 Die: Drawings No. 1, 2, 4, and 4 Faith Ringgold 7066 (American, born 1930) (American) (1930) (0) (Female) 1967 4 drawings ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128074 Clara and baby (plate, facing page 14) from Po... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 24.500000 NaN NaN 21.800000 NaN NaN 534.100000 NaN
128075 Crapshooters (plate, facing page 22) from Porg... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 22.700000 NaN NaN 27.000000 NaN NaN 612.900000 NaN
128076 Crown kills Robbins (plate, facing page 29) fr... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 29.700000 NaN NaN 24.700000 NaN NaN 733.590000 NaN
128077 Porgy and moon (plate, facing page 38) from Po... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 23.500000 NaN NaN 18.000000 NaN NaN 423.000000 NaN
128078 Porgy and Bess embrace (plate, facing page 54)... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 26.200000 NaN NaN 16.500000 NaN NaN 432.300000 NaN
128079 The dance (plate, facing page 61) from Porgy &... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 27.500000 NaN NaN 20.000000 NaN NaN 550.000000 NaN
128080 Crown and Bess on the island (plate, facing pa... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 20.000000 NaN NaN 23.700000 NaN NaN 474.000000 NaN
128081 Crown seduces Bess (plate, facing page 64) fro... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 18.200000 NaN NaN 21.500000 NaN NaN 391.300000 NaN
128082 Bess, delirious, remembers (plate, facing page... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 19.500000 NaN NaN 17.000000 NaN NaN 331.500000 NaN
128083 Fisherman (plate, facing page 72) from Porgy &... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 25.500000 NaN NaN 24.300000 NaN NaN 619.650000 NaN
128084 Clara, Bess, and baby (plate, facing page 87) ... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 22.000000 NaN NaN 27.500000 NaN NaN 605.000000 NaN
128085 Bess and baby (plate, facing page 87) from Por... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 19.700000 NaN NaN 20.200000 NaN NaN 397.940000 NaN
128086 Porgy kills Crown (plate, facing page 89) from... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 21.200000 NaN NaN 29.500000 NaN NaN 625.400000 NaN
128087 Porgy taken to jail (plate, facing page 93) fr... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 21.000000 NaN NaN 19.500000 NaN NaN 409.500000 NaN
128088 Sporting Life and Bess (plate, facing page 94)... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 25.300000 NaN NaN 21.700000 NaN NaN 549.010000 NaN
128089 Porgy, departing, remembers (plate, facing pag... Kara Walker 7679 (American, born 1969) (American) (1969) (0) (Female) 2013 One from an illustrated book with sixteen lith... ... NaN NaN 21.200000 NaN NaN 20.300000 NaN NaN 430.360000 NaN
128210 Outfitumentary K8 Hardy 49713 (American, born 1977) (American) (1977) (0) (Female) 2016 Digital cinema ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128246 Dancing Boys Esther Regelson 49722 (American, born 1959) (American) (1959) (0) (Female) c. 1979 Super 8mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128247 Catharsis/Blih-Ah/WMEN Esther Regelson 49722 (American, born 1959) (American) (1959) (0) (Female) 1981–1982 16mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128248 Stop Action Esther Regelson 49722 (American, born 1959) (American) (1959) (0) (Female) 1980–1981 16mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128249 Angela Rebecca Miller 31259 (American, born 1962) (American) (1962) (0) (Female) 1995 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128250 The Ballad of Jack and Rose Rebecca Miller 31259 (American, born 1962) (American) (1962) (0) (Female) 2005 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128251 Maggie’s Plan Rebecca Miller 31259 (American, born 1962) (American) (1962) (0) (Female) 2015 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128252 Terminal Island Stephanie Rothman 49723 (American, born 1936) (American) (1936) (0) (Female) 1973 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128253 Group Marriage Stephanie Rothman 49723 (American, born 1936) (American) (1936) (0) (Female) 1973 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
128254 The Working Girls Stephanie Rothman 49723 (American, born 1936) (American) (1936) (0) (Female) 1974 35mm film ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

18085 rows × 31 columns


In [19]:
#Which year did the MoMA acquire the most artworks? What about the top ten years? Can you put that in a pretty chart?
#df['DateAcquired']

#I don't know how to do this

In [20]:
#What is the most common media used?
#df['Medium'].describe()
#How to come up with a list of the number of all the differnt types of media?
df['Medium'].value_counts() #yay!


Out[20]:
Gelatin silver print                                                                                                                                                                             13810
Lithograph                                                                                                                                                                                        7101
Albumen silver print                                                                                                                                                                              4842
Lithograph, printed in color                                                                                                                                                                      1942
Pencil on paper                                                                                                                                                                                   1713
Etching                                                                                                                                                                                           1690
Lithograph, printed in black                                                                                                                                                                      1592
Chromogenic color print                                                                                                                                                                           1464
Letterpress                                                                                                                                                                                       1307
Ink on paper                                                                                                                                                                                      1286
Pencil on tracing paper                                                                                                                                                                           1224
Oil on canvas                                                                                                                                                                                     1065
Drypoint                                                                                                                                                                                          1046
Woodcut                                                                                                                                                                                            970
Video (color, sound)                                                                                                                                                                               967
Offset lithograph                                                                                                                                                                                  948
Gelatin silver printing-out-paper print                                                                                                                                                            877
Screenprint                                                                                                                                                                                        869
Etching, printed in black                                                                                                                                                                          712
35mm film                                                                                                                                                                                          690
Poster                                                                                                                                                                                             669
Wood engraving, printed in black                                                                                                                                                                   635
Woodcut, printed in color                                                                                                                                                                          547
Photogravure                                                                                                                                                                                       528
Woodcut, printed in black                                                                                                                                                                          524
Etching and aquatint                                                                                                                                                                               502
Platinum print                                                                                                                                                                                     491
Collotype                                                                                                                                                                                          469
Matte albumen silver print                                                                                                                                                                         463
35mm film (color, sound)                                                                                                                                                                           448
                                                                                                                                                                                                 ...  
Tea stain, pencil, gouache and paint on cardboard on paper                                                                                                                                           1
Lift ground aquatint, aquatint, etching, and soft ground etching, relief and intaglio printed in color                                                                                               1
Typewriting and ballpoint pen on folded paper                                                                                                                                                        1
Etching, aquatint, collage and paper transfer                                                                                                                                                        1
Portfolio of 30 lithographs                                                                                                                                                                          1
Multiple of stencil and bricks                                                                                                                                                                       1
Felt tip pen                                                                                                                                                                                         1
Illustrated book with 13 etchings (including table of etchings); 67 wood engravings (cut by George Aubert after Picasso drawings); and 16 pages reproducing (lineblock) dot and line drawings        1
Cut-and-pasted paper, photolithograph, and gelatin silver photographs with ink on paper                                                                                                              1
Graphite on cut-and-pasted paper                                                                                                                                                                     1
Photolithograph and rubber stamp, printed in color, with collage and pencil additions                                                                                                                1
Artist's book with sixteen prints of etching, screenprint, woodcut, digital print, and laser cut                                                                                                     1
Oil and enamel on paper on board                                                                                                                                                                     1
Synthetic polymer paint, pencil, and cut-and-pasted colored paper on colored paper                                                                                                                   1
terracotta                                                                                                                                                                                           1
Lithograph with airbrushed lacquer additions                                                                                                                                                         1
Engraving and scratching on riveted metal plates                                                                                                                                                     1
Fourty four chromogenic color prints, printed 1985                                                                                                                                                   1
10 lift ground aquatints over photogravure, with drypoint, etching, and/or roulette; and 4 drypoints with roulette over photogravure (2 with etching) printed in black                               1
Drypoint from an illustrated book with three drypoints, two with etching                                                                                                                             1
Electrostatic print                                                                                                                                                                                  1
Twenty 35mm color slides                                                                                                                                                                             1
Photolithographic reproduction of photograph and rubber stamp, printed in color on white, smooth, wove paper mounted on white, smooth, wove paper                                                    1
19 leaves, paper-clipped in the upper left corner, photocopy, from an edition downloaded from www.antinomianpress.org circa 2011                                                                     1
Lambskin, satin ribbon, sterling silver, prosthetic plastic, petroleum jelly, and self-lubricating plastic with graphite in acrylic case                                                             1
Oil, casein and synthetic polymer paint on canvas                                                                                                                                                    1
Photocopy and chromogenic color print                                                                                                                                                                1
Acrylic, chalk, and canvas on canvas                                                                                                                                                                 1
Series of 16 digital prints                                                                                                                                                                          1
Pen and ink, and crayon on brown cardboard                                                                                                                                                           1
Name: Medium, dtype: int64

In [27]:
#What are the most common types of classification? Can you chart that?
df['Classification'].value_counts().head(5).plot(kind='hist', legend=False)

#top_class = df.sort_values(by=['Classification'], ascending=False).head(5)
#df.groupby("Classification").plot(kind='hist', legend=False)


#How to put value of value count into a chart?
#How to use groupby? How do I get the top five classifications to show?


Out[27]:
<matplotlib.axes._subplots.AxesSubplot at 0x10f39f940>

In [ ]:


In [ ]: