nmacsai

280 Reputation

9 Badges

4 years, 154 days

MaplePrimes Activity


These are replies submitted by nmacsai

Invaluable Response Thank You@Scot Gould 

@mmcdara This is good to keep in mind!  I wondered how far I'd get with csv. 

The data set I am working with is a csv file.  Is there a way to convert it into a binary format? convert(n,binary) ?  I wasn't sure when to do the conversion.  Do I:

1.  Import the data as a csv, then convert to binary and proceed with manipulations?  Seems non-ideal because I still have to use the csv at the start.  Not sure.
2. Somehow convert it to binary before it is imported?  Or at the import stage?  Not sure.

@acer Yes the datatable method was what I had in mind.  Thank you very much.  Your response is much appreciated.

Lesson:  Importing string columns takes longer than importing plain numerics.  This kind of solves my speed issue however my question still stands.  Can I save imported data variables into the worksheet so I don't have reduently call importdata when troubleshooting.

1 2 3 Page 3 of 3