If you want to use subset, you could try: subset(df, !duplicated(subset(df, select=c(allrl, RAW.PVAL)))) # RAW.PVAL GR allrl Bak #1 0.05 fr EN1 B12 #3 0.45 fr EN2 B10 #4 0.35 fg EN2 B066 But, I think @thelatemail’s approach would be better df[!duplicated(df[c(“RAW.PVAL”,”allrl”)]),]
Your example data is not sufficient to actually carry out t-tests on all subgroups. For that reason, I take the iris dataset, which contains 3 species of plants: Setosa, Versicolor, and Virginica. These are my groups. You will have to adjust your code accordingly. Below I show how to test one groups versus all other … Read more
Since you didn’t provide a data set I made my own from the link you provided. Your method works for me and I get an empty data set only if I don’t meet both of the conditions supplied (month and year) so I’m guessing you’re you’re attempting to subset a date series (month and year) … Read more
We could use split: mylist <- split(df, df$State) mylist $AL ID Rate State 1 1 24 AL 4 4 34 AL $FL ID Rate State 3 3 46 FL 6 6 99 FL $MN ID Rate State 2 2 35 MN 5 5 78 MN To access elements number: mylist[[1]] or by name: mylist$AL ID … Read more
I’ll assume that Time and Product are columns in a DataFrame, df is an instance of DataFrame, and that other variables are scalar values: For now, you’ll have to reference the DataFrame instance: k1 = df.loc[(df.Product == p_id) & (df.Time >= start_time) & (df.Time < end_time), [‘Time’, ‘Product’]] The parentheses are also necessary, because of … Read more
You can use the .index* family of functions to get certain months or certain days of the month. See ?index for the full list of functions. For example: library(quantmod) getSymbols(“SPY”) SPY[.indexmon(SPY)==0] # January for all years (note zero-based indexing!) SPY[.indexmday(SPY)==1] # The first of every month SPY[.indexwday(SPY)==1] # All Mondays
OP provided only a single column in the example. Assuming that there are multiple columns in the original dataset, we group by ‘z’, sample 1 row from the sequence of rows per group, get the row index (.I), extract the column with the row index ($V1) and use that to subset the rows of ‘dt’. … Read more
You could use a nested Any() for this check which is available on any Enumerable: bool hasMatch = myStrings.Any(x => parameters.Any(y => y.source == x)); Faster performing on larger collections would be to project parameters to source and then use Intersect which internally uses a HashSet<T> so instead of O(n^2) for the first approach (the … Read more
You can use rowSums to construct the condition in base R: df[rowSums(df > 10) >= 1, ] with dplyr (0.7.0), now you can use filter_all like this: library(dplyr) filter_all(df, any_vars(. > 10))
From the help page for Logical Operators, accessible by ?”&&”: & and && indicate logical AND and | and || indicate logical OR. The shorter form performs elementwise comparisons in much the same way as arithmetic operators. The longer form evaluates left to right examining only the first element of each vector. Evaluation proceeds only … Read more