Download app.py from Sangwon78/chet: direct link, hf CLI and curl.
- Browser
- Download file 6.76 kB
-
https://huggingface.co/spaces/Sangwon78/chet/resolve/main/app.py
- Command line
-
hf download hf://spaces/Sangwon78/chet/app.py
-
curl -L -o app.py https://huggingface.co/spaces/Sangwon78/chet/resolve/main/app.py
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() | |