Skip to main content
K
ksk_1059423212-Amethyst
12-Amethyst
December 10, 2024
Solved

NaN in a table

  • December 10, 2024
  • 3 replies
  • 828 views

Hi 

 

I want to plot numbers from a table along with a function. But - if I select for example Row 2 and Class C, I want NaN to appear, i.e no value at all in the plot. Is it possible to incorporate NaN in a table? Or is NaN not applicable in this case? How can I solve this? 

 

ksk_10594232_1-1733821158331.png

 

Worksheet attached (prime 7).

 

Thanks in advance! 

 

 

 

 

 

 

 

 

Best answer by Werner_E

If a trace consists of more than one point and at least one of them is not a NaN, Prime would silently ignore this point. Unfortunately this behaviour changes when the plot consists of one single point only as in your case.

Furthermore the value you get from the Excel sheet is not Primes NaN but rather the string "NaN"  and strings cannot be plotted as well.

 

A possible workaround can be to replace a "NaN" for a value outside the plot range. This requires you to manually set the plot range. In the example below I had chosen the value -1 to be replaced for "NaN" and have set manually the lower limits for both axis to zero.

You may also use 'infinity' (ctrl z) as replacement value and limit the upper axis limits manually.

Werner_E_0-1733851933094.png

Attached worksheet is P10, but you can see all necessary changes in the picture.

3 replies

W
Werner_E25-Diamond IAnswer
25-Diamond I
December 10, 2024

If a trace consists of more than one point and at least one of them is not a NaN, Prime would silently ignore this point. Unfortunately this behaviour changes when the plot consists of one single point only as in your case.

Furthermore the value you get from the Excel sheet is not Primes NaN but rather the string "NaN"  and strings cannot be plotted as well.

 

A possible workaround can be to replace a "NaN" for a value outside the plot range. This requires you to manually set the plot range. In the example below I had chosen the value -1 to be replaced for "NaN" and have set manually the lower limits for both axis to zero.

You may also use 'infinity' (ctrl z) as replacement value and limit the upper axis limits manually.

Werner_E_0-1733851933094.png

Attached worksheet is P10, but you can see all necessary changes in the picture.

S
StuartBruff23-Emerald V
23-Emerald V
December 10, 2024

How and where would you expect something that is "not a number" to appear in the plot?  What would you be trying to present to the reader?

 

Would this kind of thing be suitable?   I've created a vector that transforms the NaNs into their interpolated position on the x&y coordinates, and shown them as a separate trace to indicate that they represent missing values from the Number values.  This is intended to show where they would appear if mapped onto your x,y function, but it doesn't necessarily represent where they would have appeared in the column data if they weren't NaNs.

 

If it isn't what you want, could you sketch out what you would prefer and post an image/photo of it?

 

2024 12 10 A.png

 

Stuart

Catalina
CatalinaCommunity Manager
Community Moderator
December 17, 2024

Hi @ksk_10594232,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution or please feel free to detail in a reply what has helped you and mark it as the Accepted Solution. It will help other members who may have the same question.
Please note that industry experts also review the replies and may eventually accept one of them as solution on your behalf.

Of course, if you have more to share on your issue, please pursue the conversation.

Thanks,

Catalina | PTC Community Moderator
Terms & ConditionsAccessibility statement