开始使用python处理数据(getting started with processing data with python)

开始使用python处理数据(getting started with processing data with python)

我有一个约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