擅长:python、mysql、java
<pre><code>import numpy as np
import pandas as pd
import itertools
import functools
def cartesian(df1, df2):
rows = itertools.product(df1.iterrows(), df2.iterrows())
df = pd.DataFrame(left.append(right) for (_, left), (_, right) in rows)
return df.reset_index(drop=True)
df1 = pd.read_csv('first_name.csv')
df2 = pd.read_csv('second_name.csv')
df3 = pd.read_csv('first_last_name.csv')
df4 = pd.read_csv('second_last_name.csv')
combined = functools.reduce(cartesian, [df1, df2, df3, df4])
combined.to_csv('combined.csv')
</code></pre>