Prev: output lines from text file whose string contains a specificword.
Next: problem about read and write data from tcp/ip object
From: Sukumar reddy on 4 Aug 2010 18:36 Hi friends, I had extracted a huge x-y data form get-data software.From that i have to extract y-coordinate values for given data. when i am trying to use 'shape-preserving' curve fitting it is saying "repeated x-values are not permitted when fitting with shape-preserving tool". How to avoid this problem. Even when i am using cubic interpolation also it is giving same error. Data is 1.00455927051672e+002 1.57749681431633e+020 1.01367781155015e+002 1.53662241551511e+020 1.02279635258359e+002 1.52565982949770e+020 1.03191489361702e+002 1.51839492300136e+020 1.07750759878419e+002 1.39671499064437e+020 1.08662613981763e+002 1.41011239906908e+020 1.09574468085106e+002 1.38014708705350e+020 1.10486322188450e+002 1.38014708705350e+020 1.15045592705167e+002 1.29401794346583e+020 1.15957446808511e+002 1.29401794346583e+020 1.16869300911854e+002 1.29093333139781e+020 1.17781155015198e+002 1.26651967350146e+020 1.18693009118541e+002 1.29401794346583e+020 1.22340425531915e+002 1.16224719699318e+020 1.23252279635258e+002 1.14846056218399e+020 1.24164133738602e+002 1.14846056218399e+020 1.25075987841945e+002 1.13754909496946e+020 1.29635258358663e+002 1.08971626412869e+020 1.30547112462006e+002 1.07936292359554e+020 1.31458966565350e+002 1.06655946621342e+020 1.32370820668693e+002 1.04389475720912e+020 1.33282674772036e+002 1.04389475720912e+020 1.35106382978723e+002 9.37594228618377e+019 1.36018237082067e+002 9.37594228618377e+019 1.36930091185410e+002 9.35359240697917e+019 1.37841945288754e+002 9.15482575892567e+019 1.38753799392097e+002 9.19862790296698e+019 1.42401215805471e+002 7.93343062226510e+019 1.43313069908815e+002 7.63619974982418e+019 1.44224924012158e+002 7.40291878788014e+019 1.45136778115502e+002 7.31510499223096e+019 1.46960486322188e+002 6.23413380464450e+019 1.47872340425532e+002 6.16018419535430e+019 1.48784194528875e+002 5.91525492765440e+019 1.49696048632219e+002 5.59930762684964e+019 1.52431610942249e+002 4.91052238172732e+019 1.53343465045593e+002 4.70403970114354e+019 1.54255319148936e+002 4.45278617705510e+019 1.56990881458967e+002 3.72302131281090e+019 1.57902735562310e+002 3.64390599168283e+019 1.58814589665654e+002 3.53258702114477e+019 1.59726443768997e+002 3.47406131553425e+019 1.61550151975684e+002 2.98908986360380e+019 1.62462006079027e+002 2.87710176787761e+019 1.63373860182371e+002 2.73645968790636e+019 1.64285714285714e+002 2.80924994754179e+019 1.65197568389058e+002 3.38404517960145e+019 1.66109422492401e+002 3.60068179521557e+019 1.67021276595745e+002 5.16290179172327e+019 1.67933130699088e+002 5.41531281823024e+019 1.68844984802432e+002 7.45611225369929e+019 1.69756838905775e+002 8.00952876037312e+019 1.70668693009119e+002 8.24223088712977e+019 1.73404255319149e+002 8.04785112080940e+019 1.74316109422492e+002 7.59983759615318e+019 1.75227963525836e+002 7.26291750173621e+019 1.77051671732523e+002 5.65301665959791e+019 1.77963525835866e+002 5.31290040751122e+019 1.78875379939210e+002 5.08949812308224e+019 1.80699088145897e+002 4.22502406926099e+019 1.81610942249240e+002 4.04736592466149e+019 1.82522796352584e+002 3.84951753139139e+019 1.83434650455927e+002 3.80385436048061e+019 1.86170212765957e+002 3.27284451218421e+019 1.87082066869301e+002 3.14271603156678e+019 1.87993920972644e+002 3.07593237196317e+019 1.91641337386018e+002 2.87710176787761e+019 1.92553191489362e+002 2.75612244242860e+019 1.93465045592705e+002 2.69755401270978e+019 1.94376899696049e+002 2.74955254238216e+019 1.96200607902736e+002 2.47546457872377e+019 1.97112462006079e+002 2.42286021290589e+019 1.98024316109423e+002 2.35445582917798e+019 1.98936170212766e+002 2.36008166800921e+019 2.02583586626140e+002 2.08961527841945e+019 2.03495440729483e+002 2.07470752554427e+019 2.04407294832827e+002 1.97800414500060e+019 2.07142857142857e+002 1.67368336706157e+019 2.08054711246201e+002 1.63031668587946e+019 2.08966565349544e+002 1.66571360019015e+019 2.11702127659574e+002 1.36964691474339e+019 2.12613981762918e+002 1.34695545614865e+019 2.13525835866261e+002 1.28111189819863e+019 2.15349544072948e+002 1.14244636688075e+019 2.16261398176292e+002 1.16169256712624e+019 2.17173252279635e+002 1.07371057501752e+019 2.18996960486322e+002 9.23822899117573e+018 2.19908814589666e+002 8.84977046524722e+018 2.20820668693009e+002 9.12864465342511e+018 2.22644376899696e+002 7.27679765148664e+018 2.23556231003040e+002 7.13918152203712e+018 2.24468085106383e+002 7.52403969200924e+018 2.25379939209726e+002 5.99770463624766e+018 2.26291793313070e+002 6.08420698148466e+018 2.28115501519757e+002 4.99086459912334e+018 2.29027355623100e+002 5.32305388278445e+018 2.27203647416413e+002 4.62389849606648e+018 2.30851063829787e+002 4.16296716145305e+018 2.31762917933131e+002 3.95002943265393e+018 2.32674772036474e+002 3.77491459992735e+018 2.34498480243161e+002 3.22477316233321e+018 2.35410334346505e+002 3.00195821881950e+018 2.36322188449848e+002 3.01632137654301e+018 2.39057750759878e+002 2.73515383638310e+018 2.38145896656535e+002 2.45077523181657e+018 2.37234042553192e+002 2.40442706910732e+018 2.40881458966565e+002 1.95827628020320e+018 2.41793313069909e+002 1.88041510591786e+018 2.42705167173252e+002 1.86699983087116e+018 2.43617021276596e+002 1.66094996791044e+018 2.45440729483283e+002 1.98178430548473e+018 2.44528875379939e+002 1.68893112887069e+018 2.45440729483283e+002 1.73385696348838e+018 2.47264437689970e+002 1.70513149922989e+018 2.48176291793313e+002 1.37554339287662e+018 2.49088145896657e+002 1.44969602665763e+018 2.50000000000000e+002 1.52784607202531e+018 2.50911854103343e+002 1.46011277689517e+018 2.52735562310030e+002 1.65699068253788e+018 2.53647416413374e+002 1.60637068921415e+018 2.54559270516717e+002 1.71738367390861e+018 2.55471124620061e+002 1.60637068921415e+018 2.56382978723404e+002 1.64910040310520e+018 2.58206686930091e+002 1.36247442287647e+018 2.59118541033435e+002 1.42567836414202e+018 2.57294832826748e+002 1.78423098859853e+018 2.60030395136778e+002 1.53515619845285e+018 2.60942249240122e+002 1.56101817715054e+018 2.61854103343465e+002 1.62565428221649e+018 2.62765957446809e+002 1.41213306425011e+018 2.63677811550152e+002 1.47411830225234e+018 2.64589665653495e+002 1.39205603166129e+018 2.65501519756839e+002 1.35598657473727e+018 2.67325227963526e+002 1.08608134690380e+018 2.68237082066869e+002 1.08090963085011e+018 2.69148936170213e+002 8.93039455148428e+017 2.68237082066869e+002 7.94479908270492e+017 2.70972644376900e+002 7.25598735841973e+017 2.70060790273556e+002 7.05112975213013e+017 2.71884498480243e+002 6.81942766398754e+017 2.72796352583587e+002 7.18704858004329e+017 2.75531914893617e+002 5.93788579994357e+017 2.73708206686930e+002 4.97659165105754e+017 2.76443768996960e+002 5.64762265428089e+017 2.74620060790274e+002 4.80158634432028e+017 2.75531914893617e+002 4.75596670904592e+017 2.76443768996960e+002 4.27166331386152e+017 2.78267477203647e+002 4.50193964464750e+017 2.79179331306991e+002 4.61067500306539e+017 2.77355623100304e+002 3.98601539577781e+017 2.80091185410334e+002 4.39576863486890e+017 2.79179331306991e+002 3.62309400149927e+017 2.80091185410334e+002 3.71946887382726e+017 2.81003039513678e+002 3.74619501335066e+017 2.82826747720365e+002 4.24118837347096e+017 2.80091185410334e+002 3.01488197369647e+017 2.79179331306991e+002 2.88122460189316e+017 2.81914893617021e+002 3.28536592116547e+017 2.82826747720365e+002 3.23093602104580e+017 2.83738601823708e+002 4.68834864880347e+017 2.83738601823708e+002 3.30108507028930e+017 2.84650455927052e+002 3.66658724412577e+017 2.86474164133739e+002 3.16227766016838e+017 2.86474164133739e+002 4.09204403447902e+017 2.87386018237082e+002 3.53764915349485e+017 2.84650455927052e+002 2.47310253560524e+017 2.85562310030395e+002 2.58782749834918e+017 2.88297872340426e+002 3.96703473666663e+017 2.89209726443769e+002 3.75514633412479e+017 2.90121580547112e+002 3.28536592116547e+017 2.91033434650456e+002 3.26192743286425e+017 2.90121580547112e+002 2.77327774473965e+017 2.89209726443769e+002 2.50877104252846e+017 2.89209726443769e+002 4.33327169858903e+017 2.91945288753799e+002 3.02930696636776e+017 2.92857142857143e+002 3.51241082379653e+017 2.93768996960486e+002 3.27753443828730e+017 2.90121580547112e+002 2.26949217609656e+017 2.94680851063830e+002 3.01488197369647e+017 2.94680851063830e+002 4.04350400196921e+017 2.91033434650456e+002 2.30222409732904e+017 2.95592705167173e+002 3.80930521394804e+017 2.95592705167173e+002 2.94378082868418e+017 2.96504559270517e+002 3.42957626061815e+017 2.97416413373860e+002 3.37275717324781e+017 2.98328267477204e+002 3.93873308032240e+017 2.99240121580547e+002 3.91063333391972e+017 2.99240121580547e+002 2.95786563109108e+017 2.98328267477204e+002 2.72733180316955e+017 3.00151975683891e+002 2.94378082868418e+017 2.97416413373860e+002 2.46720728356078e+017 3.01063829787234e+002 3.34071277352676e+017 3.01975683890578e+002 3.21555090856217e+017 3.02887537993921e+002 3.11731790867939e+017 3.03799392097264e+002 3.09507831008154e+017 3.06534954407295e+002 2.66301206670038e+017 3.05623100303951e+002 2.86750474971969e+017 3.03799392097264e+002 2.16887982634897e+017 3.02887537993921e+002 2.26949217609656e+017 3.06534954407295e+002 3.37275717324781e+017 3.05623100303951e+002 2.30222409732904e+017 3.04711246200608e+002 2.14827340598355e+017 3.07446808510638e+002 3.30897282606857e+017 3.09270516717325e+002 2.90192756065437e+017 3.08358662613982e+002 3.06567212355768e+017 3.07446808510638e+002 2.52077449878915e+017 3.06534954407295e+002 2.28579954862828e+017 3.10182370820669e+002 2.55103500454395e+017 3.05623100303951e+002 1.88851049636783e+017 3.12006079027356e+002 2.90192756065437e+017 3.11094224924012e+002 2.29126133716630e+017 3.10182370820669e+002 2.10262195086014e+017 3.12917933130699e+002 2.71434475969404e+017 3.13829787234043e+002 3.33274935772635e+017 3.12917933130699e+002 3.65784702586312e+017 3.14741641337386e+002 3.38081618545710e+017 3.14741641337386e+002 2.48493533246518e+017 3.15653495440730e+002 2.80656941251662e+017 3.17477203647416e+002 3.16227766016838e+017 3.16565349544073e+002 2.21068753862271e+017 3.17477203647416e+002 2.44376646872353e+017 3.18389057750760e+002 2.85385022891383e+017 3.19300911854103e+002 2.56324067679441e+017 3.17477203647416e+002 2.10262195086014e+017 3.20212765957447e+002 2.39183569726386e+017 3.21124620060790e+002 2.26949217609656e+017 3.22036474164134e+002 2.72083053273815e+017 3.21124620060790e+002 2.86750474971969e+017 3.22036474164134e+002 2.26408227974233e+017 3.22948328267477e+002 2.76666695078382e+017 3.22036474164134e+002 3.28536592116547e+017 3.23860182370821e+002 2.68214706539548e+017 3.25683890577508e+002 3.16983374350417e+017 3.26595744680851e+002 2.79987925963018e+017 3.24772036474164e+002 1.93412369465729e+017 3.27507598784195e+002 2.52679774665999e+017 3.25683890577508e+002 1.99507184888358e+017 3.28419452887538e+002 2.34660217742435e+017 3.29331306990881e+002 2.05794060286978e+017 3.31155015197568e+002 2.90192756065437e+017 3.28419452887538e+002 1.72066576303699e+017 3.30243161094225e+002 1.91574768073220e+017 3.32978723404255e+002 2.17406224183374e+017 3.32066869300912e+002 2.27491499909168e+017 3.31155015197568e+002 1.97140620609278e+017 3.35714285714286e+002 1.97140620609278e+017 3.34802431610942e+002 1.97140620609278e+017 3.33890577507599e+002 1.84837908109504e+017 3.33890577507599e+002 2.55103500454395e+017 3.34802431610942e+002 2.71434475969404e+017 3.32978723404255e+002 3.13223301593038e+017 3.32066869300912e+002 3.16227766016838e+017 3.29331306990881e+002 1.57148455167872e+017 3.30243161094225e+002 1.53442361464427e+017 3.36626139817629e+002 2.25330114377457e+017 3.35714285714286e+002 2.69498005590695e+017 3.37537993920973e+002 2.20016065841638e+017 3.37537993920973e+002 2.00461746196228e+017 3.36626139817629e+002 1.57900347060782e+017 3.38449848024316e+002 1.87056785119224e+017 3.35714285714286e+002 1.42840297573033e+017 3.39361702127660e+002 1.75383362151692e+017 3.40273556231003e+002 1.92951323209013e+017 3.39361702127660e+002 2.18446425165668e+017 3.40273556231003e+002 2.29126133716630e+017 3.41185410334347e+002 1.79619396894355e+017 3.42097264437690e+002 1.77065654207971e+017 3.42097264437690e+002 2.22657237207719e+017 3.43009118541033e+002 2.10262195086014e+017 3.44832826747720e+002 1.96201873879721e+017 3.43920972644377e+002 1.54176521195687e+017 3.41185410334347e+002 1.30767803563421e+017 3.45744680851064e+002 1.83081772251861e+017 3.44832826747720e+002 1.60944062160918e+017 3.42097264437690e+002 1.27075848506931e+017 3.46656534954407e+002 1.55655395438317e+017 3.47568389057751e+002 2.19491603089572e+017 3.46656534954407e+002 2.39755085317243e+017 3.48480243161094e+002 2.50279076576896e+017 3.49392097264438e+002 1.70025513906213e+017 3.50303951367781e+002 1.66015735471930e+017 3.45744680851064e+002 1.25868507131528e+017 3.46656534954407e+002 1.24375448558197e+017 3.51215805471125e+002 2.03838821060045e+017 3.50303951367781e+002 2.41477838774524e+017 3.49392097264438e+002 2.44376646872353e+017 3.52127659574468e+002 1.93412369465729e+017 3.54863221884498e+002 2.06285793536441e+017 3.53951367781155e+002 1.61328628880472e+017 3.53039513677812e+002 1.91118102194272e+017 3.53951367781155e+002 2.13804373019259e+017 3.53039513677812e+002 2.20541781767742e+017 3.51215805471125e+002 2.62515063465755e+017 3.56686930091185e+002 2.05794060286978e+017 3.55775075987842e+002 2.01902158464669e+017 3.55775075987842e+002 1.42160118816463e+017 3.54863221884498e+002 1.42840297573033e+017 3.57598784194529e+002 2.19491603089572e+017 3.58510638297872e+002 1.99031610130472e+017 3.59422492401216e+002 2.14827340598355e+017 3.60334346504559e+002 1.49110237754681e+017 3.62158054711246e+002 1.93412369465729e+017 3.61246200607903e+002 1.53809003295114e+017 3.63069908814590e+002 1.94802128634912e+017 3.63981762917933e+002 2.05794060286978e+017 3.62158054711246e+002 1.35533949152169e+017 3.64893617021277e+002 1.94337769543218e+017 3.64893617021277e+002 2.19491603089572e+017 3.61246200607903e+002 1.27683855121917e+017 3.65805471124620e+002 1.84837908109504e+017 3.68541033434650e+002 1.94802128634912e+017 3.66717325227964e+002 1.38476618895956e+017 3.69452887537994e+002 1.72477719640741e+017 3.69452887537994e+002 2.14827340598355e+017 3.67629179331307e+002 1.34888561858991e+017 3.70364741641337e+002 1.56773852927054e+017 3.71276595744681e+002 2.12786276620270e+017 3.72188449848024e+002 1.50540515777675e+017 3.71276595744681e+002 1.36834002265631e+017 3.72188449848024e+002 1.97611676954821e+017 3.72188449848024e+002 1.32653812024286e+017 3.74012158054711e+002 1.70431780240276e+017 3.74012158054711e+002 1.38476618895956e+017 3.73100303951368e+002 1.33926238618608e+017 3.74924012158055e+002 1.68008662693722e+017 3.75835866261398e+002 1.49110237754681e+017 3.76747720364742e+002 1.47693548732710e+017 3.74924012158055e+002 1.30145111763289e+017 3.78571428571429e+002 2.14827340598355e+017 3.78571428571429e+002 1.57523952499525e+017 3.77659574468085e+002 1.42840297573033e+017 3.79483282674772e+002 2.18446425165668e+017 3.80395136778116e+002 1.87056785119224e+017 3.81306990881459e+002 1.98557169022738e+017 3.82218844984802e+002 1.83957744593737e+017 3.82218844984802e+002 2.28579954862828e+017 3.80395136778116e+002 2.68855590387296e+017 3.83130699088146e+002 1.76643574393266e+017 3.84042553191489e+002 1.66015735471930e+017 3.80395136778116e+002 1.25868507131528e+017 3.84954407294833e+002 1.64438428149114e+017 3.85866261398176e+002 1.68008662693722e+017 3.85866261398176e+002 2.26408227974233e+017 3.86778115501520e+002 1.57523952499525e+017 3.86778115501520e+002 2.17925704040675e+017 3.87689969604863e+002 1.65225199618652e+017 3.89513677811550e+002 1.89754625640999e+017 3.86778115501520e+002 1.23193763549654e+017 3.91337386018237e+002 1.78764082952061e+017 3.90425531914894e+002 1.71247227479130e+017 3.84954407294833e+002 1.12781743988337e+017 3.85866261398176e+002 1.14135626540955e+017 3.88601823708207e+002 1.29834878675435e+017 3.87689969604863e+002 1.19430273776219e+017 3.89513677811550e+002 1.28294770803010e+017 3.93161094224924e+002 1.80478803168441e+017 3.92249240121581e+002 1.88400876414913e+017 3.90425531914894e+002 2.36911098415432e+017 3.89513677811550e+002 2.44960571026879e+017 3.90425531914894e+002 1.24672636647045e+017 3.91337386018237e+002 1.26169262799260e+017 3.94072948328268e+002 1.71247227479130e+017 3.94072948328268e+002 2.06285793536441e+017 3.95896656534954e+002 1.59034935586589e+017 3.96808510638298e+002 1.71247227479130e+017 3.94984802431611e+002 2.01902158464669e+017 3.95896656534954e+002 2.04325882376133e+017 3.92249240121581e+002 2.44376646872353e+017 3.93161094224924e+002 2.49682474447937e+017 3.97720364741641e+002 1.28294770803010e+017 3.96808510638298e+002 1.16613702749988e+017 3.98632218844985e+002 1.36507824551608e+017 3.96808510638298e+002 1.99507184888358e+017 3.97720364741641e+002 1.99507184888358e+017 3.98632218844985e+002 1.99507184888358e+017
From: Walter Roberson on 4 Aug 2010 18:49 Sukumar reddy wrote: > I had extracted a huge x-y data form get-data software.From that i have > to extract y-coordinate values for given data. > when i am trying to use 'shape-preserving' curve fitting it is saying > "repeated x-values are not permitted when fitting with shape-preserving > tool". Starting from 3.69452887537994e+002 you do have a number of places where you have exactly the same first column with different second columns. > How to avoid this problem. The first thing you have to do is define what it means to you to interpolate a at a given x coordinate when there are multiple different y values there (or at the closest points). Do you want to use only the first Y value for any given X? Average them? Use the maximum? The minimum? Median? You will also have to define how you want to take nearby points in to account when you are interpolating at a location that has no defined data. "Cubic Spline" is one of the possible answers to that, but only if you filter down each duplicated X point to a single representative value at that location.
From: Sukumar reddy on 4 Aug 2010 19:28
Thanks for reply. I had tried with origin 8.0(cubic spline method). it does not given any errors.It is the better one for small simulations. |