擅长:python、mysql、java
<p><strong>文件1.csv</strong>:</p>
<pre><code>2015/1/2,Jina,17
2015/1/3,JJ,25
2015/1/4,Carole,8
</code></pre>
<p><strong>文件2.csv</strong>:</p>
<pre><code>2015/1/1,Rouba,14
2015/1/2,GG,78
2015/1/3,James,7
2015/1/4,Elie,15
</code></pre>
<p>您的解决方案:</p>
<pre><code>import pandas as pd
df1 = pd.read_csv('file1.csv', names=["Name", "Age"], index_col=0,
header=-1)
df2 = pd.read_csv('file2.csv', names=["Name", "Age"], index_col=0,
header=-1)
df = pd.concat([df2, df1], axis=1)
df.to_csv('filex.csv', header=False)
</code></pre>
<p><strong>文件x.csv</strong>:</p>
<pre><code>2015/1/1,,,Rouba,14
2015/1/2,GG,78,Jina,17
2015/1/3,James,7,JJ,25
2015/1/4,Elie,15,Carole,8
</code></pre>
<p>如果要删除<code>filex.csv</code>中的多个逗号,请执行以下操作:</p>
<pre><code>import re
with open('filex.csv', 'r') as desc:
filex = re.sub(',+', ',', desc.read())
with open('filex.txt', 'w') as desc:
desc.write(filex)
</code></pre>
<p><strong>文件x.txt</strong>:</p>
<pre><code>2015/1/1,Rouba,14,
2015/1/2,GG,78,Jina,17
2015/1/3,James,7,JJ,25
2015/1/4,Elie,15,Carole,8
</code></pre>