Techno Blender
Digitally Yours.
Browsing Tag

Measuring

Measuring string similarity in BigQuery using SQL | by Romain Granger | Jun, 2022

Use Levenshtein distance to discover similar or duplicated values, clean your data, and more!Photo by Suraj Kardile on UnsplashUsing the Levenshtein distance methodThis method can be used among others (Soundex, LIKE statement, Regexp) to perform string similarity or string matching in order to identify two elements (text, strings, inputs) that are similar but not identical.This method can be used for a variety of applications, including identifying duplicates, handling misspelled user input data, cleaning customer data,…

New Image of Mars Reveals a Crater Eerily Similar to a Huge, Creepy Eye

A new image snapped by a spacecraft orbiting Mars could be enough to give one Lovecraftian nightmares.Far below the camera of ESA's Mars Express, a large, city-sized, unnamed crater gapes on the surface of the red planet, smears of dark material making it appear like an enormous eye gazing out to the stars. Yet the purpose of the image is not to give you the cosmic shivers; satellite imagery can help us better understand the geology and history of Mars.  The crater, measuring 30 kilometers (18.6 miles) across, sits in a…

Measuring the Age and Size of the Universe

Spiral galaxy NGC 4603 containing Cepheids being used for distance measurements. Credit: ESA/Hubble & NASA, J. MaundThe search for CepheidsThe top-ranked scientific justification for building the <span class="glossaryLink" aria-describedby="tt" data-cmtooltip="<div class=glossaryItemTitle>Hubble Space Telescope</div><div class=glossaryItemBody>The Hubble Space Telescope (often referred to as Hubble or HST) is one of NASA's Great Observatories and was launched into low…

Measuring the “Wettability” of Graphene and Other 2D Materials at the Molecular Level

Water contact angle measurements of graphene give information about macroscopic wettability. On the other hand, the VSFG experiment can provide information about the microscopic structure of interfacial water and the wettability of graphene. Credit: Institute for Basic ScienceMicroscopic measurement of wettability can be achieved at the molecular level using ‘vibrational sum-frequency generation spectroscopy’ (VSFG).Wettability of the material is the ability of a liquid to maintain contact with a solid surface, and it is…