SHA256 a CSV file using Pandas

hash.py

import pandas as pd
import hashlib

# Load the csv file into a pandas DataFrame
df = pd.read_csv('filename.csv')

# Define a function to hash a string
def hash_for_google(input):
    if pd.isnull(input):
        return None
    input = str(input).lower().strip()
    return hashlib.sha256(input.encode()).hexdigest()

# Apply the hash function to the 'Email', 'First Name', and 'Last Name' columns
df['Email'] = df['Email'].apply(hash_for_google)
df['First Name'] = df['First Name'].apply(hash_for_google)
df['Last Name'] = df['Last Name'].apply(hash_for_google)

# Save the DataFrame to a new csv file
df.to_csv('hashed_emails.csv', index=False)