import 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")
Edit Report
Pub: 29 Apr 2025 11:29 UTC
Views: 17