Python动态命名导出多个CSV文件报错求助

1. Fix the Syntax Error in Your CSV Export Code #

Let's break down why your code threw a syntax error first:

• Quotation mark misalignment: Your path string wasn't properly closed before you tried to concatenate the n variable, which confused Python's parser.
• Windows path escape issue: Single backslashes (\) in Windows paths are treated as escape characters in Python. You need to either use double backslashes (\\) or prefix the path with r to make it a raw string.

Here are two clean, working versions of your export code:

Option 1: Use F-Strings & Raw Path (Simplest) #

# Use a raw string for the Windows path to avoid escape problems
save_folder = r'C:\Users\egagne\Downloads'

# Loop through groups and export each to CSV
for group_name, group_data in df.groupby('col'):
    # Build the full file path with an f-string for readability
    full_file_path = f"{save_folder}\\{group_name}stars.csv"
    # Add index=False if you don't want the pandas index included in the CSV
    group_data.to_csv(full_file_path, index=False)

Option 2: Use os.path.join (Cross-Platform Friendly) #

If you want your code to work seamlessly on Windows, macOS, or Linux, use os.path.join to handle path separators automatically:

import os

save_folder = r'C:\Users\egagne\Downloads'

for group_name, group_data in df.groupby('col'):
    file_name = f"{group_name}stars.csv"
    # os.path.join ensures the correct path separator is used for your OS
    full_file_path = os.path.join(save_folder, file_name)
    group_data.to_csv(full_file_path, index=False)

2. Bulk Download All 200+ CSV Files in Jupyter Lab #

Downloading 200 files one by one is a huge hassle. Instead, we can zip all the generated CSVs into a single archive and create a one-click download link in your notebook:

Step 1: Generate All CSV Files #

First, run either of the fixed export codes above to create all your CSV files in the Downloads folder.

Step 2: Zip Files & Create Download Link #

import zipfile
from IPython.display import FileLink

save_folder = r'C:\Users\egagne\Downloads'
zip_file_path = os.path.join(save_folder, 'all_star_csvs.zip')

# Create a compressed ZIP file containing only your star-themed CSVs
with zipfile.ZipFile(zip_file_path, 'w', zipfile.ZIP_DEFLATED) as zip_archive:
    for file in os.listdir(save_folder):
        # Filter to include only the CSV files you generated
        if file.endswith('.csv') and 'stars' in file:
            file_full_path = os.path.join(save_folder, file)
            # Add the file to the ZIP while keeping its original name
            zip_archive.write(file_full_path, arcname=file)

# Display a clickable link to download the ZIP
display(FileLink(zip_file_path))

When you run this code, a clickable link will appear in your Jupyter Lab notebook. Click it to download the entire ZIP archive with all 200+ CSV files at once.

内容的提问来源于stack exchange，提问作者LMGagne