Databricks: Convert Unstructured data into Structured data in 2 minutes.

If you think it's clickbait, it's Definitely Not. Read the article to find out how.

Image by Grok

If you need to extract data from the following statements, you need to tokenize them, then try with NLP and Reg Expressions on them.

From 2007 to 2019, Jim Parsons brought to life the eccentric physicist Sheldon Cooper during The Big Bang Theory’s 12-season run.

Jerry Seinfeld pulled double duty — starring as a fictional version of himself and creating the iconic sitcom Seinfeld, which entertained audiences across 9 seasons until its finale in 1998.

For a decade starting 1994, millions tuned in to watch Courteney Cox portray the perfectionist chef Monica Geller, as Friends became a cultural phenomenon over its 10 seasons.

Everybody Loves Raymond ran until 2005, with Ray Romano headlining as Ray Barone in this family comedy that kept audiences laughing for 9 seasons after its 1996 debut.

Over 8 hilarious seasons at the 99th precinct, Andy Samberg’s Jake Peralta evolved from an immature detective to a seasoned sergeant, as Brooklyn Nine-Nine entertained viewers from 2013 to 2021.

The Mother of Dragons came to life through Emilia Clarke’s portrayal of Daenerys Targaryen in HBO’s epic fantasy Game of Thrones, which dominated television for 8 seasons between 2011 and 2019.

The same can be done in one SQL Query.

create or replace table gannychan.rawdata.unstructured_data (comment string);

insert into gannychan.rawdata.unstructured_data values 
('From 2007 to 2019, Jim Parsons brought to life the eccentric physicist Sheldon Cooper during The Big Bang Theory 12-season run.'),
('Jerry Seinfeld pulled double duty - starring as a fictional version of himself and creating the iconic sitcom Seinfeld, which entertained audiences across 9 seasons until its finale in 1998.'),
('For a decade starting 1994, millions tuned in to watch Courteney Cox portray the perfectionist chef Monica Geller, as Friends became a cultural phenomenon over its 10 seasons.'),
('Everybody Loves Raymond ran until 2005, with Ray Romano headlining as Ray Barone in this family comedy that kept audiences laughing for 9 seasons after its…