This will be our example data frame:
df = pd.DataFrame({"color": ['red', 'blue', 'red', 'blue']},
index=[True, False, True, False])
color
True red
False blue
True red
False blue
Accessing with .loc
df.loc[True]
color
True red
True red
...
This will be our example data frame:
color name size
0 red rose big
1 blue violet big
2 red tulip small
3 blue harebell small
Using the magic __getitem__ or [] accessor. Giving it a list of True and False of the same length as the dataframe will give you:
...
Validating the Name entered by a User contain the following check
Ensure it is not empty
Ensure it contain only alphabets, space and/or dot.
So, the regular expression for this is
^[A-Z][a-z]*(\.?\s?[A-Z][a-z]*)+$
This means
^ -> Should start with
[A-Z] -> the first lette...
Let's take the Range is from 18 to 80.
So, to validate,
We should check that the age is a positive integer.
Then check it should be greater than or equal to 18 and less than or equal to 80.
The test to check whether it is a number or not can be performed by a simple regular expression like
^[0-...
Sometimes, we have to take input from users which should contain only alpha numeric characters.
For example, lets say a Username system which allow only letters and numbers,
Then this can be done with the following Regular Expression
^[a-zA-Z0-9]+$
^ is restrict the start
[a-zA-Z0-9]+ is th...
Consider a company where every employee who is a manager, manages 1 or more employees, and every employee has only 1 manager.
This results in two tables:
EMPLOYEES
EMP_IDFIRST_NAMELAST_NAMEMGR_IDE01JohnnyAppleseedM02E02ErinMacklemoreM01E03ColbyPaperworkM03E04RonSonswanM01
MANAGERS
MGR_IDFIRST_N...
SELECT e.emp_id , e.first_name , e.last_name FROM employees e INNER JOIN managers m ON m.mgr_id = e.mgr_id WHERE m.mgr_id = 'M01' ;
Results in:
EMP_IDFIRST_NAMELAST_NAMEE02ErinMacklemoreE04RonSonswan
Ultimately, for every manager we query for, we will see 1 or more employees returned.
Consult the above example tables when looking at this example.
SELECT m.mgr_id , m.first_name , m.last_name FROM managers m INNER JOIN employees e ON e.mgr_id = m.mgr_id WHERE e.emp_id = 'E03' ;
MGR_IDFIRST_NAMELAST_NAMEM03BarrelJones
As this is the inverse of the above example, we know that for ...
Consider next example:
public interface A {
default void foo() { System.out.println("A.foo"); }
}
public interface B {
default void foo() { System.out.println("B.foo"); }
}
Here are two interfaces declaring default method foo with the same signature.
If you wi...
Python
Most commonly used scenario:
open page in new window
switch to it
do something
close it
switch back to parent window
# Open "Google" page in parent window
driver.get("https://google.com")
driver.title # 'Google'
# Get parent window
parent_window = driver...
Data can be extracted from a blastdb using blastdbcmd which should be included in a blast installation. You can specify from the options below as part of -outfmt what metadata to include and in what order.
From the man page:
-outfmt <String>
Output format, where the available format sp...
public class ExpandBarDynamicContentExample {
private final Display display;
private final Shell shell;
public ExpandBarDynamicContentExample() {
display = new Display();
shell = new Shell(display);
shell.setLayout(new FillLayout());
// Create...
/**
* Add meta box to post types.
*
* @since 1.0.0
*/
function myplugin_add_meta_box() {
// Set up the default post types/
$types = array(
'post',
);
// Optional filter for adding the meta box to more types. Uncomment to use.
// $types = apply_filters( 'mypl...
Every Heroku app runs in at least two environments: on Heroku (we’ll call that production) and on your local machine (development). If more than one person is working on the app, then you’ve got multiple development environments - one per machine, usually. Usually, each developer will also have a te...
Let's start using ExtJS to build a simple web application.
We will create a simple web application which will have only one physical page (aspx/html). At a minimum, every ExtJS application will contain one HTML and one JavaScript file—usually index.html and app.js.
The file index.html or your defa...
Reagent is an interface between ClojureScript and react. It allows you to define efficient React components using nothing but plain ClojureScript functions and data, that describe your UI using a Hiccup-like syntax.
Example:-
(defn sample-component []
[:div
[:p "I am a component!"...
DB backup
Database backup is a must before starting any Dynamics CRM upgrade process. This is mandatory as to always have the option to rollback in case of any major roadblock.
Wrong Estimation
DO NOT underestimate the work involved in a CRM Upgrade process.
Audit your current Microsoft Dynamics...
Now, here are some common pitfalls which might come along your way when upgrading your Dynamics CRM system.
The organisation database selected for the import is a different version than the organisation database that is currently deployedCRM Organization Database
To fix this issue, we need to in...
