Re: Re: help! to input data...
- To: mathgroup at smc.vnet.net
- Subject: [mg4394] Re: [mg4228] Re: help! to input data...
- From: welter at .ti.com (Jason Welter)
- Date: Mon, 15 Jul 1996 10:31:57 -0400
- Organization: Texas Instruments
- Sender: owner-wri-mathgroup at wolfram.com
In article <4qqn4c$49m at dragonfly.wolfram.com>, jfultz at wolfram.com says... > >> In article <4pit53$jk5 at dragonfly.wolfram.com>, tcdoe+ at pitt.edu says... >> > >> >well, silly me. >> >I thought i was pretty good at the basics of mathematica, but today i >> >tried to input some numerical data that was comma delimited. i.e. >> > >> >456,-45,21,0,5 >> >43,25,3,66,65 >> >... >> >... >> >... >> > >> >it is a large data file (10Mb+) with 5 numbers per line. i can't >> >convert the commas to tabs easily. >> >> You don't need to convert the commas to tabs. >> >> Solution #1: Open the file and put a "{" before the first number >> and a "}" after the last. This creats one big list and can be >> read in using something like data = <<"C:\\temp\\data.txt"; > >BAD!! Don't do this! You will get erroneous data and Mathematica will >never tell you there were any errors. Here's what happens. Create the >sample data file: > >{1,2,3,4 >5,6,7,8} This is close but not the way real comma delimited files look. I took his word for it and assumed it was really comma delimited. If the data did look like: 1,2,3,4 5,6,7,8 then it would be comma and return delimited. If that was the case, a global search and replace of the return character with either a "," + return or "},{" + return is easy enough. In either case I find it easier to do the search and replace than to remember "Map[First, ReadList["d:\\tmp\\foo", {Number, Character}]]"! Can it get any more obscure? BUT... John, do you know of a way to read this into MMA: Intradie---> [ACON] # TestName[ACT245P ] [ PMC1] [ PMC2] [ PMC3] [ PMC4] [ PMC5] ---------------------- ---------- ---------- ---------- ---------- ---------- 1 [CONTI_M1 ] & 0.00000 & 1.00000 & 1.00000 & 1.00000 & 2.00000 Intradie---> [ACHNB] # TestName[ACT245P ] [ PMC1] [ PMC2] [ PMC3] [ PMC4] [ PMC5] ---------------------- ---------- ---------- ---------- ---------- ---------- 2 [CA_GOI_GOE_NM ] -19.5000 -19.3000 -19.6000 -20.0000 -19.7000 3 [CA_GOI_GOE_PM ] 18.0000 17.8000 18.0000 18.4000 18.2000 4 [CH_1.00_NM_TR ] 121.853 115.612 188.382 168.093 273.507 5 [CH_1.00_NM_TH ] 125.392 162.555 164.442 244.348 251.892 6 [CH_1.00_PM_TR ] 3.44601 3.30223 3.10842 3.45061 4.58194 7 [CH_1.00_PM_TH ] 2.25403 2.03261 2.07853 2.33058 3.10277 Intradie---> [ACON] # TestName[ACT245P ] [ PMC1] [ PMC2] [ PMC3] [ PMC4] [ PMC5] ---------------------- ---------- ---------- ---------- ---------- ---------- 1 [CONTI_M1 ] & 0.00000 & 1.00000 & 1.00000 & 1.00000 & 2.00000 Intradie---> [ACHNB] # TestName[ACT245P ] [ PMC1] [ PMC2] [ PMC3] [ PMC4] [ PMC5] ---------------------- ---------- ---------- ---------- ---------- ---------- 2 [CA_GOI_GOE_NM ] -19.5000 -19.3000 -19.6000 -20.0000 -19.7000 3 [CA_GOI_GOE_PM ] 18.0000 17.8000 18.0000 18.4000 18.2000 4 [CH_1.00_NM_TR ] 121.853 115.612 188.382 168.093 273.507 5 [CH_1.00_NM_TH ] 125.392 162.555 164.442 244.348 251.892 6 [CH_1.00_PM_TR ] 3.44601 3.30223 3.10842 3.45061 4.58194 7 [CH_1.00_PM_TH ] 2.25403 2.03261 2.07853 2.33058 3.10277 etc. I have about a dozen files each hundreds of K large and am having to load it into Excel, parse & sort & prep for mathematica. I need the numbers to be recognized as numbers by MMA, not characters. Ideally the data would look like: {{1,{1,0.00000,1.00000,1.00000,1.00000,2.00000}, {2,-19.500,-19.300,-19.600,-20.000,-19.700}, {3,18.0000,17.8000,18.0000,18.4000,18.2000}, {4,121.853,115.612,188.382,168.093,273.507}, {5,125.392,162.555,164.442,244.348,251.892}, {6,3.44601,3.30223,3.10842,3.45061,4.58194}, {7,2.25403,2.03261,2.07853,2.33058,3.10277}}, {2,{1,0.00000,1.00000,1.00000,1.00000,2.00000}, {2,-19.500,-19.300,-19.600,-20.000,-19.700}, {3,18.0000,17.8000,18.0000,18.4000,18.2000}, {4,121.853,115.612,188.382,168.093,273.507}, {5,125.392,162.555,164.442,244.348,251.892}, {6,3.44601,3.30223,3.10842,3.45061,4.58194}, {7,2.25403,2.03261,2.07853,2.33058,3.10277}}} Jason Welter ==== [MESSAGE SEPARATOR] ====