如何将Python脚本中print输出的多段数据导出至CSV或Excel？

Got it, let's break this down for you. You’ve got a Python script that prints dates plus other loop-generated data, and you want to either capture all that on-screen output or export the underlying data to CSV/Excel. Here are a few practical approaches tailored to your needs:

If you don’t want to rewrite your existing print statements, you can redirect Python’s standard output (all the text that goes to your screen) to a buffer or file, then convert that to CSV/Excel. This is perfect for quick fixes without touching your core logic.

Example: Capture Output & Export to CSV #

from contextlib import redirect_stdout
import io
import csv

# Capture all print output in memory
output_buffer = io.StringIO()
with redirect_stdout(output_buffer):
    # Paste YOUR entire script here (the date prints + looped print statements)
    # Example of your existing code:
    print("2024-01-01")
    print("2024-01-02")
    for i in range(3):
        print(f"Metric {i}: {i * 20}")

# Extract captured lines
all_output = output_buffer.getvalue().splitlines()

# Write to CSV
with open('full_output.csv', 'w', newline='', encoding='utf-8') as csv_file:
    writer = csv.writer(csv_file)
    # If each print line is a single value, write each as a row
    for line in all_output:
        writer.writerow([line])  # Wrap in list to ensure it's treated as a single cell

Export to Excel (Using Pandas) #

If you prefer Excel, use Pandas to convert the captured lines into a spreadsheet:

import pandas as pd

# Use the same all_output list from the previous example
df = pd.DataFrame(all_output, columns=['Script Output'])
df.to_excel('full_output.xlsx', index=False)

Note: If your print lines have multiple values (e.g., print("2024-01-01", "Sales", 1500)), you’ll need to split each line into columns first (e.g., line.split() or line.split(',')) before writing to CSV/Excel.

This approach is more robust because it separates data generation from printing/exporting. Instead of printing directly, you’ll store your data in a list/dictionary first, then print it AND export it. This gives you cleaner, structured output files.

Example: Structured Data Collection & Export #

import csv
import pandas as pd

# Initialize a list to store all your data
structured_data = []

# Part 1: Date output (collect + print)
dates = ["2024-01-01", "2024-01-02", "2024-01-03"]
for date in dates:
    print(date)
    # Store with a label for clarity
    structured_data.append({"Type": "Date", "Value": date})

# Part 2: Loop-generated data (collect + print)
for idx in range(3):
    metric_value = idx * 20
    print(f"Metric {idx}: {metric_value}")
    structured_data.append({"Type": "Metric", "Value": metric_value, "Index": idx})

# Export to CSV (with headers!)
with open('structured_output.csv', 'w', newline='', encoding='utf-8') as csv_file:
    fieldnames = ["Type", "Value", "Index"]
    writer = csv.DictWriter(csv_file, fieldnames=fieldnames)
    writer.writeheader()
    writer.writerows(structured_data)

# Export to Excel (structured columns)
df = pd.DataFrame(structured_data)
df.to_excel('structured_output.xlsx', index=False)

No Pandas? Export Excel with OpenPyXL #

If you can’t install Pandas, use the openpyxl library directly:

from openpyxl import Workbook

wb = Workbook()
ws = wb.active

# Add header row
ws.append(["Type", "Value", "Index"])

# Add data rows
for item in structured_data:
    ws.append([item["Type"], item["Value"], item.get("Index", "")])

wb.save('structured_output_openpyxl.xlsx')

Quick Recap #

• Use the output capture method if you want to avoid modifying your existing print code.
• Use the structured data collection method if you want clean, organized CSV/Excel files that are easy to analyze later.

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