我有一个约300万细胞的Excel电子表格。 我问了下面的问题,我喜欢将电子表格保存为CSV然后用python处理它的答案:
解决方案可对300万个数据点执行大量计算并制作图表
有没有一个我可以使用的库,将csv读入矩阵,或者我应该自己写一个吗? python会不会用VBA说话? 在我完成数据处理之后,是否可以简单地将它放回CSV格式,以便我可以在Excel中打开它进行查看?i have an excel spreadsheet of about 3 million cells. i asked the following question and i liked the answer about saving the spreadsheet as CSV and then processing it with python:
solution to perform lots of calculations on 3 million data points and make charts
is there a library that i can use that will read the csv into a matrix or should i write one myself? does python speak with VBA at all? after i am done processing the data, is it simple to put it back in the form of a CSV so that i can open it in excel for viewing?最满意答案
有没有一个我可以使用的库,将csv读入矩阵,或者我应该自己写一个吗?
csv模块处理你想要的任何东西。
python会不会用VBA说话?
铁蟒可能。
在我完成数据处理之后,是否可以简单地将它放回CSV格式,以便我可以在Excel中打开它进行查看?
csv模块处理你想要的任何东西。
建议:阅读: http : //docs.python.org/library/csv.html
is there a library that i can use that will read the csv into a matrix or should i write one myself?
The csv module handles just about everything you could want.
does python speak with VBA at all?
Iron Python might.
after i am done processing the data, is it simple to put it back in the form of a CSV so that i can open it in excel for viewing?
The csv module handles just about everything you could want.
Suggestion: Read this: http://docs.python.org/library/csv.html
更多推荐
发布评论