blocks|key|465841|text|在进行直线拟合时，应该创建一个名称为YourDataTable_Straight+line的数据表。回归系数将在那里。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|465842|entityMap^0|I|R|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

When doing the straight line fit, there should be a data table created with a name like <code>YourDataTable_Straight line</code>. The regressed coefficients will be there.

blocks|key|4247437|text|转到属性的“直线和曲线”中的“直线拟合”，选择它并转到“更多”。从那里，您可以将系数导出到文本文件，重新导入它，并将它的列链接到原始数据表。Exporting+the+coefficients+of+a+curve+fit|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4247438|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/xZ5lR.png^0|1Y|15|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Go to the 'Straight Line Fit' in 'Lines &amp; Curves' of the properties, select it and go to 'More'. From there you can export the coefficients to a text file, re-import it and link it's columns to the original data table.
<a href="https://i.stack.imgur.com/xZ5lR.png" rel="nofollow noreferrer">Exporting the coefficients of a curve fit</a>

blocks|key|2781490|text|使用r脚本，您可以将系数放入数据帧中。对于这个问题，我已经使用了这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2781491|tb.lm+<-+lm(y+~+x,+data+=+yourtable)
tb.summary.lm+<-+summary(tb.lm)
df+<-+as.data.frame(tb.summary.lm$coefficients)

row.names(df)=c("intercept","slope")
coef+<-+data.frame(yourColumnname+=+row.names(df),df)|code-block|syntax|javascript|2781492|其中coef将是您的输出，作为spotfire分析中的一个表。|offset|length|style|CODE|2781493|在读完这篇文章后，我得出了这个结论：Linear-Regression|2781494|这个是：TIBCO+support|2781495|entityMap|0|LINK|mutability|MUTABLE|url|http://r-statistics.co/Linear-Regression.html|1|https://support.tibco.com/s/article/Data-function-returns-Error-in-as-data-frame-default-cannot-coerce-class-summary-lm-into-a-data-frame^0|0|0|2|4|0|I|H|0|0|4|D|1|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@$I|13|J|14|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|15|8|@]|9|@$I|16|J|17|1|18]]|A|$]]|$1|O|3|P|5|6|7|19|8|@]|9|@$I|1A|J|1B|1|1C]]|A|$]]|$1|Q|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]|Y|$5|T|U|V|A|$W|Z]]]]

With a r script you are able to get the coefficients into a data frame. I've used this one, for exactly that issue:

<pre><code>tb.lm &lt;- lm(y ~ x, data = yourtable)
tb.summary.lm &lt;- summary(tb.lm)
df &lt;- as.data.frame(tb.summary.lm$coefficients)

row.names(df)=c("intercept","slope")
coef &lt;- data.frame(yourColumnname = row.names(df),df)
</code></pre>

Where <code>coef</code> will be your output, as a table in your spotfire analysis.

I've reached to this after reading this:
<a href="http://r-statistics.co/Linear-Regression.html" rel="nofollow noreferrer">Linear-Regression</a>

and this:
<a href="https://support.tibco.com/s/article/Data-function-returns-Error-in-as-data-frame-default-cannot-coerce-class-summary-lm-into-a-data-frame" rel="nofollow noreferrer">TIBCO support</a>

blocks|key|2781571|text|如果你想构建已经由Spotfire计算并显示在图表中的拟合(基于this)，还有另一个选择使用IronPython。这避免了在R中运行另一个拟合并提取那些(可能略有不同的)拟合结果，在我的例子中(非常大的数据集)是一个实时节省。我想这同样适用于折线图。因此，注册一个IronPython脚本，并将以下代码调整为您的页面和可视化标题：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2781572|from+Spotfire.Dxp.Application.Visuals+import+ScatterPlot,+FittingModels

#+grab+the+fitting+model+of+the+first+(counting+starts+at+0!)+lines+&+curves+item+and+export+to+data+table
for+page+in+Document.Pages:++#Loop+through+every+page
++++if+page.Title+==+'Your+Page+Title':++#find+the+right+page
++++++++for+viz+in+page.Visuals:++#On+this+page,+loop+through+every+viz+++++++++
++++++++++++if+viz.Title+==+'Your+Scatter+Plot+Title':++#find+the+right+viz+++++++++++++
++++++++++++++++ScatterPlot=viz.As[ScatterPlot]()+++++++++++++++
++++++++++++++++ScatterPlot.FittingModels[0].Enabled=True+#+[0]+is+the+first+fit+in+the+list+of+fits+in+the+lines+&+curves+section+of+the+properties+menue
++++++++++++++++ds+=+ScatterPlot.FittingModels[0].GetResultsDataSource()
++++++++++++++++if+Document.Data.Tables.Contains("Curve+Fit+Results"):
++++++++++++++++++++table=Document.Data.Tables["Curve+Fit+Results"]
++++++++++++++++++++table.ReplaceData(ds)
++++++++++++++++else:
++++++++++++++++++++Document.Data.Tables.Add("Curve+Fit+Results",+ds)|code-block|syntax|javascript|2781573|结果将是一个称为曲线拟合结果的附加数据表，其中(在直线拟合的情况下)保存每个直线拟合的截距a、坡度b和R²。例如，您可以将此脚本绑定到文本区域中的操作控件以触发它。|2781574|entityMap|0|LINK|mutability|MUTABLE|url|https://spotfired.blogspot.com/2015/10/extract-values-from-curve.html^0|W|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

There is another option using IronPython if you want to build on the fits already computed by Spotfire and shown in the chart (based on <a href="https://spotfired.blogspot.com/2015/10/extract-values-from-curve.html" rel="nofollow noreferrer">this</a>). This avoids running yet another fit in R and extracting those (potentially slightly different) fit results, which in my case (very large data set) was a real time saver. The same would probably work for line charts I reckon. So register an IronPython script and adjust the below code to your page and visualzation titles:
<pre><code>from Spotfire.Dxp.Application.Visuals import ScatterPlot, FittingModels

# grab the fitting model of the first (counting starts at 0!) lines &amp; curves item and export to data table
for page in Document.Pages: #Loop through every page
 if page.Title == 'Your Page Title': #find the right page
 for viz in page.Visuals: #On this page, loop through every viz 
 if viz.Title == 'Your Scatter Plot Title': #find the right viz 
 ScatterPlot=viz.As[ScatterPlot]() 
 ScatterPlot.FittingModels[0].Enabled=True # [0] is the first fit in the list of fits in the lines &amp; curves section of the properties menue
 ds = ScatterPlot.FittingModels[0].GetResultsDataSource()
 if Document.Data.Tables.Contains(&quot;Curve Fit Results&quot;):
 table=Document.Data.Tables[&quot;Curve Fit Results&quot;]
 table.ReplaceData(ds)
 else:
 Document.Data.Tables.Add(&quot;Curve Fit Results&quot;, ds)
</code></pre>
The result will be an additional data table called [Curve Fit Results] wich (in case of a straight line fit) holds intercept a, slope b and R² for each straight line fit. You can e.g. tie this script to an action control in a text area to trigger it.

I have set up a trellis visualization in Spotfire showing line charts for my data. I've also added a "Straight Line Fit" in the "Lines &amp; Curves" tab of the properties

<img src="https://i.stack.imgur.com/xuQ1O.jpg" alt="see image for my current setup">.

Does anyone know how to access those coefficients of intercept and slope? I would like to sort my visualizations with the slope (most- to least-negative) information calculated.

I'm using the Spotfire 7.6.0.57 build. Thanks!

How can I extract fitted line slope coefficients in Spotfire?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云AI代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我在Spotfire中设置了一个网格可视化，为我的数据显示折线图。我还在属性的“直线和曲线”选项卡中添加了“直线拟合”。​。有人知道如何获取截距系数和斜率系数吗？我想用计算出的斜率(从最大到最小)信息对我的可视化进行排序。我使用的是Spotfire 7.6.0.57版本。谢谢!

问如何在Spotfire中提取拟合的线斜率系数？
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Spotfire中提取拟合的线斜率系数？EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Spotfire中提取拟合的线斜率系数？
EN