A Easy Guide for Practical Applications
Have you ever ever had a necessity for a dataset that doesn’t easily exist? Desired to easily generate data that matches your exact requirements for interviewing prospective data science candidates, software testing + development, or training models? Or what about just wanting the best data to make use of to display skills + techniques for a Medium article (that doesn’t violate copyright laws)?
Enter dummy data! 📊✨
Until recently, creating dummy datasets was somewhat tedious and arduous, the technical folks amongst us could generate if with expertly written python code, but coding up all of your requirements by hand might be time intensive and has a high technical barrier to entry.
Let’s say we’ve a use case where we wish to check a candidate applying for data science to a fintech, and there are real world patterns we wish them to have the ability to discover and discuss, but for privacy reasons we cannot share actual customer transaction data externally.
The answer? Leverage the facility of Generative AI to expertly craft complex python code to output our ✨Designer Dummy Datasets✨
Let’s take a look at how we will prompt GPT4 to generate a dataset for us that meets all of our exact, and somewhat tedious, requirements:
Hi there! You might be my expert python programmer and data scientist extraordinaire.
I would like to generate a "designer dummy dataset" that meets the next conditions and specifications,
are you able to please write the python code for me to generate it? The dataset is transactions in 2019, 2020, and 2021
I need the dataset to contain the next columns: id, transaction_timestamp, user_id, amount, merchant, network, card_type.
The merchant_name must be either: Walmart, Netflix.com, Starbucks, Home Depot, 7/11, Dunkin Donuts, Trader Joe's, and Amazon.com
The user_id must be between 1 and 100 - the quantity must be 9.99 for each Netflix.com purchase, lower than $10 for Starbucks and Dunkin Donuts, between $25 and 500 for Walmart, Amazon.com, and Home Depot, lower than $25 for 7/11, and between $10 and $250 for Trader Joe's
There…