Python读取无表头.txt文件并实现数据绘图方法咨询

Hey there! Let's break down how to read that formatted .txt file and visualize your experiment data with Python. I'll cover two approaches: a basic native Python method, and a more efficient one using pandas.

Step 1: Understand Your File Structure #

First, let's recap the structure to make sure we're targeting the right parts:

• Lines 1-3: Metadata (experiment ID, date, column headers)
• Line 4 onwards: Tabular data with columns: Index, A, B, C

Step 2: Read and Parse the File #

Option 1: Native Python (No External Libraries) #

If you prefer not to use pandas, this method uses built-in functions to extract the data:

# Replace 'experiment_data.txt' with your actual file path
with open('experiment_data.txt', 'r') as f:
    # Skip the first 3 metadata lines
    for _ in range(3):
        next(f)
    
    # Initialize lists to store each column's values
    indices = []
    a_vals = []
    b_vals = []
    c_vals = []
    
    # Process each data line
    for line in f:
        # Remove extra whitespace and split into columns
        data = line.strip().split()
        if not data:  # Skip empty lines if present
            continue
        # Convert values to appropriate types
        indices.append(int(data[0]))
        a_vals.append(float(data[1]))
        b_vals.append(float(data[2]))
        c_vals.append(float(data[3]))

Option 2: Using Pandas (Faster for Tabular Data) #

Pandas simplifies parsing tabular data, especially if your file has consistent formatting:

import pandas as pd

# Read the file: skip first 3 rows, set column names, use whitespace as separator
df = pd.read_csv(
    'experiment_data.txt',
    skiprows=3,
    sep='\s+',  # Handles spaces/tabs as separators
    names=['Index', 'A', 'B', 'C']
)

# Check the parsed data (optional)
print(df.head())

Step 3: Plot the Data with Matplotlib #

Once you have the data parsed, use matplotlib to create your plots.

Plotting with Native Python Data #

import matplotlib.pyplot as plt

plt.figure(figsize=(10, 6))

# Plot each dataset with unique markers and labels
plt.plot(indices, a_vals, label='A', marker='o', color='blue')
plt.plot(indices, b_vals, label='B', marker='s', color='green')
plt.plot(indices, c_vals, label='C', marker='^', color='red')

# Add plot details
plt.xlabel('Sample Index')
plt.ylabel('Measurement Value')
plt.title('Experiment 1: A, B, C Measurements')
plt.legend()
plt.grid(alpha=0.3)

# Display the plot
plt.show()

Plotting with Pandas DataFrame #

Pandas integrates directly with matplotlib for quick plotting:

import matplotlib.pyplot as plt

df.plot(
    x='Index',
    y=['A', 'B', 'C'],
    figsize=(10, 6),
    marker=['o', 's', '^'],
    color=['blue', 'green', 'red']
)

plt.xlabel('Sample Index')
plt.ylabel('Measurement Value')
plt.title('Experiment 1: A, B, C Measurements')
plt.grid(alpha=0.3)
plt.show()

Quick Notes #

• Replace 'experiment_data.txt' with the full path to your file if it's not in your working directory.
• If your file has inconsistent lines (e.g., missing values), add try-except blocks in the native Python method to handle errors gracefully.
• The sep='\s+' in pandas works for any number of spaces or tabs between columns—perfect for your data format.

内容的提问来源于stack exchange，提问作者L. Rivera