【python】将xlsx文件转成sav文件

import pandas as pd
import pyreadstat
# 读取 .xlsx 文件
excel_file = 'your_file_name.xlsx'  # 替换为你的文件路径
df = pd.read_excel(excel_file)

# 将列名转换为合法的变量名
df.columns = [col.strip().replace(' ', '_').replace('(', '').replace(')', '').replace('/', '_') 
              for col in df.columns]

# 保存为 .sav 文件
sav_file = 'your_file_name.sav'  # 替换为你想保存的文件路径
pyreadstat.write_sav(df, sav_file)

print(f"File converted and saved as {sav_file}")