擅长:python、mysql、java
<p>您可以按cityName列对行进行分组,然后将每个组导出为单独的csv,如下所示:</p>
<p>编辑:将保存结果添加到csv文件</p>
<p>编辑:添加所有文件</p>
<pre><code>import zipfile
import pandas as pd
df = pd.DataFrame(
data={'col1': ['a', 's', 'd', 'f', 'x'], 'col2': [5, 10, 0, 2, 4],
'cityName': ['Madrid', 'NEWYORK', 'London', 'Berlin', 'Madrid']})
groupby = df.groupby('cityName')
out_zip = zipfile.ZipFile("58377674.zip", "w")
for n, g in groupby:
print(n)
csv = g.to_csv(index=False)
print(csv)
csv_filename = "{}.csv".format(n)
with open(csv_filename, 'w') as out_file:
out_file.write(csv)
out_zip.write(csv_filename)
</code></pre>