Tutorial by Examples: e

import pandas as pd # Save dataframe to pickled pandas object df.to_pickle(file_name) # where to save it usually as a .plk # Load dataframe from pickled pandas object df= pd.read_pickle(file_name)

The foreach statement is used to loop through arrays. For each iteration the value of the current array element is assigned to $value variable and the array pointer is moved by one and in the next iteration next element will be processed. The following example displays the items in the array a...

The break keyword immediately terminates the current loop. Similar to the continue statement, a break halts execution of a loop. Unlike a continue statement, however, break causes the immediate termination of the loop and does not execute the conditional statement again. $i = 5; while(true) {...

The do...while statement will execute a block of code at least once - it then will repeat the loop as long as a condition is true. The following example will increment the value of $i at least once, and it will continue incrementing the variable $i as long as it has a value of less than 25; $i...

The continue keyword halts the current iteration of a loop but does not terminate the loop. Just like the break statement the continue statement is situated inside the loop body. When executed, the continue statement causes execution to immediately jump to the loop conditional. In the followin...

The while statement will execute a block of code if and as long as a test expression is true. If the test expression is true then the code block will be executed. After the code has executed the test expression will again be evaluated and the loop will continue until the test expression is foun...

Find single record based on id. $model = User::findOne($id); Select single column based on id. $model = User::findOne($id)->name; Retrieve the single record from the database based on condition. $model = User::find()->one(); // give first record $model = User::find()->where(['i...

Using scenario you can perform validation on different situation Define scenario in model class class User extends \yii\db\ActiveRecord { public static function tableName() { return 'user_master'; } // define validation in rule() function public ...

Vector based graphics are represented by a plethora of data that must be computed by the CPU (vector points, arcs, colors, etc). Anything other than simple shapes with minimal points and straight lines will consume vast amounts of CPU resource. There is a "Cache as Bitmap" flag that can b...

Rendering text consumes a lot of CPU. Fonts are rendered in a fashion similar to vector graphics and contain many vector points for every character. Altering text frame-by-frame will degrade performance. The "Cache as bitmap" flag is extremely useful if used correctly, meaning you must avo...

Using the Vector.<T> type and the for each loop is more performant than a conventional array and for loop: Good: var list:Vector.<Sprite> = new <Sprite>[]; for each(var sprite:Sprite in list) { sprite.x += 1; } Bad: var list:Array = []; for (var i:int = 0; i < ...

If you do not require an array to be in any particular order, a little trick with pop() will afford you enormous performance gains compared to splice(). When you splice() an array, the index of subsequent elements in that array needs to be reduced by 1. This process can consume a large chunk of tim...

If you have a value that you use often, you can store it in a variable. You could use this to define color schemes, for example. You would only have to define your scheme once and then you could use it throughout your stylesheets. To define a variable, you must prefix its name with the $ symbol. (L...

Steps to Create component: Create a folder named components in your project root folder Create your component inside components folder e.g.: MyComponent.php namespace app\components; use Yii; use yii\base\Component; use yii\base\InvalidConfigException; class MyComponent ...

Create function in MyComponent.php namespace app\components; use Yii; use yii\base\Component; use yii\base\InvalidConfigException; use yii\helpers\Url; use yii\helpers\ArrayHelper; use app\models\User; class MyComponent extends Component ...

A session is usually obtained using sessionmaker, which creates a Session class unique to your application. Most commonly, the Session class is bound to an engine, allowing instances to use the engine implicitly. from sqlalchemy.orm import sessionmaker # Initial configuration arguments Session ...

New or detached objects may be added to the session using add(): session.add(obj) A sequence of objects may be added using add_all(): session.add_all([obj1, obj2, obj3]) An INSERT will be emitted to the database during the next flush, which happens automatically. Changes are persisted when t...

To delete persisted objects use delete(): session.delete(obj) Actual deletion from the database will happen on next flush.

There are many ways find the location of a value in an array. The following example snippets all assume that the array is one of the following: String[] strings = new String[] { "A", "B", "C" }; int[] ints = new int[] { 1, 2, 3, 4 }; In addition, each one sets...

Using ActiveCell or ActiveSheet can be source of mistakes if (for any reason) the code is executed in the wrong place. ActiveCell.Value = "Hello" 'will place "Hello" in the cell that is currently selected Cells(1, 1).Value = "Hello" 'will always place "Hello&...