tel3 / tools.py
mfoud444's picture
all
f796ac0
raw
history blame contribute delete
592 Bytes
import pandas as pd
import os
csv_file = "final_results.csv"
output_file = "new.csv"
df = pd.read_csv(csv_file)
status_column = "status"
status = 1 # Fixed from tuple to integer
mygroubs = pd.read_csv("my_telegram_groups.csv")
# βœ… Filter based on status
filtered_df = df[df[status_column] == status]
# βœ… Correct comparison using .isin()
filtered_df = filtered_df[~filtered_df["link"].isin(mygroubs['link'])]
final = filtered_df[filtered_df["type"] == "Group"]
# βœ… Save the filtered data
final.to_csv(output_file, index=False)
print(f"βœ… Filtered results saved to {output_file}")