Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.soft-sys.math.mathematica > #2157

Re: Import speed from different file types

Show all headers | View raw

On 5/4/11 at 7:47 PM, hisicon@gmail.com (CPE Bach) wrote:

>Hi users, So I have hundreds of data files of time series of stock
>returns. To make the import process as fast as possible in
>Mathematica 8, should I prepare those data files in what format?

>xls? csv? dat? txt?

Using xls format will be the slowest since Import has to do more
work to convert this into a Mathematica format. But while it is
easy to identify the slowest format, it isn't so easy to
identify the fastest format without knowing more about the data itself.

If you have mixed data types and will be using Import to read
the data then there will likely be little difference between csv
and txt. The dat extension isn't well defined. So, I cannot
predict performance. By not well defined, I mean different
programs will output data in different formats despite
consistently using the .dat file name extension.

Back to comp.soft-sys.math.mathematica | Previous | Next | Find similar | Unroll thread

Thread

Re: Import speed from different file types Bill Rowe <readnews@sbcglobal.net> - 2011-05-07 11:32 +0000

csiph-web