Pocket: Interactive Data Analysis with Python and Excel
That’s where xlwings comes into play. At the simplest level, xlwings allows us to glue python and Excel together in two main ways:
- Control Excel from python
- Call custom python code from within Excel
This article will focus on building an Excel worksheet that calls your custom python code.
Experiments in Linear Regression Land, Part 1 – PowerPivotPro
Furthermore, if you believe you have a good linear regression model, you can use it in a predictive capacity – given one variable, you can get a decent guess at an outcome. In the chart above, for instance, if we had an X value of 6, the linear regression “predicts” that Y would be 20.
But all of that lacks Power Pivot’s elegant flexibility – you can’t quickly modify an “old school” Excel analysis like you can in Power Pivot. Slice it, filter it, sort it, rearrange it, whatever – in Power Pivot, that’s all effortless, whereas in Excel alone, those all require “re-builds” of your original analysis.
Posted from Diigo. The rest of my favorite links are here.