Vaex: Big Data exploration in the era of Gaia
arXiv:1801.02638 · doi:10.1051/0004-6361/201732493
Abstract
We present a new Python library called vaex, to handle extremely large tabular datasets, such as astronomical catalogues like the Gaia catalogue, N-body simulations or any other regular datasets which can be structured in rows and columns. Fast computations of statistics on regular N-dimensional grids allows analysis and visualization in the order of a billion rows per second. We use streaming algorithms, memory mapped files and a zero memory copy policy to allow exploration of datasets larger than memory, e.g. out-of-core algorithms. Vaex allows arbitrary (mathematical) transformations using normal Python expressions and (a subset of) numpy functions which are lazily evaluated and computed when needed in small chunks, which avoids wasting of RAM. Boolean expressions (which are also lazily evaluated) can be used to explore subsets of the data, which we call selections. Vaex uses a similar DataFrame API as Pandas, a very popular library, which helps migration from Pandas. Visualization is one of the key points of vaex, and is done using binned statistics in 1d (e.g. histogram), in 2d (e.g. 2d histograms with colormapping) and 3d (using volume rendering). Vaex is split in in several packages: vaex-core for the computational part, vaex-viz for visualization mostly based on matplotlib, vaex-jupyter for visualization in the Jupyter notebook/lab based in IPyWidgets, vaex-server for the (optional) client-server communication, vaex-ui for the Qt based interface, vaex-hdf5 for hdf5 based memory mapped storage, vaex-astro for astronomy related selections, transformations and memory mapped (column based) fits storage. Vaex is open source and available under MIT license on github, documentation and other information can be found on the main website: https://vaex.io, https://docs.vaex.io or https://github.com/maartenbreddels/vaex
arXiv comment14 pages, 8 figures, Submitted to A&A, interactive version of Fig 4: https://vaex.io/paper/fig4
References in corpus (7)
- XGBoost: A Scalable Tree Boosting System
- Astropy: A Community Python Package for Astronomy
- Gaia Data Release 1. Summary of the astrometric, photometric, and survey properties
- The Aquarius Project: the subhalos of galactic halos
- Mapping the substructure in the Galactic halo with the next generation of astrometric satellites
- Principles of High-Dimensional Data Visualization in Astronomy
- Gaia Data Release 1: The archive visualisation service
Cited by in corpus (52)
- Gaia Data Release 3: Summary of the content and survey properties
- Estimating distances from parallaxes. V: Geometric and photogeometric distances to 1.47 billion stars in Gaia Early Data Release 3
- Gaia Data Release 3: Stellar multiplicity, a teaser for the hidden treasure
- Multiple retrograde substructures in the Galactic halo: A shattered view of Galactic history
- Gaia Data Release 3: Astrophysical parameters inference system (Apsis) I -- methods and content overview
- Gaia Data Release 3: Apsis II -- Stellar Parameters
- Characterization and history of the Helmi streams with Gaia DR2
- Discovery of a dormant 33 solar-mass black hole in pre-release Gaia astrometry
- The Panchromatic Hubble Andromeda Treasury: Triangulum Extended Region (PHATTER) I. Ultraviolet to Infrared Photometry of 22 Million Stars in M33
- The Gaia DR3 view of dynamical substructure in the stellar halo near the Sun
- A massive mess: When a large dwarf and a Milky Way-like galaxy merge
- A search of the full six years of the Dark Energy Survey for outer Solar System objects
- Gaia Data Release 3: Reflectance spectra of Solar System small bodies
- Substructure in the stellar halo near the Sun. II. Characterisation of independent structures
- Substructure in the stellar halo near the Sun. I. Data-driven clustering in Integrals of Motion space
- Gaia Data Release 3: A Golden Sample of Astrophysical Parameters
- Determination of the escape velocity of the Milky Way using a proper motion selected halo sample
- Age Determination of Galaxy Merger Remnant Stars using Asteroseismology
- The 33 M black hole Gaia BH3 is part of the disrupted ED-2 star cluster
- Astrophysical Parameters from Gaia DR2, 2MASS & AllWISE
- MCR-TRGB: A Multiwavelength-Covariant, Robust Tip of the Red Giant Branch Measurement Method
- Hunting for C-rich long-period variable stars in the Milky Way's bar-bulge using unsupervised classification of Gaia BP/RP spectra
- Gaia Focused Product Release: Asteroid orbital solution. Properties and assessment
- The tilt of the velocity ellipsoid in the Milky Way with Gaia DR2
- ED-2: a cold but not so narrow stellar stream crossing the Solar neighbourhood
- Linking nearby stellar streams to more distant halo overdensities
- Unveiling the past evolution of the progenitor of the Helmi streams
- Gaia Focused Product Release: Sources from Service Interface Function image analysis -- Half a million new sources in omega Centauri
- Gaia's brightest very metal-poor (VMP) stars. Metallicity catalogue of a thousand VMP stars from Gaia's radial velocity spectrometer spectra
- On the Galactic rotation curve inferred from the Jeans equations Assessing its robustness using Gaia DR3 and cosmological simulations
- An analytical model of turbulence in Parker spiral geometry and associated magnetic field line lengths
- Evidence for C and Mg variations in the GD-1 stellar stream
- Frequencies, chaos and resonances: a study of orbital parameters of nearby thick disc and halo stars
- Characterisation of local halo building blocks: Thamnos and Sequoia
- The Pristine survey: XXV. The very metal-poor Galaxy: Chemodynamics through the follow-up of the Pristine-Gaia synthetic catalogue
- The Reduced Proper Motion selected halo: methods and description of the catalogue
- Characterization and dynamics of the peculiar stream Jhelum, A tentative role for the Sagittarius dwarf galaxy
- Hidden deep in the halo: selection of a reduced proper motion halo catalogue and mining retrograde streams in the velocity space
- Time evolution of gaps in stellar streams in axisymmetric Stäckel potentials
- Firefly: a browser-based interactive 3D data visualization tool for millions of data points
- On the chaos induced by the Galactic bar on the orbits of nearby halo stars
- Gaia Focused Product Release: A catalogue of sources around quasars to search for strongly lensed quasars
- A Pristine-UNIONS view on the Galaxy: Kinematics of the distant spur feature of the Sagittarius stream traced by Blue Horizontal Branch stars
- RGB photometric calibration of 15 million Gaia stars
- First measurement of the triaxiality of the inner dark matter halo of the Milky Way
- GaiaUnlimited: The old stellar disc of the Milky Way as traced by the Red Clump
- The Pristine survey XXVIII. Journey to the Galactic outskirts: Mapping the outer halo red giant stars down to the very metal-poor end
- Differentiable Modeling of Planet and Substellar Atmosphere: High-Resolution Emission, Transmission, and Reflection Spectroscopy with ExoJAX2
- A slow spin to win: The gradual kinematic evolution across metallicities of the proto-Galaxy to the high- disc
- Photometric Catalogue for Space and Ground Night-Time Remote-Sensing Calibration: RGB Synthetic Photometry from Gaia DR3 Spectrophotometry
- DIETERpy: a Python framework for The Dispatch and Investment Evaluation Tool with Endogenous Renewables
- Testing MOND using the dynamics of nearby stellar streams