import pandas as pd

df = pd.read_csv("followers_info.csv", encoding="utf-8-sig")

filtered = df[df["nickname"] == "ゲスト"]
print(f"nickname == ゲスト: {len(filtered)} found")

filtered = df[df["followeeCount"] == 1]
print(f"followeeCount == 1: {len(filtered)} found")

filtered = df[(df["nickname"] == "ゲスト") & (df["followeeCount"] == 1)]
print(f"nickname == ゲスト & followeeCount == 1: {len(filtered)} found")

filtered = df[df["icon"] == "https://secure-dcdn.cdn.nimg.jp/nicoaccount/usericon/defaults/blank.jpg"]
print(f"icon == blank.jpg: {len(filtered)} found")

filtered = df[(df["icon"] == "https://secure-dcdn.cdn.nimg.jp/nicoaccount/usericon/defaults/blank.jpg") & (df["followeeCount"] == 1)]
print(f"icon == blank.jpg & followeeCount == 1: {len(filtered)} found")

filtered = df[(df["nickname"] == "ゲスト") & (df["icon"] == "https://secure-dcdn.cdn.nimg.jp/nicoaccount/usericon/defaults/blank.jpg") & (df["followeeCount"] == 1)]
print(f"nickname == ゲスト & icon == blank.jpg & followeeCount == 1: {len(filtered)} found")
Edit
Pub: 29 Apr 2025 11:09 UTC
Views: 31