shuffle rows in pandas dataframe
#PYTHON PROGRAM TO SHUFFLE PANDAS DATAFARME ROWS
USE sample() to PANDAS DATAFRAME
import pandas as pd
#create a Dataframe with employee info
df_employee = pd.DataFrame({
"empID":[101,102,103,104,105,106,107,108,109,110],
"empName": ['E1','E2','E3','E4','E5','E6','E7','E8','E9','E10'],
"Age":[10,30,65,78,34,24,67,73,12,54]
})
print("EMPLOYEE DATAFRAME:")
print(df_employee)
df_shuffled_employee = df_employee.sample(10)
print("SHUFFLED EMPLOYEE DATAFRAME:")
print(df_shuffled_employee)
output:
EMPLOYEE DATAFRAME:
empID empName Age
0 101 E1 10
1 102 E2 30
2 103 E3 65
3 104 E4 78
4 105 E5 34
5 106 E6 24
6 107 E7 67
7 108 E8 73
8 109 E9 12
9 110 E10 54
SHUFFLED EMPLOYEE DATAFRAME:
empID empName Age
2 103 E3 65
4 105 E5 34
1 102 E2 30
6 107 E7 67
3 104 E4 78
7 108 E8 73
0 101 E1 10
5 106 E6 24
8 109 E9 12
9 110 E10 54