ChatGPT Data Extraction: A quick demonstration

I demonstration of how to use ChatGPT to extract data from text documents. I run through the various ways to perform AI powered structured data extraction, show some tricks I learned, explain where it falls short and how this applies to data journalism.

[ianmatiello]

I have no words how to thank you.

I'm a Brazilian lawyer and for months, maybe even more than a year, I've been looking for ways to automate boring repetitive and analogue tasks in my work, which only waste my time, with my limited programming knowledge (almost zero).

You were the first to teach a method that is easily understandable and applicable to those who don't have much knowledge in programming, and, most importantly, it is useful.

I work in a Union, and here there is a culture almost against technology, but perhaps it is due to ignorance of its possibilities than anything else.

To give you an idea, we calculate how much a union member has to receive in a lawsuit.

The information is contained in a financial statement provided by the City Hall.

Until then, the calculation is done "by hand", that is, reading the information from the table and manually entering it into an Excel spreadsheet, which, for each calculation, takes around one or two hours.

[Back_at_Bardot]

❤ finally been searching for content on this sort of topics

[biraescudero]

Great! I usually have this kind of problem and your approach is very good! Thanks for sharing!

[mookfaru]

Have you tried to work with chatgpt through the API? I have heard it does not have a upper limit on the amount of work it can do. Just as much as you can pay.

[retrogamingplayback]

Don't forget on long outputs, typing "continue" is your friend. It should resume where it left off.

[TheHavyxon]

Do you think that the police reports are intentionally written so they are this difficult to read specifically because of data extraction?

[andre-le-bone-aparte]

Excellent Content - Another sub for you sir!

[sarahbratt]

Awesome video! Could you link to PDF Plumber?

[ainru]

I guess the occasional mistakes might have been caused by the temperature set too high (unfortunately, I don't know how to change it in the ChatGPT interface because I don't use it)