Created
April 22, 2023 14:18
-
-
Save mikefrizzell/22e6fa614ce1b7e052db7a8d214a5d09 to your computer and use it in GitHub Desktop.
Python script to create random data in CSV format for an example Streamlit application
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import csv | |
import random | |
from datetime import datetime, timedelta | |
names = ["Person1", "Person2", "Person3", "Person4", "Person5"] | |
request_types = ["Continuing care", "Patient", "Insurance", "Attorney", "Work comp", "Law enforcement", "Regulatory"] | |
# Set the start and end dates | |
start_date = datetime.strptime('1/1/2022', '%m/%d/%Y') | |
end_date = datetime.strptime('12/31/2023', '%m/%d/%Y') | |
# Open a new CSV file for writing | |
with open('random_data.csv', mode='w', newline='') as file: | |
writer = csv.writer(file) | |
# Write the headers | |
writer.writerow(['date', 'name', 'calls', 'voicemail', 'call_time', 'request_type', 'number_done', 'pages_sent', 'time_spent', 'cds_created', 'images_clouded']) | |
# Generate 20,000 rows of random data | |
for i in range(20000): | |
# Generate random values for each field | |
date = start_date + timedelta(days=random.randint(0, (end_date - start_date).days)) | |
name = random.choice(names) | |
calls = random.randint(0, 248) | |
voicemail = random.randint(0, 74) | |
call_time = random.randint(0, 8) | |
request_type = random.choice(request_types) | |
number_done = random.randint(0, 103) | |
pages_sent = random.randint(0, 5000) | |
time_spent = random.randint(0, 8) | |
cds_created = random.randint(0, 44) | |
images_clouded = random.randint(0, 199) | |
# Write the row to the CSV file | |
writer.writerow([date.strftime('%m/%d/%Y'), name, calls, voicemail, call_time, request_type, number_done, pages_sent, time_spent, cds_created, images_clouded]) | |
print("Data generated and saved to random_data.csv") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This script is for a healthcare release of information application I'm working on. The result is a dataset that shows employee production releasing records.