Using Mockaroo to Create Data

 

In this blog, I will demonstrate how to create simple data using Mockaroo. This data can be used for various purposes, such as training or testing.

 

This is the website where you can create the data.

 

 

 

Introduction to Mockaroo

 

Mockaroo is a website that allows you to create realistic test data quickly. It provides tools to generate data schemas, upload and store datasets, create APIs, and manage projects. The main options available on the website include:

Schemas: Where you create your dataset structure.

Datasets: After downloading your schema, you can save this data under Datasets.

APIs: Allows you to create and connect to APIs for data generation.

Scenario: Stores the scenarios you have created.

Projects: Displays all your projects, which you can also share with others.

Functions: Custom functions you can use to enhance your data generation process.

 

On the top right corner, you will find Settings and Account details. At the bottom of the screen, there are options to Generate Data, Preview the results, and Save your schema.

 

Creating a Table

 

Below the header, you will find the main area for creating your dataset table. This section allows you to customize columns and select the format type for each column.

 

Adding and Renaming Columns

 

  1. Start by clearing all pre-existing columns, keeping only the first one.
  2. Create and rename your columns to fit your desired data structure. For this example, we will create 4 columns: ID, Name, Product, and Price.

 

 

Selecting Format Types

 

When you click on the Format Type field, a new screen appears where you can select or search for the desired format type. The process for each column is as follows:

 

  • ID Column: Use the format type Row Number.
  • Name Column: Change the format type to Full Name.

 

 

 

 

  • Product Column: Choose Custom List. Add the list of products manually, and select Weighted to control the distribution.

 

 

 

 

In this example, the weights are: Mobile (40%), Notebook (40%), Watch (10%), and Video Game (10%).

 

 

 

  • Price Column: Set the format type to Number. Configure the settings to have a minimum of 100, a maximum of 1500, with two decimal places and no blanks.

 

 

 

 

Generating and Previewing Data

 

 

Once all columns are set, click on Preview to see the generated data. The result will display the data according to your schema.

 

 

 

 

 

 

Conclusion

This is a basic guide on how to create data using Mockaroo. It is a powerful tool for generating data for various use cases, from testing and training to data analysis and development. Mockaroo’s flexibility makes it extremely useful for building datasets that match your specific requirements.

 

Augusto Terra
Author: Augusto Terra

Before joining the Data Schools, Augusto was a PE teacher and Football coach. A few years after enjoying working with data at his master's degree, Augusto decided this was the path that he was willing to pursue. This led him to join The Data School; he is keen to work with different data and find business solutions. He also enjoys being with his friends and playing sports (Football).