⎗ ✓ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17import pandas as pd from datetime import datetime df = pd.read_csv("followers_info.csv", encoding="utf-8-sig") df["date"] = pd.to_datetime(df["follow_datetime"]).dt.date date_counts = df["date"].value_counts().sort_index() most_common_date = date_counts.idxmax() max_count = date_counts.max() print(f"result: {most_common_date} ({max_count} followers increased)") filtered_df = df[df["date"] == most_common_date] # print(filtered_df.head()) filtered = filtered_df[(filtered_df["nickname"] == "ゲスト") & (filtered_df["icon"] == "https://secure-dcdn.cdn.nimg.jp/nicoaccount/usericon/defaults/blank.jpg") & (filtered_df["followeeCount"] == 1)] print(f"nickname == ゲスト & icon == blank.jpg & followeeCount == 1: {len(filtered)} found")