无关联条件无主键的两个CSV文件简单合并实现方法咨询

Got it, so you want to merge two CSV files without any matching keys or conditions—just combine their headers into one, then merge the data accordingly. There are two common interpretations of this request, so I’ll cover both scenarios with practical, easy-to-implement solutions.

1. Horizontal Merge (Side-by-Side, Same Row Count) #

If your two CSVs have the same number of rows and you want to stick each row from file1.csv next to the corresponding row in file2.csv (with a combined header row):

Using Python (Pandas) #

This is the most reliable method, especially if your CSVs contain quoted fields or special characters:

import pandas as pd

# Load both CSV files into DataFrames
df1 = pd.read_csv("file1.csv")
df2 = pd.read_csv("file2.csv")

# Concatenate columns (axis=1) to merge headers and rows side-by-side
merged_df = pd.concat([df1, df2], axis=1)

# Save the result to a new CSV (index=False avoids adding an extra index column)
merged_df.to_csv("merged_output.csv", index=False)

Using Command Line (Linux/macOS/WSL) #

If you prefer shell tools, use paste—just ensure both files have the exact same row count:

# Write the combined header first
head -n 1 file1.csv > merged_output.csv
# Append file2's header (replace newline with comma, then add a fresh newline)
head -n 1 file2.csv | tr '\n' ',' >> merged_output.csv && echo >> merged_output.csv
# Paste data rows side-by-side using commas as separators
tail -n +2 file1.csv | paste -d ',' - file2.csv >> merged_output.csv

2. Cross Merge (Cartesian Product: All Row Combinations) #

If you need every possible pair of rows from file1.csv and file2.csv (e.g., every row in file1 paired with every row in file2):

Using Python (Pandas) #

We’ll use a temporary dummy key to perform a cross join:

import pandas as pd

df1 = pd.read_csv("file1.csv")
df2 = pd.read_csv("file2.csv")

# Add a temporary dummy column to both DataFrames
df1["_temp_key"] = 1
df2["_temp_key"] = 1

# Merge on the dummy key to get all combinations, then drop the temporary column
cross_merged = pd.merge(df1, df2, on="_temp_key").drop("_temp_key", axis=1)

# Save the cross-merged result
cross_merged.to_csv("cross_merged_output.csv", index=False)

Using Command Line (Awk) #

This awk script handles the cross join and combined headers in one go:

awk '
BEGIN {FS=OFS=","}
# Read file1 first: store its header and data rows
NR==FNR {
    if (FNR == 1) header1 = $0;
    else rows[++row_count] = $0;
    next;
}
# Process file2
{
    if (FNR == 1) {
        # Print the combined header row
        print header1 "," $0;
        next;
    }
    # Print every row from file1 paired with the current file2 row
    for (i=1; i<=row_count; i++) {
        print rows[i] "," $0;
    }
}
' file1.csv file2.csv > cross_merged_output.csv

Quick Notes: #

• If your CSVs have quoted fields with commas inside, command line tools may break—stick with pandas, which properly parses CSV formatting rules.
• For horizontal merges with unequal row counts: pandas will fill missing values with NaN, while paste will stop at the shorter file’s last row.

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