将秒数上的值分配到新列中

import pandas as pd

# 创建一个示例数据集
data = {'秒数': [60, 120, 180, 240, 300]}
df = pd.DataFrame(data)

# 创建新列
df['分配值'] = ''

# 遍历每一行数据
for index, row in df.iterrows():
    seconds = row['秒数']
    
    # 分配值到新列
    if seconds < 60:
        df.at[index, '分配值'] = f'{seconds}秒'
    elif seconds < 3600:
        minutes = seconds // 60
        df.at[index, '分配值'] = f'{minutes}分钟'
    elif seconds < 86400:
        hours = seconds // 3600
        df.at[index, '分配值'] = f'{hours}小时'
    else:
        days = seconds // 86400
        df.at[index, '分配值'] = f'{days}天'

# 打印结果
print(df)