Tutorial by Examples: n

First try use pivot: import pandas as pd import numpy as np df = pd.DataFrame({'Name':['Mary', 'Josh','Jon','Lucy', 'Jane', 'Sue'], 'Age':[34, 37, 29, 40, 29, 31], 'City':['Boston','New York', 'Chicago', 'Los Angeles', 'Chicago', 'Boston'], ...
import pandas as pd import numpy as np df = pd.DataFrame({'Name':['Mary', 'Jon','Lucy', 'Jane', 'Sue', 'Mary', 'Lucy'], 'Age':[35, 37, 40, 29, 31, 26, 28], 'City':['Boston', 'Chicago', 'Los Angeles', 'Chicago', 'Boston', 'Boston', 'Chicago'], ...
Subclass UINavigationController and then override these methods: In Objective-C: - (UIStatusBarStyle)preferredStatusBarStyle { return UIStatusBarStyleLightContent; } In Swift: override func preferredStatusBarStyle() -> UIStatusBarStyle { return .lightContent } Alternativel...
Since Git 1.7.12 it is possible to rebase down to the root commit. The root commit is the first commit ever made in a repository, and normally cannot be edited. Use the following command: git rebase -i --root
Note that you cannot overload a function based on its return type. For example: // WRONG CODE std::string getValue() { return "hello"; } int getValue() { return 0; } int x = getValue(); This will cause a compilation error as the compiler will not be able to work out wh...
Filters can either be defined in a method and then added to Jinja's filters dictionary, or defined in a method decorated with Flask.template_filter. Defining and registering later: def format_datetime(value, format="%d %b %Y %I:%M %p"): """Format a date time to (Defau...
It is also possible to write a context manager using generator syntax thanks to the contextlib.contextmanager decorator: import contextlib @contextlib.contextmanager def context_manager(num): print('Enter') yield num + 1 print('Exit') with context_manager(2) as cm: # the ...
Intents can be used to broadcast messages to other components of your application (such as a running background service) or to the entire Android system. To send a broadcast within your application, use the LocalBroadcastManager class: Intent intent = new Intent("com.example.YOUR_ACTION"...
TRUNCATE TABLE Employee; Using truncate table is often better then using DELETE TABLE as it ignores all the indexes and triggers and just removes everything. Delete table is a row based operation this means that each row is deleted. Truncate table is a data page operation the entire data page is...
This code selects data out of a table and displays it in the query tool (usually SSMS) SELECT Column1, Column2, Column3 FROM MySourceTable; This code inserts that data into a table: INSERT INTO MyTargetTable (Column1, Column2, Column3) SELECT Column1, Column2, Column3 FROM MySourceTable;
This code selects data out of a table: SELECT Column1, Column2, Column3 FROM MySourceTable; This code creates a new table called MyNewTable and puts that data into it SELECT Column1, Column2, Column3 INTO MyNewTable FROM MySourceTable;
To move data you first insert it into the target, then delete whatever you inserted from the source table. This is not a normal SQL operation but it may be enlightening What did you insert? Normally in databases you need to have one or more columns that you can use to uniquely identify rows so we w...
public class Dog : RealmObject { public string Name { get; set; } public int Age { get; set; } } var realm = Realm.GetInstance(); realm.Write(() => { var mydog = realm.CreateObject<Dog>(); mydog.Name = "Rex"; mydog.Age = 1; }); var pups = real...
class Dog {} Dog.schema = { name: 'Dog', properties: { name: 'string', age: 'int', } }; let realm = new Realm(); realm.write(() => { realm.create('Dog', {name: 'Rex', age: 1}); }); let pups = realm.objects('Dog').filtered('age > 2');
It is a common practice to place multiple <div> inside another <div>. This is usually referred to as "nesting" elements and allows for further dividing elements into subsections or aid developers with CSS styling. The <div class="outer-div"> is used to group to...
Since C# 6.0 exceptions can be filtered using the when operator. This is similar to using a simple if but does not unwind the stack if the condition inside the when is not met. Example try { // ... } catch (Exception e) when (e.InnerException != null) // Any condition can go in here. { ...
You can access SharedPreferences in several ways: Get the default SharedPreferences file: import android.preference.PreferenceManager; SharedPreferences prefs = PreferenceManager.getDefaultSharedPreferences(this); Get a specific SharedPreferences file: public static final String PREF_FILE_NAM...
The shift operators allow programmers to adjust an integer by shifting all of its bits to the left or the right. The following diagram shows the affect of shifting a value to the left by one digit. Left-Shift uint value = 15; // 00001111 uint doubled = value << 1; // Resu...
Within a catch block the throw keyword can be used on its own, without specifying an exception value, to rethrow the exception which was just caught. Rethrowing an exception allows the original exception to continue up the exception handling chain, preserving its call stack or associated data: try...
You can use the CONVERT function to cast a datetime datatype to a formatted string. SELECT GETDATE() AS [Result] -- 2016-07-21 07:56:10.927 You can also use some built-in codes to convert into a specific format. Here are the options built into SQL Server: DECLARE @convert_code INT = 100 -- See ...

Page 149 of 1088