Hey Julian, great call using the python-can library's BLFReader—that's exactly the right approach for parsing BLF files in Python, so your initial code is already on solid ground! Let's build out the rest of the script to export that CAN data to a clean CSV file.

Step-by-Step Breakdown #

1. Add the CSV module: Python's built-in csv module will handle all the heavy lifting for writing formatted CSV rows.
2. Define output details: Pick a filename for your CSV and outline the data fields you want to include (timestamp, arbitration ID, payload, etc.).
3. Iterate through CAN messages: Pull the key data points from each message in the BLF log, format them for readability, and write them to the CSV.

Complete Working Code #

import can
import csv

# Load your BLF file (your existing code is correct!)
filename = "test.blf"
log = can.BLFReader(filename)

# Set your output CSV filename
output_csv = "can_data_export.csv"

# Open the CSV file and start writing
with open(output_csv, mode='w', newline='', encoding='utf-8') as csv_file:
    # Define your CSV headers - tweak these based on what data you care about!
    csv_headers = [
        'Timestamp (s)',
        'Arbitration ID',
        'DLC',
        'Channel',
        'Data (Hex)',
        'Is Extended Frame?'
    ]
    
    # Initialize the CSV writer
    writer = csv.DictWriter(csv_file, fieldnames=csv_headers)
    writer.writeheader()
    
    # Loop through every message in the BLF log
    for msg in log:
        # Format raw byte data into a human-readable hex string
        formatted_data = ' '.join(f'{byte:02X}' for byte in msg.data)
        
        # Write the message's data as a new CSV row
        writer.writerow({
            'Timestamp (s)': round(msg.timestamp, 6),  # Round for cleaner output
            'Arbitration ID': msg.arbitration_id,
            'DLC': msg.dlc,
            'Channel': msg.channel,
            'Data (Hex)': formatted_data,
            'Is Extended Frame?': msg.is_extended_id
        })

print(f"Conversion complete! Data saved to {output_csv}")

Quick Customization Tips #

• Add/remove fields: If you need extra data (like is_remote_frame or error_state_indicator), just add the field name to csv_headers and a corresponding entry in the writerow() dictionary.
• Adjust data formatting: If you prefer decimal values instead of hex for the payload, replace the formatted_data line with ' '.join(str(byte) for byte in msg.data).
• Timestamp precision: Remove the round() function around msg.timestamp if you need the full raw precision of the log's timestamps.

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