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