import pandas as pd
import random

df = pd.read_excel("result.xlsx")
columns = df.columns
data_list = df.values.tolist()
print(len(data_list))


# 定义范围
start, end = 0, 531

# 从1到532中随机取出30个不重复的数字
random_numbers = random.sample(range(start, end + 1), 30)

result = []
for i in random_numbers:
    print(data_list[i])
    result.append(data_list[i])

out_df = pd.DataFrame(result, columns=columns)
out_df.to_excel("test.xlsx", index=False)