14 Mining Text to Find Meaningful Data
Next, you’ll learn how to use SQL to transform, search, and analyze text. You’ll start with simple text wrangling using string formatting and pattern matching before moving on to more advanced analysis. We’ll use two data-sets: a small collection of crime reports from a sheriff’s department near Washington, DC, and a set of speeches delivered by US presidents.
Text offers plenty of possibilities for analysis. You can extract meaning from unstructured data—paragraphs of text in speeches, reports, press releases, and other documents—by transforming it into structured data, in rows and columns in a table. ...
Get Practical SQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
