• Select the data for each column with df[col]
• The csv file name will be f'{col}.csv', where col is the column name.
• df.to_csv(os.getcwd()+'\\ file.csv')进入 AppData 文件夹
• 当前工作目录不一定是您想要保存文件的位置.
• 指定完整的所需保存路径，例如'c:/Users/<< user_name>>/Documents/{col} .csv'.
• df.to_csv(os.getcwd()+'\\file.csv') goes into the AppData folder
• The current working directory is not necessarily where you want the file saved.
• Specify the full desired save path, 'c:/Users/<<user_name>>/Documents/{col}.csv', for example.

import pandas as pd

# set Date as the index
df.set_index('Date', inplace=True)

# iterate through each column and save it
for col in df.columns:
    df[col].to_csv(f'c:/Users/<<user_name>>/Documents/{col}.csv', index=True)