添加新的列年份并提取给定的文件名(pandas，glob，os)

import pandas as pd
import glob
import os

files = glob.glob('path_to_folder/*.csv')  # 替换为实际的文件夹路径和文件类型

dataframes = []
for file in files:
    df = pd.read_csv(file)  # 根据实际情况选择适当的读取函数，如read_excel()
    file_name = os.path.basename(file)
    year = file_name.split('.')[0][-4:]  # 假设文件名格式为"filename_year.csv"
    df['年份'] = year
    dataframes.append(df)

result = pd.concat(dataframes)
result.to_csv('path_to_save/result.csv', index=False)  # 替换为实际的保存路径和文件名