Tutorial by Examples: r

INNER JOIN

An INNER JOIN is a JOIN operation that allows you to specify an explicit join clause. Syntax TableExpression [ INNER ] JOIN TableExpression { ON booleanExpression | USING clause } You can specify the join clause by specifying ON with a boolean expression. The scope of expressions in the ON c...

Oracle Database • JOINS

LEFT OUTER JOIN

A LEFT OUTER JOIN performs a join between two tables that requires an explicit join clause but does not exclude unmatched rows from the first table. Example: SELECT ENAME, DNAME, ...

Oracle Database • JOINS

RIGHT OUTER JOIN

A RIGHT OUTER JOIN performs a join between two tables that requires an explicit join clause but does not exclude unmatched rows from the second table. Example: SELECT ENAME, DNAME, ...

Oracle Database • JOINS

FULL OUTER JOIN

A FULL OUTER JOIN performs a join between two tables that requires an explicit join clause but does not exclude unmatched rows in either table. In other words, it returns all the rows in each table. Example: SELECT * ...

Oracle Database • JOINS

Combining an Array's elements with reduce(_:combine:)

reduce(_:combine:) can be used in order to combine the elements of a sequence into a single value. It takes an initial value for the result, as well as a closure to apply to each element – which will return the new accumulated value. For example, we can use it to sum an array of numbers: let numbe...

Swift Language • Arrays

Update using Merge

Using Merge MERGE INTO TESTTABLE USING (SELECT T1.ROWID AS RID, T2.TESTTABLE_ID FROM TESTTABLE T1 INNER JOIN MASTERTABLE T2 ON TESTTABLE.TESTTABLE_ID = MASTERTABLE.TESTTABLE_ID WHERE...

Oracle Database • Different ways to update records

Modify Scrapy user agent

Sometimes the default Scrapy user agent ("Scrapy/VERSION (+http://scrapy.org)") is blocked by the host. To change the default user agent open settings.py, uncomment and edit the following line to what ever you want. #USER_AGENT = 'projectName (+http://www.yourdomain.com)' For example ...

Python Language • Web scraping with Python

Hello, World! (SQLAlchemy Core)

This example shows how to create a table, insert data, and select from the database using SQLAlchemy Core. For information re: the SQLAlchemy ORM, see here. First, we'll need to connect to our database. from sqlalchemy import create_engine engine = create_engine('sqlite://') The engine is ...

sqlalchemy • Getting started with sqlalchemy

Linearize a FASTA sequence with AWK

Reading line by line awk '/^>/ {printf("%s%s\t",(N>0?"\n":""),$0);N++;next;} {printf("%s",$0);} END {printf("\n");}' < input.fa one can read this awk script as: if the current line ($0) starts like a fasta header (^>). Then we prin...

bioinformatics • Linearizing a FASTA sequence.

Linearize FASTA sequences from Uniprot

download and linearize the 10 first FASTA sequences from UniProt: $ curl -s "ftp://ftp.uniprot.org/pub/databases/uniprot/current_release/knowledgebase/complete/uniprot_sprot.fasta.gz" |\ gunzip -c |\ awk '/^>/ {printf("%s%s\t",(N>0?"\n":""),$0);N...

bioinformatics • Linearizing a FASTA sequence.

Context-sensitive Hotkeys and Hotstrings

In order to create a hotkey or hotstring that only triggers when certain windows are active or exist, you can put one or several of the following directives before the hotkey definition: #IfWinActive [, WinTitle, WinText] #IfWinExist [, WinTitle, WinText] #IfWinNotActive [, WinTitle, WinText] #I...

AutoHotkey • Hotkey Scripts

Advanced Environment Configurations

For more complex applications, you'll want to build up a ``settings.json` object using multiple environment variables. if(Meteor.isServer){ Meteor.startup(function()){ // this needs to be run on the server var environment, settings; environment = process.env.METEOR_ENV || "...