swap_row_cells_in_column.py

import pandas as pd
import openpyxl
import random


data = pd.read_excel('Book1.xlsx', usecols="C,D,E,F")
wb = openpyxl.load_workbook('Book1.xlsx')
sheet = wb.active

columns = ["C", "D", "E", "F"]


try:
  #range can be set manually
    for i in range(0, 6000):
        options = [sheet[f"C{i+1}"].value, sheet[f"D{i+1}"].value,
                   sheet[f"E{i+1}"].value, sheet[f"F{i+1}"].value]
        random.shuffle(options)
        print(options)
        sheet[f"C{i+1}"].value = options[0]
        sheet[f"D{i+1}"].value = options[1]
        sheet[f"E{i+1}"].value = options[2]
        sheet[f"F{i+1}"].value = options[3]

     
    wb.save('output.xlsx')


except Exception as e:
    print(e)