kinship | web app for storing and organizing info | State Container library

Given a dataframe df as follows:

I have a table with columns amount and feehead

I'm running this SQL statement built into a string using sp_executesql but it always fails with this error:

Msg 103010, Level 16, State 1, Line 1
Parse error at line: 4, column: 1: Incorrect syntax near 'GO '.

Here's the code:

I'm trying to filter a data.frame with family information. It looks like this:

I have a table showing bi-univocal kinship relations. In other words, I may have a first row showing the record of a father who has a son, and in the next line, this son shows his relation with his father. But, the father may have another son (son2), so we have another two entries in the table showing the father related to his son2, and son2 linked to the common father. The problem arises when the relation between the two sons does not appear in the table. There is no entry showing son1 is the brother of son2, and I need to derive this from the table. This is my goal, and every individual in the table, has a unique identifier.

What I've been trying to do so far is:

a) To create a list of all the possible kinship roles (in my simplified example above, there would only be 2 roles: father and son).

b) To subset the original table into as many groups as roles are there. As any individual in my example could be a son and/or a father, I create two groups of data. These groups are the elements of a list, so, in other words I created a list by subsetting the roles of the records. In this example, the list has two elements: one for the records where the second person is a son of the first, and another element showing the entries whose second person is a father of the first.

c) My idea was also to subset the previous (two) elements of the list by the first person´s ID. This way, my goal was to create groups of each given ID with all the relations they have. For instance, in our example, we would obtain a group for one ID (the father) formed by two rows: the records of son1 and son2.

d) Once here, the previous subgroup shows that son1 and son2, are brothers. As, again, this is not reported in the original table, my purpose is to derive it through coding creating two new records in the original table which would show that son1 has a brother son2, and son2 has a brother son1.

Given that my dataframe is df and that the variable role of the second person in the relation is Role_2nd, step a) is simple:

I am trying to use the python module limmbo (https://github.com/HannahVMeyer/limmbo) with R via the reticulate R package. I have successfully installed limmbo with Anaconda2. I'm now trying to use the function limmbo$core$vdbootstrap$LiMMBo$runBootstrapCovarianceEstimation, as in my code below. When I run the code below, I get an error about converting a float64 to an integer64.

I am getting an error with selenium's find_element_by_xpath. This is the error I'm getting:

I have a problem with a linear mixed effects model not completing in R.

I use the package lmekin to run the model, as I am fitting a kinship matrix as a random effect. The formula I am using is:

model <- lmekin(disease ~ score + age + (1|IID), data=phenotype_df, varlist=kinship_mx)

phenotype_df is a dataframe, with 12000 individuals, each with a disease status (1 or 0), a score and their age. (Note: I am treating the disease status here as quantitative). kinship_mx is a kinship matrix, ie. a positive-definite matrix (12000x12000) with diagonals ~0.5.

This model runs in around 1 minute when I use ~1000 individuals. However, I left the model to run with all 12000 individuals on our large server and it has not finished after 5 days. Could anyone suggest a reason as to why this is happening and if there are any solutions to enable the model to complete?