In [1]:
import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inline

In [73]:
df = pd.read_excel("NASA_Labs_Facilities.xlsx")

1. Open your dataset up using pandas in a Jupyter notebook


In [74]:
df


Out[74]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
0 DOD Air Force Research Laboratory Public Mach 6, High Reynolds Number Facility 1960.0 Under Rehabilitation NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
1 DOD Air Force Research Laboratory Public Subsonic Aerodynamic Research Laboratory 1985.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
2 DOD Air Force Research Laboratory Public Trisonic Gasdynamics Facility 1960.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
3 DOD Air Force Research Laboratory Public Vertical Wind Tunnel 1960.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
4 DOD Arnold Engineering Development Center Public 10V Test Chamber 1965.0 Active http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2013-08-23 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513
5 DOD Arnold Engineering Development Center Public 7V Sensor Test Facility 1994.0 Active http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2012-09-19 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513
6 DOD Arnold Engineering Development Center Public Mark I Aerospace Chamber 1963.0 Inactive http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2012-09-19 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513
7 DOE Pacific Northwest National Laboratory Public Atmospheric Measurements Laboratory NaN Active http://www.pnnl.gov/atmospheric/programs/atmos... 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
8 DOE Pacific Northwest National Laboratory Public Atmospheric Radiation Measurement Climate Rese... NaN Active http://www.pnnl.gov/atmospheric/programs/arm.stm 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
9 DOE Pacific Northwest National Laboratory Public Atmospheric Research Measurement Aerial Facility NaN Active http://www.pnnl.gov/atmospheric/programs/arm_a... 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
10 DOE Pacific Northwest National Laboratory Public Biological Sciences Facility NaN Active www.pnnl.gov 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
11 DOE Pacific Northwest National Laboratory Public Bioproducts Sciences and Engineering Laboratory NaN Active http://www.pnnl.gov/biobased/bsel.stm 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
12 DOE Pacific Northwest National Laboratory Public Environmental and Molecular Sciences Laboratory NaN Active http://www.emsl.pnnl.gov/emslweb/ 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
13 DOE Pacific Northwest National Laboratory Public Joint Global Change Research Institute NaN Active http://www.pnnl.gov/atmospheric/programs/jgcri... 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
14 DOE Pacific Northwest National Laboratory Public Marine Sciences Facility NaN Active http://marine.pnnl.gov/ 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
15 DOE Pacific Northwest National Laboratory Public Materials Sciences & Techonolgy Laboratory NaN Active www.pnnl.gov 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
16 DOE Pacific Northwest National Laboratory Public Radiochemical Process Laboratory NaN Active http://rpl.pnnl.gov/ 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
17 DOE Pacific Northwest National Laboratory Public Research Aircraft Facility NaN Active http://www.pnnl.gov/atmospheric/programs/raf.stm 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
18 DOE Pacific Northwest National Laboratory Public Ultra-low Background Counting Laboratory NaN Active www.pnnl.gov 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
19 Intelsat Intelsat General Public Environmental Test Lab-Shaker 1969.0 Active NaN 1996-04-29 2013-08-26 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
20 Intelsat Intelsat General Public Environmental Test Lab-Test Chamber 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
21 Intelsat Intelsat General Public Large Anechoic Chamber 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
22 Intelsat Intelsat General Public Outdoor Antenna Test Range 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
23 Intelsat Intelsat General Public Scanning Auger Multiprobe; Electron Microscope 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
24 Intelsat Intelsat General Public Semiconductor Fabrication 1 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
25 Intelsat Intelsat General Public Semiconductor Fabrication 2 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
26 Intelsat Intelsat General Public Semiconductor Fabrication 3 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
27 Intelsat Intelsat General Public Semiconductor Fabrication 4 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
28 Intelsat Intelsat General Public Semiconductor Fabrication 5 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
29 Intelsat Intelsat General Public Semiconductor Fabrication 6 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
409 NASA 2 Stennis Space Center Public Hydrogen Transfer Facility #3415 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
410 NASA 2 Stennis Space Center Public Industrial Water Reservoir #4325 1966.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
411 NASA 2 Stennis Space Center Public Measurement Standards & Calibration Lab #8100 1966.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
412 NASA 2 Stennis Space Center Public Propellant Transfer & Storage Facility #3414 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
413 NASA 2 Stennis Space Center Public Push Boat 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
414 NASA 2 Stennis Space Center Public Repair, Fab. & Fluid Component Proc. #2201,220... 1964.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
415 NASA 2 Stennis Space Center Public Science Laboratory #8110 1966.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
416 NASA 2 Stennis Space Center Public Sensor Laboratory #1105 1966.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
417 NASA 2 Stennis Space Center Public Test Facility E-1 #4050 1992.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
418 NASA 2 Stennis Space Center Public Test Facility E-2 #4001 1994.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
419 NASA 2 Stennis Space Center Public Test Facility E-3 #4071 NaN Active http://rockettest.nasa.gov 2000-12-11 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
420 NASA 2 Stennis Space Center Public Test Facility H-1 #5001 1995.0 Inactive NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
421 NASA 2 Stennis Space Center Public Test Operations Bldg. E Complex #4010 1991.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
422 NASA 2 Stennis Space Center Public Test Stand A-1 #4120 1967.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
423 NASA 2 Wallops Flight Facility/GSFC Public Launch Range 1959.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-11 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
424 NASA 2 Wallops Flight Facility/GSFC Public Main Base Laboratories and Shops 1959.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
425 NASA 2 Wallops Flight Facility/GSFC Public McMurdo Ground Station (MGS) 1994.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
426 NASA 2 Wallops Flight Facility/GSFC Public Meteorological Facilities and ASRF 1959.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
427 NASA 2 Wallops Flight Facility/GSFC Public Mobile Range Systems 1960.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
428 NASA 2 Wallops Flight Facility/GSFC Public National Scientific Balloon Facility 1977.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
429 NASA 2 Wallops Flight Facility/GSFC Public Poker Flat Research Range & SAR Facility 1970.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
430 NASA 2 Wallops Flight Facility/GSFC Public Wallops Orbital Tracking Station 1960.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
431 NASA 2 Wallops Flight Facility/GSFC Public WFF Research Airport 1958.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
432 NASA 2 Wallops Flight Facility/GSFC Public White Sands Missile Range 1964.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
433 OSC Orbital Satellite Manufacturing Facility - Ari... Public 15 X 20 Thermal Vacuum Test Facility NaN Active http://www.orbital.com/NewsInfo/Publications/S... 2011-11-22 2013-08-28 00:00:00 1721 Elliot Road Gibert AZ 85223 US GaryRico, Lead Thermal Vacuum Test Engineer NaN 480 355 7275
434 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Anechoic Chambers NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2013-09-12 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171
435 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Climatics Test Area NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2013-09-12 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171
436 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Component Test and Analysis Laboratories NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2012-06-26 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171
437 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Sensor Thermal Vacuum Chamber - Integrated Tes... NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2012-06-26 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171
438 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Vibration Test Laboratory NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2013-09-12 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171

439 rows × 17 columns

3. Do a .columns to get a feel for your data


In [75]:
df.columns


Out[75]:
Index(['Agency', 'Center', 'Center Search Status', 'Facility', 'Occupied',
       'Status', 'URL Link', 'Record Date', 'Last Update', 'Address', 'City',
       'State', 'ZIP', 'Country', 'Contact', 'Mail Stop', 'Phone'],
      dtype='object')

4. Do a .head() to get a feel for your data


In [76]:
df.head()


Out[76]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
0 DOD Air Force Research Laboratory Public Mach 6, High Reynolds Number Facility 1960.0 Under Rehabilitation NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
1 DOD Air Force Research Laboratory Public Subsonic Aerodynamic Research Laboratory 1985.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
2 DOD Air Force Research Laboratory Public Trisonic Gasdynamics Facility 1960.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
3 DOD Air Force Research Laboratory Public Vertical Wind Tunnel 1960.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
4 DOD Arnold Engineering Development Center Public 10V Test Chamber 1965.0 Active http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2013-08-23 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513

4. Write down 12 questions to ask your data, or 12 things to hunt for in the data

  1. Find all the agencies that house a NASA Lab facility.
  2. Count the number of each agencies that house a Nasa Lab facility.
  3. Find the different centers that run a NASA lab, and their count.
  4. List the status of the lab facilities and their count?
  5. Find how many active labs are operating today.
  6. Which of the US states has the highest number of NASA Lab facilities ?
  7. Of all the states that has a NASA lab, which state has the lowest number in the country ?
  8. Group them by agencies.
  9. Group them by centers, and discover how many active labs are operating under each of them.
  10. Find all the cities with a Lab facility. Group them and find how many active labs are operating in each city.
  11. Group the states and find how many active labs are operating in each city.
  12. Find all the point of contacts. Find how many lab facilities each one handles.
  13. Find the current status of lab facilities under each point of contacts.
  14. Find the year in which they have made the last update.
  15. Find the number of centers that begin between 1960 - 1969, 1970 - 1979, 1980 - 1989, 1990 - 1999, and 2000 and beyond

1.Find all the agencies that house a NASA Lab facility.


In [6]:
df['Agency'].value_counts()


Out[6]:
NASA 2      397
Intelsat     17
DOE          12
DOD           7
RAYTHEON      5
OSC           1
Name: Agency, dtype: int64

In [7]:
print("NASA runs a total of 397 lab facilities, Nasa Intelsat runs 17, Department of Defence(DOD) runs 7 labs, Department of Energy runs 12 labs, Raytheon runs 5, and Orbital Sciences Corporation (osc) runs only one NASA lab facility")


NASA runs a total of 397 lab facilities, Nasa Intelsat runs 17, Department of Defence(DOD) runs 7 labs, Department of Energy runs 12 labs, Raytheon runs 5, and Orbital Sciences Corporation (osc) runs only one NASA lab facility

2. Find the different centers that run a NASA lab, and their count.


In [8]:
df['Center'].value_counts()


Out[8]:
Marshall Space Flight Center                          136
Langley Research Center                                50
Jet Propulsion Lab                                     39
Goddard Space Flight Center                            32
Glenn Research Center                                  31
Stennis Space Center                                   27
NASA Aircraft Management Division                      23
Michoud Assembly Facility                              17
Intelsat General                                       17
Ames Research Center                                   15
Pacific Northwest National Laboratory                  12
Wallops Flight Facility/GSFC                           10
Johnson Space Center                                   10
Armstrong Flight Research Center                        7
Raytheon Space and Airborne Systems - El Segundo        5
Air Force Research Laboratory                           4
Arnold Engineering Development Center                   3
Orbital Satellite Manufacturing Facility - Arizona      1
Name: Center, dtype: int64

3. List the status of the lab facilities and their count?


In [9]:
df['Status'].value_counts()


Out[9]:
Active                  388
Inactive                 22
Under Rehabilitation      2
Under                     1
Under Construction        1
Name: Status, dtype: int64

4. Find how many active labs are operating today.


In [10]:
print("There are 388 active lab facilities in the US")


There are 388 active lab facilities in the US

5. Which of the US states has the highest number of NASA Lab facilities ?


In [11]:
df['State'].value_counts()


Out[11]:
AL       136
CA        83
VA        60
OH        35
MD        32
MS        27
DC        21
LA        17
WA        12
TX        10
TN         3
20546      2
AZ         1
Name: State, dtype: int64

In [12]:
print("Alabama has the highest number of NASA Lab facilities in the country.")


Alabama has the highest number of NASA Lab facilities in the country.

6. Which of the US states has the lowest number of NASA Lab facilities ?


In [13]:
print("Alabama has the highest number of NASA Lab facilities in the country")


Alabama has the highest number of NASA Lab facilities in the country

7. Group them by agencies, and count the centers operating under each agency.


In [14]:
df.groupby("Agency")['Center'].value_counts()


Out[14]:
Agency    Center                                            
DOD       Air Force Research Laboratory                           4
          Arnold Engineering Development Center                   3
DOE       Pacific Northwest National Laboratory                  12
Intelsat  Intelsat General                                       17
NASA 2    Marshall Space Flight Center                          136
          Langley Research Center                                50
          Jet Propulsion Lab                                     39
          Goddard Space Flight Center                            32
          Glenn Research Center                                  31
          Stennis Space Center                                   27
          NASA Aircraft Management Division                      23
          Michoud Assembly Facility                              17
          Ames Research Center                                   15
          Johnson Space Center                                   10
          Wallops Flight Facility/GSFC                           10
          Armstrong Flight Research Center                        7
OSC       Orbital Satellite Manufacturing Facility - Arizona      1
RAYTHEON  Raytheon Space and Airborne Systems - El Segundo        5
Name: Center, dtype: int64

8. Group them by centers, and discover how many active labs are operating under each of them.


In [15]:
df.groupby("Agency")['Status'].value_counts()


Out[15]:
Agency    Status              
DOD       Active                    5
          Inactive                  1
          Under Rehabilitation      1
DOE       Active                   12
Intelsat  Active                    1
NASA 2    Active                  364
          Inactive                 21
          Under                     1
          Under Construction        1
          Under Rehabilitation      1
OSC       Active                    1
RAYTHEON  Active                    5
Name: Status, dtype: int64

9. Find all the cities with a Lab facility. Group them and find how many active labs are operating in each city.


In [16]:
df['City'].value_counts()


Out[16]:
MSFC                    136
Hampton                  50
PASADENA                 39
Greenbelt                32
Cleveland                31
Stennis Space Center     27
Washington               21
New Orleans              17
Rancho Palos Verdes      17
Moffett Field            15
Richland                 12
Houston                  10
Wallops Island           10
Edwards                   7
El Segundo                5
Wright-Patterson AFB      4
Arnold AFB                3
DC                        2
Gibert                    1
Name: City, dtype: int64

10. Find all the cities with a Lab facility. Group them and find how many active labs are operating in each city.


In [17]:
df.groupby("City")['Status'].value_counts()


Out[17]:
City                  Status              
Arnold AFB            Active                    2
                      Inactive                  1
Cleveland             Active                   30
                      Under Construction        1
DC                    Active                    2
Edwards               Active                    7
El Segundo            Active                    5
Gibert                Active                    1
Greenbelt             Active                   32
Hampton               Active                   48
                      Inactive                  2
Houston               Active                    9
                      Under Rehabilitation      1
MSFC                  Active                  118
                      Inactive                  8
                      Under                     1
Moffett Field         Active                   14
                      Inactive                  1
New Orleans           Active                   16
                      Inactive                  1
PASADENA              Active                   34
                      Inactive                  5
Rancho Palos Verdes   Active                    1
Richland              Active                   12
Stennis Space Center  Active                   25
                      Inactive                  2
Wallops Island        Active                   10
Washington            Active                   19
                      Inactive                  2
Wright-Patterson AFB  Active                    3
                      Under Rehabilitation      1
Name: Status, dtype: int64

11. Group the states and find how many active labs are operating in each city


In [18]:
state= df.groupby("State")['Status'].value_counts()
state


Out[18]:
State  Status              
20546  Active                    2
AL     Active                  118
       Inactive                  8
       Under                     1
AZ     Active                    1
CA     Active                   61
       Inactive                  6
DC     Active                   19
       Inactive                  2
LA     Active                   16
       Inactive                  1
MD     Active                   32
MS     Active                   25
       Inactive                  2
OH     Active                   33
       Under Construction        1
       Under Rehabilitation      1
TN     Active                    2
       Inactive                  1
TX     Active                    9
       Under Rehabilitation      1
VA     Active                   58
       Inactive                  2
WA     Active                   12
Name: Status, dtype: int64

12. Find all the point of contacts. Find how many lab facilities each one handles.


In [19]:
df['Contact'].value_counts()


Out[19]:
Roslin HIcks                                   136
Sherry Johnson                                  50
Gary Gray                                       39
Barry Green                                     32
Linda C. Elonen-Wright                          31
Robert Bruce                                    27
Hsien (Shen) Yen                                21
Bryan Benedict                                  17
Ernest Graham                                   17
Rocci Caringello                                15
Mardell Sours                                   12
Charles Noel                                    10
Scott H. Schaire                                10
Facilities Utilization Officer                   7
Paul N. Stovner                                  5
Mr. Chris Love                                   4
Capabilities Integration Division                3
LD010                                            2
GaryRico, Lead Thermal Vacuum Test Engineer      1
Name: Contact, dtype: int64

13.Find all the point of contacts. Find various status of lab facilities.


In [20]:
df.groupby("Contact")['Status'].value_counts()


Out[20]:
Contact                                      Status              
Barry Green                                  Active                   32
Bryan Benedict                               Active                    1
Capabilities Integration Division            Active                    2
                                             Inactive                  1
Charles Noel                                 Active                    9
                                             Under Rehabilitation      1
Ernest Graham                                Active                   16
                                             Inactive                  1
Facilities Utilization Officer               Active                    7
Gary Gray                                    Active                   34
                                             Inactive                  5
GaryRico, Lead Thermal Vacuum Test Engineer  Active                    1
Hsien (Shen) Yen                             Active                   19
                                             Inactive                  2
LD010                                        Active                    2
Linda C. Elonen-Wright                       Active                   30
                                             Under Construction        1
Mardell Sours                                Active                   12
Mr. Chris Love                               Active                    3
                                             Under Rehabilitation      1
Paul N. Stovner                              Active                    5
Robert Bruce                                 Active                   25
                                             Inactive                  2
Rocci Caringello                             Active                   14
                                             Inactive                  1
Roslin HIcks                                 Active                  118
                                             Inactive                  8
                                             Under                     1
Scott H. Schaire                             Active                   10
Sherry Johnson                               Active                   48
                                             Inactive                  2
Name: Status, dtype: int64

14. Sort by the year in which they have made the last update.


In [77]:
for x in (df['Last Update']):
    if isinstance(x, str):
        print(x)


300 E St, SW
300 E St, SW

In [78]:
dropped = df[df['Last Update'] != "300 E St, SW"]
for x in (dropped['Last Update']):
    if isinstance(x, str):
        print(x)

In [81]:
df['Last Update'].str[:5]
df


Out[81]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
0 DOD Air Force Research Laboratory Public Mach 6, High Reynolds Number Facility 1960.0 Under Rehabilitation NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
1 DOD Air Force Research Laboratory Public Subsonic Aerodynamic Research Laboratory 1985.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
2 DOD Air Force Research Laboratory Public Trisonic Gasdynamics Facility 1960.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
3 DOD Air Force Research Laboratory Public Vertical Wind Tunnel 1960.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
4 DOD Arnold Engineering Development Center Public 10V Test Chamber 1965.0 Active http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2013-08-23 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513
5 DOD Arnold Engineering Development Center Public 7V Sensor Test Facility 1994.0 Active http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2012-09-19 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513
6 DOD Arnold Engineering Development Center Public Mark I Aerospace Chamber 1963.0 Inactive http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2012-09-19 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513
7 DOE Pacific Northwest National Laboratory Public Atmospheric Measurements Laboratory NaN Active http://www.pnnl.gov/atmospheric/programs/atmos... 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
8 DOE Pacific Northwest National Laboratory Public Atmospheric Radiation Measurement Climate Rese... NaN Active http://www.pnnl.gov/atmospheric/programs/arm.stm 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
9 DOE Pacific Northwest National Laboratory Public Atmospheric Research Measurement Aerial Facility NaN Active http://www.pnnl.gov/atmospheric/programs/arm_a... 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
10 DOE Pacific Northwest National Laboratory Public Biological Sciences Facility NaN Active www.pnnl.gov 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
11 DOE Pacific Northwest National Laboratory Public Bioproducts Sciences and Engineering Laboratory NaN Active http://www.pnnl.gov/biobased/bsel.stm 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
12 DOE Pacific Northwest National Laboratory Public Environmental and Molecular Sciences Laboratory NaN Active http://www.emsl.pnnl.gov/emslweb/ 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
13 DOE Pacific Northwest National Laboratory Public Joint Global Change Research Institute NaN Active http://www.pnnl.gov/atmospheric/programs/jgcri... 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
14 DOE Pacific Northwest National Laboratory Public Marine Sciences Facility NaN Active http://marine.pnnl.gov/ 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
15 DOE Pacific Northwest National Laboratory Public Materials Sciences & Techonolgy Laboratory NaN Active www.pnnl.gov 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
16 DOE Pacific Northwest National Laboratory Public Radiochemical Process Laboratory NaN Active http://rpl.pnnl.gov/ 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
17 DOE Pacific Northwest National Laboratory Public Research Aircraft Facility NaN Active http://www.pnnl.gov/atmospheric/programs/raf.stm 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
18 DOE Pacific Northwest National Laboratory Public Ultra-low Background Counting Laboratory NaN Active www.pnnl.gov 2013-09-23 2013-09-23 00:00:00 Battelle Boulevard Richland WA 99352 US Mardell Sours LSB MSN J2-33 509-372-6026
19 Intelsat Intelsat General Public Environmental Test Lab-Shaker 1969.0 Active NaN 1996-04-29 2013-08-26 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
20 Intelsat Intelsat General Public Environmental Test Lab-Test Chamber 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
21 Intelsat Intelsat General Public Large Anechoic Chamber 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
22 Intelsat Intelsat General Public Outdoor Antenna Test Range 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
23 Intelsat Intelsat General Public Scanning Auger Multiprobe; Electron Microscope 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
24 Intelsat Intelsat General Public Semiconductor Fabrication 1 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
25 Intelsat Intelsat General Public Semiconductor Fabrication 2 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
26 Intelsat Intelsat General Public Semiconductor Fabrication 3 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
27 Intelsat Intelsat General Public Semiconductor Fabrication 4 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
28 Intelsat Intelsat General Public Semiconductor Fabrication 5 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
29 Intelsat Intelsat General Public Semiconductor Fabrication 6 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
409 NASA 2 Stennis Space Center Public Hydrogen Transfer Facility #3415 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
410 NASA 2 Stennis Space Center Public Industrial Water Reservoir #4325 1966.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
411 NASA 2 Stennis Space Center Public Measurement Standards & Calibration Lab #8100 1966.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
412 NASA 2 Stennis Space Center Public Propellant Transfer & Storage Facility #3414 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
413 NASA 2 Stennis Space Center Public Push Boat 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
414 NASA 2 Stennis Space Center Public Repair, Fab. & Fluid Component Proc. #2201,220... 1964.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
415 NASA 2 Stennis Space Center Public Science Laboratory #8110 1966.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
416 NASA 2 Stennis Space Center Public Sensor Laboratory #1105 1966.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
417 NASA 2 Stennis Space Center Public Test Facility E-1 #4050 1992.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
418 NASA 2 Stennis Space Center Public Test Facility E-2 #4001 1994.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
419 NASA 2 Stennis Space Center Public Test Facility E-3 #4071 NaN Active http://rockettest.nasa.gov 2000-12-11 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
420 NASA 2 Stennis Space Center Public Test Facility H-1 #5001 1995.0 Inactive NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
421 NASA 2 Stennis Space Center Public Test Operations Bldg. E Complex #4010 1991.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
422 NASA 2 Stennis Space Center Public Test Stand A-1 #4120 1967.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
423 NASA 2 Wallops Flight Facility/GSFC Public Launch Range 1959.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-11 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
424 NASA 2 Wallops Flight Facility/GSFC Public Main Base Laboratories and Shops 1959.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
425 NASA 2 Wallops Flight Facility/GSFC Public McMurdo Ground Station (MGS) 1994.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
426 NASA 2 Wallops Flight Facility/GSFC Public Meteorological Facilities and ASRF 1959.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
427 NASA 2 Wallops Flight Facility/GSFC Public Mobile Range Systems 1960.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
428 NASA 2 Wallops Flight Facility/GSFC Public National Scientific Balloon Facility 1977.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
429 NASA 2 Wallops Flight Facility/GSFC Public Poker Flat Research Range & SAR Facility 1970.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
430 NASA 2 Wallops Flight Facility/GSFC Public Wallops Orbital Tracking Station 1960.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
431 NASA 2 Wallops Flight Facility/GSFC Public WFF Research Airport 1958.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
432 NASA 2 Wallops Flight Facility/GSFC Public White Sands Missile Range 1964.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
433 OSC Orbital Satellite Manufacturing Facility - Ari... Public 15 X 20 Thermal Vacuum Test Facility NaN Active http://www.orbital.com/NewsInfo/Publications/S... 2011-11-22 2013-08-28 00:00:00 1721 Elliot Road Gibert AZ 85223 US GaryRico, Lead Thermal Vacuum Test Engineer NaN 480 355 7275
434 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Anechoic Chambers NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2013-09-12 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171
435 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Climatics Test Area NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2013-09-12 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171
436 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Component Test and Analysis Laboratories NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2012-06-26 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171
437 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Sensor Thermal Vacuum Chamber - Integrated Tes... NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2012-06-26 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171
438 RAYTHEON Raytheon Space and Airborne Systems - El Segundo Public Vibration Test Laboratory NaN Active http://www.raytheon.com/capabilities/products/... 2012-06-26 2013-09-12 00:00:00 2000 E. El Segundo Blvd. El Segundo CA 90245 US Paul N. Stovner A130 310-647-4171

439 rows × 17 columns


In [82]:
dropped.sort_values(by='Last Update',ascending=False).head(3)


Out[82]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
52 NASA 2 Armstrong Flight Research Center Public Bldg. 4800 - Research Development & Test Facility 1954.0 Active www.nasa.gov/centers/dryden/home/index.html 2010-04-13 2014-12-19 00:00:00 P.O.Box 273 Edwards CA 93523-0273 US Facilities Utilization Officer B-4800, Room 2004 661-276-2585
54 NASA 2 Armstrong Flight Research Center Public Bldg. 4824 - Communications Building NaN Active NaN 2010-04-13 2014-12-19 00:00:00 P.O.Box 273 Edwards CA 93523-0273 US Facilities Utilization Officer B-4800, Room 2004 661-276-2585
56 NASA 2 Armstrong Flight Research Center Public Bldg. 4982 - Aeronautical Tracking Facility NaN Active NaN 2010-04-13 2014-12-19 00:00:00 P.O.Box 273 Edwards CA 93523-0273 US Facilities Utilization Officer B-4800, Room 2004 661-276-2585

15. Find all the centers that begin between 1960 - 1969, 1970 - 1979, 1980 - 1989, 1990 - 1999, and 2000 and beyond


In [28]:
year60 = df[(df['Occupied'] >= 1960) & (df['Occupied'] <=1969)]
year60


Out[28]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
0 DOD Air Force Research Laboratory Public Mach 6, High Reynolds Number Facility 1960.0 Under Rehabilitation NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
2 DOD Air Force Research Laboratory Public Trisonic Gasdynamics Facility 1960.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
3 DOD Air Force Research Laboratory Public Vertical Wind Tunnel 1960.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
4 DOD Arnold Engineering Development Center Public 10V Test Chamber 1965.0 Active http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2013-08-23 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513
6 DOD Arnold Engineering Development Center Public Mark I Aerospace Chamber 1963.0 Inactive http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2012-09-19 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513
19 Intelsat Intelsat General Public Environmental Test Lab-Shaker 1969.0 Active NaN 1996-04-29 2013-08-26 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
20 Intelsat Intelsat General Public Environmental Test Lab-Test Chamber 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
21 Intelsat Intelsat General Public Large Anechoic Chamber 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
22 Intelsat Intelsat General Public Outdoor Antenna Test Range 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
23 Intelsat Intelsat General Public Scanning Auger Multiprobe; Electron Microscope 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
24 Intelsat Intelsat General Public Semiconductor Fabrication 1 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
25 Intelsat Intelsat General Public Semiconductor Fabrication 2 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
26 Intelsat Intelsat General Public Semiconductor Fabrication 3 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
27 Intelsat Intelsat General Public Semiconductor Fabrication 4 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
28 Intelsat Intelsat General Public Semiconductor Fabrication 5 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
29 Intelsat Intelsat General Public Semiconductor Fabrication 6 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
30 Intelsat Intelsat General Public Semiconductor Fabrication 7 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
31 Intelsat Intelsat General Public Small Anechoic Chamber 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
32 Intelsat Intelsat General Public SSTD 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
33 Intelsat Intelsat General Public Subjective Evaluation Room 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
34 Intelsat Intelsat General Public System Simulation Laboratory 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
35 Intelsat Intelsat General Public Video System Lab 1969.0 NaN NaN 1996-04-29 2013-08-22 00:00:00 28035 Ambergate Drive Rancho Palos Verdes CA 90275 US Bryan Benedict In-Orbit Servicing 424 206-2725
38 NASA 2 Ames Research Center Public N204A - SPACE TECHNOLOGY BUILDING: AMES VERTIC... 1966.0 Active http://thermo-physics.arc.nasa.gov 1996-03-01 2014-06-12 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
40 NASA 2 Ames Research Center Public N221A - 20-G AND HUMAN POWER CENTRIFUGE (PAPAC) 1964.0 Active http://spacebiosciences.arc.nasa.gov/page/20-g... 1996-03-01 2012-01-18 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
41 NASA 2 Ames Research Center Public N229 - EXPER. AEROTHERMODYNAMIC FAC.: ELECTRIC... 1961.0 Active http://thermo-physics.arc.nasa.gov 1996-03-01 2014-06-13 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
43 NASA 2 Ames Research Center Public N234 - THERMAL PROTECTION LAB: AERODYNAMIC HEA... 1962.0 Active http://thermo-physics.arc.nasa.gov 1996-03-01 2014-06-13 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
44 NASA 2 Ames Research Center Public N234A - THERMAL PROTECTION LAB BOILER: STEAM V... 1962.0 Active http://thermo-physics.arc.nasa.gov 1996-03-01 2014-06-12 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
45 NASA 2 Ames Research Center Public N237 - HYPERVELOCITY FREE FLIGHT AERODYNAMIC F... 1964.0 Active http://thermo-physics.arc.nasa.gov 1996-03-01 2014-06-13 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
46 NASA 2 Ames Research Center Public N237 - HYPERVELOCITY FREE FLIGHT GUN DEVELOPME... 1964.0 Inactive http://thermo-physics.arc.nasa.gov 1996-03-01 2013-07-19 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
53 NASA 2 Armstrong Flight Research Center Public Bldg. 4820 - Flight Loads Laboratory 1966.0 Active www.nasa.gov/centers/dryden/research/Facilitie... 1996-03-01 2013-07-10 00:00:00 P.O.Box 273 Edwards CA 93523-0273 US Facilities Utilization Officer B-4800, Room 2004 661-276-2585
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
349 NASA 2 Marshall Space Flight Center Public Neutral Buoyancy Facility 4705 1968.0 Inactive NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
355 NASA 2 Marshall Space Flight Center Public Vacuum Drop Tube Facility 4550 1965.0 Inactive NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
368 NASA 2 Michoud Assembly Facility Public Port Michoud Facility 1963.0 Active http://mafbusiness.msfc.nasa.gov/ 2009-01-29 2013-02-19 00:00:00 PO Box 29300 New Orleans LA 70189 US Ernest Graham AS60 504.257-2619
371 NASA 2 Michoud Assembly Facility Public Thermal Protection System Area 1963.0 Active http://mafbusiness.msfc.nasa.gov/ 2009-04-06 2013-02-19 00:00:00 PO Box 29300 New Orleans LA 70189 US Ernest Graham AS60 504.257-2619
372 NASA 2 Michoud Assembly Facility Public Vertical Assembly Facility 1963.0 Active http://mafbusiness.msfc.nasa.gov/ 2009-02-03 2013-02-19 00:00:00 PO Box 29300 New Orleans LA 70189 US Ernest Graham AS60 504.257-2619
396 NASA 2 Stennis Space Center Public A Complex Test Control Center (TCC) #4110 1966.0 Active NaN 1996-03-01 2014-09-02 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
397 NASA 2 Stennis Space Center Public B Complex Test Control Center (TCC) #4210 1966.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
398 NASA 2 Stennis Space Center Public Barge, Liquid Hydrogen (3 each) 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
399 NASA 2 Stennis Space Center Public Barge, Liquid Oxygen (6 each) 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
400 NASA 2 Stennis Space Center Public Canals, Lock & Dock System #0036,2310,2311,2317 1966.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
401 NASA 2 Stennis Space Center Public Communications Building #1201 1965.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
402 NASA 2 Stennis Space Center Public Cryogenics Docks #0008 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
403 NASA 2 Stennis Space Center Public Data Acquisition Facility (DAF) #4995 1966.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
404 NASA 2 Stennis Space Center Public Electrical Distribution System #0010 1964.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
405 NASA 2 Stennis Space Center Public Emergency Power Generating System #4400 1966.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
406 NASA 2 Stennis Space Center Public Engine Processing Building #3202 1965.0 Inactive http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
407 NASA 2 Stennis Space Center Public High Pressure Gas Facility #0041,3305,6,9,10,11 1966.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
408 NASA 2 Stennis Space Center Public High Pressure Industrial Water Plant #4400 1966.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
409 NASA 2 Stennis Space Center Public Hydrogen Transfer Facility #3415 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
410 NASA 2 Stennis Space Center Public Industrial Water Reservoir #4325 1966.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
411 NASA 2 Stennis Space Center Public Measurement Standards & Calibration Lab #8100 1966.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
412 NASA 2 Stennis Space Center Public Propellant Transfer & Storage Facility #3414 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
413 NASA 2 Stennis Space Center Public Push Boat 1965.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
414 NASA 2 Stennis Space Center Public Repair, Fab. & Fluid Component Proc. #2201,220... 1964.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
415 NASA 2 Stennis Space Center Public Science Laboratory #8110 1966.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
416 NASA 2 Stennis Space Center Public Sensor Laboratory #1105 1966.0 Active NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
422 NASA 2 Stennis Space Center Public Test Stand A-1 #4120 1967.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
427 NASA 2 Wallops Flight Facility/GSFC Public Mobile Range Systems 1960.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
430 NASA 2 Wallops Flight Facility/GSFC Public Wallops Orbital Tracking Station 1960.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
432 NASA 2 Wallops Flight Facility/GSFC Public White Sands Missile Range 1964.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120

152 rows × 17 columns


In [29]:
year60['Occupied'].value_counts()


Out[29]:
1965.0    25
1960.0    23
1964.0    22
1966.0    20
1969.0    18
1963.0    14
1961.0    12
1962.0    11
1968.0     5
1967.0     2
Name: Occupied, dtype: int64

In [30]:
print("There are", year60['Occupied'].value_counts().sum(), "Lab facilities started between 1960-1969")


There are 152 Lab facilities started between 1960-1969

In [31]:
year70 = df[(df['Occupied'] >= 1970) & (df['Occupied'] <=1979)]
year70


Out[31]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
42 NASA 2 Ames Research Center Public N234 - THERMAL PROTECTION LAB: 2x9 INCH SUPERS... 1972.0 Active http://thermo-physics.arc.nasa.gov 1996-03-01 2014-06-12 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
47 NASA 2 Ames Research Center Public N238 - ARC JET LABORATORY: INTERACTION HEATING... 1975.0 Active http://thermo-physics.arc.nasa.gov 1996-03-01 2014-06-13 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
48 NASA 2 Ames Research Center Public N238 - ARC JET LABORATORY: PANEL TEST FACILITY... 1972.0 Active http://thermo-physics.arc.nasa.gov 1996-03-01 2014-06-12 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
76 NASA 2 Glenn Research Center Public Propulsion Systems Laboratory, Bldg. 125 1972.0 Active http://facilities.grc.nasa.gov/psl/ 1996-03-01 2013-08-13 00:00:00 21000 Brookpark Road Cleveland OH 44135 US Linda C. Elonen-Wright 2014-06-08 00:00:00 216-433-9370
96 NASA 2 Goddard Space Flight Center Public 500 WSC: Antenna, 10m S-band 1977.0 Active NaN 1996-03-01 2013-08-15 00:00:00 Greenbelt Road Greenbelt MD 20771 US Barry Green Code 500 301 286 2520
97 NASA 2 Goddard Space Flight Center Public 500 WSC: Antenna, 19m S/Ku-band 1977.0 Active NaN 1996-03-01 2013-08-16 00:00:00 Greenbelt Road Greenbelt MD 20771 US Barry Green Code 500 301 286 2520
98 NASA 2 Goddard Space Flight Center Public 500/WSC: Antenna, 4.5m S/Ku-band 1977.0 Active NaN 1996-03-01 2013-08-16 00:00:00 Greenbelt Road Greenbelt MD 20771 US Barry Green Code 500 301 286 2520
99 NASA 2 Goddard Space Flight Center Public 500/WSC: Data Interface System 1977.0 Active NaN 1996-03-01 2013-08-16 00:00:00 Greenbelt Road Greenbelt MD 20771 US Barry Green Code 500 301 286 2520
103 NASA 2 Goddard Space Flight Center Public 500: Space-Ground Link Terminal 1977.0 Active NaN 1996-03-01 2013-08-16 00:00:00 Greenbelt Road Greenbelt MD 20771 US Barry Green Code 500 301 286 2520
118 NASA 2 Goddard Space Flight Center Public TDRSS Control Center 1977.0 Active NaN 1996-03-01 2013-08-16 00:00:00 Greenbelt Road Greenbelt MD 20771 US Barry Green Code 500 301 286 2520
146 NASA 2 Jet Propulsion Lab Public Lidar Facility 1973.0 Active NaN 1996-03-01 2013-08-07 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
151 NASA 2 Jet Propulsion Lab Public Remote Surface Lab 1972.0 Active NaN 1996-03-01 2013-08-08 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
174 NASA 2 Langley Research Center Public Ceramic & Glass Laboratory (B-1237A) 1978.0 Active NaN 1996-03-01 2013-02-13 00:00:00 NASA Langley Research Center Hampton VA 23681-2199 US Sherry Johnson 241 757.864-3848
176 NASA 2 Langley Research Center Public Composite Material Development Laboratory/B1238B 1978.0 Active NaN 1996-03-01 2013-02-25 00:00:00 NASA Langley Research Center Hampton VA 23681-2199 US Sherry Johnson 241 757.864-3848
185 NASA 2 Langley Research Center Public Helicopter Hover Facility/647 1977.0 Active NaN 1996-03-01 2013-02-15 00:00:00 NASA Langley Research Center Hampton VA 23681-2199 US Sherry Johnson 241 757.864-3848
277 NASA 2 Marshall Space Flight Center Public EM Space Environmental Effects Facility 4605 1970.0 Active NaN 1996-03-01 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
307 NASA 2 Marshall Space Flight Center Public EP Hot Gas Test Facility 4554 1976.0 NaN NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
321 NASA 2 Marshall Space Flight Center Public ES Low Energy Ion Facility 4481 1974.0 Active NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
344 NASA 2 Marshall Space Flight Center Public EV LAB 1/2 Mile Antenna Test Range 4194 1976.0 Active NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
428 NASA 2 Wallops Flight Facility/GSFC Public National Scientific Balloon Facility 1977.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120
429 NASA 2 Wallops Flight Facility/GSFC Public Poker Flat Research Range & SAR Facility 1970.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120

In [32]:
year70['Occupied'].value_counts()


Out[32]:
1977.0    8
1972.0    4
1978.0    2
1976.0    2
1970.0    2
1975.0    1
1974.0    1
1973.0    1
Name: Occupied, dtype: int64

In [33]:
print("There are", year70['Occupied'].value_counts().sum(), "Lab facilities started between 1970-1979")


There are 21 Lab facilities started between 1970-1979

In [34]:
year80 = df[(df['Occupied'] >= 1980) & (df['Occupied'] <=1989)]
year80


Out[34]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
1 DOD Air Force Research Laboratory Public Subsonic Aerodynamic Research Laboratory 1985.0 Active NaN 1996-03-01 2013-09-09 00:00:00 1864 4th St Wright-Patterson AFB OH 45433-7541 US Mr. Chris Love B015 937 255-1689
49 NASA 2 Ames Research Center Public N240 - CENTER FOR ENGINEERING INNOVATION: FLIG... 1982.0 Active NaN 1996-03-01 2012-01-30 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
75 NASA 2 Glenn Research Center Public Power Systems Facility, Bldg. 333 & 333A 1989.0 Active http://www.grc.nasa.gov/WWW/Facilities/ext/psf... 1996-03-01 2013-08-13 00:00:00 21000 Brookpark Road Cleveland OH 44135 US Linda C. Elonen-Wright 2014-06-08 00:00:00 216-433-9370
77 NASA 2 Glenn Research Center Public Research Analysis Center, Bldg. 142 1980.0 Active NaN 1996-03-01 2013-08-13 00:00:00 21000 Brookpark Road Cleveland OH 44135 US Linda C. Elonen-Wright 2014-06-08 00:00:00 216-433-9370
124 NASA 2 Jet Propulsion Lab Public 48-inch Telescope 1988.0 Active NaN 1996-03-01 2013-08-07 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
144 NASA 2 Jet Propulsion Lab Public Frequency Standards Laboratory 1985.0 Active NaN 1996-03-01 2013-08-07 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
147 NASA 2 Jet Propulsion Lab Public Mesa Antenna Test Facility 1980.0 Active NaN 1996-03-01 2013-08-07 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
153 NASA 2 Jet Propulsion Lab Public SOLAR TEST FACILITY 1985.0 Active NaN 1996-03-01 2013-08-08 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
160 NASA 2 Johnson Space Center Public 11 ft. Chamber, Space Suit Dev. & Cert, EC, B-7 1989.0 Active http://www.nasa.gov/centers/johnson/engineerin... 1996-03-01 2012-03-20 00:00:00 2101 NASA Parkway Houston TX 77058 US Charles Noel JP 281.483.3219
204 NASA 2 Langley Research Center Public National Transonic Facility 1982.0 Active http://www.aeronautics.nasa.gov/atp/index.html 1996-03-01 2013-02-25 00:00:00 NASA Langley Research Center Hampton VA 23681-2199 US Sherry Johnson 241 757.864-3848
205 NASA 2 Langley Research Center Public Nondestructive Evaluation Lab 1988.0 Active NaN 1996-03-01 2013-02-25 00:00:00 NASA Langley Research Center Hampton VA 23681-2199 US Sherry Johnson 241 757.864-3848
234 NASA 2 Marshall Space Flight Center Public ED Air Flow Turbine Test Facility 4777 1985.0 Active NaN 1996-03-01 2014-05-30 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
235 NASA 2 Marshall Space Flight Center Public ED Coldflow R & D Test Complex 4776 1985.0 Active NaN 1996-03-01 2014-05-30 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
236 NASA 2 Marshall Space Flight Center Public ED Liquid Rocket Engine Air Flow Fac 4777 1985.0 Active NaN 1996-03-01 2014-05-30 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
237 NASA 2 Marshall Space Flight Center Public ED Liquid/Solid Rocket Eng Water Flow Fac 4776 1985.0 Active NaN 1996-03-01 2014-05-30 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
239 NASA 2 Marshall Space Flight Center Public ED Solid Rocket Engine Air Flow Fac 4777 1985.0 Active NaN 1996-03-01 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
240 NASA 2 Marshall Space Flight Center Public ED Water Flow Inducer Test Loop 4777 1985.0 Active NaN 1996-03-01 2014-05-30 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
244 NASA 2 Marshall Space Flight Center Public EH Computer Aided Design (CAD)Room 4708 1989.0 Active NaN 1996-05-29 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
269 NASA 2 Marshall Space Flight Center Public EI Manned Habitat ECLSS Test Facility 4755 1985.0 Active NaN 1996-05-17 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
289 NASA 2 Marshall Space Flight Center Public EM-20 Computed Tomography Facility 4707 1985.0 Active NaN 1996-03-01 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
303 NASA 2 Marshall Space Flight Center Public EO UDC/ Express Rack/ Express Pallet 4612 1988.0 Under NaN 1996-05-29 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
314 NASA 2 Marshall Space Flight Center Public EP Transient Pressure Test Facility 4515 1987.0 Inactive NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
339 NASA 2 Marshall Space Flight Center Public EV Engine Hardware Simulation Laboratory, 4436 1988.0 Active NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
342 NASA 2 Marshall Space Flight Center Public EV Contact Dynamics Simulation Lab (6DOF) 4663 1980.0 Active NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
343 NASA 2 Marshall Space Flight Center Public EV Flight Robotics Laboratory (Flat Floor) 4619 1983.0 Active NaN 1996-06-03 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
357 NASA 2 Michoud Assembly Facility Public Component Ablator Facility Mix Room 1985.0 Active http://mafbusiness.msfc.nasa.gov/ 2009-04-06 2013-02-19 00:00:00 PO Box 29300 New Orleans LA 70189 US Ernest Graham AS60 504.257-2619
358 NASA 2 Michoud Assembly Facility Public Component Ablator Facility SLA Spray Preparati... 1985.0 Active http://mafbusiness.msfc.nasa.gov/ 2009-04-06 2013-02-19 00:00:00 PO Box 29300 New Orleans LA 70189 US Ernest Graham AS60 504.257-2619
359 NASA 2 Michoud Assembly Facility Public Component Ablator Facility SLA Spray Room 1985.0 Active http://mafbusiness.msfc.nasa.gov/ 2009-04-07 2013-02-19 00:00:00 PO Box 29300 New Orleans LA 70189 US Ernest Graham AS60 504.257-2619
364 NASA 2 Michoud Assembly Facility Public High Bay Facility 1982.0 Active http://mafbusiness.msfc.nasa.gov/ 2009-02-03 2013-02-19 00:00:00 PO Box 29300 New Orleans LA 70189 US Ernest Graham AS60 504.257-2619
365 NASA 2 Michoud Assembly Facility Public LH2 Ablator Spray Facility 1980.0 Active http://mafbusiness.msfc.nasa.gov/ 2009-04-06 2013-02-19 00:00:00 PO Box 29300 New Orleans LA 70189 US Ernest Graham AS60 504.257-2619

In [35]:
year80['Occupied'].value_counts()


Out[35]:
1985.0    14
1980.0     4
1988.0     4
1982.0     3
1989.0     3
1983.0     1
1987.0     1
Name: Occupied, dtype: int64

In [36]:
print("There are", year80['Occupied'].value_counts().sum(), "Lab facilities started between 1980-1989")


There are 30 Lab facilities started between 1980-1989

In [37]:
year90 = df[(df['Occupied'] >= 1990) & (df['Occupied'] <=1999)]
year90


Out[37]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
5 DOD Arnold Engineering Development Center Public 7V Sensor Test Facility 1994.0 Active http://www.arnold.af.mil/library/factsheets/fa... 1996-03-01 2012-09-19 00:00:00 100 Kindel Dr, MS-1214 Arnold AFB TN 37389-1214 US Capabilities Integration Division AEDC/XPR (931) 454-6513
55 NASA 2 Armstrong Flight Research Center Public Bldg. 4840 - Research Aircraft Integration Fac... 1992.0 Active www.nasa.gov/centers/dryden/pdf/152685main_RAI... 1996-03-01 2014-12-17 00:00:00 P.O.Box 273 Edwards CA 93523-0273 US Facilities Utilization Officer B-4800, Room 2004 661-276-2585
61 NASA 2 Glenn Research Center Public Aero Acoustic Propulsion Lab., (AAPL) Bldg. 145 1990.0 Active http://facilities.grc.nasa.gov/aapl/index.html 1996-03-01 2013-08-13 00:00:00 21000 Brookpark Road Cleveland OH 44135 US Linda C. Elonen-Wright 2014-06-08 00:00:00 216-433-9370
80 NASA 2 Glenn Research Center Public Space Experiments Laboratory, Bldg. 110 1993.0 Active NaN 1996-03-01 2013-08-13 00:00:00 21000 Brookpark Road Cleveland OH 44135 US Linda C. Elonen-Wright 2014-06-08 00:00:00 216-433-9370
88 NASA 2 Glenn Research Center Public Zero Gravity Research Facility, (Bldg. 110) 1993.0 Active http://microgravity.grc.nasa.gov/zero-g/ 1996-03-01 2013-08-13 00:00:00 21000 Brookpark Road Cleveland OH 44135 US Linda C. Elonen-Wright 2014-06-08 00:00:00 216-433-9370
105 NASA 2 Goddard Space Flight Center Public 700: Cryogenic Research and Integration Facility 1994.0 Active NaN 1996-03-01 2013-08-16 00:00:00 Greenbelt Road Greenbelt MD 20771 US Barry Green Code 500 301 286 2520
112 NASA 2 Goddard Space Flight Center Public 700: SSDIF Clean Room, B.29 1990.0 Active NaN 1996-03-01 2013-08-16 00:00:00 Greenbelt Road Greenbelt MD 20771 US Barry Green Code 500 301 286 2520
134 NASA 2 Jet Propulsion Lab Public DSS 24 Antenna 1994.0 Active NaN 1996-03-01 2013-08-07 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
148 NASA 2 Jet Propulsion Lab Public Microdevices Laboratory (MDL) 1990.0 Active NaN 1996-03-01 2013-08-08 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
149 NASA 2 Jet Propulsion Lab Public Mirror Refurbishment Building 1992.0 Active NaN 1996-03-01 2013-08-08 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
150 NASA 2 Jet Propulsion Lab Public Optical Laboratories 1993.0 Active NaN 1996-03-01 2013-08-08 00:00:00 JPL:2800 PASADENA CA 91109-8099 US Gary Gray JPL:2800 818.354.0701
180 NASA 2 Langley Research Center Public Experimental Test Range 1990.0 Active NaN 1996-03-01 2013-02-25 00:00:00 NASA Langley Research Center Hampton VA 23681-2199 US Sherry Johnson 241 757.864-3848
195 NASA 2 Langley Research Center Public Jet Noise Laboratory 1995.0 Active NaN 1996-03-01 2013-02-25 00:00:00 NASA Langley Research Center Hampton VA 23681-2199 US Sherry Johnson 241 757.864-3848
223 NASA 2 Marshall Space Flight Center Public Cosmic Ray Emulsion Laboratory 4481 1991.0 Inactive NaN 1996-03-01 2014-05-30 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
224 NASA 2 Marshall Space Flight Center Public EB Audio Reverberant Facility 4477 1991.0 Active NaN 1996-03-01 2014-05-30 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
238 NASA 2 Marshall Space Flight Center Public ED Pump Test Equipment Facility 4777 1995.0 Active NaN 1996-05-30 2014-05-30 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
270 NASA 2 Marshall Space Flight Center Public EI Space Systems Integration and Test Facility 4 1992.0 Active NaN 1996-03-01 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
271 NASA 2 Marshall Space Flight Center Public EI MSFC Electromagnetic Interference (EMI) Tes... 1995.0 Active NaN 1996-03-01 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
274 NASA 2 Marshall Space Flight Center Public EL X-Ray & Cryogenic Facility (XRCF), 4718 1991.0 Active http://optics.nasa.gov/facilities/xraycal.html 1996-03-01 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
291 NASA 2 Marshall Space Flight Center Public EM-20 Acoustic Emission Facility 4711 1992.0 Active NaN 2006-08-04 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
299 NASA 2 Marshall Space Flight Center Public EM-20 Shearography Facility 4711 1992.0 Active NaN 2006-08-04 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
301 NASA 2 Marshall Space Flight Center Public EM-20 Thermography Facility 4711 1992.0 Active NaN 2006-08-04 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
317 NASA 2 Marshall Space Flight Center Public ES BATSE Operations & Data Analysis Lab 4481 1990.0 Active NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
318 NASA 2 Marshall Space Flight Center Public ES Dist Active Archive Center 917 Expl. Blvd. 1991.0 NaN NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
319 NASA 2 Marshall Space Flight Center Public ES Earth Science & Appl.Computer Facility 4492 1991.0 NaN NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
320 NASA 2 Marshall Space Flight Center Public ES Laboratory for Structural Biology 4484 1994.0 NaN NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
322 NASA 2 Marshall Space Flight Center Public ES Plasma Wind Tunnel 4481 1991.0 NaN NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
347 NASA 2 Marshall Space Flight Center Public Low Gravity Materials Science Facility 4550 1991.0 Inactive NaN 1996-03-01 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
417 NASA 2 Stennis Space Center Public Test Facility E-1 #4050 1992.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
418 NASA 2 Stennis Space Center Public Test Facility E-2 #4001 1994.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
420 NASA 2 Stennis Space Center Public Test Facility H-1 #5001 1995.0 Inactive NaN 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
421 NASA 2 Stennis Space Center Public Test Operations Bldg. E Complex #4010 1991.0 Active http://rockettest.nasa.gov 1996-03-01 2012-01-30 00:00:00 PA10-Planning, Development, & Analysis Office Stennis Space Center MS 39529-6000 US Robert Bruce PA10 601-688-1646
425 NASA 2 Wallops Flight Facility/GSFC Public McMurdo Ground Station (MGS) 1994.0 Active http://www.nasa.gov/centers/wallops 1996-03-01 2013-07-19 00:00:00 Code 802 Wallops Island VA 23337-5099 US Scott H. Schaire F-6 757-824-1120

In [38]:
year90['Occupied'].value_counts()


Out[38]:
1991.0    8
1992.0    7
1994.0    6
1990.0    5
1995.0    4
1993.0    3
Name: Occupied, dtype: int64

In [39]:
print("There are", year90['Occupied'].value_counts().sum(), "Lab facilities started between 1990-1999")


There are 33 Lab facilities started between 1990-1999

In [40]:
year00 = df[(df['Occupied'] >= 2000) & (df['Occupied'] <=2009)]
year00


Out[40]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
283 NASA 2 Marshall Space Flight Center Public EM Impact Testing Facility 4571, 4612 2005.0 Active NaN 2006-08-04 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
293 NASA 2 Marshall Space Flight Center Public EM-20 Backscatter Radiography Facility 4711/4707 2002.0 Active NaN 2006-08-04 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
295 NASA 2 Marshall Space Flight Center Public EM-20 Digital X-ray Laminography 4711 2006.0 Active NaN 2006-08-04 2014-06-02 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
300 NASA 2 Marshall Space Flight Center Public EM-20 Terahertz Imaging Facility 4711 2003.0 Active NaN 2006-08-04 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795
350 NASA 2 Marshall Space Flight Center Public Propulsion Research and Development Laboratory 2005.0 Active NaN 2006-08-10 2014-03-31 00:00:00 MARSHALL SPACE FLIGHT CENTER MSFC AL 35812 US Roslin HIcks AS21/4250 256-544-7795

In [41]:
year00['Occupied'].value_counts()


Out[41]:
2005.0    2
2006.0    1
2003.0    1
2002.0    1
Name: Occupied, dtype: int64

In [42]:
print("There are", year00['Occupied'].value_counts().sum(), "Lab facilities started between 2000-2009")


There are 5 Lab facilities started between 2000-2009

In [43]:
year10 = df[(df['Occupied'] >= 2010) & (df['Occupied'] <=2017)]
year10


Out[43]:
Agency Center Center Search Status Facility Occupied Status URL Link Record Date Last Update Address City State ZIP Country Contact Mail Stop Phone
37 NASA 2 Ames Research Center Public DYNAVAC THERMAL VACUUM CHAMBER 2010.0 Active http://www.nasa.gov/centers/ames/research/tech... 2014-10-29 2014-10-29 00:00:00 Code RC Moffett Field CA 94035 US Rocci Caringello 213-1 650 603-9506
164 NASA 2 Johnson Space Center Public General Vibration Lab (GVL) 2012.0 Active http://www.nasa.gov/centers/johnson/pdf/639503... 2010-07-08 2012-09-26 00:00:00 2101 NASA Parkway Houston TX 77058 US Charles Noel JP 281.483.3219

In [44]:
year10['Occupied'].value_counts()


Out[44]:
2010.0    1
2012.0    1
Name: Occupied, dtype: int64

In [45]:
year10['Facility']


Out[45]:
37     DYNAVAC THERMAL VACUUM CHAMBER
164       General Vibration Lab (GVL)
Name: Facility, dtype: object

In [46]:
print("There are only", year10['Occupied'].value_counts().sum(), "Lab facilities started since 2010")


There are only 2 Lab facilities started since 2010

Graph 1 - NASA Lab Center Distribution in Different States


In [84]:
df['State'].value_counts().plot(kind='bar', x='State')


Out[84]:
<matplotlib.axes._subplots.AxesSubplot at 0x752d310>

Graph 2 NASA Lab Facilities Distribution by Agencies


In [26]:
df['Agency'].value_counts().plot(kind='bar', x='Agency')


Out[26]:
<matplotlib.axes._subplots.AxesSubplot at 0x63bc4b0>

Graph 3 NASA Lab Facilities Started Over the Last 60 Years


In [68]:
df = pd.read_excel("year-num-nasa.xlsx")

In [69]:
df


Out[69]:
Year Number
0 1960-69 152
1 1970 – 79 21
2 1980 – 89 30
3 1990 – 99 33
4 2000 – 09 5
5 2010 – 1016 2

In [70]:
df['Number'].plot(kind='pie', labels=df['Year'])


Out[70]:
<matplotlib.axes._subplots.AxesSubplot at 0x46941d0>

In [ ]: