Tutorial by Examples: a

Using SUMPRODUCT with numeric ranges

Consider the ranges A1:A3 and B1:B3 having the same size and only number values, as below =SUMPRODUCT(A1:A3,B1:B3) This will loop through the ranges, taking the product of values in the same row and summing them, returning 32 in this example. A1*B1 = 4 A2*B2 = 10 A3*B3 = 18

excel • SUMPRODUCT function

Using SUMPRODUCT with boolean arrays

Consider the following ranges A1:A3 and B1:B3 as below =SUMPRODUCT(--(A1:A3="c"),B1:B3) This will first manipulate (A1:A3="c") into the following array A1="c" = FALSE A2="c" = FALSE A3="c" = TRUE Then apply the -- operator which converts...

excel • SUMPRODUCT function

Managing Traffic Managers

With Azure PowerShell you can get certain functionality currently unavailable on Azure Portal, like: Reconfigure all Traffic Manager's endpoints at once Address other services via Azure ResourceId instead of domain name, so you don't need to set Location manually for Azure Endpoints Prerequis...

azure • Azure Powershell

Create a new repository on Bitbucket website

Go to https://bitbucket.org/dashboard/overview Login to your Bitbucket account Choose repositories from the top menu, then choose Create Repository Choose the owner, enter the repository name and select if you want to have it public or private repository Choose the repository type (Git or Merc...

bitbucket • Create a new repository

Bundler/inline (bundler v1.10 and later)

Sometimes you need to make a script for someone but you are not sure what he has on his machine. Is there everything that your script needs? Not to worry. Bundler has a great function called in line. It provides a gemfile method and before the script is run it downloads and requires all the necessa...

Ruby Language • Gem Usage

Cloning a Git repository

Go to the repository you want to clone (something like: https://bitbucket.org/username/repo) On the left side, click on ... and choose Clone A small window will appear, copy the url (something like: git clone https://[email protected]/hamzawey/vm_dop_experiment.git) Open a terminal windo...

bitbucket • Clone existing repository

Using .loc and slicers

Unlike the .xs method, this allows you to assign values. Indexing using slicers is available since version 0.14.0. In [1]: import pandas as pd import numpy as np arrays = [['bar', 'bar', 'baz', 'baz', 'foo', 'foo', 'qux', 'qux'], ['one', 'two', 'one', 'two', 'one', 'two', 'one', 'two'...

pandas • Cross sections of different axes with MultiIndex

Installing the autodoc extension

Add the autodoc module in the extensions list present in the conf.py file at the root of your documentation: extensions = [ 'sphinx.ext.autodoc', ... ]

python-sphinx • Writing docstrings using autodoc

Adding your code path in the sphinx config

Autodoc needs to imports your modules to work. You can include your code path in your conf.py file. For instance: import os sys.path.insert(0, os.path.abspath('../src'))

python-sphinx • Writing docstrings using autodoc

Installation or Setup

Detailed instructions on getting uikit set up or installed.

uikit • Getting started with uikit

Getting started with Bitbucket - Create an account

Create an account Go to https://bitbucket.org/ Click on Get Started on the top right corner Enter your email address, and click continue Enter your full name, password and verification code. Then click Continue An email will be sent to you to verify that you created your account After that...

bitbucket • Getting started with bitbucket

How to add users and groups to an existing Bitbucket repository

Go to the Bitbucket repository you want to add users to. On the left, go to Settings (the last icon on the bottom left). Select Users and group access. Under Users, start typing the name or email address of the user whom you want to add. Select the privilege you want to grant that user (Read, ...

bitbucket • Add collaborators to a repository

Passing a Switch parameter using Splatting

To use Splatting to call Get-Process with the -FileVersionInfo switch similar to this: Get-Process -FileVersionInfo This is the call using splatting: $MyParameters = @{ FileVersionInfo = $true } Get-Process @MyParameters Note: This is useful because you can create a default set of p...

PowerShell • Splatting

Multi window signal slot connection

A simple multiwindow example using signals and slots. There is a MainWindow class that controls the Main Window view. A second window controlled by Website class. The two classes are connected so that when you click a button on the Website window something happens in the MainWindow (a text label i...

Qt • Signals and Slots