lacy | compile/run for the lazy | GPU library

I'm trying to use Pandas and groupby to calculate the ratio of two columns. In the example below I want to calculate the ratio of staff Status per Department (Number of Status in Department/Total Number of Employees per Department). For example the Sales department has a total of 3 Employees and the number of staff that have Employee Status is 2 which gives the ratio of 2/3, 66.67%. I managed to hack my way through to get this but there must be a more elegant and simple way to do this. How can I get the desired output below more efficiently?

Original DataFrame:

I am trying to make a function that outputs a dataframe from 8 different CSV files. They all have the same variables and same sort of data. The only difference in them is the year. I have tried to write out the function, but I can't seem to make it work. I am thinking a lapply woulf work, but I am not sure how to incorporate it.

These are the instructions: Write a function named 'air' that takes a 'year' argument and returns a data.frame containing that data for that year, suppressing the automatic conversion to factors.

I am joining table_2 & table_3 below, as you can see in some records the surrogate key Father in table_3 contains many values of Hats, to 1 value of Father.

I need to identify the values of Father in Table_3 have many Hat values to 1 Father as it should be 1 to 1 to hats to Father. How can I write a query (I can have two different that is ok :)) that shows the ID's that have a 1-1 relationship and then the id's that have a 1-many.

I am having trouble writing a query that outputs WHAT TABLE_3 Fathers have 1-to-many relationships with Hats and what table_3 Father values have 1-to-1 relationships with Hats. It makes it trickier because a Father can have many Kids.

Use SQL Fiddle http://sqlfiddle.com to follow along on the code here:

I have a program using NHibernate, recently we have made an update to the database model, we have added a table. Now we use SQLite to sync parts of the "central" database to enable a offline support in the program. It is now the problems start arising... When a user have an updated version of the program, but an old version of the database NHibernate wont work properly.

So I would like to "migrate" the database to the new schema. I have testet with SchemaExport, but that clears the database of all it's data. Do I have to manually create the table?

Also, I only notice this when I try to access a lacy loaded property in my database, is there anyway to see if the model correlates with the database schema?

So I am writing a js script to create table and populate it with data. I want to limit presented data and decided to delete each array entry after I show insert it to dom.

The problem is that splice and shift methods delete every second element and I don't get it why.

This is the main responsible function.

I want to take all of the thumbnailURL's in my data set and add them to an array.

I have tried a .map and a .push and have thought about having to change things up because it is an object, I'll show you the data set and I'll show you my methods:

So just to be clear, I want to check each roles array and take from each account the thumbnail URL and add it to an array:

In my code snippet, it works and it is identical to my actual code, the data and the logic, but in my real code I get the error:

I have a problem - here is my Employee table:

I have a question about date formats in plotly. I made a time series plot in ggplot2 that I'm trying to visualize with plotly but a format issue for date-time appears on the hover (see image). I would like the date format to be YYMMD-hh:mm. How could I get this format?

Relevant R code on my script:

I just finished building a MOBA-like game in node.js for the web platform. Now I am planning on redoing it as an actual game in Game maker studio 2 while fixing some bugs and adding some new features. I ran into a problem a while back, however, I couldn't figure out the matchmaking (Game maker was my first choice but I switched to web because of this problem). I built the matchmaker in javascript as an array, however, I feel this will be problematic when there is a lot of players trying to find a game. I don't have any code in Game maker yet because if it is not relevant to do it I might try switching to a different game engine.
Matchmaking:

1) Like smite or league of legend, where you can accept or decline a match

2) Someone in one game shouldn't be able to interact with another game.

I would really appreciate any help. I just need help understanding the logic for gamemaker because the networking is different and there is a room system.

Thank you very much!
Brandon Lacy