chet / app.py
Sangwon78's picture
Update app.py
d58afa8 verified
Raw History Blame Contribute Delete
6.76 kB
import os
import pandas as pd
import gradio as gr
from datetime import datetime
import openai
##############################################
# [LLM์ž๋ฃŒ] - gpt-4o-mini ๋ชจ๋ธ์„ ํ™œ์šฉํ•œ ํ•จ์ˆ˜
##############################################
openai.api_key = os.getenv("OPENAI_API_KEY") # ํ† ํฐ ์ˆจ๊น€
def call_api(content, system_message="๋‹น์‹ ์€ ๋ฆฌ๋ทฐ ๋ถ„์„์„ ๋•๋Š” AI์ž…๋‹ˆ๋‹ค.", max_tokens=500, temperature=0.7, top_p=1.0):
response = openai.ChatCompletion.create(
model="gpt-4o-mini", # ๋ฐ˜๋“œ์‹œ gpt-4o-mini ๋ชจ๋ธ ์‚ฌ์šฉ
messages=[
{"role": "system", "content": system_message},
{"role": "user", "content": content},
],
max_tokens=max_tokens,
temperature=temperature,
top_p=top_p,
)
return response.choices[0].message['content']
##############################################
# [๊ธฐ๋ณธ์ฝ”๋“œ] (์ ˆ๋Œ€ ์ˆ˜์ • / ์‚ญ์ œ / ๋ณ€๊ฒฝ ๊ธˆ์ง€)
##############################################
def read_excel_data(file):
df = pd.read_excel(file, usecols="A, B, C, D, E", skiprows=1,
names=["ID", "Review Date", "Option", "Review", "ReviewScore"], engine='openpyxl')
df['Review Date'] = pd.to_datetime(df['Review Date']).dt.tz_localize(None).dt.date
df['Year'] = df['Review Date'].astype(str).str.slice(0, 4)
df['Option1'] = df['Option'].astype(str).str.split(" / ").str[0]
df['Review Length'] = df['Review'].str.len()
return df
def get_positive_reviews(df):
positive_reviews = df[df['ReviewScore'] >= 4].sort_values(by='Review Length', ascending=False)
positive_reviews = positive_reviews.head(20)
positive_reviews.reset_index(drop=True, inplace=True)
positive_reviews.index += 1
positive_reviews['์ˆœ๋ฒˆ'] = positive_reviews.index
positive_output = "\n\n".join(positive_reviews.apply(
lambda x: f"{x['์ˆœ๋ฒˆ']}. **{x['Review Date']} / {x['ID']} / {x['Option']}**\n\n{x['Review']}", axis=1))
return positive_output
def get_negative_reviews(df):
negative_reviews = df[df['ReviewScore'] <= 2].sort_values(by='Review Length', ascending=False)
negative_reviews = negative_reviews.head(30)
negative_reviews.reset_index(drop=True, inplace=True)
negative_reviews.index += 1
negative_reviews['์ˆœ๋ฒˆ'] = negative_reviews.index
negative_output = "\n\n".join(negative_reviews.apply(
lambda x: f"{x['์ˆœ๋ฒˆ']}. **{x['Review Date']} / {x['ID']} / {x['Option']}**\n\n{x['Review']}", axis=1))
return negative_output
def process_reviews(file):
df = read_excel_data(file)
positive_reviews = get_positive_reviews(df)
negative_reviews = get_negative_reviews(df)
return positive_reviews, negative_reviews
def analyze_reviews(positive_reviews, negative_reviews):
positive_analysis_prompt = (
f"๋‹ค์Œ์€ ๊ธ์ • ๋ฆฌ๋ทฐ ๋ชฉ๋ก์ž…๋‹ˆ๋‹ค:\n\n{positive_reviews}\n\n"
"์œ„ ๋ฆฌ๋ทฐ๋“ค์— ๋Œ€ํ•œ ์š”์•ฝ ๋ฐ ๋ถ„์„์„ ํ•ด์ฃผ์„ธ์š”."
)
positive_analysis_result = call_api(positive_analysis_prompt)
negative_analysis_prompt = (
f"๋‹ค์Œ์€ ๋ถ€์ • ๋ฆฌ๋ทฐ ๋ชฉ๋ก์ž…๋‹ˆ๋‹ค:\n\n{negative_reviews}\n\n"
"์œ„ ๋ฆฌ๋ทฐ๋“ค์— ๋Œ€ํ•œ ์š”์•ฝ ๋ฐ ๋ถ„์„์„ ํ•ด์ฃผ์„ธ์š”."
)
negative_analysis_result = call_api(negative_analysis_prompt)
return positive_analysis_result, negative_analysis_result
def create_interface():
with gr.Blocks() as demo:
gr.Markdown("### ๋ฆฌ๋ทฐ ๋ฐ์ดํ„ฐ ์—…๋กœ๋“œ")
file_input = gr.File(label="์—‘์…€ ํŒŒ์ผ ์—…๋กœ๋“œ", file_types=[".xlsx"])
analyze_button = gr.Button("๋ฆฌ๋ทฐ๋ถ„์„")
with gr.Column():
gr.Markdown("### ๊ธ์ •์ ์ธ ์ฃผ์š” ๋ฆฌ๋ทฐ (์ตœ๋Œ€ 20๊ฐœ)")
positive_reviews_output = gr.Textbox(label="๊ธ์ •์ ์ธ ์ฃผ์š” ๋ฆฌ๋ทฐ", interactive=False, lines=20)
gr.Markdown("### ๋ถ€์ •์ ์ธ ์ฃผ์š” ๋ฆฌ๋ทฐ (์ตœ๋Œ€ 30๊ฐœ)")
negative_reviews_output = gr.Textbox(label="๋ถ€์ •์ ์ธ ์ฃผ์š” ๋ฆฌ๋ทฐ", interactive=False, lines=30)
gr.Markdown("### ๊ธ์ • ๋ฆฌ๋ทฐ ๋ถ„์„๊ฒฐ๊ณผ")
positive_analysis_output = gr.Textbox(label="๊ธ์ • ๋ฆฌ๋ทฐ ๋ถ„์„๊ฒฐ๊ณผ", interactive=False, lines=10)
gr.Markdown("### ๋ถ€์ • ๋ฆฌ๋ทฐ ๋ถ„์„๊ฒฐ๊ณผ")
negative_analysis_output = gr.Textbox(label="๋ถ€์ • ๋ฆฌ๋ทฐ ๋ถ„์„๊ฒฐ๊ณผ", interactive=False, lines=10)
# ์ ˆ๋Œ€ ์ˆ˜์ • ๊ธˆ์ง€: ๊ธฐ์กด ์ฒด์ธ
analyze_button.click(
fn=process_reviews,
inputs=[file_input],
outputs=[positive_reviews_output, negative_reviews_output]
).then(
fn=analyze_reviews,
inputs=[positive_reviews_output, negative_reviews_output],
outputs=[positive_analysis_output, negative_analysis_output]
)
######################################################
# [์ถ”๊ฐ€ ์ฝ”๋“œ] - ์—‘์…€ ๋‹ค์šด๋กœ๋“œ ๊ธฐ๋Šฅ
######################################################
download_button = gr.Button("๊ฒฐ๊ณผ ์—‘์…€ ๋‹ค์šด๋กœ๋“œ")
result_file = gr.File(label="๋ถ„์„๊ฒฐ๊ณผ ์—‘์…€ ํŒŒ์ผ(.xlsx)")
def create_excel_file(positive, negative, pos_analysis, neg_analysis):
from io import BytesIO
import xlsxwriter
# ๋ฉ”๋ชจ๋ฆฌ ์ƒ์—์„œ ์—‘์…€ ์ƒ์„ฑ
output = BytesIO()
workbook = xlsxwriter.Workbook(output, {'in_memory': True})
# ์‹œํŠธ 1: ์ฃผ์š” ๋ฆฌ๋ทฐ
ws_reviews = workbook.add_worksheet("์ฃผ์š” ๋ฆฌ๋ทฐ")
ws_reviews.write(0, 0, "๊ธ์ • ๋ฆฌ๋ทฐ")
ws_reviews.write(0, 1, "๋ถ€์ • ๋ฆฌ๋ทฐ")
# ๊ธ์ • ๋ฆฌ๋ทฐ ๋‚ด์šฉ -> row 1๋ถ€ํ„ฐ
positive_lines = positive.split("\n\n")
for i, line in enumerate(positive_lines, start=1):
ws_reviews.write(i, 0, line)
# ๋ถ€์ • ๋ฆฌ๋ทฐ ๋‚ด์šฉ -> row 1๋ถ€ํ„ฐ
negative_lines = negative.split("\n\n")
for j, line in enumerate(negative_lines, start=1):
ws_reviews.write(j, 1, line)
# ์‹œํŠธ 2: ๋ถ„์„ ๊ฒฐ๊ณผ
ws_analysis = workbook.add_worksheet("๋ถ„์„ ๊ฒฐ๊ณผ")
ws_analysis.write(0, 0, "๊ธ์ • ๋ฆฌ๋ทฐ ๋ถ„์„๊ฒฐ๊ณผ")
ws_analysis.write(0, 1, "๋ถ€์ • ๋ฆฌ๋ทฐ ๋ถ„์„๊ฒฐ๊ณผ")
ws_analysis.write(1, 0, pos_analysis)
ws_analysis.write(1, 1, neg_analysis)
workbook.close()
output.seek(0)
return output
download_button.click(
fn=create_excel_file,
inputs=[positive_reviews_output, negative_reviews_output, positive_analysis_output, negative_analysis_output],
outputs=result_file
)
return demo
if __name__ == "__main__":
interface = create_interface()
interface.launch()