From: Sukumar reddy on
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
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
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.