Pandas + Faker: Generate a DataFrame with Random Numbers and Text

Updated: February 21, 2024 By: Guest Contributor Post a comment


In the world of data science and machine learning, the ability to generate mock datasets can be incredibly valuable. These datasets allow practitioners to test algorithms, models, and data pipelines without the need for real data, which may not always be available or may contain sensitive information. In this tutorial, we’re going to explore how we can leverage two powerful Python libraries, Pandas and Faker, to generate a DataFrame filled with random numbers and text. This method is particularly useful for scenario testing, educational purposes, or if you’re just looking to play around with data analysis techniques.

Getting Started

Pandas is an open-source data analysis and manipulation tool, widely used in Python for its high-performance, easy-to-use data structures and data analysis tools. Faker, on the other hand, is a Python package that generates fake data for you, whether you need to bootstrap your database, fill-in your persistence to stress test it, or anonymize data taken from a production service. First things first, ensure you have both Pandas and Faker installed in your Python environment:

pip install pandas faker

Basic Random Data Generation

Let’s start by generating a simple DataFrame with random numbers:

import pandas as pd
import numpy as np

# Generating a DataFrame with 100 rows and 2 columns of random numbers
df = pd.DataFrame(np.random.randint(0, 100, size=(100, 2)), columns=['Number1', 'Number2'])

The above code snippet generates a DataFrame named df with 100 rows and 2 columns named ‘Number1’ and ‘Number2’, each filled with random integers between 0 and 100. Take a look at the first few rows with df.head().

Generating Fake Text Data with Faker

Now, let’s introduce Faker into the mix and generate some text data:

from faker import Faker
fake = Faker()

# Add a new column of fake names
df['Name'] = [ for _ in range(100)]

With just a few lines of code, we have added a new column named ‘Name’ filled with fake names generated by Faker.

Combining Random Numbers and Fake Text

Now that we have our basic random number DataFrame and we know how to generate fake text data, let’s combine these skills to create a more complex dataset:

df['Age'] = np.random.randint(18, 65, size=(100,))
df['Email'] = [ for _ in range(100)]
df['Address'] = [fake.address() for _ in range(100)]

This time, besides adding names, we have also included columns for age, email, and addresses with corresponding random data and fake information. This demonstrates how seamlessly Pandas and Faker can work together to generate very detailed datasets.

Customize Your Data

Both Pandas and Faker offer flexibility in terms of data customization. For instance, with Faker, you can specify the locale to generate data that is region-specific:

fake = Faker('en_GB')  # British English

# Now, generating British-specific addresses
for _ in range(5):

This method ensures that the data you generate aligns with a specific cultural or geographic context, making your mock datasets even more realistic.

Advanced Data Generation Techniques

For those looking to generate data in a more complex or specific way, there’s plenty more that Pandas and Faker have to offer. For instance, you could create a DataFrame schema first and then populate it with random data:

schema = {'Name': lambda:,
          'Age': lambda: np.random.randint(18, 65),
          'Email': lambda:,
          'Phone Number': lambda: fake.phone_number()}

# Creating a DataFrame with the above schema

pd.DataFrame({column: [func() for _ in range(100)] for column, func in schema.items()})

This technique gives you more control over your DataFrame’s structure, allowing for a more organized and customizable approach to data generation.


By combining the data manipulation power of Pandas with the versatility of Faker, we can effortlessly generate comprehensive and customizable datasets for various applications. Whether you’re looking to test your latest data model or simply want to play around with data analysis techniques, this tutorial offers a solid foundation to get started with generating mock data.