import pandas as pd # Read the Excel file input_file = "input.xls" # Replace "input.xls" with the path to your input Excel file output_file = "output.xls" # Replace "output.xls" with the desired output file path data = pd.read_excel(input_file) # Randomize the order of entries randomized_data = data.sample(frac=1).reset_index(drop=True) # Save the randomized data to a new Excel file randomized_data.to_excel(output_file, index=False) print("Randomization complete. Output saved to", output_file)