How to Shuffle DataFrame Rows

Shuffling rows in a DataFrame means changing the order of rows. In this short how-to article, we will learn how to do this operation in Pandas DataFrames.

Pandas

We can use the sample method, which returns a randomly selected sample from a DataFrame. If we make the size of the sample the same as the original DataFrame, the resulting sample will be the shuffled version of the original one.

# with n parameter
df = df.sample(n=len(df))

# with frac parameter
df = df.sample(frac=1)

The frac and n parameters define the size of the sample.

This question is also being asked as:

• Pandas – how do you randomize the rows of a DataFrame

People have also asked for:

• Use a list of values to select rows from a Pandas DataFrame
• How to change the order of DataFrame columns
• How do I get the row counts of a Pandas DataFrame

Aporia Team

Sometimes, writing is a joint effort.

building a RAG app?

Read about Aporia’s AI Guardrails

Learn more