如何去除 与 并将列表转为数组，提取16*2矩阵数据

Got it, let's break down how to get your 16×2 data matrix cleaned up into proper tab-separated columns, removing any extra tabs or newlines along the way. Since you've already figured out skipping the header with [1:17], we'll focus on the formatting step using two common tools—Python (great for flexibility) and bash/awk (quick command-line fix).

Python Implementation #

This approach gives you full control over the data processing, perfect if you need to extend the workflow later.

1. Read the file and extract your target rows:

with open('your_data_file.txt', 'r') as input_file:
    # Skip the header line, grab the next 16 lines to form your 16x2 matrix
    target_lines = input_file.readlines()[1:17]

2. Clean and reformat each line:

formatted_rows = []
for line in target_lines:
    # Strip off any leading/trailing whitespace (including newlines)
    cleaned_line = line.strip()
    # Split the line by any number of spaces, then rejoin with a single tab
    tab_separated_line = '\t'.join(cleaned_line.split())
    formatted_rows.append(tab_separated_line)

3. Output or save the result:

# Print the formatted matrix directly to console
for row in formatted_rows:
    print(row)

# Or save to a new tab-separated text file
with open('formatted_16x2_matrix.txt', 'w') as output_file:
    output_file.write('\n'.join(formatted_rows))

Key Notes: #

• line.strip() removes all leading/trailing whitespace (including newlines and stray tabs)
• cleaned_line.split() automatically handles any number of spaces between columns (so even if some lines have multiple spaces, it still works)
• '\t'.join(...) replaces those spaces with a single tab to get your clean two-column layout

Quick Command-Line Fix with Awk #

If you prefer a one-liner without writing a full script, awk is perfect for this:

awk 'NR > 1 && NR <= 17 { gsub(/ +/, "\t"); print }' your_data_file.txt > formatted_matrix.txt

What this does: #

• NR > 1 && NR <=17: Targets rows 2 to 17 (skips the header, grabs exactly 16 rows)
• gsub(/ +/, "\t"): Replaces one or more spaces with a single tab
• print: Outputs the reformatted line
• The > formatted_matrix.txt saves the result to a new file instead of printing to console

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