如何在pandas中获取多个csv文件夹中一列的平均值？

import pandas as pd
import os

def get_csv_files(folder_path):
    csv_files = []
    for root, dirs, files in os.walk(folder_path):
        for file in files:
            if file.endswith(".csv"):
                csv_files.append(os.path.join(root, file))
    return csv_files

folder_path = "path/to/csv_folder"
csv_files = get_csv_files(folder_path)

data = pd.DataFrame()

for file in csv_files:
    df = pd.read_csv(file)
    column_data = df["column_name"]  # 指定要获取平均值的列名
    data = data.append(column_data, ignore_index=True)

average = data.mean()

import pandas as pd
import os

def get_csv_files(folder_path):
    csv_files = []
    for root, dirs, files in os.walk(folder_path):
        for file in files:
            if file.endswith(".csv"):
                csv_files.append(os.path.join(root, file))
    return csv_files

folder_path = "path/to/csv_folder"
csv_files = get_csv_files(folder_path)
data = pd.DataFrame()

for file in csv_files:
    df = pd.read_csv(file)
    column_data = df["column_name"]  # 指定要获取平均值的列名
    data = data.append(column_data, ignore_index=True)

average = data.mean()