NASA Home Page Goddard Space Flight Center Home Page
NASA Logo - Goddard Space Flight Center   + Visit NASA.gov
a directory of Earth science data and services Global Change Master Directory Web site
header 2 bullet Links bullet FAQ bullet Contact Us bullet Site Map
Home Data Sets Data Services Learn about GCMD_legacy's portal collaborations. Add new dataset or dataservice records to GCMD_legacy What's New Participate Calendar About GCMD_legacy
 

Data Wrangler - An Interactive Tool for Data Cleaning and Transformation
Entry ID: STANFORD_VIS_WRANGLER
[ Get Service ]
[ Update this Record ]


Summary
Abstract: Though data analysis tools continue to improve, analysts still expend an inordinate amount of time and effort manipulating data and assessing data quality issues. Such "data wrangling" regularly involves reformatting data values or layout, correcting erroneous or missing values, and integrating multiple data sources. These transforms are often difficult to specify and difficult to reuse across analysis tasks, teams, and tools. In response, we introduce Wrangler, an interactive system for creating data transformations. Wrangler combines direct manipulation of visualized data with automatic inference of relevant transforms, enabling analysts to iteratively explore the space of applicable operations and preview their effects. Wrangler leverages semantic data types (e.g., geographic locations, dates, classification codes) to aid validation and type conversion. Interactive histories support review, refinement, and annotation of transformation scripts. User study results show that Wrangler significantly reduces specification time and promotes the use of robust, auditable transforms instead of manual editing.

[Summary provided by Stanford University.]

Related URL
Link: GET SERVICE
Description: Access Data Wrangler.

Link: VIEW RELATED INFORMATION
Description: Access the Data Wrangler research paper.
Service Citation
Originators: Sean Kandel, Andreas Paepcke, Joseph Hellerstein, Jeffrey Heer
Title: Data Wrangler - An Interactive Tool for Data Cleaning and Transformation
Release_Date: 2011
Provider: Stanford University
URL: http://vis.stanford.edu/papers/wrangler
Science Keywords
AGRICULTURE >AGRICULTURAL AQUATIC SCIENCES   [Definition]
AGRICULTURE >AGRICULTURAL CHEMICALS   [Definition]
AGRICULTURE >AGRICULTURAL ENGINEERING   [Definition]
AGRICULTURE >AGRICULTURAL PLANT SCIENCE   [Definition]
AGRICULTURE >ANIMAL COMMODITIES   [Definition]
AGRICULTURE >ANIMAL SCIENCE   [Definition]
AGRICULTURE >FEED PRODUCTS   [Definition]
AGRICULTURE >FOOD SCIENCE   [Definition]
AGRICULTURE >FOREST SCIENCE   [Definition]
AGRICULTURE >PLANT COMMODITIES   [Definition]
AGRICULTURE >SOILS   [Definition]
ATMOSPHERE >AEROSOLS   [Definition]
ATMOSPHERE >AIR QUALITY   [Definition]
ATMOSPHERE >ALTITUDE   [Definition]
ATMOSPHERE >ATMOSPHERIC CHEMISTRY   [Definition]
ATMOSPHERE >ATMOSPHERIC ELECTRICITY   [Definition]
ATMOSPHERE >ATMOSPHERIC PHENOMENA   [Definition]
ATMOSPHERE >ATMOSPHERIC TEMPERATURE   [Definition]
ATMOSPHERE >ATMOSPHERIC WATER VAPOR   [Definition]
ATMOSPHERE >ATMOSPHERIC WINDS   [Definition]
ATMOSPHERE >CLOUDS   [Definition]
ATMOSPHERE >PRECIPITATION   [Definition]
ATMOSPHERE >ATMOSPHERIC RADIATION   [Definition]
BIOSPHERE >ECOLOGICAL DYNAMICS   [Definition]
BIOSPHERE >TERRESTRIAL ECOSYSTEMS   [Definition]
BIOSPHERE >VEGETATION   [Definition]
CRYOSPHERE >SEA ICE   [Definition]
CRYOSPHERE >SNOW/ICE   [Definition]
HUMAN DIMENSIONS >SOCIAL BEHAVIOR   [Definition]
HUMAN DIMENSIONS >BOUNDARIES   [Definition]
HUMAN DIMENSIONS >ECONOMIC RESOURCES   [Definition]
HUMAN DIMENSIONS >ENVIRONMENTAL IMPACTS   [Definition]
HUMAN DIMENSIONS >PUBLIC HEALTH   [Definition]
HUMAN DIMENSIONS >INFRASTRUCTURE   [Definition]
HUMAN DIMENSIONS >ENVIRONMENTAL GOVERNANCE/MANAGEMENT >LAND MANAGEMENT >LAND USE/LAND COVER CLASSIFICATION   [Definition]
HUMAN DIMENSIONS >NATURAL HAZARDS   [Definition]
HUMAN DIMENSIONS >POPULATION   [Definition]
TERRESTRIAL HYDROSPHERE >GROUND WATER   [Definition]
TERRESTRIAL HYDROSPHERE >SNOW/ICE   [Definition]
TERRESTRIAL HYDROSPHERE >SURFACE WATER   [Definition]
TERRESTRIAL HYDROSPHERE >WATER QUALITY/WATER CHEMISTRY   [Definition]
LAND SURFACE >EROSION/SEDIMENTATION   [Definition]
LAND SURFACE >GEOMORPHOLOGY   [Definition]
LAND SURFACE >LAND TEMPERATURE   [Definition]
LAND SURFACE >LAND USE/LAND COVER   [Definition]
LAND SURFACE >LANDSCAPE   [Definition]
LAND SURFACE >SOILS   [Definition]
LAND SURFACE >SURFACE RADIATIVE PROPERTIES   [Definition]
LAND SURFACE >TOPOGRAPHY   [Definition]
OCEANS >BATHYMETRY/SEAFLOOR TOPOGRAPHY   [Definition]
OCEANS >COASTAL PROCESSES   [Definition]
OCEANS >MARINE ENVIRONMENT MONITORING   [Definition]
OCEANS >MARINE GEOPHYSICS   [Definition]
OCEANS >MARINE SEDIMENTS   [Definition]
OCEANS >OCEAN ACOUSTICS   [Definition]
OCEANS >OCEAN CHEMISTRY   [Definition]
OCEANS >OCEAN CIRCULATION   [Definition]
OCEANS >OCEAN HEAT BUDGET   [Definition]
OCEANS >OCEAN OPTICS   [Definition]
OCEANS >OCEAN PRESSURE   [Definition]
OCEANS >OCEAN TEMPERATURE   [Definition]
OCEANS >OCEAN WAVES   [Definition]
OCEANS >OCEAN WINDS   [Definition]
OCEANS >SALINITY/DENSITY   [Definition]
OCEANS >SEA ICE   [Definition]
OCEANS >TIDES   [Definition]
OCEANS >WATER QUALITY   [Definition]
PALEOCLIMATE >ICE CORE RECORDS   [Definition]
PALEOCLIMATE >LAND RECORDS   [Definition]
PALEOCLIMATE >OCEAN/LAKE RECORDS   [Definition]
SPECTRAL/ENGINEERING >INFRARED WAVELENGTHS   [Definition]
SPECTRAL/ENGINEERING >MICROWAVE   [Definition]
SPECTRAL/ENGINEERING >PLATFORM CHARACTERISTICS   [Definition]
SPECTRAL/ENGINEERING >RADAR   [Definition]
SPECTRAL/ENGINEERING >SENSOR CHARACTERISTICS   [Definition]
SPECTRAL/ENGINEERING >ULTRAVIOLET WAVELENGTHS   [Definition]
SPECTRAL/ENGINEERING >VISIBLE WAVELENGTHS   [Definition]
SUN-EARTH INTERACTIONS >SOLAR ACTIVITY   [Definition]
SOLID EARTH >GEOCHEMISTRY   [Definition]
SOLID EARTH >GRAVITY/GRAVITATIONAL FIELD   [Definition]
SOLID EARTH >GEOMAGNETISM   [Definition]
SOLID EARTH >GEOMORPHIC LANDFORMS/PROCESSES   [Definition]
SOLID EARTH >GEOTHERMAL DYNAMICS   [Definition]
SOLID EARTH >EARTH GASES/LIQUIDS   [Definition]
SOLID EARTH >ROCKS/MINERALS/CRYSTALS   [Definition]
SOLID EARTH >TECTONICS >EARTHQUAKES   [Definition]
SOLID EARTH >TECTONICS   [Definition]
SOLID EARTH >TECTONICS >VOLCANIC ACTIVITY   [Definition]
OCEANS >SEA SURFACE TOPOGRAPHY   [Definition]
OCEANS >MARINE VOLCANISM   [Definition]
ATMOSPHERE >ATMOSPHERIC PRESSURE   [Definition]
SPECTRAL/ENGINEERING >GAMMA RAY   [Definition]
SPECTRAL/ENGINEERING >RADIO WAVE   [Definition]
CRYOSPHERE >FROZEN GROUND   [Definition]
LAND SURFACE >FROZEN GROUND   [Definition]
OCEANS >AQUATIC SCIENCES   [Definition]
CLIMATE INDICATORS >ATMOSPHERIC/OCEAN INDICATORS >HUMIDITY INDICES   [Definition]
CLIMATE INDICATORS >ATMOSPHERIC/OCEAN INDICATORS >TELECONNECTIONS   [Definition]
SPECTRAL/ENGINEERING >X-RAY   [Definition]
CRYOSPHERE >GLACIERS/ICE SHEETS   [Definition]
TERRESTRIAL HYDROSPHERE >GLACIERS/ICE SHEETS   [Definition]
HUMAN DIMENSIONS >HABITAT CONVERSION/FRAGMENTATION   [Definition]
PALEOCLIMATE >PALEOCLIMATE RECONSTRUCTIONS   [Definition]
SUN-EARTH INTERACTIONS >IONOSPHERE/MAGNETOSPHERE DYNAMICS   [Definition]
SUN-EARTH INTERACTIONS >SOLAR ENERGETIC PARTICLE FLUX   [Definition]
SUN-EARTH INTERACTIONS >SOLAR ENERGETIC PARTICLE PROPERTIES
BIOLOGICAL CLASSIFICATION >ANIMALS/VERTEBRATES   [Definition]
BIOLOGICAL CLASSIFICATION >ANIMALS/INVERTEBRATES   [Definition]
BIOLOGICAL CLASSIFICATION >PROTISTS   [Definition]
BIOLOGICAL CLASSIFICATION >BACTERIA/ARCHAEA   [Definition]
BIOLOGICAL CLASSIFICATION >FUNGI   [Definition]
BIOLOGICAL CLASSIFICATION >PLANTS   [Definition]
BIOLOGICAL CLASSIFICATION >VIRUSES
BIOSPHERE >AQUATIC ECOSYSTEMS   [Definition]
SPECTRAL/ENGINEERING >LIDAR   [Definition]
ISO Topic Category
FARMING
BIOTA
BOUNDARIES
CLIMATOLOGY/METEOROLOGY/ATMOSPHERE
ECONOMY
ELEVATION
ENVIRONMENT
GEOSCIENTIFIC INFORMATION
HEALTH
IMAGERY/BASE MAPS/EARTH COVER
INLAND WATERS
OCEANS
PLANNING CADASTRE
SOCIETY
STRUCTURE
TRANSPORTATION
UTILITIES/COMMUNICATIONS
Access Constraints
None
Service Provider
Human-Computer Interaction & Visualization Group, Computer Science Department, Stanford University

Service Provider Personnel
Name: JEFFREY MICHAEL HEER
Phone: 650-723-0033
Email: jheer at cs.stanford.edu
Contact Address:
375 Gates Hall (3B Wing)
City: Stanford
Province or State: CA
Postal Code: 94305-9035
Country: USA
Distribution Media
Distribution_Media: Online
Fees: No fees
Personnel
JEFFREY MICHAEL HEER
Role: TECHNICAL CONTACT
Phone: 650-723-0033
Email: jheer at cs.stanford.edu
Contact Address:
375 Gates Hall (3B Wing)
City: Stanford
Province or State: CA
Postal Code: 94305-9035
Country: USA

TYLER B. STEVENS
Role: SERF AUTHOR
Phone: (301) 614-6898
Fax: 301-614-5268
Email: Tyler.B.Stevens at nasa.gov
Contact Address:
NASA Goddard Space Flight Center
Global Change Master Directory
City: Greenbelt
Province or State: MD
Postal Code: 20771
Country: USA
Creation and Review Dates
SERF Creation Date: 2011-06-02
SERF Last Revision Date: 2011-06-06
[ Update this Record ]
USA dot gov - The U.S. Government's Official Web Portal NASA
Webmaster:  Monica Holland
Responsible NASA Official:  Lola Olsen
Last Updated:  April 2014