[Date Index] [Thread Index] [Author Index]
Import[filename,"CSV"] is so slooooooooow!
Hi. I'm getting data in CSV files to analyze. With the new ver. 4.2 I can get these data in nicely using data = Import["filename", "CSV"] but it takes 30 seconds to get in a 100kB file. And I've got to do some much longer files. On the other hand, if I change all the comma delimiters to spaces, I can get the data in using inFile = OpenRead["filename"]; y = ReadList[inFile, Number, RecordLists -> True]; Close[inFile]; This pulls in the same 100kB file in a second or so. But, doing this comma to space conversion is truly slow (using Word). So, can someone out there enlighten me with a suggestion on how to either speed up Import or get ReadList to handle comma delimiters? Thanks and Regards, Rob