Tutorial by Examples: t

Let us assume we have the following two DataFrames: In [7]: df1 Out[7]: A B 0 a1 b1 1 a2 b2 In [8]: df2 Out[8]: B C 0 b1 c1 The two DataFrames are not required to have the same set of columns. The append method does not change either of the original DataFrames. Inst...

You can quickly determine if a text includes a specific pattern using Regex. There are multiple ways to work with Regex in PowerShell. #Sample text $text = @" This is (a) sample text, this is a (sample text) "@ #Sample pattern: Content wrapped in () $pattern = '\(.*?\)' Using ...

Sometimes you need to replace a value matching a pattern with a new value that's based on that specific match, making it impossible to predict the new value. For these types of scenarios, a MatchEvaluator can be very useful. In PowerShell, a MatchEvaluator is as simple as a scriptblock with a singl...

A regex-pattern uses many special characters to describe a pattern. Ex., . means "any character", + is "one or more" etc. To use these characters, as a .,+ etc., in a pattern, you need to escape them to remove their special meaning. This is done by using the escape character whi...

There are multiple ways to find all matches for a pattern in a text. #Sample text $text = @" This is (a) sample text, this is a (sample text) "@ #Sample pattern: Content wrapped in () $pattern = '\(.*?\)' Using Select-String You can find all matches (global match) by adding t...

You can delete existing snapshots of database using DELETE DATABASE statement: DROP DATABASE Mydatabase_morning In this statement you should reference name of the database snapshot.

Tuples are immutable ordered collections of arbitrary distinct objects, either of the same type or of different types. Typically, tuples are constructed using the (x, y) syntax. julia> tup = (1, 1.0, "Hello, World!") (1,1.0,"Hello, World!") The individual objects of a tup...

The typeof a tuple is a subtype of Tuple: julia> typeof((1, 2, 3)) Tuple{Int64,Int64,Int64} julia> typeof((1.0, :x, (1, 2))) Tuple{Float64,Symbol,Tuple{Int64,Int64}} Unlike other data types, Tuple types are covariant. Other data types in Julia are generally invariant. Thus, julia>...

Because Julia function parameter lists are themselves tuples, dispatching on various kinds of tuples is often easier done through the method parameters themselves, often with liberal usage for the "splatting" ... operator. For instance, consider the implementation of reverse for tuples, fr...

Tuples are frequently used for multiple return values. Much of the standard library, including two of the functions of the iterable interface (next and done), returns tuples containing two related but distinct values. The parentheses around tuples can be omitted in certain situations, making multip...

The IIF statement can be used in expressions to screen for division by zero: =IIF(Fields!PossibleZero.Value=0,0,Fields!Denominator.Value/IIF(Fields!PossibleZero.Value=0,1,Fields!PossibleZero.Value)) SSRS does not short circuit IIF arguments. Therefore, using a single IIF function to screen for ...

In order to use a plain-text editor to create a Console application that is written in C#, you'll need the C# Compiler. The C# Compiler (csc.exe), can be found at the following location: %WINDIR%\Microsoft.NET\Framework64\v4.0.30319\csc.exe N.B. Depending upon which version of the .NET Framework t...

svn2git is a Ruby wrapper around git's native SVN support through git-svn, helping you with migrating projects from Subversion to Git, keeping history (incl. trunk, tags and branches history). Examples To migrate a svn repository with the standard layout (ie. branches, tags and trunk at the root l...

Given a CLLocationDistance (simply a Double representing meters), output a user-readable string: let distance = CLLocationDistance(42) let formatter = MKDistanceFormatter() let answer = formatter.stringFromDistance(distance) // answer = "150 feet" Objective-C CLLocationDistance dis...

import Mapkit Set units to one of .Default, .Metric, .Imperial, .ImperialWithYards: formatter.units = .Metric var answer = formatter.stringFromDistance(distance) // "40 m" formatter.units = .ImperialWithYards answer = formatter.stringFromDistance(distance) // "50 yards" ...

Set unitStyle to one of .Default, .Abbreviated, .Full: formatter.unitStyle = .Full var answer = formatter.stringFromDistance(distance) // "150 feet" formatter.unitStyle = .Abbreviated answer = formatter.stringFromDistance(distance) // "150 ft" Objective-C formatter.un...

inputype attribute in EditText widget: (tested on Android 4.4.3 and 2.3.3) <EditText android:id="@+id/et_test" android:inputType="?????"/> textLongMessage= Keyboard: alphabet/default. Enter button: Send/Next. Emotion: yes. Case: lowercase. Suggestion: yes. Add. chars: ,...

RowAB1FruitApple2WeekdayMonday3AnimalDog Formula on C1 ={A1:A3} Result RowC1Fruit2Weekday3Dog Alternative formula =ARRAYFORMULA(A1:A3)

The simplest manner of defining custom behavior for individual routes would be fairly easy. In this example we use it to authenticate a user : 1) routes.js: create a new property (like requireAuth) for any desired route angular.module('yourApp').config(['$routeProvider', function($routeProvider) ...

using System.Diagnostics.Contracts; public int IncrementByRandomAmount(int input) { Contract.Requires<ArgumentNullException>(input != null); // Don't allow null parameter. Contract.Requires<ArgumentOutOfRangeException>(input < int.MaxValue); // We can't do anything if...