Ekstraksi jawaban

Pengantar Generative AI di Snowflake

James Cha-Earley

Senior Developer Advocate, Snowflake

Mengapa menggunakan ekstraksi jawaban?

$$

  • Mengidentifikasi keluhan
  • Mengekstrak masukan tentang fasilitas
  • Menjawab pertanyaan dari dokumen panjang

Sebuah dokumen dengan tanda tanya dikelilingi emoji wajah senyum atau sedih, melambangkan bahwa kita tidak tahu tiap ulasan membahas apa

Pengantar Generative AI di Snowflake

Masalah bisnis umum

review = """
The property needs updating and management needs to hire more staff. 
The staff does everything they can but it is not enough for the number of guests. 
The rooms look old as well as everything in the bathrooms. 
Definitely better options in the hotel zone.
"""
  • Snowflake Cortex siap membantu!
Pengantar Generative AI di Snowflake

Mengekstrak jawaban

from snowflake.cortex import extract_answer

response = extract_answer( from_text=review, question="What did the guest complain about?" )
Pengantar Generative AI di Snowflake

Keluaran

print(response)
[
    {
    "answer": "Management needs to hire more staff.",
    "score": 0.8013839254
    }
]
  • Skor berkisar dari 0 hingga 1
Pengantar Generative AI di Snowflake

Membangun alur kerja

SELECT DESCRIPTION
FROM HOTELS.REVIEWS
WHERE RATING < 6
    AND DATE = '2023-08-23';
Pengantar Generative AI di Snowflake

Keluaran SQL

I will never book a vacation through Expedia not only did I pay over 5;000 dollars
but they false advertise the resort; in my reservation It clearly stated that
breakfast and dinner was included. When I got to the resort they informed me that 
these issues have happed before with Expedia because the resort does not offer an
all exclusive. After flighting practically all day I called Expedia and they had me
on hold for 45min and nothing got resolved. I ended up spending over 1000.00 more
just on food. I am beyond me they are not only false advertising but refused to
take any responsibility on their part for the issues they caused me and my family.  Again I will never chose Expedia to plan a vacation!!!
Pengantar Generative AI di Snowflake

Mengajukan pertanyaan

negative_review = dataframe_1.to_pandas()['DESCRIPTION'].iloc[0]

response = extract_answer( from_text=negative_review, question="What was the primary issue that the guest mentioned?" ) print(response)
Pengantar Generative AI di Snowflake

Meninjau respons

[
    {
    "answer" : "Expedia falsely advertised that meals were included, but the
                resort did not offer an all-inclusive package.",
    "score": 0.75829312442
    }
]
Pengantar Generative AI di Snowflake

Keterbatasan

$$

  • Dapat mengembalikan frasa parsial atau samar
  • Paling baik untuk paragraf, bukan dokumen multi-topik
  • Selalu tinjau keluaran yang kritis

Tanda peringatan

Pengantar Generative AI di Snowflake

Ayo berlatih!

Pengantar Generative AI di Snowflake

Preparing Video For Download...