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


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

Importing a file and extracting data

From howardfink@gmail.com
Newsgroups comp.soft-sys.math.mathematica
Subject Importing a file and extracting data
Date 2013-06-14 08:54 +0000
Message-ID <kpeln9$htb$1@smc.vnet.net> (permalink)
Organization Time-Warner Telecom

Show all headers | View raw


I have a series of files of this form:

June 7, 2013      
Tc+Naphthalene  vs Temperature (oC)

Run 1
Tc_Naph_84_2C			3.740 ns
Tc_Naph_87_1C			3.731 ns
Tc_Naph_89_9C			3.720 ns
Tc_Naph_92_9C			3.704 ns
Tc_Naph_94_7C			3.687 ns
Tc_Naph_97_6C			3.694 ns


Run 2
Tc_Naph_83_2C			3.758 ns
Tc_Naph_83_4C			3.750 ns
Tc_Naph_86_4C			3.728 ns
Tc_Naph_88_1C			3.725 ns
Tc_Naph_90_2C			3.716 ns
Tc_Naph_93_1C			3.704 ns
Tc_Naph_94_7C			3.673 ns
Tc_Naph_97_7C			3.684 ns
Tc_Naph_97_9C			3.665 ns




I used an Import command to read in the file, but now I am just sitting and=
 staring, without a clue how to get the 84_2 converted to the number 84.2,e=
tc. and ending up with two lists: Run 1 and Run 2, consisting of pairs of t=
emperature and time.  The temperature will eventually be converted to 1/abs=
olute temperature.

I've read lots and lots of help, thumbed through dozens of pages of a Mathe=
matica 5 manual, and don't know where to start.  I'm trying to help a 90-ye=
ar-old chemistry professor, who is currently using a calculator, but  there=
 will be dozens of runs of this experiment.

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


Thread

Importing a file and extracting data howardfink@gmail.com - 2013-06-14 08:54 +0000
  Re: Importing a file and extracting data David Bailey <dave@removedbailey.co.uk> - 2013-06-15 08:13 +0000
  Re: Importing a file and extracting data Helen Read <readhpr@gmail.com> - 2013-06-15 08:13 +0000

csiph-web