用途：

import os, shutil, glob

d = df.set_index('file_name')['site_number']

for file in glob.glob('fruit/*.xyz'):
    base_filename = os.path.basename(file)
    output = f'fruit_{d.get(os.path.splitext(base_filename)[0])}'
    #print (file)
    #print (output)
    shutil.move(file, output)

需要Python 3.4

import pandas as pd
from pathlib import Path

df = pd.DataFrame({
    'file_name': ['apple', 'banana', 'grape'],
    'site_number': [1, 1, 2]})

out = "/Users/my_cool_username/Downloads/so/out"
nm = "fruit"

# create the folders we need
df.apply(lambda x: Path.mkdir(Path(out, nm + "_" + str(x['site_number'])), parents=True, exist_ok=True), axis=1)

# move the folders
df.apply(lambda x: Path(x['file_name'] + '.csv').rename(Path(out, nm + "_" + str(x['site_number']), x['file_name'] + '.csv')), axis=1)