How to create a dataset from generating new data to modify existing data for an excel file. With Python ?
Can I create code in Python that will allow me to build a list of records that I can them import into Excel or a database that will do the following.
1. Generate Names or Words for a field. Say the name Robert or the words 205 Walnut Lane
2. Modify existing records in order to change and existing name in a field Say First Name from Mary to Frances? Having it modify randomly each name.
3. Finally. How can I Generate a list of records for a currency field to generate random values set between a range. Say $20,000 to millions of dollars?
Can python do that and if so any ideas on what the code would look like or how to get examples of it. I could play around with.
The goal is to build a fictitious dataset for this excel file or to add to a DB.
1. Generate Names or Words for a field. Say the name Robert or the words 205 Walnut Lane
2. Modify existing records in order to change and existing name in a field Say First Name from Mary to Frances? Having it modify randomly each name.
3. Finally. How can I Generate a list of records for a currency field to generate random values set between a range. Say $20,000 to millions of dollars?
Can python do that and if so any ideas on what the code would look like or how to get examples of it. I could play around with.
The goal is to build a fictitious dataset for this excel file or to add to a DB.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER