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')
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 [ ]:
Content source: honjy/foundations-homework
Similar notebooks: