second_parsedata.py

import pandas as pd

# Read the file and extract relevant lines based on the '#' symbol
with open('your_file_path') as file:
    lines = file.readlines()
    start_row = None
    for i, line in enumerate(lines):
        if line.startswith('# Data lines:'):
            start_row = i + 2  # Skip two lines after the metadata line
            break

# Read the file again, skipping the metadata lines dynamically
data = pd.read_csv('your_file_path', delimiter=';', skiprows=start_row)

# Preview the extracted data
print(data.head())