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 module import 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 module import 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: