Q:

Pandas – How to shuffle a DataFrame rows?

mahmoud2506
Save to bookmark
|
2022-05-25
|
  352 
0

Shuffling of rows means changing the sequence of rows randomly. Pandas allow us to shuffle the order or rows using the sample() method. We will be using the sample() method to randomly shuffle the order of rows in pandas DataFrame.

pandas.DataFrame.sample() Method

The sample() method is an inbuilt method for shuffling sequences in python. Hence, in order to shuffle the rows in DataFrame, we will use DataFrame.sample() method. Shuffle method takes a sequence (list) as an input and it reorganize the order of that particular sequence.

Syntax:

DataFrame.sample(
    n=None, 
    frac=None, 
    replace=False, 
    weights=None, 
    random_state=None, 
    axis=None, 
    ignore_index=False
    )

# or
DataFrame.sample(n=none, frac=none, axis= none)

Parameters:

  • n: n is total number of rows to be shuffled.
  • frac: frac is fraction of total instances needs to be returned, i.e., number of times shuffling needs to be done.
  • axis: '0' or 'row' for rows and '1' or 'column' for columns.

Note: The sample() method does not work with immutable types of data types like strings.

To work with Python Pandas, we need to import the pandas library. Below is the syntax,

import pandas as pd
Python programming, examples, Python programming examples,
login and add your own answer to this question

All Answers

mahmoud2506
2022-05-25
need an explanation for this answer? contact us directly to get an explanation for this answer

Example:

# Importing pandas package
import pandas as pd

# Creating a dictionary
d = {
    'States':['Punjab','Madhya Pradesh','Uttar Pradesh','Himachal Pradesh',
    'Haryana','Uttrakhand','Gujrat','Rajasthan','Chattisgarh'],
    'Capitals':['Chandigarh','Bhopal','Lucknow','Shimla','Chandigarh',
    'Dehradun','Gandhinagar','Jaipur','Raipur']
}

# Creating a DataFrame
df = pd.DataFrame(d)

# Printing original DataFrame
print("\nOrignal DataFrame:\n\n",df)

# Shuffling the order of rows 
# using the sample() method
df = df.sample(n=9)

# Printing the shuffled DataFrame
print("\nShuffled DataFrame:\n\n",df)

Output:

Orignal DataFrame:

              States     Capitals
0            Punjab   Chandigarh
1    Madhya Pradesh       Bhopal
2     Uttar Pradesh      Lucknow
3  Himachal Pradesh       Shimla
4           Haryana   Chandigarh
5        Uttrakhand     Dehradun
6            Gujrat  Gandhinagar
7         Rajasthan       Jaipur
8       Chattisgarh       Raipur

Shuffled DataFrame:

              States     Capitals
5        Uttrakhand     Dehradun
1    Madhya Pradesh       Bhopal
2     Uttar Pradesh      Lucknow
6            Gujrat  Gandhinagar
4           Haryana   Chandigarh
7         Rajasthan       Jaipur
0            Punjab   Chandigarh
8       Chattisgarh       Raipur
3  Himachal Pradesh       Shimla

shuffle a DataFrame rows | Output

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions

need a help?

find thousands of online teachers now