import requests import json import datetime import streamlit as st from itertools import…
- User
import requests import json import datetime import streamlit as st from itertools import zip_longest import os import seaborn as sns import pandas as pd import matplotlib.pyplot as plt
def basic_info(): config = dict() config["access_token"] = st.secrets["access_token"] config['instagram_account_id'] = st.secrets.get("instagram_account_id", "") config["version"] = 'v16.0' config["graph_domain"] = 'https://graph.facebook.com/' config["endpoint_base"] = config["graph_domain"] + config["version"] + '/' return config
def InstaApiCall(url, params, request_type): if request_type == 'POST': req = requests.post(url, params) else: req = requests.get(url, params) res = dict() res["url"] = url res["endpoint_params"] = params res["endpoint_params_pretty"] = json.dumps(params, indent=4) res["json_data"] = json.loads(req.content) res["json_data_pretty"] = json.dumps(res["json_data"], indent=4) return res
def getUserMedia(params, pagingUrl=''): Params = dict() Params['fields'] = 'id,caption,media_type,media_url,permalink,thumbnail_url,timestamp,username,like_count,comments_count' Params['access_token'] = params['access_token']
if not params['endpoint_base']: return None if pagingUrl == '': url = params['endpoint_base'] + params['instagram_account_id'] + '/media' else: url = pagingUrl return InstaApiCall(url, Params, 'GET')def getUser(params): Params = dict() Params['fields'] = 'followers_count' Params['access_token'] = params['access_token']
if not params['endpoint_base']: return None url = params['endpoint_base'] + params['instagram_account_id'] return InstaApiCall(url, Params, 'GET')def saveCount(count, filename): with open(filename, 'w') as f: json.dump(count, f, indent=4)
def getCount(filename): try: with open(filename, 'r') as f: return json.load(f) except (FileNotFoundError, json.decoder.JSONDecodeError): return {}
st.set_page_config(layout="wide") params = basic_info()
count_filename = "count.json"
if not params['instagram_account_id']: st.write('.envファイルでinstagram_account_idを確認') else: response = getUserMedia(params) user_response = getUser(params) if not response or not user_response: st.write('.envファイルでaccess_tokenを確認') else: posts = response['json_data']['data'][::-1] user_data = user_response['json_data'] followers_count = user_data.get('followers_count', 0)
NUM_COLUMNS = 6 MAX_WIDTH = 1000 BOX_WIDTH = int(MAX_WIDTH / NUM_COLUMNS) BOX_HEIGHT = 400 yesterday = (datetime.datetime.now(datetime.timezone(datetime.timedelta(hours=9))) - datetime.timedelta(days=1)).strftime('%Y-%m-%d') follower_diff = followers_count - getCount(count_filename).get(yesterday, {}).get('followers_count', followers_count) st.markdown(f"<h4 style='font-size:1.2em;'>Follower: {followers_count} ({'+' if follower_diff >= 0 else ''}{follower_diff})</h4>", unsafe_allow_html=True) show_description = st.checkbox("キャプションを表示") show_summary_graph = st.checkbox("サマリーグラフを表示") show_like_comment_graph = st.checkbox("いいね/コメント数グラフを表示") posts.reverse() post_groups = [list(filter(None, group)) for group in zip_longest(*[iter(posts)] * NUM_COLUMNS)] count = getCount(count_filename) today = datetime.datetime.now(datetime.timezone(datetime.timedelta(hours=9))).strftime('%Y-%m-%d') if today not in count: count[today] = {} count[today]['followers_count'] = followers_count if datetime.datetime.now(datetime.timezone(datetime.timedelta(hours=9))).strftime('%H:%M') == '23:59': count[yesterday] = count[today] max_like_diff = 0 max_comment_diff = 0 for post_group in post_groups: for post in post_group: like_count_diff = post['like_count'] - count.get(yesterday, {}).get(post['id'], {}).get('like_count', post['like_count']) comment_count_diff = post['comments_count'] - count.get(yesterday, {}).get(post['id'], {}).get('comments_count', post['comments_count']) max_like_diff = max(like_count_diff, max_like_diff) max_comment_diff = max(comment_count_diff, max_comment_diff) like_diff_sum = 0 comment_diff_sum = 0 for date in sorted(count.keys()): date = datetime.datetime.strptime(date, '%Y-%m-%d') daily_like_diff = 0 daily_comment_diff = 0 for post_id in count[date]: if post_id == "followers_count": continue daily_like_diff += count[date][post_id]["like_count"] - count.get(date.strftime('%Y-%m-%d'), {}).get(post_id, {}).get("like_count", count[date][post_id]["like_count"]) daily_comment_diff += count[date][post_id]["comments_count"] - count.get(date.strftime('%Y-%m-%d'), {}).get(post_id, {}).get("comments_count", count[date][post_id]["comments_count"]) like_diff_sum += daily_like_diff comment_diff_sum += daily_comment_diff if show_summary_graph: plt.xlabel("Date") plt.ylabel("Count") plt.title('Summary') sns.lineplot(x=date.strftime('%m/%d'), y=like_diff_sum, label='like_count', color='skyblue') sns.lineplot(x=date.strftime('%m/%d'), y=comment_diff_sum, label='comments_count', color='green') sns.lineplot(x=date.strftime('%m/%d'), y=(follower_diff / (like_diff_sum + comment_diff_sum)), label='follower_diff', color='orange') if show_summary_graph: plt.legend(loc='best') plt.gca().set_facecolor('#121212') plt.show() for post_group in post_groups: with st.container(): columns = st.columns(NUM_COLUMNS) for i, post in enumerate(post_group): with columns[i]: st.image(post['media_url'], width=BOX_WIDTH, use_column_width=True) st.write(f"{datetime.datetime.strptime(post['timestamp'], '%Y-%m-%dT%H:%M:%S%z').astimezone(datetime.timezone(datetime.timedelta(hours=9))).strftime('%Y-%m-%d %H:%M:%S')}") like_count_diff = post['like_count'] - count.get(yesterday, {}).get(post['id'], {}).get('like_count', post['like_count']) comment_count_diff = post['comments_count'] - count.get(yesterday, {}).get(post['id'], {}).get('comments_count', post['comments_count']) st.markdown( f"👍: {post['like_count']} <span style='{'' if like_count_diff != max_like_diff or max_like_diff == 0 else 'color:green;'}'>({ '+' if like_count_diff >= 0 else ''}{like_count_diff})</span>" f"\n💬: {post['comments_count']} <span style='{'' if comment_count_diff != max_comment_diff or max_comment_diff == 0 else 'color:green;'}'>({ '+' if comment_count_diff >= 0 else ''}{comment_count_diff})</span>", unsafe_allow_html=True) caption = post['caption'] if caption is not None: caption = caption.strip() if "[Description]" in caption: caption = caption.split("[Description]")[1].lstrip() if "[Tags]" in caption: caption = caption.split("[Tags]")[0].rstrip() caption = caption.replace("#", "") caption = caption.replace("[model]", "👗") caption = caption.replace("[Equip]", "📷") caption = caption.replace("[Develop]", "🖨") if show_description: st.write(caption or "No caption provided") else: st.write(caption[:0] if caption is not None and len(caption) > 50 else caption or "No caption provided") if show_like_comment_graph: post_like_diffs = [] post_comment_diffs = [] post_dates = [] for date in sorted(count.keys()): date = datetime.datetime.strptime(date, '%Y-%m-%d') if post['id'] in count[date]: date_like_diff = count[date][post['id']]['like_count'] - count.get(date.strftime('%Y-%m-%d'), {}).get(post['id'], {}).get("like_count", count[date][post['id']]['like_count']) date_comment_diff = count[date][post['id']]['comments_count'] - count.get(date.strftime('%Y-%m-%d'), {}).get(post['id'], {}).get("comments_count", count[date][post['id']]['comments_count']) post_like_diffs.append(date_like_diff) post_comment_diffs.append(date_comment_diff) post_dates.append(date.strftime('%m/%d')) post_data = pd.DataFrame({ "Date": pd.to_datetime(post_dates), "like_count": post_like_diffs, "comments_count": post_comment_diffs }) fig, ax1 = plt.subplots() plt.title('Like/Comment Count') ax1.set_xlabel('Date') ax1.set_ylabel('Like', color='C1') ax1.plot(post_data["Date"], post_data["like_count"], color='C1') ax1.tick_params(axis='y', labelcolor='C1') ax2 = ax1.twinx() ax2.set_ylabel('Comment', color='C2') ax2.plot(post_data["Date"], post_data["comments_count"], color='C2') ax2.tick_params(axis='y', labelcolor='C2') fig.tight_layout() plt.gca().set_facecolor('#121212') plt.show() count[today][post['id']] = {'like_count': post['like_count'], 'comments_count': post['comments_count']} saveCount(count, count_filename)'''
上記のコードを実行すると、下記のエラーが表示されます。改修したコード全文を表示してください
'''
2023-04-30 19:43:59.926 Uncaught app exception Traceback (most recent call last): File "/home/walhalax/anaconda3/lib/python3.9/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 565, in _run_script exec(code, module.dict) File "/home/walhalax/PycharmProjects/pythonProject/その他/Instargram/inst_tileview/inst_tileview.py", line 130, in for post_id in count[date]: KeyError: datetime.datetime(2023, 4, 24, 0, 0) issing
- Assistant
It seems that the error is caused by the
datevariable not being present in thecountdictionary. You can fix the error by modifying the loop where the error occurred, like so:for date_str in sorted(count.keys()): date = datetime.datetime.strptime(date_str, '%Y-%m-%d') daily_like_diff = 0 daily_comment_diff = 0 for post_id in count[date_str]: if post_id == "followers_count": continue daily_like_diff += count[date_str][post_id]["like_count"] - count.get(date.strftime('%Y-%m-%d'), {}).get(post_id, {}).get("like_count", count[date_str][post_id]["like_count"]) daily_comment_diff += count[date_str][post_id]["comments_count"] - count.get(date.strftime('%Y-%m-%d'), {}).get(post_id, {}).get("comments_count", count[date_str][post_id]["comments_count"]) like_diff_sum += daily_like_diff comment_diff_sum += daily_comment_diff if show_summary_graph: plt.xlabel("Date") plt.ylabel("Count") plt.title('Summary') sns.lineplot(x=date.strftime('%m/%d'), y=like_diff_sum, label='like_count', color='skyblue') sns.lineplot(x=date.strftime('%m/%d'), y=comment_diff_sum, label='comments_count', color='green') sns.lineplot(x=date.strftime('%m/%d'), y=(follower_diff / (like_diff_sum + comment_diff_sum)), label='follower_diff', color='orange') if show_summary_graph: plt.legend(loc='best') plt.gca().set_facecolor('#121212') plt.show()By changing the loop variable from
datetodate_str, we avoid the KeyError by accessing the dictionary with the correct string key format. - User
上記の改修コードを含んだ全文を表示してください
- Assistant
Here's the full script with the updated loop:
import requests import json import datetime import streamlit as st from itertools import zip_longest import os import seaborn as sns import pandas as pd import matplotlib.pyplot as plt def basic_info(): config = dict() config["access_token"] = st.secrets["access_token"] config['instagram_account_id'] = st.secrets.get("instagram_account_id", "") config["version"] = 'v16.0' config["graph_domain"] = 'https://graph.facebook.com/' config["endpoint_base"] = config["graph_domain"] + config["version"] + '/' return config def InstaApiCall(url, params, request_type): if request_type == 'POST': req = requests.post(url, params) else: req = requests.get(url, params) res = dict() res["url"] = url res["endpoint_params"] = params res["endpoint_params_pretty"] = json.dumps(params, indent=4) res["json_data"] = json.loads(req.content) res["json_data_pretty"] = json.dumps(res["json_data"], indent=4) return res def getUserMedia(params, pagingUrl=''): Params = dict() Params['fields'] = 'id,caption,media_type,media_url,permalink,thumbnail_url,timestamp,username,like_count,comments_count' Params['access_token'] = params['access_token'] if not params['endpoint_base']: return None if pagingUrl == '': url = params['endpoint_base'] + params['instagram_account_id'] + '/media' else: url = pagingUrl return InstaApiCall(url, Params, 'GET') def getUser(params): Params = dict() Params['fields'] = 'followers_count' Params['access_token'] = params['access_token'] if not params['endpoint_base']: return None url = params['endpoint_base'] + params['instagram_account_id'] return InstaApiCall(url, Params, 'GET') def saveCount(count, filename): with open(filename, 'w') as f: json.dump(count, f, indent=4) def getCount(filename): try: with open(filename, 'r') as f: return json.load(f) except (FileNotFoundError, json.decoder.JSONDecodeError): return {} st.set_page_config(layout="wide") params = basic_info() count_filename = "count.json" if not params['instagram_account_id']: st.write('.envファイルでinstagram_account_idを確認') else: response = getUserMedia(params) user_response = getUser(params) if not response or not user_response: st.write('.envファイルでaccess_tokenを確認') else: posts = response['json_data']['data'][::-1] user_data = user_response['json_data'] followers_count = user_data.get('followers_count', 0) NUM_COLUMNS = 6 MAX_WIDTH = 1000 BOX_WIDTH = int(MAX_WIDTH / NUM_COLUMNS) BOX_HEIGHT = 400 yesterday = (datetime.datetime.now(datetime.timezone(datetime.timedelta(hours=9))) - datetime.timedelta(days=1)).strftime('%Y-%m-%d') follower_diff = followers_count - getCount(count_filename).get(yesterday, {}).get('followers_count', followers_count) st.markdown(f"<h4 style='font-size:1.2em;'>Follower: {followers_count} ({'+' if follower_diff >= 0 else ''}{follower_diff})</h4>", unsafe_allow_html=True) show_description = st.checkbox("キャプションを表示") show_summary_graph = st.checkbox("サマリーグラフを表示") show_like_comment_graph = st.checkbox("いいね/コメント数グラフを表示") posts.reverse() post_groups = [list(filter(None, group)) for group in zip_longest(*[iter(posts)] * NUM_COLUMNS)] count = getCount(count_filename) today = datetime.datetime.now(datetime.timezone(datetime.timedelta(hours=9))).strftime('%Y-%m-%d') if today not in count: count[today] = {} count[today]['followers_count'] = followers_count if datetime.datetime.now(datetime.timezone(datetime.timedelta(hours=9))).strftime('%H:%M') == '23:59': count[yesterday] = count[today] max_like_diff = 0 max_comment_diff = 0 for post_group in post_groups: for post in post_group: like_count_diff = post['like_count'] - count.get(yesterday, {}).get(post['id'], {}).get('like_count', post['like_count']) comment_count_diff = post['comments_count'] - count.get(yesterday, {}).get(post['id'], {}).get('comments_count', post['comments_count']) max_like_diff = max(like_count_diff, max_like_diff) max_comment_diff = max(comment_count_diff, max_comment_diff) like_diff_sum = 0 comment_diff_sum = 0 for date_str in sorted(count.keys()): date = datetime.datetime.strptime(date_str, '%Y-%m-%d') daily_like_diff = 0 daily_comment_diff = 0 for post_id in count[date_str]: if post_id == "followers_count": continue daily_like_diff += count[date_str][post_id]["like_count"] - count.get(date.strftime('%Y-%m-%d'), {}).get(post_id, {}).get("like_count", count[date_str][post_id]["like_count"]) daily_comment_diff += count[date_str][post_id]["comments_count"] - count.get(date.strftime('%Y-%m-%d'), {}).get(post_id, {}).get("comments_count", count[date_str][post_id]["comments_count"]) like_diff_sum += daily_like_diff comment_diff_sum += daily_comment_diff if show_summary_graph: plt.xlabel("Date") plt.ylabel("Count") plt.title('Summary') sns.lineplot(x=date.strftime('%m/%d'), y=like_diff_sum, label='like_count', color='skyblue') sns.lineplot(x=date.strftime('%m/%d'), y=comment_diff_sum, label='comments_count', color='green') sns.lineplot(x=date.strftime('%m/%d'), y=(follower_diff / (like_diff_sum + comment_diff_sum)), label='follower_diff', color='orange') if show_summary_graph: plt.legend(loc='best') plt.gca().set_facecolor('#121212') plt.show() for post_group in post_groups: with st.container(): columns = st.columns(NUM_COLUMNS) for i, post in enumerate(post_group): with columns[i]: st.image(post['media_url'], width=BOX_WIDTH, use_column_width=True) st.write(f"{datetime.datetime.strptime(post['timestamp'], '%Y-%m-%dT%H:%M:%S%z').astimezone(datetime.timezone(datetime.timedelta(hours=9))).strftime('%Y-%m-%d %H:%M:%S')}") like_count_diff = post['like_count'] - count.get(yesterday, {}).get(post['id'], {}).get('like_count', post['like_count']) comment_count_diff = post['comments_count'] - count.get(yesterday, {}).get(post['id'], {}).get('comments_count', post['comments_count']) st.markdown( f"👍: {post['like_count']} <span style='{'' if like_count_diff != max_like_diff or max_like_diff == 0 else 'color:green;'}'>({ '+' if like_count_diff >= 0 else ''}{like_count_diff})</span>" f"\n💬: {post['comments_count']} <span style='{'' if comment_count_diff != max_comment_diff or max_comment_diff == 0 else 'color:green;'}'>({ '+' if comment_count_diff >= 0 else ''}{comment_count_diff})</span>", unsafe_allow_html=True) caption = post['caption'] if caption is not None: caption = caption.strip() if "[Description]" in caption: caption = caption.split("[Description]")[1].lstrip() if "[Tags]" in caption: caption = caption.split("[Tags]")[0].rstrip() caption = caption.replace("#", "") caption = caption.replace("[model]", "👗") caption = caption.replace("[Equip]", "📷") caption = caption.replace("[Develop]", "🖨") if show_description: st.write(caption or "No caption provided") else: st.write(caption[:0] if caption is not None and len(caption) > 50 else caption or "No caption provided") if show_like_comment_graph: post_like_diffs = [] post_comment_diffs = [] post_dates = [] for date_str in sorted(count.keys()): date = datetime.datetime.strptime(date_str, '%Y-%m-%d') if post['id'] in count[date_str]: date_like_diff = count[date_str][post['id']]['like_count'] - count.get(date.strftime('%Y-%m-%d'), {}).get(post['id'], {}).get("like_count", count[date_str][post['id']]['like_count']) date_comment_diff = count[date_str][post['id']]['comments_count'] - count.get(date.strftime('%Y-%m-%d'), {}).get(post['id'], {}).get("comments_count", count[date_str][post['id']]['comments_count']) post_like_diffs.append(date_like_diff) post_comment_diffs.append(date_comment_diff) post_dates.append(date.strftime('%m/%d')) post_data = pd.DataFrame({ "Date": pd.to_datetime(post_dates), "like_count": post_like_diffs, "comments_count": post_comment_diffs }) fig, ax1 = plt.subplots() plt.title('Like/Comment Count') ax1.set_xlabel('Date') ax1.set_ylabel('Like', color='C1') ax1.plot(post_data["Date"], post_data["like_count"], color='C1') ax1.tick_params(axis='y', labelcolor='C1') ax2 = ax1.twinx() ax2.set_ylabel('Comment', color='C2') ax2.plot(post_data["Date"], post_data["comments_count"], color='C2') ax2.tick_params(axis='y', labelcolor='C2') fig.tight_layout() plt.gca().set_facecolor('#121212') plt.show() count[today][post['id']] = {'like_count': post['like_count'], 'comments_count': post['comments_count']} saveCount(count, count_filename)I updated the loop where the error occurred by changing the loop variable from
datetodate_str.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.