Flash Fill and FlashExtract

4 220
22
Опубликовано 6 февраля 2017, 16:36
99% of computer users do not know programming and struggle with repetitive tasks. Programming by Examples (PBE) can revolutionize this landscape by allowing end users to create small scripts from input-output examples. A killer application of this technology today is in the space of data cleaning. Apparently, data scientists spend 80% of their time wrangling with data. In this short video, I will demonstrate the PBE concept using two data preparation features: (i) The Flash Fill feature in Microsoft Excel that allows performing syntactic string transformations from examples. (ii) The FlashExtract technology (available as the ConvertFrom-string cmdlet in Powershell and Custom Logs/Fields feature in Microsoft OMS) that allows parsing custom log files into structured tables by giving examples of various fields.

Speaker Name: Sumit Gulwani
Случайные видео
26.06.22 – 248 8700:58
What is VO2 max? | Xiaomi Academy
06.07.06 – 28 3205:50
Nvidia - "The Nvidia Engine Room"
автотехномузыкадетское