Try Faker - https://github.com/joke2k/faker

try_faker.py

import csv

from faker import Faker


fake = Faker()
with open('transactions.csv', 'r') as file_:
    with open('anonymized_transactions.csv', 'w') as new_file:
        reader = csv.DictReader(file_)
        writer = csv.DictWriter(new_file, fieldnames=reader.fieldnames)
        writer.writeheader()
        for row in reader:
            row['name'] = fake.name()
            row['email'] = fake.email()
            row['credit_card_number'] = fake.credit_card_number()
            writer.writerow(row)