13MINING TEXT TO FIND MEANINGFUL DATA
Although it might not be obvious at first glance, you can extract data and even quantify data from text in speeches, reports, press releases, and other documents. Even though most text exists as unstructured or semi-structured data, which is not organized in rows and columns, as in a table, you can use SQL to derive meaning from it.
One way to do this is to transform the text into structured data. You search for and extract elements such as dates or codes from the text, load them into a table, and analyze them. Another way to find meaning from textual data is to use advanced text analysis features, such as ...
Get Practical SQL 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.
