Home > Uncategorized > daily 04/20/2016

daily 04/20/2016

      • 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.

    • 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.

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: