擅长:python、mysql、java
<p>简单/简单/快速>;将您的数据从Pandas下载到拆分1000000的CSV,然后让Excel打开它。Excel将相应地调整并打开多个工作表</p>
<p>您可以调整一些代码:</p>
<pre><code>#split file code
lines_per_file = 1000000
smallfile = None
with open('Plan.txt') as bigfile:
for lineno, line in enumerate(bigfile):
if lineno % lines_per_file == 0:
if smallfile:
smallfile.close()
small_filename = 'small_file_{}.txt'.format(lineno + lines_per_file)
smallfile = open(small_filename, "w")
smallfile.write(line)
if smallfile:
smallfile.close()
</code></pre>