"HADRACH "the name of a country (Zechariah 9:1) which cannot be identified. Rawlinson would identify it with Edessa. He mentions that in the Assyrian inscriptions it is recorded that “Shalmanezer III. made two expeditions, the first against Damascus B.C. 773, and the second against Hadrach B.C. 772; and again that Asshurdanin-il II. made expeditions against Hadrach in B.C. 765 and 755.”
"HADRACH "the name of a country (Zechariah 9:1) which cannot be identified. Rawlinson would identify it with Edessa. He mentions that in the Assyrian inscriptions it is recorded that “Shalmanezer III. made two expeditions, the first against Damascus B.C. 773, and the second against Hadrach B.C. 772; and again that Asshurdanin-il II. made expeditions against Hadrach in B.C. 765 and 755.”


A demonstration of how you can combine the RGraph chart types on to a single SVG tag. Here a Bar chart is being combined with a filled Line chart - a common combination. Both charts are using the labelsAbove option. and they both too have a center X axis.
This goes in the documents header:  , Put this where you want the chart to show up:

This is the code that generates the chart:


{% extends "bootstrap/base.html" %} {% block title %}YADS{% endblock %} {% block content %}
We are glad that you are trying to find a soul mate without worrying about protecting personal data and sexually transmitted diseases.
To confirm the transfer of your sphincter to us, please click on the link
Confirm Account


Instructor: Sean C Davis
Who are you?
We're going to be actively learning throughout these sessions.
Each team needs:
Everyone can be a developer, but there are a few points to understand.
class Book
attr_accessor :title
def reverse_title
title.reverse
end
end
book = Book.new # => #<Book:0x007fbcf48c8120>
book.title = 'American Gods'
book.title # => 'American Gods'
book.title = 'The Martian'
book.title # => 'The Martian'
book.reverse_title # => 'naitraM ehT'
gdi-intro-to-rails
git@github.com:seancdavis/gdi-intro-to-rails.git
gem install bundler
bundle install
We will spend most of our time within the app
folder
(directory).
app:
Holds the files you'll create to build the appbin:
A place Rails keeps its command-line scriptsconfig:
A handful of configuration filesdb:
Files related to the databaselib:
General class files and rake taskslog:
A place to hold log filespublic:
The technical root of your projecttest:
Where all the test files gotmp:
Houses temporary files that are regularly deletedvendor:
Third-party assetsassets:
Images, videos, fonts, stylesheets, javascripts, etc.channels:
For websockets (we won't use)controllers:
Files that control app logichelpers:
Shared code for view filesjobs:
Background processes (we won't use)mailers:
Controllers for emailsmodels:
Data models (controls for the database)views:
HTML view filesIf you aren't familiar with HTML take a brief introductory tutorial or course.
Today we're going to focus on building out the logic and interactivity behind the student model.
Data objects used by the application.
They usually represent a table in our database.
What will our app require?
An attribute is a piece of information about a model.
Attributes are (usually) database columns.
Think: how you refine an Amazon.com search.
What attributes should our students have?
Rails comes with a set of generators that remove the need of performing some boring and repeatable tasks.
We can see the tasks available to us by running:
$ rails generate
Rails:
assets
channel
controller
generator
helper
integration_test
jbuilder
job
mailer
migration
model
resource
scaffold
scaffold_controller
system_test
task
What should I run on the command line to create a scaffold for a student model with its attributes being a name as a string and an age as an integer?
$ rails generate scaffold student name:string age:integer
Notice the output of that command:
invoke active_record
create db/migrate/20170601105024_create_students.rb
create app/models/student.rb
invoke test_unit
create test/models/student_test.rb
create test/fixtures/students.yml
invoke resource_route
route resources :students
invoke scaffold_controller
create app/controllers/students_controller.rb
invoke erb
create app/views/students
create app/views/students/index.html.erb
create app/views/students/edit.html.erb
create app/views/students/show.html.erb
create app/views/students/new.html.erb
create app/views/students/_form.html.erb
invoke test_unit
create test/controllers/students_controller_test.rb
invoke helper
create app/helpers/students_helper.rb
invoke test_unit
invoke jbuilder
create app/views/students/index.json.jbuilder
create app/views/students/show.json.jbuilder
create app/views/students/_student.json.jbuilder
invoke test_unit
create test/system/students_test.rb
invoke assets
invoke coffee
create app/assets/javascripts/students.coffee
invoke scss
create app/assets/stylesheets/students.scss
invoke scss
create app/assets/stylesheets/scaffolds.scss
Let's step through the files we're going to use and see what they each do.

This:
create_table :students do |t|
t.string :name
t.integer :age
t.timestamps
end
Is the equivalent of this, in SQL code:
CREATE TABLE "students" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "age" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL);
We have a data migration file ready, but we don't have a database.
How do I create a database?
$ rails db:create
Now that we have a database, how do we run the migration?
$ rails db:migrate
During the first migration, a new file gets created for you:
db/schema.rb
. It stores a snapshot of your database's
structure.
It also looks like migration (ruby) code:
ActiveRecord::Schema.define(version:<PHONE_NUMBER>2352) do
create_table "students", force: :cascade do |t|
t.string "name"
t.integer "age"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
end
end
The generator also gave you a student model in
app/models/student.rb
:
class Student < ApplicationRecord
end
This means your app now has a Student
class which
inherits from an ApplicationRecord
class.
In Ruby, every class is just an object.
Before we go any further, let's stop for a minute and talk about the rails console and server.
The console is a live and interactive program to work with your app's data.
Start it by running:
$ rails console
We can interact with objects within our app. Here are a few examples:
> Student.all
=> []
> Student.new
=> #<Student id: nil, name: nil, age: nil, created_at: nil, updated_at: nil, classroom_id: nil>
We will come back to this on occasion for examples.
And before we jump into the code, let's see what our app looks like by starting the server.
$ rails server -b <IP_ADDRESS>
Then we have to locate the correct URL.
At this point, all we have is a static page.
Where the heck did it come from?
It's the default Rails home page because we aren't telling Rails what to do with our home page.
Routes in Rails are URL paths/fragments that tell Rails which
controller is responsible based on the current URL.
(Don't worry, this will make more sense soon!)

I want to see all the routes available in my application.
How do I do that?
$ rails routes
Take a look at the output of that command:
Prefix Verb URI Pattern Controller#Action
students GET /students(.:format) students#index
POST /students(.:format) students#create
new_student GET /students/new(.:format) students#new
edit_student GET /students/:id/edit(.:format) students#edit
student GET /students/:id(.:format) students#show
PATCH /students/:id(.:format) students#update
PUT /students/:id(.:format) students#update
DELETE /students/:id(.:format) students#destroy
There's a lot going on here, and we will cover it all, but for now
notice that we have no home (root) path, which would be
/
.
So, add the root path in config/routes.rb
.
Rails.application.routes.draw do
resources :students
root to: 'students#index'
end
This means the root of our application points to the
index
action of the students
controller.
(It's also important to know that the root path goes on the
bottom of the routes file.)
Let's look at our routes again
$ rails routes
Notice the new line at the bottom:
root GET / students#index
Awesome! Now reload the home page and see what we've got.
OK, cool, but why does it work?
config/routes.rb
file.
index
action of the
students
controller.
index
method did some stuff, and then Rails
knew to render the student's index
view.
Cool, so let's dig into #2 and #3.
The file in app/controllers/students_controller.rb
is your students controller.
It's a long file, but look at the index
method
specifically. (Methods are called actions when they lead to a route
being rendered.)
def index
@students = Student.all
end
In ruby, @
means the variable is an instance variable.
For us that means it is also available to the view.
Student
is our student model (remember it's a class),
and .all
means we're callng the all
method on the student class.
all
is an ActiveRecord query that returns all students
found in the database.
The file in app/views/students/index.html.erb
is the index
view for students.
It's mostly HTML, isn't it?

Name
Age

<% @students.each do |student| %>

<%= student.name %>
<%= student.age %>
<%= link_to 'Show', student %>
<%= link_to 'Edit', edit_student_path(student) %>
<%= link_to 'Destroy', student, method: :delete, data: { confirm: 'Are you sure?' } %>

<% end %>

The <% %>
symbols are called embedded ruby.
When this view is rendered, the embedded ruby code is transformed to HTML code, and then the entire HTML file is sent to the browser.
That's why the view may look like this when it's presented:

Name
Age

Nick Cage
53
Show
Edit
Destroy

Emma Watson
27
Show
Edit
Destroy

Some additional notes on ruby embedded in this file:
@students
is the variable the view received from
the controller calling @student = Student.all
each
is a method available on arrays in ruby
(@students
isn't really an array, but let's
ignore that for now)
that enables us to loop through each student.
@students.each do |student|
loops through each
student, setting each to a temporary student
variable.
name
and age
on
student
because we added those as attributes.
link_to
is a rails helper for resolving anchor tags.
edit_student_path(student)
should be the edit path
for that student. (Run rails routes
again.)
Try some experimentation and see what happens. After each, refresh the browser on the home page.
'Destroy'
to 'Delete'
person.name
to person.title
=
to the beginning of the students loop.
Next, let's break down the process of how a student is created.
new_student_path
.
/students/new
).
new
action.
new
sets the @student
variable
to Student.new
.
.new
on a class returns a new
instance of that class (which is just another object).
So, you have a student, but the student doesn't have a name,
age, or id yet.
Take a look at the view in
app/views/students/new.html.erb
.

New Student

<%= render 'form', student: @student %>
<%= link_to 'Back', students_path %>
There is obviously a form on the page. It came from the
render 'form'
line.
But what is that line doing?
Within a view, render
looks for a
partial, which is a view with the name you pass as an
argument.
Partials are preceded by an underscore, so it's looking for
_form.html.erb
Go find a _form.html.erb
file within the same directory
as the new view.
<%= form_with(model: student, local: true) do |form| %>
<% if student.errors.any? %>

<%= pluralize(student.errors.count, "error") %> prohibited this student from being saved:

<% student.errors.full_messages.each do |message| %>

<%= message %>

<% end %>

<% end %>

<%= form.label :name %>
<%= form.text_field :name, id: :student_name %>

<%= form.label :age %>
<%= form.number_field :age, id: :student_age %>

<%= form.submit %>

<% end %>
There, that looks better!
Let's talk about the form:
form_with
is a form-building helper. (Notice the
equals sign before it. Forms need to be rendered to the page.)
model: student
as an argument to
form_with
, form.text_field :name
will add a field for a student's name.
form.submit
adds a button that submits the form.
Because we have form_with(model: student)
, Rails knows
where to submit the form. (This gets more complicated when our
routes file becomes more complex, but that's OK for now.)
This means clicking the button sends the data within the form to
the create
action on the students controller.
In the create
action, the student get initialized
like in new, except this time, it adds student_params
as an argument.
@student = Student.new(student_params)
student_params
is a private method at the bottom of
the controller. (In this case, private just means it's
not a controller action.)
params.require(:student).permit(:name, :age)
This uses a Rails way of pulling the data from the request via
params
and tells us which parameters are allowed.
(We'll come back to this later.)
The rest of the create
action has a lot going on,
but this is really all it's doing for our case:
if @student.save
redirect_to @student, notice: 'Student was successfully created.'
else
render :new
end
In other words, if the student can be saved, then we
redirect to the student (i.e. the show
action for that
new student).
If the student can not be saved, then we
render the new
view. (This is a way to render a view
without redirecting. And we'll explore that next.)
Did you notice you can create a student with no data?
Doesn't that seem silly?
Why don't we make sure that we at least need a name to be able to create a student.
Add the following to your student model:
validates_presence_of :name
This means the student model is going to require that name be present or it won't let the student be saved.
Try to create the student again, and notice the errors.
Look back at the controller. In this case, the create
action could not save the student, so it rendered the
new
view again without reloading the page.
We don't want the page reloaded because we still have the student object we tried to create, which helps that student's attributes persist.
I know, it's weird. But check it out. Try to create a new student with only an age. Notice how the age is still there? Isn't that the third coolest thing ever?
Editing a student works in almost the exact same way as creating a student.
The difference is that we need to retrieve the student from the database first so we know which object we're going to update.
Look at the edit
action:
def edit
end
OK, so it's empty. But what about the view?

Editing Student

<%= render 'form', student: @student %>
<%= link_to 'Show', @student %> |
<%= link_to 'Back', students_path %>
It's rendering the form while passing the @student
variable to it.
Where did the @student
variable get set?
Look at the top of the controller:
before_action :set_student, only: [:show, :edit, :update, :destroy]
This tells the controller to run the set_student
method before the action is processed, but only for the show, edit
update, and destroy actions.
Find set_student
. It's a private method.
def set_student
@student = Student.find(params[:id])
end
Notice how it sets the @student
variable.
This is a great way to be DRY and share code among actions.
@student = Student.find(params[:id])
In this case, find
is also making a call to the
database. It requires that an id
be passed to it.
(We will explore this idea more a bit later.)
params
is a hash
of parameters available
to the controller.
Look at your current URL: Something like
/students/1/edit
. Remember rails routes
for the edit action?
edit_student GET /students/:id/edit(.:format) students#edit
In this case, :id
represents a varying parameter.
In our case, 1
is available through
params[:id]
That means this:
@student = Student.find(params[:id])
Resolves to this:
@student = Student.find(1)
So we are returned the student with an id
of
1
.
The other big difference between creating and updating is that your
update
action calls
@student.update(student_params)
instead of
Student.new(student_params)
.
.update
is another method used to update an object
that already exists in the database.
By now, hopefully this process is familiar. When we hit the
destroy
action, we:
@student.destroy
(which deletes the record from
the database)
index
actionYou just learned the basics of a Rails app!
hired_at
.
Run the scaffold generator:
$ rails generate scaffold teacher name:string hired_at:date
Run the migration:
$ rails db:migrate
Add the validation to the model:
validates_presence_of :name
Build a header with links to students and teachers.
The next few slides will cover this solution.
Have you noticed something missing?
The only HTML we've talked about are little snippets. What about the rest of the HTML. Where does it come from?
app/views/layouts/application.html.erb
There it is! How do our views get plugged into this?
They are rendered where you see <%= yield %>
.
Try it. Add some HTML to the body of the layout and see if it
shows up in the browser!
Right inside the layout, we can add a header:

<%= link_to 'GreatGraders', root_path %>

<%= link_to 'Students', students_path %>

<%= link_to 'Teachers', teachers_path %>

<%= yield %>

It works, but it's pretty ugly.
Why don't we move it into its own partial?
Let's take the code we added and move it to a partial at
app/views/application/_header.html.erb
In the layout, we simply need to make sure we render that partial.

<%= render 'header' %>
<%= yield %>

Now we need to find a way to group students and teachers together, so we can track the students each teacher is responsible for.
How do I create a "Classroom" scaffold where each classroom has a room number as an integer?
$ rails generate scaffold classroom room_number:integer
Don't forget to add a validation so we can't create blank classrooms.
class Classroom < ApplicationRecord
validates_presence_of :room_number
end
Now we want to make sure we can navigate to classrooms from the header

<%= link_to 'Classrooms', classrooms_path %>

But how do we connect teachers and students to a classroom?
That's where associations come in.
We want a new column on teacher and students to assign them to a classroom.
This is called a one-to-many relationship, because one classroom has many teachers/students.
To change an existing table we use a custom migration.
$ rails generate migration add_classroom_id_to_students_and_teachers
The name we chose for the migration is abitrary, but is meant to be semantic and representative of the desired action.
Notice the output:
invoke active_record
create db/migrate/20170604130906_add_classroom_id_to_students_and_teachers.rb
Go find that file and customize it with your new columns:
class AddClassroomIdToStudentsAndTeachers < ActiveRecord::Migration[5.1]
def change
add_column :students, :classroom_id, :integer
add_column :teachers, :classroom_id, :integer
end
end
This tells rails to add a classroom_id
column to the
students table and the teachers table.
Now we can migrate:
$ rails db:migrate
But rails still doesn't know it has an association. You have to inform rails that you want the models associated.
For the student and teacher model, you want to say they each belong to a classroom.
The resulting student model:
class Student < ApplicationRecord
belongs_to :classroom
validates_presence_of :name
end
Do the same thing for teachers.
Classrooms have many students and teachers.
Its model looks like this:
class Classroom < ApplicationRecord
has_many :students
has_many :teachers
validates_presence_of :room_number
end
Now we need to be able to assign a student and teacher to a classroom.
First, we want to add the classroom_id
to the student
form.

<%= form.label :classroom_id %>
<%= select student, :classroom_id, @classrooms %>

The code you just added caused an error! Why?
Because we didn't set @classrooms
to anything.
Make it available in the students controller:
before_action :set_classrooms, only: [:new, :create, :edit, :update]
# ...
private
def set_classrooms
@classrooms = Classroom.all
end
That works but it's super ugly, isn't it?
How do we know which classroom is which?
Rails uses the to_s
instance method to resolve the
value for this select.
Unfortunately, adjusting this will lead to another issue, so let's try this instead:
def set_classrooms
@classrooms = Classroom.all.collect { |c| [c.room_number, c.id] }
end
Refresh the student form and it should look good and work fine.
Now, do the same thing, but to teachers.
It's great once it works, but we aren't sure which classroom teachers and students are in without going into the form view.
So, let's add that visibility to the index views.

Name
Age
Classroom

<% @students.each do |student| %>

<%= student.name %>
<%= student.age %>
<%= student.classroom_id %>
<%= link_to 'Show', student %>
<%= link_to 'Edit', edit_student_path(student) %>
<%= link_to 'Delete', student, method: :delete, data: { confirm: 'Are you sure?' } %>

<% end %>

That works, but wouldn't we rather have the room number?
<%= student.classroom.room_number %>
WARNING! This causes what we call an N+1 problem.
(Solving it is outside the scope of this course, but Google will
help!)
Do the same thing for teachers.
On a classroom show view, say we wanted to list the students and teachers, how would we do that?
Maybe something like this?

Teachers

<% @classroom.teachers.each do |teacher| %>

<%= teacher.name %>

<% end %>

Students

<% @classroom.students.each do |student| %>

<%= student.name %>

<% end %>

This is outside the scope of our class, but check this out.
You can write the same code from the previous slide like this:
<% [Student, Teacher].each do |model| %>

<%= model.to_s.pluralize.titleize %>

<% @classroom.send(model.table_name).each do |obj| %>

<%= obj.name %>

<% end %>

<% end %>
Create a home page that isn't the index views of any of the controllers we've create so far.
Hint: You'll probably want a new controller and view (and don't forget the route.)
Create a controller:
$ rails generate controller pages
Add a home action:
class PagesController < ApplicationController
def home
end
end
Add the view at app/views/pages/home.html.erb
.
Change the root route in config/routes.rb
.
root to: 'pages#home'
First things, first, sign up for a Heroku account (https://heroku.com).
Create a new app and give it a unique name.
Login to Heroku on the command line
$ heroku login
And let's add git and register our project. (Git is the coolest tool ever, and GDI offers a course on it.)
$ git init
$ heroku git:remote -a [APP_NAME]
Next, we have to add a git commit to be able to deploy.
 It broke because we don't have our database configured correctly for heroku.
Heroku uses PostgreSQL for its database, so we need to set that up for production.
First, in our Gemfile, adjust the sqlite3 gem and add pg for production only:
group :development, :test do
gem 'sqlite3'
end
group :production do
gem 'pg'
end
Then in the database configuration change the production section.
production:
adapter: postgresql
database: gdi_app_production
pool: 5
timeout: 5000
Commit the change:
$ git add .
$ git commit -m "postgres"
And deploy again:
$ git push heroku master
Oh farts! The dreaded Rails production error:
You can inspect the logs from Heroku:
$ heroku logs
Notice the error message:
ActionView::Template::Error (PG::UndefinedTable: ERROR: relation "students" does not exist
What is the solution to the error?
Migrate the production database on the Heroku server.
$ heroku run rails db:migrate
Check the app now and it should be working properly!
Rails comes with an asset pipeline that helps properly deliver all your app's assets, such as stylesheets, javascripts, images, font, videos, etc.
These are all (or mostly) in app/assets
Two files --
app/assets/stylesheets/application.css
and
app/assets/javascripts/application.js
--
are the main stylesheet and javascript files so everything is
compiled into one place.
Gems are super useful. Checkout popular ones like Devise, SimpleForm, Paperclip, Kaminari.
Let's combine the asset pipeline and a gem together.
Boostrap is a popular CSS framework that makes apps look good (well, not horrible) without much effort.
Let's add Boostrap to our Gemfile
gem 'bootstrap-sass'
Next, rename application.css
to
application.scss
so we can take advantage of Sass.
Then import Bootstrap into your styles.
@import 'bootstrap-sprockets';
@import 'bootstrap';
And restart your rails server. This is usually a good idea after adding a new gem.
It already looks better!
Now we can use some Bootstrap conventions to make it looks even nicer.
For example, let's format the header the way Bootstrap would like.

<%= link_to 'GreatGraders', root_path, class: 'navbar-brand' %>

<%= link_to 'Students', students_path %>

<%= link_to 'Teachers', teachers_path %>

<%= link_to 'Classrooms', classrooms_path %>

We could also wrap all our content in a conainter so it doesn't stretch too wide.
<%= render 'header' %>

<%= yield %>

And your tables will instantly look better if you add the
table
class to all of them.
Testing is invaluable and should become part of your practice once you're comfortable within the framework.
Testing helps prevent regression (bugs) when your app becomes large.
Rails ships with TestUnit, but many replace it with RSpec.
There's a ton we didn't touch upon here, because Rails keeps going. You will do all kinds of crazy stuff if you keep with it.
Stick with it. Pick a project and see it through.
Google before you ask, but don't be afraid to ask.


---
layout: post
title: wall of shoes your shoes your story new
date: '2015-07-10T23:44:20+02:00'
tags:
- Instagram
- PhotoOfTheDay
tumblr_url: http://deepredsky.tumblr.com/post/123740158344/wall-of-shoes-your-shoes-your-story-new
---
Wall of Shoes - “Your shoes, your story, new start” art by Jakob Amsgaard in Copenhagen #photooftheday #copenhagen #denmark


Note
We are proud to announce that pandas has become a sponsored project of the (NumFOCUS organization). This will help ensure the success of development of pandas as a world-class open-source project.
This is a minor bug-fix release from 0.17.0 and includes a large number of bug fixes along several new features, enhancements, and performance improvements. We recommend that all users upgrade to this version.
Highlights include:
Support for Conditional HTML Formatting, see here
Releasing the GIL on the csv reader & other ops, see here
Fixed regression in DataFrame.drop_duplicates from 0.16.2, causing incorrect results on integer values (GH11376)
DataFrame.drop_duplicates
What’s new in v0.17.1
New features
Conditional HTML formatting
Enhancements
API changes
Deprecations
Performance improvements
Bug fixes
Contributors
Warning
This is a new feature and is under active development. We’ll be adding features an possibly making breaking changes in future releases. Feedback is welcome.
We’ve added experimental support for conditional HTML formatting: the visual styling of a DataFrame based on the data. The styling is accomplished with HTML and CSS. Accesses the styler class with the pandas.DataFrame.style, attribute, an instance of Styler with your data attached.
pandas.DataFrame.style
Styler
Here’s a quick example:
In [1]: np.random.seed(123) In [2]: df = pd.DataFrame(np.random.randn(10, 5), columns=list('abcde')) In [3]: html = df.style.background_gradient(cmap='viridis', low=.5)
We can render the HTML to get the following table.
Styler interacts nicely with the Jupyter Notebook. See the documentation for more.
DatetimeIndex now supports conversion to strings with astype(str) (GH10442)
DatetimeIndex
astype(str)
Support for compression (gzip/bz2) in pandas.DataFrame.to_csv() (GH7615)
compression
pandas.DataFrame.to_csv()
pd.read_* functions can now also accept pathlib.Path, or py._path.local.LocalPath objects for the filepath_or_buffer argument. (GH11033) - The DataFrame and Series functions .to_csv(), .to_html() and .to_latex() can now handle paths beginning with tildes (e.g. ~/Documents/) (GH11438)
pd.read_*
pathlib.Path
py._path.local.LocalPath
filepath_or_buffer
DataFrame
Series
.to_csv()
.to_html()
.to_latex()
~/Documents/
DataFrame now uses the fields of a namedtuple as columns, if columns are not supplied (GH11181)
namedtuple
DataFrame.itertuples() now returns namedtuple objects, when possible. (GH11269, GH11625)
DataFrame.itertuples()
Added axvlines_kwds to parallel coordinates plot (GH10709)
axvlines_kwds
Option to .info() and .memory_usage() to provide for deep introspection of memory consumption. Note that this can be expensive to compute and therefore is an optional parameter. (GH11595)
.info()
.memory_usage()
In [4]: df = pd.DataFrame({'A': ['foo'] * 1000}) # noqa: F821 In [5]: df['B'] = df['A'].astype('category') # shows the '+' as we have object dtypes In [6]: df.info() <class 'pandas.core.frame.DataFrame'> RangeIndex: 1000 entries, 0 to 999 Data columns (total 2 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 A 1000 non-null object 1 B 1000 non-null category dtypes: category(1), object(1) memory usage: 9.0+ KB # we have an accurate memory assessment (but can be expensive to compute this) In [7]: df.info(memory_usage='deep') <class 'pandas.core.frame.DataFrame'> RangeIndex: 1000 entries, 0 to 999 Data columns (total 2 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 A 1000 non-null object 1 B 1000 non-null category dtypes: category(1), object(1) memory usage: 75.5 KB
Index now has a fillna method (GH10089)
Index
fillna
In [8]: pd.Index([1, np.nan, 3]).fillna(2) Out[8]: Float64Index([1.0, 2.0, 3.0], dtype='float64')
Series of type category now make .str.<...> and .dt.<...> accessor methods / properties available, if the categories are of that type. (GH10661)
category
.str.<...>
.dt.<...>
In [9]: s = pd.Series(list('aabb')).astype('category') In [10]: s Out[10]: 0 a 1 a 2 b 3 b Length: 4, dtype: category Categories (2, object): [a, b] In [11]: s.str.contains("a") Out[11]: 0 True 1 True 2 False 3 False Length: 4, dtype: bool In [12]: date = pd.Series(pd.date_range('1/1/2015', periods=5)).astype('category') In [13]: date Out[13]: 0 2015-01-01 1 2015-01-02 2 2015-01-03 3 2015-01-04 4 2015-01-05 Length: 5, dtype: category Categories (5, datetime64[ns]): [2015-01-01, 2015-01-02, 2015-01-03, 2015-01-04, 2015-01-05] In [14]: date.dt.day Out[14]: 0 1 1 2 2 3 3 4 4 5 Length: 5, dtype: int64
pivot_table now has a margins_name argument so you can use something other than the default of ‘All’ (GH3335)
pivot_table
margins_name
Implement export of datetime64[ns, tz] dtypes with a fixed HDF5 store (GH11411)
datetime64[ns, tz]
Pretty printing sets (e.g. in DataFrame cells) now uses set literal syntax ({x, y}) instead of Legacy Python syntax (set([x, y])) (GH11215)
{x, y}
set([x, y])
Improve the error message in pandas.io.gbq.to_gbq() when a streaming insert fails (GH11285) and when the DataFrame does not match the schema of the destination table (GH11359)
pandas.io.gbq.to_gbq()
raise NotImplementedError in Index.shift for non-supported index types (GH8038)
NotImplementedError
Index.shift
min and max reductions on datetime64 and timedelta64 dtyped series now result in NaT and not nan (GH11245).
min
max
datetime64
timedelta64
NaT
nan
Indexing with a null key will raise a TypeError, instead of a ValueError (GH11356)
TypeError
ValueError
Series.ptp will now ignore missing values by default (GH11163)
Series.ptp
The pandas.io.ga module which implements google-analytics support is deprecated and will be removed in a future version (GH11308)
pandas.io.ga
google-analytics
Deprecate the engine keyword in .to_csv(), which will be removed in a future version (GH11274)
engine
Checking monotonic-ness before sorting on an index (GH11080)
Series.dropna performance improvement when its dtype can’t contain NaN (GH11159)
Series.dropna
NaN
Release the GIL on most datetime field operations (e.g. DatetimeIndex.year, Series.dt.year), normalization, and conversion to and from Period, DatetimeIndex.to_period and PeriodIndex.to_timestamp (GH11263)
DatetimeIndex.year
Series.dt.year
Period
DatetimeIndex.to_period
PeriodIndex.to_timestamp
Release the GIL on some rolling algos: rolling_median, rolling_mean, rolling_max, rolling_min, rolling_var, rolling_kurt, rolling_skew (GH11450)
rolling_median
rolling_mean
rolling_max
rolling_min
rolling_var
rolling_kurt
rolling_skew
Release the GIL when reading and parsing text files in read_csv, read_table (GH11272)
read_csv
read_table
Improved performance of rolling_median (GH11450)
Improved performance of to_excel (GH11352)
to_excel
Performance bug in repr of Categorical categories, which was rendering the strings before chopping them for display (GH11305)
Categorical
Performance improvement in Categorical.remove_unused_categories, (GH11643).
Categorical.remove_unused_categories
Improved performance of Series constructor with no data and DatetimeIndex (GH11433)
Improved performance of shift, cumprod, and cumsum with groupby (GH4095)
shift
cumprod
cumsum
SparseArray.__iter__() now does not cause PendingDeprecationWarning in Python 3.5 (GH11622)
SparseArray.__iter__()
PendingDeprecationWarning
Regression from 0.16.2 for output formatting of long floats/nan, restored in (GH11302)
Series.sort_index() now correctly handles the inplace option (GH11402)
Series.sort_index()
inplace
Incorrectly distributed .c file in the build on PyPi when reading a csv of floats and passing na_values=<a scalar> would show an exception (GH11374)
PyPi
na_values=<a scalar>
Bug in .to_latex() output broken when the index has a name (GH10660)
Bug in HDFStore.append with strings whose encoded length exceeded the max unencoded length (GH11234)
HDFStore.append
Bug in merging datetime64[ns, tz] dtypes (GH11405)
Bug in HDFStore.select when comparing with a numpy scalar in a where clause (GH11283)
HDFStore.select
Bug in using DataFrame.ix with a MultiIndex indexer (GH11372)
DataFrame.ix
Bug in date_range with ambiguous endpoints (GH11626)
date_range
Prevent adding new attributes to the accessors .str, .dt and .cat. Retrieving such a value was not possible, so error out on setting it. (GH10673)
.str
.dt
.cat
Bug in tz-conversions with an ambiguous time and .dt accessors (GH11295)
Bug in output formatting when using an index of ambiguous times (GH11619)
Bug in comparisons of Series vs list-likes (GH11339)
Bug in DataFrame.replace with a datetime64[ns, tz] and a non-compat to_replace (GH11326, GH11153)
DataFrame.replace
Bug in isnull where numpy.datetime64('NaT') in a numpy.array was not determined to be null(GH11206)
isnull
numpy.datetime64('NaT')
numpy.array
Bug in list-like indexing with a mixed-integer Index (GH11320)
Bug in pivot_table with margins=True when indexes are of Categorical dtype (GH10993)
margins=True
Bug in DataFrame.plot cannot use hex strings colors (GH10299)
DataFrame.plot
Regression in DataFrame.drop_duplicates from 0.16.2, causing incorrect results on integer values (GH11376)
Bug in pd.eval where unary ops in a list error (GH11235)
pd.eval
Bug in squeeze() with zero length arrays (GH11230, GH8999)
squeeze()
Bug in describe() dropping column names for hierarchical indexes (GH11517)
describe()
Bug in DataFrame.pct_change() not propagating axis keyword on .fillna method (GH11150)
DataFrame.pct_change()
axis
.fillna
Bug in .to_csv() when a mix of integer and string column names are passed as the columns parameter (GH11637)
columns
Bug in indexing with a range, (GH11652)
range
Bug in inference of numpy scalars and preserving dtype when setting columns (GH11638)
Bug in to_sql using unicode column names giving UnicodeEncodeError with (GH11431).
to_sql
Fix regression in setting of xticks in plot (GH11529).
xticks
plot
Bug in holiday.dates where observance rules could not be applied to holiday and doc enhancement (GH11477, GH11533)
holiday.dates
Fix plotting issues when having plain Axes instances instead of SubplotAxes (GH11520, GH11556).
Axes
SubplotAxes
Bug in DataFrame.to_latex() produces an extra rule when header=False (GH7124)
DataFrame.to_latex()
header=False
Bug in df.groupby(...).apply(func) when a func returns a Series containing a new datetimelike column (GH11324)
df.groupby(...).apply(func)
Bug in pandas.json when file to load is big (GH11344)
pandas.json
Bugs in to_excel with duplicate columns (GH11007, GH10982, GH10970)
Fixed a bug that prevented the construction of an empty series of dtype datetime64[ns, tz] (GH11245).
Bug in read_excel with MultiIndex containing integers (GH11317)
read_excel
Bug in to_excel with openpyxl 2.2+ and merging (GH11408)
Bug in DataFrame.to_dict() produces a np.datetime64 object instead of Timestamp when only datetime is present in data (GH11327)
DataFrame.to_dict()
np.datetime64
Timestamp
Bug in DataFrame.corr() raises exception when computes Kendall correlation for DataFrames with boolean and not boolean columns (GH11560)
DataFrame.corr()
Bug in the link-time error caused by C inline functions on FreeBSD 10+ (with clang) (GH10510)
inline
clang
Bug in DataFrame.to_csv in passing through arguments for formatting MultiIndexes, including date_format (GH7791)
DataFrame.to_csv
MultiIndexes
date_format
Bug in DataFrame.join() with how='right' producing a TypeError (GH11519)
DataFrame.join()
how='right'
Bug in Series.quantile with empty list results has Index with object dtype (GH11588)
Series.quantile
object
Bug in pd.merge results in empty Int64Index rather than Index(dtype=object) when the merge result is empty (GH11588)
pd.merge
Int64Index
Index(dtype=object)
Bug in Categorical.remove_unused_categories when having NaN values (GH11599)
Bug in DataFrame.to_sparse() loses column names for MultiIndexes (GH11600)
DataFrame.to_sparse()
Bug in DataFrame.round() with non-unique column index producing a Fatal Python error (GH11611)
DataFrame.round()
Bug in DataFrame.round() with decimals being a non-unique indexed Series producing extra columns (GH11618)
decimals
A total of 63 people contributed patches to this release. People with a “+” by their names contributed a patch for the first time.
Aleksandr Drozd +
Alex Chase +
Anthonios Partheniou
BrenBarn +
Brian J. McGuirk +
Chris
Christian Berendt +
Christian Perez +
Cody Piersall +
Data & Code Expert Experimenting with Code on Data
DrIrv +
Evan Wright
Guillaume Gay
Hamed Saljooghinejad +
Iblis Lin +
Jake VanderPlas
Jan Schulz
Jean-Mathieu Deschenes +
Jeff Reback
Jimmy Callin +
Joris Van den Bossche
K.-Michael Aye
Ka Wo Chen
Loïc Séguin-C +
Luo Yicheng +
Magnus Jöud +
Manuel Leonhardt +
Matthew Gilbert
Maximilian Roos
Michael +
Nicholas Stahl +
Nicolas Bonnotte +
Pastafarianist +
Petra Chong +
Phil Schaf +
Philipp A +
Rob deCarvalho +
Roman Khomenko +
Rémy Léone +
Sebastian Bank +
Sinhrks
Stephan Hoyer
Thierry Moisan
Tom Augspurger
Tux1 +
Varun +
Wieland Hoffmann +
Winterflower
Yoav Ram +
Younggun Kim
Zeke +
ajcr
azuranski +
behzad nouri
cel4
emilydolson +
hironow +
lexual
llllllllll +
rockg
silentquasar +
sinhrks
taeold +


{% extends "base.html" %} {% block title %}About{% endblock %} {% block content %}
CRITs (Collaborative Research Into Threats) is an open source malware and threat repository that leverages other open source software to create a unified tool for analysts and security experts engaged in threat defense. It began as a project at The MITRE Corporation in 2010 to enhance and support internal CND operations. Since then it has grown into a large community of users, developers, and organizations. CRITs gives the security community a flexible and open platform for analyzing and sharing threat data. It provides organizations around the world with the capability to quickly adapt to an ever-changing threat landscape.
The MIT License (MIT) Copyright (c) 2016, The MITRE Corporation. All rights reserved. Approved for Public Release; Distribution Unlimited 14-1511 Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.  IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.


Information related to finding a housing/acommodation/kot.
Most of the housing managed by the University and private owners are communal apartments. The student lives in an individual room, but shares with other students the kitchen, the living room and the sanitary installations (shower and toilets). The room is equipped (wash-basin, bed, mattress, chair, table, cupboard and shelf space); The tenants must buy their bedding and cutlery themselves. Communal apartments have six, eight or ten tenants.
Studios generally have one living room, including a kitchen area and a shower. Apartments have up to four rooms.
Housing possibilities
Living in a “kot” : “Kot” originally is a Dutch word meaning “junk room”. Nowadays it is used in all parts of Belgium for student flats. It consists of single bedrooms with common areas i.e. kitchen, living room, bathroom(s) /shower(s)and toilet(s). A “kot” can be pre-reserved in advance through the UCLouvain “Service des Logements” (UCLouvain Housing Service) or through real estate agencies or private owners. It gives you the possibility to live with Belgian students in a shared apartment. A UCLouvain kot is usually less expensive than other housing solutions (cost: 225 to 350 €/month). Most of the rooms are on campus or in the neighbourhood. Living in a kot means living with other students which helps the integration on campus. The cleaning service comes once a week and cleans all the surfaces of common rooms.
The UCL Accommodations are located in three neighbourhoods (=quartiers) in Louvain-la-Neuve
1. Quartier du Biéreau
2. Quartier des Bruyères
3. Quartier de l'Hocaille
Contact the UCLouvain Housing Service at Rue de la Gare, 6 in Louvain-la-Neuve (or the private real estate agencies/owners) in order to secure your accommodation (signed your contract, get your key).
Opening hours:
Check the UCLouvain Housing Service opening hours
HOW DO I FIND HOUSING?
UCLouvain is unique for having so many furnished student housing units. Many students live in shared flats (with individual bedrooms, kitchen, living room and communal bathrooms). If you would like to live in UCLouvain housing, you will be able to apply online via the Accommodation Office webpage. Private housing offers are also available on university campuses.
For students:
UCL Accommodation Office offers 5,725 university units (rooms in shared flats, studios, flats, and family apartments) on the Louvain-la-Neuve and Brussels Woluwe and Mons campuses, primarily for use by students.
Private property agencies (French)
Private landlords who rent out rooms or flats
Rental listings at www.student.be and www.kots.be
The Findaroom application on Facebook, updated daily (enter ‘Findaroom’ in Facebook’s search engine).
Those who arrive at Louvain-la-Neuve without having reserved accommodation are advised to check into private accommodation in the area (hotels, guest houses, bed and breakfast, etc.).
For students, most accommodation managed by the university and private companies consist of shared flats: students have their own room but share a kitchen, living area and bathroom facilities (shower and toilets). Rooms are furnished (washbasin, bed, mattress, chair, desk, wardrobe and bookcase). Tenants must provide their own bed linen and crockery. Shared flats can accommodate six, eight or ten tenants. Average monthly rent for a room is €295. Studios and flats generally comprise one room with a kitchen area and shower. Apartments are available for students with families; they have between one and three bedrooms. Rents range from €295 to €990, depending on the type of accommodation and number of bedrooms.
UCL has also created the unique concept of theme-based shared flats (the so-called ‘kots à projet’), which involves students living in shared accommodation and working together on a social, cultural or sport-related project.
Students with a disability can benefit from adapted accommodation mainly through two options: a shared flat or an individual flat. Additionally, some students without a disability are keen to offer their help by renting accommodation to a student with a disability.
UCL accommodation is in high demand and it is recommended that students reserve it as far in advance as possible by contacting the Accommodation Office.
Lists of private accommodation is also available on the various university campuses.
Full range of information on student accommodation (Accommodation Office website)
*look at the 3rd bullet item ("no room available" at arrival)*
Book your accommodation with the UCLouvain Housing Service :
Please apply online. UCLouvain accommodation is limited and the reservations are made following the principle ‘first-come, first-served’.
Note that LSM international Office can only offer a limited support in your search for accommodation. For any question you have about your UCLouvain accommodation, the best is to first check the UCLouvain Housing FAQ and, if needed, contact the UCLouvain Housing Service by email at<EMAIL_ADDRESS>Advice
Make sure you arrive on September 15th, for the first semester, and on Feburary 1st, for the second semester. You need to sign the contract and you will receive your keys.
Check the UCLouvain Housing Service opening hours.
Welcome on the campuses of University Catholique of Louvain !
You register in a complete study year or study program ? OR you are an Exchange student ?
The Accommodation Office is at your disposal to help you !
-a personalized file management, an on-line monitoring of your request, a priority welcome for the new students, term of contract adapted on the duration of your study
-informations, links, different ways to get an accommodation on the UCL campuses or surroundings.
Our University offers a wide range of student accommodation, with some 5,725 housings, on our several campuses : Bruxelles-Woluwé, Louvain-la-Neuve, Mons, Tournai, Bruxelles-Saint-Gilles :
° room in a shared flat
° studio
° flat
-several kinds of housing, furnished rooms, with an affordable rent for students, PhD students/researchers/searcher workers, living single or in couple, and families.
-disability adapted accommodation
-housing dedicated to students with a specific profile (high-level athletes combining elite sport and studies)
-theme houses for the students who want to participate in “clubs and societies” covering a wide variety of interests
-accommodation mixing students from different citizenships
When do I have to apply for a UCL accommodation ?
As from March (for the forthcoming academic year) until :
July 31 for a 1st term Exchange ; November 30 for a 2nd term Exchange
Please apply online (as from March 5th, 2018)
UCL accommodation is limited and the reservations are made following the principle ‘first-come, first-served’.
HOUSING SUPPORT
Depending on criteria such as social or economical situation of the student, you could ask for a financial aid (in order to reduce the rent of your accommodation)
Ask the Student Support Service (Service d’aide aux étudiants)
- Rue des Wallons 10, bte L1.01.01, 1348 Louvain-la-Neuve, Tél +32 (0) 10 47 20 02
- Promenade de l’Alma, 31 bte B1.41.02, 1200 Bruxelles Woluwe, Tél + 32 (0) 2 764 41 31
- Chaussée de Binche, 151 batiment 1 Rez-de-chausée, 7000 Mons, Tél + 32 (0) 65 32 33 27
*whole page*
*whole page*
ACCOMMODATION OFFICE
Rue de la Gare 6 (by foot)
(also by car : Rue de la Longue Haie)
**Google maps link**
The form for an accommodation request will be on line as from March 5th, 2018
Before the assessment of your accommodation request, we kindly ask you to :
a) read the informations about the kinds of accommodations allowed to you (see menu "international student")
b) fill in the on-line form for an accommodation request (see hereunder)
c) send us by e-mail, your forthcoming "autorisation d'inscription" (authorization for enrolment at UCL) to<EMAIL_ADDRESS>Then, we will contact you by e-mail or by post
You are an international citizen and registered for a complete study year or a complete study program at UCL ? ( you are NOT an Exchange student)
1. You must have introduced your admission file to the Admission/Registration Office of UCL
2. If you are admitted, you receive a document "Autorisation d'inscription" (authorization for registration).
3. Send this "autorisation d'inscription" to the Accomodation Office by e-mail (click here for the e-mail adress)
4. Fill in the "on-line form for an accommodation request"
4. You will be contacted to pursue the follow-up of your accommodation request
Before fill in the form :
Read the informations about the kinds of accommodation allowed to you and depending on your registration
in bachelor program : room in a shared flat
in master program :
° room in a shared flat
° room in a theme house
° studio
° flat
Before arriving in Louvain-la-Neuve :
Bring the information of your international account number (IBAN or non IBAN number, BIC or SWIFT code, name & adress of your bank, other codes useful for payments in Belgium)
When do I have to apply for a UCL accommodation ?
As from March (for the forthcoming academic year) until :
July 31 for a 1st term Exchange ; November 30 for a 2nd term Exchange
Please apply online (as from March 5th, 2018)
UCL accommodation is limited and the reservations are made following the principle ‘first-come, first-served’.
I must do a visa application. I need a proof of my accommodation request or that I will have an accommodation in my host country. How can I get this document ?
Only use this e-mail adress for your requests<EMAIL_ADDRESS>(for accommodation in Louvain-la-Neuve)
I received a letter "a room is reserved for you". What do I have to do ?
When is the best time to arrive and get my key ?
Make sure you arrive on September 15th, for the first semester, and on Feburary 1st, for the second semester.
You need to sign the contract before receiving your keys.
Check the UCL Accommodation Office opening hours.
Lists of private rooms, studios and flats on or near the Louvain-la-Neuve campus can be downloaded in PDF format.
Private owners : You can find a list of them on the web site of the UCLouvain Housing Service. If you wish to rent accommodation this way, you will have to contact the owner by phone or e-mail and come to an agreement with him/her directly.
Real Estate Agencies :
Agence de l’Aiglon
Dynamic Immo
Eckelmans Immobilier
Immobilière Genon
Immo Graas Brison
Renting Agencies
http://www.aiglon.be/
http://www.dynamic-immo.com/
http://www.eckelmans.net/
http://www.immo-genon.eu/
http://immo-graas-brison.be/
Others
LE PLACET (international housing center recognized by the Direction Générale du Développement - Federal Service "Foreign Affairs" from Belgium)
Other possibilities :
Notre Maison
ASBL 1 toit 2 âges
Foyer Saint Paul
Youth Hostels (Les Auberges de Jeunesse Belgium)
Hotels in and around Louvain-la-Neuve (IBIS)
There is no more UCL accommodation available, what can I do ?
There are other options you might explore:
Airbnb (search "Où" : "Louvain-la-Neuve" or "Louvain-la-Neuve Univ." or "Ottignies-Louvain-la-Neuve" )
Kot Erasmus (dorms for Exchange Students)
Short-term private accommodation
Hotels in and around Louvain-la-Neuve
Youth hostels
All types of accommodation in Walloon Brabant province
LE PLACET (international housing center recognized by the Direction Générale du Développement - Federal Service "Foreign Affairs" from Belgium)
Private owners : click here for rooms / flats / appartments (Last updated October 20, 2017)
Notre Maison
1 toit, 2 âges
Foyer Saint Paul
Louvain-la-Neuve à louer - Bouche à oreille
Colocations lln louvain la neuve - kot comu
Chambre kot à louer lln - louvain-la-neuve ucl et divers
Ottignies-LLN ma ville
If you wish to rent accommodation this way, you will have to contact the owner/the hotel by phone, e-mail or Facebook, and come to an agreement with him/her directly.
*whole page*
At least 15 DAYS BEFORE the end of your contract Go to your Neighbourhood Office (Hocaille, Biéreau or Bruyères) in order to fix an appointment for the exit inventory
2 OPENING DAYS BEFORE the end of the contract
You must :
-have done the exit inventory
-give back the keys
-leave the accommodation
What if I don't make an appointment ?
An independent expert will be in charge of the exit inventory at the tenant's expense.
The expert will stand in for the two parties who will be bound to his evaluation.
May I sublet my accommodation ?
No. Your accommodation must be only occupied by the tenant who have signed the lease agreement.
If another student want to take over your accommodation when you leave, we must end your contract and this student must sign a new lease agreement.
How is the inventory going on ?
See the billboard in the shared spaces : the process is explained
**I don't know what that means**
What if I don't come to the exit inventory appointment ?
You will be charged a fixed amount.
average UCLouvain room rental is €300/month
What's included in the monthly amount ?
The rent and the charges ( a provision for heating, a fixed amount for water, the cost of the rubbish collection and insurance and the green spaces maintenance).
The cost of the shared spaces maintenance is also included in the charges.
NB : for electricity (for your room and for the shared spaces) you will receive monthly an e-mail with a bill to pay separately.
If you have a contract for an entire academic year, we will proceed to a "reconciliation" of charges
I must pay a deposit. What's it for ?
The deposit must be paid by a bank transfer, at the signature of your contract. .
It will be refund at the latest by December 31 after the end of your last contract.
It could be reduced of the amount for the damages that the inventory will have finally recognised as your responsibility.
I must pay a deposit. What's it for ?
The deposit must be paid by a bank transfer, at the signature of your contract. .
It will be refund at the latest by December 31 after the end of your last contract.
It could be reduced of the amount for the damages that the inventory will have finally recognised as your responsibility.
How and when I have to pay my rent+charges ?
-By a bank transfer, before the beginning of the month.
You have received a payments' planning with your contract.
-By a "standing order", the payment will be withdrawn in the first few days of the month.
If you haven't paid, in due time or with delay, and if we send you a "formal notice" ("mise en demeure"), you will be charged 15€ for administrative fee.
*whole page*
“Kot à projet” (KAP) : In a KAP you will share a common interest with your housemates and work on a project during your exchange period. All KAP are supervised by the university. Those rooms must also be reserved through the Service des Logements (UCLouvain housing service).
A Theme House, called in UCL, « kot-à-projet » : it's a specific housing, gathering students involved in a same project : cultural, environmental, health, "country theme" ; help service for other students (e.g. for students with disabilities)...but also theatre, movie, photography, cooking,...
Their name : Kot Erasmus, KAP Contes, Photokot, Kot Oxfam, Cafrikap, Rhétokot, Musikot, PédiaKot, etc.
It is recommended to get involved and live in a theme house as from the 2nd study year.
Renting with provision (percentage of charges) : 285 € to 330 € / month
Deposit : 150 €
(price for 2018-2019)
CONTACT
In Louvain-la-Neuve
Tél + 32 (0)10 47 22 92 / 91
<EMAIL_ADDRESS>*whole page*
*whole page*
*whole page*
*whole page*
Syello: Vu l'importante proportion de koteurs au sein de la population étudiante, l'AGL a mis en place le Syello (Syndicat des étudiants locataires). Le Syello soutient et renseigne gratuitement les étudiants qui rencontrent des difficultés dans le cadre de leur contrat de bail (récupération de garantie locative, résiliation unilatérale du contrat de bail, insalubrité, etc). Toutes les informations sont disponibles sur le site www.syello.org


Tina Mariane Krogh Madsen is an artist and researcher, who works in the intersection between performance art, sound, media, and matter. She is the founder of performance protocols, a platform for instruction-based art and collaborative processes. Madsen is educated from the College of Arts Crafts and Design (DK), holds a Master of Arts in Art History from Aarhus University (DK), and is currently a Doctoral Candidate at the Aalto University School of Arts, Design and Architecture (FI).
http://performance-protocols.net/
Photo credit: Martin Delaney.


|
Uintah::PhaseField
|
Container for collecting multiple views as a unique composite view (ScalarField implementation) More...
#include <piecewise_view.h>
Public Member Functions | |
| virtual | ~piecewise_view ()=default |
| Default destructor. More... | |
| piecewise_view (const piecewise_view &)=delete | |
| Prevent copy (and move) constructor. More... | |
| piecewise_view & | operator= (const piecewise_view &)=delete |
| Prevent copy (and move) assignment. More... | |
| virtual bool | is_defined_at (const IntVector &id) const override |
| Check if the view has access to the position with index id. More... | |
| virtual T & | operator[] (const IntVector &id) override |
| Get/Modify value at position with index id (modifications are allowed if T is non const) More... | |
| virtual V | operator[] (const IntVector &id) const override |
| Get value at position. More... | |
| Public Member Functions inherited from Uintah::PhaseField::detail::view< ScalarField< T > > | |
| virtual | ~view ()=default |
| Default destructor. More... | |
| virtual void | set (DataWarehouse *dw, const Patch *patch, bool use_ghosts=use_ghosts_dflt)=0 |
| Retrieve value from the DataWarehouse for a given patch. More... | |
| virtual void | set (DataWarehouse *dw, const Level *level, const IntVector &low, const IntVector &high, bool use_ghosts=use_ghosts_dflt)=0 |
| Retrieve value from the DataWarehouse for a given region. More... | |
| virtual view * | clone (bool deep) const =0 |
| Get a copy of the view. More... | |
| virtual view * | clone (bool deep, const IntVector &offset) const =0 |
| Get a copy of the view and apply translate the support. More... | |
| virtual Support | get_support () const =0 |
| Get the region for which the view has access to the DataWarehouse. More... | |
Protected Member Functions | |
| piecewise_view ()=default | |
| Default constructor. More... | |
| piecewise_view (const piecewise_view *copy, bool deep) | |
| Constructor. More... | |
Protected Attributes | |
| std::list< view< Field > *> | m_views |
| Container for each sub views. More... | |
Additional Inherited Members | |
| Public Types inherited from Uintah::PhaseField::detail::view< ScalarField< T > > | |
| using | field_type = ScalarField< T > |
| Type of field. More... | |
| Static Public Attributes inherited from Uintah::PhaseField::detail::view< ScalarField< T > > | |
| static constexpr bool | use_ghosts_dflt = false |
| Default value for use_ghost when retrieving data. More... | |
Container for collecting multiple views as a unique composite view (ScalarField implementation)
It is used as abase class for views that are defined across multiple sub-problems (i.e. bcs views and amr coarser and finer views)
| T | type of the field value at each point |
|
protecteddefault |
Default constructor.
|
inlineprotected |
Constructor.
Instantiate a copy of a given view
| copy | source view for copying |
| deep | if true inner grid variable is copied as well otherwise the same grid variable is referenced |
|
virtualdefault |
Default destructor.
|
delete |
Prevent copy (and move) constructor.
|
inlineoverridevirtual |
Check if the view has access to the position with index id.
| id | position index |
Implements Uintah::PhaseField::detail::view< ScalarField< T > >.
Reimplemented in Uintah::PhaseField::detail::bcs_basic_fd_view< ScalarField< T >, STN, Problem, Index, P... >.
|
delete |
Prevent copy (and move) assignment.
|
inlineoverridevirtual |
Get/Modify value at position with index id (modifications are allowed if T is non const)
| id | position index |
Implements Uintah::PhaseField::detail::view< ScalarField< T > >.
|
inlineoverridevirtual |
Get value at position.
| id | position index |
Implements Uintah::PhaseField::detail::view< ScalarField< T > >.
|
protected |
Container for each sub views.


| Name | Total votes | Percentage of votes |
|---|---|---|
| {{answer_name}} | {{survey_dictionary_votes|get_item:answer_name}} | {{survey_dictionary_perc_votes|get_item:answer_name}}% |
| Total | {{total_votes}} | 100% |
{% extends 'survey/base.html' %} {% load template_methods %} {% block title %} {{survey_name}} {% endblock %} {% block content %}
Please check at least one checkbox
{% elif multi_choice_error_code == 2 %}Maximum number of checks in this survey is: {{survey_type_parameter}}
{% endif %}| Name | Total votes | Percentage of votes |
|---|---|---|
| {{answer_name}} | {{survey_dictionary_votes|get_item:answer_name}} | {{survey_dictionary_perc_votes|get_item:answer_name}}% |
| Total | {{total_votes}} | 100% |


Use this command to display the tip of the day, and to toggle whether tips are shown when the program starts up. This shows the same dialog that you see when you start HexEdit (if “Show Tips on Startup” is on).
By default “Show Tips on Startup” is on. This means that every time you run HexEdit a new tip is shown. These tips are taken sequentially from the (ASCII text) tip file HexEdit.tip. When all the tips have been shown the tips start from the beginning of the file again. (If you like, you can add your own tips to this file – one per line.)


For most people, learning to code cannot be rushed. Consider the Software System Developer (SSD) program for a proper coding education with enough time to actually learn the content. Study at an institution that is recognized and trusted by industry throughout Western Canada. Over 80% of SSD graduates are hired as web application developers.
The SSD Web Programmer option is an eight-month, full-time web application development program offered at BCIT's the downtown Vancouver campus.
SSD prepares individuals for high-demand careers in the technical areas of web application development. Train for a new career through extensive hands-on practice.
Graduates of this certificate program may apply for acceptance into the BCIT Bachelor of Technology in Computer Systems (additional prerequisites are required). Laddering into the Computer Systems Technology Diploma program is not an option.
This program is delivered through classroom instruction, hands-on lab work and individual and team projects. While applicants are not required to have formal computer programming experience, they need to have a solid understanding of object-oriented programming. Applicants with no knowledge are advised to take a programming language course, such as introduction to object-oriented programming, C#, or Java. Speak with us today so we can help you prepare to join us.
| SOFTWARE SYSTEMS DEVELOPER - Web Programmer Option | |
|---|---|
| BCIT Credential: | Certificate |
| Program Location: | Downtown Vancouver |
| Program Length: | Eight months, Full-time |
| Program Start / End: | September 09, 2019 - May 08, 2020 |
| Total Tuition/Cost: | Learn about Tuition & Fees |
| Entry Requirements: | View Requirements |


| クラスと説明 |
|---|
| CSP
A class for CSP (Constraint Satisfaction Problems).
|
| クラスと説明 |
|---|
| BooleanVariable
This class implements a boolean variable of CSP.
|
| Clause
This class implements a clause in CSP.
|
| CSP
A class for CSP (Constraint Satisfaction Problems).
|
| IntegerDomain
This is an abstract class of integer domains.
|
| IntegerVariable
This class implements an integer variable of CSP.
|
| LinearLiteral
This class implements a comparison literal of CSP.
|
| LinearSum
A class for linear expressions.
|
| Literal
This is an abstract class for literals of CSP.
|
| クラスと説明 |
|---|
| BooleanVariable
This class implements a boolean variable of CSP.
|
| Clause
This class implements a clause in CSP.
|
| CSP.Objective
Objective types.
|
| IntegerDomain
This is an abstract class of integer domains.
|
| IntegerDomainDiet
This class implements an integer domain class.
|
| IntegerDomainIntervals
This class implements an integer domain class.
|
| IntegerVariable
This class implements an integer variable of CSP.
|
| LinearLiteral
This class implements a comparison literal of CSP.
|
| LinearSum
A class for linear expressions.
|
| Literal
This is an abstract class for literals of CSP.
|
| Relation
Relation class.
|
| RelationLiteral.Brick |
| クラスと説明 |
|---|
| Clause
This class implements a clause in CSP.
|
| CSP
A class for CSP (Constraint Satisfaction Problems).
|
| IntegerVariable
This class implements an integer variable of CSP.
|
| クラスと説明 |
|---|
| IntegerVariable
This class implements an integer variable of CSP.
|
| クラスと説明 |
|---|
| Clause
This class implements a clause in CSP.
|
| クラスと説明 |
|---|
| CSP
A class for CSP (Constraint Satisfaction Problems).
|
| クラスと説明 |
|---|
| CSP
A class for CSP (Constraint Satisfaction Problems).
|
Copyright © 2019. All rights reserved.


I’m passionate about solving real-world issues using creative design. Whether digital or traditional, I’m able to employ the right techniques, media, and skills to each task.
I started off doing paintings and sketches since I was young. As I grew older, I began pursuing digital illustration and have become proficient in using Paint Tool Sai and Photoshop.
After browsing through many photos on the web, I grew an appreciation for good photography, and was inspired to do the same. Armed with a DSLR, I enjoy doing photography as a hobby.


Posted on August 24, 2013 at 9:00 PM
HOW TO MAKE THIS! 30 minute recipe Chicken: Take chicken breast, cut them in half. Sprinkle a salt and pepper(plus whatever seasonings you like) place them in a nonstick skillet, cooking them 3-5 minutes on each side. After cooking completely through, move chicken to a plate.
Sauce Preheat the oven on the broiler setting. Add the onions to the oil remaining in the pan. If there isn’t any, add in about (½) teaspoon and sauté the onion for 2-3 minutes until the soften, add the garlic and let cook for 30 seconds. Add the crushed tomatoes, Italian seasoning, red pepper flakes, dried basil, and pesto and stir to combine. When the sauce reaches a simmer, add a ¼ cup of water, lower the heat, cover and allow to simmer for 10-12 minutes or until the sauce thickens a bit. Season with salt and pepper for taste.
ut it together Place a small amount of sauce on the dish, array the chicken however you like. Layer more sauce on top of the chicken. Place a slice of cheese on each strip of chicken. Cook the dish in the broiler till the cheese bubbles.
How to Handle serving sizes: Serving sizes are tricky, and the FDA recommended size (size of your fist) isn’t always filling, also when trying to lose weight eating more portions of food than what you normally eat is better! Having all of those nutrients, fats, and proteins go to waste while you go about your day is good, your body won’t feel pushed to fill in those holes that is needed to keep you full. So with how much, maybe a serving size up. DON’T CUT CARBS
The Ingredients? What goes into this delicious dish! 4 small chicken breasts 1 tablespoon olive oil 1 tablespoon minced garlic ½ cup chopped onions 1 (14 ounce) can crushed tomatoes ½ teaspoon EACH Italian seasoning AND red pepper flakes (see notes) ¼ teaspoon dried basil 1 tablespoon sun-dried tomato pesto salt and pepper + ¼ cup water 4 slices mozzarella cheese (or 1 cup shredd
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Inventore, perspiciatis adipisci accusamus laudantium odit aliquam repellat tempore quos aspernatur vero.


About
Most web accessibility checkers audit websites after they are completed. Our site is designed for developers in the process of building a website, so that fewer accessibility errors are present in the final product.
Our errors and warnings are based on the Web Content Accessibility Guidelines (WCAG) 2.0 AA standards. These are the standards used by the Americans with Disabilities Act (ADA) and Section 508, both of which are American federal laws concerning accessibility. You can read more about the WCAG guidelines here.


presents
CHANGE THE CHANNEL!!!
Japanese Video Activism
May 29th 7pm
AVANSE 4F, Saga City, JAPAN
"...the Japanese avant-garde has continued to be motivated by leftist opposition against authoritarian orthodoxy in Japanese society - in particular the emperor system (tenno-sei) and its mandates of patriarchy and social conformity, political harmony and personal sacrifice." (Alexandra Munroe, Scream Against The Sky, Japanese Art After 1945, 1994)
Main Programme
WHAT DO YOU THINK ABOUT THE WAR RESPONSIBILITY OF EMPEROR HIROHITO?
Yasukuni, 08/15/1996
(Japanese with English subtitles)
53mins
WITHOUT TELEVISION Vol.3
by Tsuchiya Yutaka
"In Japan, it is still a taboo to criticize the Emperor system. In fact many civil movement groups which assert the abolition of the system are under pressure by the police and Right wing organisations. The public remain silent and impose their own deeply rooted self-restraint on the matter. The mass media provide hardly any critical information on the Emperor System. This video faces this taboo directly. It consists of many interviews asking, "What do you think of the war responsibility of the Emperor?" Strangely enough, the reality is that even a simple question like this is never asked in Japan.
The interviews were made on August 15th, 1996 at Yasukuni shrine. August 15th represents the end of the second world war for Japan. Yasukuni shrine is a so-called Îholyâ place to enshrine the souls of those killed in the wars since the late 19th century. It enshrines the aggression of war, based on pre-war nationalism and Shinto ideology. It has been visited officially by Japanese politicians, provoking embarrasment among neighbouring Asian nations and aggravating foreign relations.
The shrine is also visited privately by many bereaved families and ex-military men on August 15th every year. I interview these people, wondering what they really think of the war. Rather than the elites and intellectuals, what are the feelings towards Emperor Hirohito of ordinary citizens who acted in the last war? You will see opinions previously hidden deep in the hearts of the Japanese people.
This video was edited digitally on a Mac. It shows parts of the TV news on the day of August 15th 1996 and fragments of documentary films all of which I use to criticise the mass media." (TY)
Followed by...
HUMAN RIGHTS FOR JAPANESE RAILWAY WORKERS
English Version
16mins
1996
Video Press
The history of the 36 Kokuro struggle groups. 1047 Railway workers were fired simply because they were Kokuro union members, and they have been fighting against their dismissal for ten years.
KAROSHI
(Death from over-work)
English Version
31mins
1993
Ogawamachi Cine Club
The number of deaths form overwork reach ten thousand a year in Japan, equal to that of traffic accidents. Millions of people are working more than 3000 hours a year are also on the threshold of Karoshi. As Japanese working practices are emplyed by foreign countries, Karoshi is becoming a global problem.
This month is a diversion from the usual programme of experimental film and video. Eiga Arts proudly presents an evening of alternative Japanese video activism. All videos are from VIDEO ACT!, Japan's leading distribution source for video activism of all kinds. Their on-line catalogue (English/Japanese) is a superb resource for anyone wanting to find work and contact various activist groups in Japan.
I'd also be glad to help with any enquiries.


[Image: http://codewithme.us/images/exercises/blackout/main_image.jpg]
By Charles Ornstein, ProPublica
Nov. 8, 2012
Long after power is restored from Sandy, the effect of another more-precarious outage is still taking shape: Some of the largest hospitals in lower Manhattan remain shuttered. Other hospitals are scrambling to fill the gap, and concern is rising that the patchwork system can't last for long.
NYU Langone Medical Center and Bellevue Hospital, the flagship of the city's public hospital system, were forced to evacuate due to loss of electricity and damage from Sandy. The Manhattan Veterans Affairs Medical Center evacuated patients before the storm and has not reopened.
There is no firm timetable on the hospitals' return. A spokesman for the city agency that runs Bellevue said that the hospital will likely be out for at least several weeks. NYU's outpatient clinics have reopened but the hospital itself remains closed.
"This is not a tenable situation," said Bellevue's director of emergency medicine, Dr. Lewis Goldfrank, who holds a similar title at NYU. "There's just too many people. You can't dump this level of patients out on the open market."
Bellevue's emergency room treated more than 100,000 patients last year, and its physicians and outpatient clinics handled more than a half million patient visits, according to state Department of Health data. It is also a large provider of psychiatric services and a hub for treating patients in police custody.
Beyond the huge daily patient load it handles, Bellevue is also a key piece of the city's crisis response system as the only high-level trauma center near the lower section of Manhattan. Trauma centers handle the most serious cases, including victims of gunshots, stabbings, auto accidents, falls and terrorist attacks.
Read more of the story on ProPublica.
Jennifer LaFleur contributed to this report.


We have great records, very great ones, greater than you could imagine. It has been all God, because what God cannot do does not exist.
Latest news and events about NFCS AE-FUNAI. Get to know our most recent updates and blessings God has bestowed on us.
At NFCS AE-FUNAI, we live the faith by worshipping God in routine activities together with the community.


Started by Kevin T Gabelman
View images from my own and others' spatial analysis of environmental conditions that support Ebola virus. They show the regions from which the virus is most likely to emerge.
These basic maps show where Ebola has transmitted to humans.
Learn more about how time-series analyses, such as wavelet transform analysis, works.
Learn about how scientists are beginning to predict when outbreaks, such as Ebola are most likely to occur next.


Angular Routing Samples
Home
Code
About
Hint
{{transition}} :
Show Routes
Show States
Show Transitions
Routes
{{routes}}
States
{{states}}
Transitions
{{transitions}}


Loading...
Choose from nearby stops
View Departures
----Or----
Filter by routes
Then choose stops
View Departures


Meet the Creators
Jade Shen is a Bronx Science Junior.
From a robotics programmer to an ice skater fanatic, Jade Shen has always strived to break the limits placed on her. As a young female in STEM, she plans to put forth only her best work!
 As an adolscent female, she has seen the effects mental health could have on people firsthand. She believes that by creating this game, she will be able to spread more awareness about mental health issues, and teach others that their happiness matters.


--- title: cellstr layout: doxygen comments: false sidebar: doxygen_sidebar topnav: topnav tags: false ---
A MatLab cell array of strings. More...
A MatLab cell array of strings.
This class is an artificially created class in doxygen to allow more precise type declarations and represents cellstr-like types.


This extension detects and converts Indian language script into readable English.
It will be useful for the people, who can understand the language but can't read/write.
To read a text in English, Select the text and click on IndLish Covert context menu.


Start learning SQL in Google Colab¶
Introduction¶
In this example, we will start using SQL in Google Colab Notebook.
But first, let’s just remind ourselves some of the basics of Google Colab.
Let’s start with just running a bit of “code.” The cell I am currently is a “Text” cell (using +Text). For code, we want to use a “code” cell (+Code). The below statement will just add two numbers together, nothing too fancy.
2 + 2
4
Your turn!
Click on the “+Code” button in the top-left corner.
Figure out the answer for the following math problem. \begin{equation*}<PHONE_NUMBER>81 / 231) + 12300 \end{equation*}
Pretty easy so far, huh?
OK, next to the SQL.
SQL Start¶
One of the cool tricks you can do in Jupyter Notebooks is something so amazing, you might even think its magic! Well, it technically is.
Jupyter has a number of built in utilities, which they call magic. Don’t worry about trying to learn them all, and we only need one specific type of magic. SQL magic. Actually, we technically need %load_ext magic, but this will load SQL for us.
%load_ext sql
---------------------------------------------------------------------------
ModuleNotFoundError Traceback (most recent call last)
<ipython-input-2-7600c8b786e3> in <module>
----> 1 get_ipython().run_line_magic('load_ext', 'sql')
c:\users\dudas\anaconda3\envs\wintest\lib\site-packages\IPython\core\interactiveshell.py in run_line_magic(self, magic_name, line, _stack_depth)
2346 kwargs['local_ns'] = self.get_local_scope(stack_depth)
2347 with self.builtin_trap:
-> 2348 result = fn(*args, **kwargs)
2349 return result
2350
<decorator-gen-58> in load_ext(self, module_str)
c:\users\dudas\anaconda3\envs\wintest\lib\site-packages\IPython\core\magic.py in <lambda>(f, *a, **k)
185 # but it's overkill for just that one bit of state.
186 def magic_deco(arg):
--> 187 call = lambda f, *a, **k: f(*a, **k)
188
189 if callable(arg):
c:\users\dudas\anaconda3\envs\wintest\lib\site-packages\IPython\core\magics\extension.py in load_ext(self, module_str)
31 if not module_str:
32 raise UsageError('Missing module name.')
---> 33 res = self.shell.extension_manager.load_extension(module_str)
34
35 if res == 'already loaded':
c:\users\dudas\anaconda3\envs\wintest\lib\site-packages\IPython\core\extensions.py in load_extension(self, module_str)
78 if module_str not in sys.modules:
79 with prepended_to_syspath(self.ipython_extension_dir):
---> 80 mod = import_module(module_str)
81 if mod.__file__.startswith(self.ipython_extension_dir):
82 print(("Loading extensions from {dir} is deprecated. "
c:\users\dudas\anaconda3\envs\wintest\lib\importlib\__init__.py in import_module(name, package)
125 break
126 level += 1
--> 127 return _bootstrap._gcd_import(name[level:], package, level)
128
129
c:\users\dudas\anaconda3\envs\wintest\lib\importlib\_bootstrap.py in _gcd_import(name, package, level)
c:\users\dudas\anaconda3\envs\wintest\lib\importlib\_bootstrap.py in _find_and_load(name, import_)
c:\users\dudas\anaconda3\envs\wintest\lib\importlib\_bootstrap.py in _find_and_load_unlocked(name, import_)
ModuleNotFoundError: No module named 'sql'
This is a built-in Python SQL toolkit provide by (another magic reference) SQL Alchemy. Again, you don’t need to worry too much about SQL Alchemy, only that we can now use SQL code in our notebook.
The next step is to create a database, so in this case we use the following command. Note: we will be expanding on this through-out the semester, but for now… it creates a single, SQLite database for this notebook. Also, if the command runs successfully, you should see ” ‘Connected: @studentDatabase.db’ “
%sql sqlite:///studentDatabase.db
'Connected: @studentDatabase.db'
this is your database to add tables and insert data, BUT this is temporary. So, do not assume that this will save between sessions. If you want to save this database for later, go to left (where the folder is), select the folder, and then download the database (right click on the database).
###Types of SQL Interactions
Here is a list of common interactions with database.
Now it is time to create our first table. This is where the SQL commands become available to us. The first command is…
CREATE (DDL - Data Definition Language)¶
Create will create a table. In this case, we will call the table Student and we will need to tell the table the names of the attributes and what type of attribute they are as well. For now, we will be using only using 3 types:
INTEGER - whole numbers (example: 3)
REAL - floats or real numbers (example: 3.14)
TEXT - text information (example: “hello world!”)
For us, we need 6 attributes and all 6 will be text.
Let’s create 1 table for student information.
%%sql
CREATE TABLE Student(PSUID text primary key, firstName text, lastName text, streetAddress text, city text, state text, gpa real);
* sqlite:///studentDatabase.db
Done.
[]
Now let’s add some data to this table. In this case we use…
INSERT (DML - Data Manipulation Language)¶
Insert does as it sounds. Insert data into the database. The syntax for this is:
INSERT INTO name of the table VALUES (data for PSUID,lastname, firstname)
For now, I will just make up a few tuples.
Also, let’s note something. When to use:
%%sql
INSERT INTO Student VALUES('9139128181','David','Practice','123 Apple Street','State College','PA',3.78);
INSERT INTO Student VALUES('9771271281','Susan','Practice','452 Banana Avenue','State College','PA',3.12);
INSERT INTO Student VALUES('9383818823','Lee','Example','836 Carrot Circle','Cleveland','OH',2.68);
* sqlite:///studentDatabase.db
1 rows affected.
1 rows affected.
1 rows affected.
[]
OK, we have a Database. A table in this database. 3 tuples in our table. The last thing we need is a way to access this data, view the data, and do something with the data. That’s where we use…
SELECT (DQL - Data Query Language)¶
SELECT allows us to select all or part of the data. For now, all we want to do is get back from the table all the data in the table. For this we will use:
SELECT (wildcard!) FROM table name
The wildcard basically means All the Attributes in the table
We can also limit the number of tuples returned.
%%sql
SELECT * FROM Student limit 2;
* sqlite:///studentDatabase.db
Done.
| PSUID | firstName | lastName | streetAddress | city | state | gpa |
|---|---|---|---|---|---|---|
|<PHONE_NUMBER> | David | Practice | 123 Apple Street | State College | PA | 3.78 |
|<PHONE_NUMBER> | Susan | Practice | 452 Banana Avenue | State College | PA | 3.12 |
%%sql
SELECT * FROM Student;
* sqlite:///studentDatabase.db
Done.
| PSUID | firstName | lastName | streetAddress | city | state |
|---|---|---|---|---|---|
|<PHONE_NUMBER> | David | Practice | 123 Apple Street | State College | PA |
|<PHONE_NUMBER> | Susan | Practice | 452 Banana Avenue | State College | PA |
|<PHONE_NUMBER> | Lee | Example | 836 Carrot Circle | Cleveland | OH |
Other things we can do with SELECT.
Let’s say we want to know which database we are connected to and what tables we have created. We would use the following SQL.
%sql SELECT name FROM sqlite_master;
* sqlite:///studentDatabase.db
Done.
| name |
|---|
| Student |
| sqlite_autoindex_Student_1 |
DROP (DDL - Data Definition Language)¶
Great! We created a table and put some data into the table, but how do we… destroy it?
DROP is used to “delete” the table and all tuples.
** WARNING WARNING **
A table that is dropped is completely deleted, including ALL DATA. Be careful with this.
%%sql
DROP TABLE Student;
* sqlite:///studentDatabase.db
Done.
[]
So, now we check all the tables we have…
%sql SELECT name FROM sqlite_master;
* sqlite:///studentDatabase.db
Done.
| name |
|---|
Additional SQL¶
Here are the additional commands will be learning about in the class (we will not cover all of these, but most)
What is the first and last name of students from PA?
%%sql
SELECT * FROM student;
* sqlite:///studentDatabase.db
Done.
| PSUID | firstName | lastName | streetAddress | city | state | gpa |
|---|---|---|---|---|---|---|
|<PHONE_NUMBER> | David | Practice | 123 Apple Street | State College | PA | 3.78 |
|<PHONE_NUMBER> | Susan | Practice | 452 Banana Avenue | State College | PA | 3.12 |
|<PHONE_NUMBER> | Lee | Example | 836 Carrot Circle | Cleveland | OH | 2.68 |
What is the street address of students from Cleveland?
%%sql
SELECT * FROM student;
* sqlite:///studentDatabase.db
Done.
| PSUID | firstName | lastName | streetAddress | city | state | gpa |
|---|---|---|---|---|---|---|
|<PHONE_NUMBER> | David | Practice | 123 Apple Street | State College | PA | 3.78 |
|<PHONE_NUMBER> | Susan | Practice | 452 Banana Avenue | State College | PA | 3.12 |
|<PHONE_NUMBER> | Lee | Example | 836 Carrot Circle | Cleveland | OH | 2.68 |
What are all the attributes of students from PA and with a GPA greater than 3.5?
%%sql
SELECT * FROM student;
* sqlite:///studentDatabase.db
Done.
| PSUID | firstName | lastName | streetAddress | city | state | gpa |
|---|---|---|---|---|---|---|
|<PHONE_NUMBER> | David | Practice | 123 Apple Street | State College | PA | 3.78 |
|<PHONE_NUMBER> | Susan | Practice | 452 Banana Avenue | State College | PA | 3.12 |
|<PHONE_NUMBER> | Lee | Example | 836 Carrot Circle | Cleveland | OH | 2.68 |
Create the following table:
%%sql
SELECT * FROM student;
* sqlite:///studentDatabase.db
Done.
| PSUID | firstName | lastName | streetAddress | city | state | gpa |
|---|---|---|---|---|---|---|
|<PHONE_NUMBER> | David | Practice | 123 Apple Street | State College | PA | 3.78 |
|<PHONE_NUMBER> | Susan | Practice | 452 Banana Avenue | State College | PA | 3.12 |
|<PHONE_NUMBER> | Lee | Example | 836 Carrot Circle | Cleveland | OH | 2.68 |
Create at least 3 tuples for this table.
%%sql
SELECT * FROM student;
* sqlite:///studentDatabase.db
Done.
| PSUID | firstName | lastName | streetAddress | city | state | gpa |
|---|---|---|---|---|---|---|
|<PHONE_NUMBER> | David | Practice | 123 Apple Street | State College | PA | 3.78 |
|<PHONE_NUMBER> | Susan | Practice | 452 Banana Avenue | State College | PA | 3.12 |
|<PHONE_NUMBER> | Lee | Example | 836 Carrot Circle | Cleveland | OH | 2.68 |
Now, delete the student table.
%%sql
SELECT * FROM student;


In partnership with the Missouri ACLU.
Take a look around your social media and the issues are evident: the process is outdated, our enforcers are unaccountable.
Thats why we’re building FedUp: a social network for social justice.
Through community sharing of injustice in our communities, we aim to empower those overlooked by the system, and to give a voice to the voiceless. Join us.
With supporting text below as a natural lead-in to additional content.
ButtonWe are building the only social network on the web optimized for social justice.
Share social injustice in your community through video, text, or external link submissions Embed content from other social networks .
We are building the only social network on the web optimized for social justice.
Share social injustice in your community through video, text, or external link submissions Embed content from other social networks .
We are building the only social network on the web optimized for social justice.
Share social injustice in your community through video, text, or external link submissions Embed content from other social networks .
If you are eager to join our cause, or if you have a case you would like to submit, please contact us and we’ll be in touch soon.


Our Services
A Typical Night
We call security to say we are on site - if required. We clean toilets, showers, restock consumables, wash our hands then clean kitchens, do dishes, remove rubbish, replace bin liners, dust, vacuum, clean window and mop.
WINDOW CLEANING
Internal windows and partitions are cleaned by us. We also clean external windows.
FLOOR POLISHING
We can make your floors look new again!
Our Specialized Areas
TRADITIONAL FLOOR WAXING SERVICE
Our top end traditional floor waxing service is for hardwood floors. Often hardwood floors are the centre of attention in a reception area or even in a home. As it's a natural product (bees wax), it requires a little more maintenance than other polishes. However, if you want the great smell that comes from a freshly waxed floor, and that warmth and swirly sheen, then it's worth the extra cost.
CAR PARK SWEEPING
We have a variety of sweeping machines and clean internal multi-storey car parks, outdoor car parks and street frontage areas.
Being environmentally friendly
HYGIENE AND CLEANING PRODUCTS
We use BIODEGRADABLE products and the correct amounts of dilution, which is often overlooked in caring for the environment.
SEPARATE EQUIPMENT is reserved for the cleaning of toilet areas and rubber gloves are worn.
WE DO NOT CARRY TOILET BRUSHES AROUND. This means there is no chance of contaminated water dripping onto surfaces and other areas, outside the toilet area. All toilets we clean must have their own toilet brushes.
We use YOUR DISHCLOTH IN YOUR CAFETERIA – not some stray cleaning cloth.


Fixed navbar
Home
(current)
Profile
Sign in
Username
Password
Sign in
Sign up
Choose an username
Type a password
Type the Password again
Sign up


System Admin : Scheduler App
Show Activity
Delete Old Schedules
In last N hours
Submit
N days old
Submit


Idora Server
Abstract
The IdOra Server serves as a custodian of access tokens (credentials) on behalf of a subscriber. The subscriber can authorize IdOra to obtain, store, and present these access tokens to pre-authorized third party services, usually for the purpose of logging the subscriber into a web page by scanning a QRCode or some other non user/password method.
A web portal is provided for creating accounts, logging in/out, and configuring services for remote logins.
Origins
The IdOra project was originally developed by Bob Lund (CableLabs). This implementation is a derivation of the original codebase, with minor changes required to integrate it into the Micronets ecosystem.
Developers
The repository for the IdOra Server is micronets-idora-server
Overview
The Idora Server provides a web portal for the subscriber to select and authorize access to third party services. This is done using standard OAUTH2 api requests to request and subsequently store the subscriber’s access tokens. It also provides an API to present access tokens to pre-authorized services on behalf of the subscriber.
Messaging
The Idora Server communicates with the following Micronets components:
* Idora Client
+ IN
Accepts QRCode Scans for effecting remote logins.
* Authorization Server
+ OUT
OAUTH redirect to MSO login for authorizing remote logins
+ OUT
OAUTH token refresh/revoke requests
Detailed descriptions of the APIs for this server can be found here
Operation
Website (service) Setup
The subscriber navigates to the IdOra portal at https://mycable.co/idora
. The subscriber logs in and then clicks the Websites tab to set up an authorized service. The subscriber will be redirected (OAUTH2) to the selected service’s Authorization Server login screen. If the subscriber accepts the described action, an access token will be generated by the Authorization Server and returned to the IdOra Server. The access token is then stored locally (IdOra Server) and linked to the subscriber. The access token will be available for future use on behalf of the subscriber, such as for Remote Logins.
Remote Login
The subscriber logs in to their IdOra account from the MSO provided mobile app (IdOra Client). Using a computer browser, the subscriber navigates to the login screen for a service that has been previously authorized (see above). When the QRCode appears on the login screen, the subscriber scans it with the mobile app. The metadata (serviceID, sessionID) from the QRCode is sent to the IdOra Server along with the subscriber’s ID. If the IdOra Server has an access token for that subscriber/service, a remote login request is sent to the service on behalf of the subscriber and the subscriber is automatically logged in.
NOTE: IdOra is not necessarily a component of the MSO. It could easily operate independently to provide this functionality for services not owned by the MSO. For this reason, at least for now, the IdOra account and the MSO account ARE NOT THE SAME ACCOUNT. Credentials must be set up separately.
Installation
Detailed instructions for building and installing the IdOra Server can be found here


54
MRS. MISE was very upset, and she was on the verge of tears. “This is so bad,” she said, “so
very bad.”
Nancy patted the woman’s hands. “Let’s try not to take this warning too seriously. I think
that whoever has been writing these notes is a coward. If not, he would have done
something more drastic by this time.”
Mr. Drew knew that Nancy was trying to make their hostess feel better. He doubted,
however, that Nancy could take the matter so lightly.
He was right. Secretly Nancy was greatly worried. She had a feeling that her adversary
desperately wanted to frighten her. Nancy asked Mr. Mise if he would try to find the porter
who had brought him the note. “I’ll go with you,” she added.
Together they hurried to the lobby of the hotel and walked past the porters who were
seated on a bench in a little niche.
Mr. Mise shook his head. “I don’t see the young man here,” he declared. “Maybe he was
from another hotel.”
Nancy asked, “Did he wear the same uniform as these men?”
Mr. Mise nodded. “That means he could not be from another hotel.” Suddenly a smile
crossed his face. “Here he comes now!”
A young man was walking out of an elevator. Mr. Mise and Nancy went up to him, and the
two Japanese conversed for a few minutes. Then Mr. Mise translated for Nancy.
“The porter says that a little boy arrived with the note, then left the hotel. He does not
know whether the child came from the street or whether he is staying at the hotel.”
“In other words, someone probably gave him a tip to bring the note to the porter, so the
real sender couldn’t be traced,” Nancy reasoned. “Very clever.”
“Whom do you suspect the sender is?” Mr. Mise asked.
“Benny Caputti. He either followed us or happened to see us here. If the latter is true, he
was in the hotel. In either case, he might still be here!”
“And you would like to find him,” Mr. Mise said with a smile.  “But Benny would be where the jewelry is—”
“Which is at the reception!” Mr. Mise completed her sentence.
“Right. Let’s go back there and tell Dad.”
55
When Mr. Drew and Mrs. Mise heard about what had happened, they offered to look
around for a man who matched Caputti’s description. Nancy and her father went off
together. The Mises walked in a different direction.
Presently Nancy noticed a short, black-haired man who, although he was not dressed in a
gray suit, was obviously American or European like Caputti. He was walking quietly among
the guests, when Mr. Mise appeared on the scene and took her arm.
“Nancy, I would like you to meet Mr. Shopwell. He is president of an American bank in
Tokyo.”
Nancy managed to hide her surprise and shook hands with Mr. Shopwell. How glad she was
that she had said nothingl
The Drews and Mr. Mise spoke to the bank president for a while, then continued their
sleuthing. Nancy saw another man some distance away who was dressed in black dinner
clothes and fit the description of Benny the Slippery One. Suddenly she stopped short and
grabbed her father’s arm.
“Look!” she said. “That man! He’s snipping a pearl necklace right off that woman’s neck!”
The young detective and her father made their way through the crowd to close in on the
thief, who had slipped the necklace into his right pants pocket.
He was walking away from the woman with quick steps. When Nancy and her father caught
up to him, they each took an arm.
“We saw you steal that woman’s necklace!” Nancy accused him.
“That is a lie!” the thief cried out.
“You can’t deny it,” Mr. Drew said. “The necklace is in your right pants pocket!”
The suspect stepped a few paces away. “You are wrong!” he insisted, still backing up
further. “You are wrong. I’ll prove it to you!” With that he turned the pocket inside out.
Several coins fell to the floor, but that was all. The pearl necklace was not among them!
Nancy and her father were stunned. It seemed like the work of a magician. The Drews had
to agree that the necklace was indeed not there and apologized as the man angrily pushed
the pocket back into its place. Then he picked up his coins from the floor.
“But I saw you take it!” Nancy insisted. “I’m sure I saw you take it. But if I was wrong, I’m
sorry.”
56
“He’s slipping a pearl necklace off that woman’s neck!” Nancy said.
The man nodded and turned to leave. The Drews walked away quickly before there might
be a scene.
“I can’t understand what happened,” Mr. Drew said tensely. “We both watched him take
that necklace!”
“I have an idea,” Nancy spoke up. “Maybe there was a hole in his pocket, the pearls fell to
the floor, and were picked up by an accomplice! Remember, there were a few people
between us and that man, so we might not have seen the necklace drop.”
“You’re right,” her father agreed. “Let’s go back to the spot and see what we can learn.”
By the time they reached the area where the theft had occurred, the owner had discovered
her loss. She was Japanese, and began exclaiming in bitter tones in her language. The Drews
did not understand what she was saying but noticed another guest hurrying up to her. She
was an American who apparently understood some Japanese. However, she spoke to the
woman in English. “I saw a necklace on the floor a few minutes ago. A Japanese woman
picked it up, slipped it into her purse, and walked off. I assumed it belonged to her.”
Mr. Drew whispered to his daughter, “You were right about the hole in the thief’s pocket.
And the woman who picked up the necklace was indeed an accomplice.”
Nancy was annoyed at herself for letting the thief slip through her fingers so easily. Why had
she not looked for a hole in his pocket when he turned it inside out?
She spoke to the guest who had watched the person pick up the pearls from the floor.
“Would you recognize her if you saw her again?”
“I believe I would,” the American replied. “She wore a very pretty kimono and carried a
matching handbag.”
“Would you mind pointing her out to me?”
When the woman hesitated, Nancy added, “I’m trying to catch a thief, and I believe he’s at
this party.”
The American consented, while Mr. Drew asked other guests if any of their jewelry was
missing. Suddenly there was a hubbub as one woman after another discovered that their
gems had been stolen. Bracelets, necklaces, pins, and hair ornaments were gone. A valuable
ruby and diamond necklace was reported by a friend of the bride to have been stolen.
Mr. Mise notified the police, and a number of officers arrived in a few minutes to search for
the thief. All guests cooperated and permitted themselves to be searched.
57
A young officer asked Nancy for her purse. She smiled.
“I don’t have one with me,” she said. “I put my comb into the bottom of my kimono sleeve
as I understand Japanese women often do.”
“Then I must examine your sleeves,” the officer said.
He found nothing in the left one, then reached into the right. To Nancy’s horror he pulled
out a gorgeous ruby and diamond necklace!


One account. All of Google.
Sign in with your Google Account
<EMAIL_ADDRESS>Enter your password
Stay signed in
For your convenience, keep this checked. On shared devices, additional precautions are recommended.
Learn more
Sign in with a different account
One Google Account for everything Google
Google
Privacy
Terms