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}") | |