pd.read_excel('path_to_file.xls', sheetname='Sheet1')
There are many parsing options for read_excel (similar to the options in read_csv.
pd.read_excel('path_to_file.xls',
sheetname='Sheet1', header=[0, 1, 2],
skiprows=3, index_col=0) # etc.
To rename a folder from oldName to newName
git mv directoryToFolder/oldName directoryToFolder/newName
Followed by git commit and/or git push
If this error occurs:
fatal: renaming 'directoryToFolder/oldName' failed: Invalid argument
Use the following command:
git mv directoryToFolder/oldN...
// A simple adder function defined as a lambda expression.
// Unlike with regular functions, parameter types often may be omitted because the
// compiler can infer their types
let adder = |a, b| a + b;
// Lambdas can span across multiple lines, like normal functions.
let multiplier = |a: i32, ...
Unlike regular functions, lambda expressions can capture their environments. Such lambdas are called closures.
// variable definition outside the lambda expression...
let lucky_number: usize = 663;
// but the our function can access it anyway, thanks to the closures
let print_lucky_number = ...
Returning lambdas (or closures) from functions can be tricky because they implement traits and thus their exact size is rarely known.
// Box in the return type moves the function from the stack to the heap
fn curried_adder(a: i32) -> Box<Fn(i32) -> i32> {
// 'move' applies move se...
// Include sequence containers
#include <vector>
#include <deque>
#include <list>
// Insert sorting algorithm
#include <algorithm>
class Base {
public:
// Constructor that set variable to the value of v
Base(int v): variable(v) {
}
i...
C++11
// Include sequence containers
#include <vector>
#include <deque>
#include <list>
#include <array>
#include <forward_list>
// Include sorting algorithm
#include <algorithm>
class Base {
public:
// Constructor that set variable to the va...
Model with ForeignKey
We will work with these models :
from django.db import models
class Book(models.Model):
name= models.CharField(max_length=50)
author = models.ForeignKey(Author)
class Author(models.Model):
name = models.CharField(max_length=50)
Suppose we often (always) access ...
Here is an example class which has a couple of instance variables, without using properties:
@interface TestClass : NSObject {
NSString *_someString;
int _someInt;
}
-(NSString *)someString;
-(void)setSomeString:(NSString *)newString;
-(int)someInt;
-(void)setSomeInt:(NSString *)...
MySQL3.19
DROP TABLE IF EXISTS MyTable;
PostgreSQL8.x
DROP TABLE IF EXISTS MyTable;
SQL Server2005
If Exists(Select * From Information_Schema.Tables
Where Table_Schema = 'dbo'
And Table_Name = 'MyTable')
Drop Table dbo.MyTable
SQLite3.0
DROP TABLE IF EXI...
Sometimes, programmers who are new Java will use primitive types and wrappers interchangeably. This can lead to problems. Consider this example:
public class MyRecord {
public int a, b;
public Integer c, d;
}
...
MyRecord record = new MyRecord();
record.a = 1; // OK
...
Use this option if you don't need an Application subclass.
This is the simplest option, but this way you can't provide your own Application subclass. If an Application subclass is needed, you will have to switch to one of the other options to do so.
For this option, simply specify the fully-quali...
