Untitled

import pandas as pd

# Load CSV file
df = pd.read_csv("filtered_cloudtrail_data.csv")

# Get unique values from each column
unique_user_agents = df["userAgent"].drop_duplicates().sort_values()
unique_event_names = df["eventName"].drop_duplicates().sort_values()

# Save unique values to separate CSV files
unique_user_agents.to_csv("unique_userAgents.csv", index=False)
unique_event_names.to_csv("unique_eventNames.csv", index=False)

print("Unique values extracted and saved in 'unique_userAgents.csv' and 'unique_eventNames.csv'.")