Re: Creating a new table using values from a column in another table,
- To: mathgroup at smc.vnet.net
- Subject: [mg66370] Re: Creating a new table using values from a column in another table,
- From: bghiggins at ucdavis.edu
- Date: Thu, 11 May 2006 02:14:23 -0400 (EDT)
- References: <e3sgqp$lsf$1@smc.vnet.net>
- Sender: owner-wri-mathgroup at wolfram.com
Michael, Try this.
First some data:
data=Table[{i,2 i+3+Random[]},{i,0.5,3,0.5}]
{{0.5,4.01533},{1.,5.95668},{1.5,6.34622},{2.,7.95788},{
2.5,8.4528},{3.,9.2798}}
Now lets fit the dat to a function
f[x_]=Fit[data,{1,x},x]
3.45921+2.02414 x
Then we use a rule to get the new table
newdata=data/.{x_,y_}\[Rule]{x,f[x]}
{{0.5,4.47128},{1.,5.48335},{1.5,6.49542},{2.,7.50748},{
2.5,8.51955},{3.,9.53162}}
Hope this helps,
Cheers,
Brian