Let us see how to shuffle the rows of a DataFrame. We will be using the sample() method of the pandas module to randomly shuffle DataFrame rows in Pandas.
Example 1:
Python3
# import the moduleimport pandas as pd # create a DataFrame data = {'Name': ['Mukul', 'Rohan', 'Mayank', 'Shubham', 'Aakash'], 'Class': ['BCA', 'BBA', 'BCA', 'MBA', 'BBA'], 'Location' : ['Saharanpur', 'Meerut', 'Agra', 'Saharanpur', 'Meerut']} df1 = pd.DataFrame(data) # print the original DataFrame print("Original DataFrame :") display(df1) # shuffle the DataFrame rows df2 = df1.sample(frac = 1) # print the shuffled DataFrame print("\nAfter Shuffle:") display(df2) |
Output:
Example 2:
Python3
# import the moduleimport pandas as pd # create a DataFrame ODI_runs = {'name': ['Tendulkar', 'Sangakkara', 'Pointing', 'Jayasurya', 'Jayawardene', 'Kohli', 'Haq', 'Kallis', 'Ganguly', 'Dravid'], 'runs': [18426, 14234, 13704, 13430, 12650, 11867, 11739, 11579, 11363, 10889]} df1 = pd.DataFrame(ODI_runs) # print the original DataFrame print("Original DataFrame :") display(df1) # shuffle the DataFrame rows df2 = df1.sample(frac = 1) # print the shuffled DataFrame print("\nAfter Shuffle:") display(df2) |
Output:
