Untitled

import pandas as pd

# Load the original file
file_path = "HIPAA_Worksheet.xlsx"  # Replace with your actual file path
data = pd.read_excel(file_path, sheet_name="HIPAA Assesment Worksheet")

# Create a new column with policy statements
data['Policy Statements'] = data['Requirement Description'].apply(
    lambda x: f"The organization will implement measures as outlined: {x}" if pd.notna(x) else None
)

# Save the updated file
export_path = "HIPAA_Worksheet_with_Policies.xlsx"
data.to_excel(export_path, index=False)
print(f"Updated file saved as {export_path}")