Skip to content
TheChatArchiveThe Chat Archive
gpt-4-0314· openaiHugging Face Suzhen/CodeChat

import requests import json import datetime import streamlit as st from itertools import…

  1. 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

  2. Assistant

    It seems that the error is caused by the date variable not being present in the count dictionary. 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 date to date_str, we avoid the KeyError by accessing the dictionary with the correct string key format.

  3. User

    上記の改修コードを含んだ全文を表示してください

  4. 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 date to date_str.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.