import pandas as pd
from sklearn.utils import shuffle
df = pd.read_excel(ori_path,sheet_name=0)
df = shuffle(df)
df.to_excel(ori_path, encoding='utf8', index=None)
简单有效,相信我
import pandas as pd
from sklearn.utils import shuffle
df = pd.read_excel(ori_path,sheet_name=0)
df = shuffle(df)
df.to_excel(ori_path, encoding='utf8', index=None)
简单有效,相信我