根据现有日期列中的年份添加二进制分类列

import pandas as pd

# 假设现有日期列名为"date"，存储在DataFrame中
df = pd.DataFrame({'date': ['2022-01-01', '2023-02-03', '2024-05-06']})

# 提取年份信息
df['year'] = pd.to_datetime(df['date']).dt.year

# 将年份转换为二进制形式
df['binary_year'] = df['year'].apply(lambda x: bin(x)[2:])

print(df)

         date  year binary_year
0  2022-01-01  2022   100011001
1  2023-02-03  2023   100011011
2  2024-05-06  2024   100011100

-- 假设现有表名为"table_name"，包含日期列"date"
-- 添加新列"binary_year"，类型为VARCHAR(20)
ALTER TABLE table_name ADD COLUMN binary_year VARCHAR(20);

-- 更新"binary_year"列的值
UPDATE table_name SET binary_year = LPAD(BIN(YEAR(date)), 20, '0');