1,299 questions
-1
votes
0
answers
28
views
Python display and count unique elements from a dataset [duplicate]
I have a dataset populated from an API call to Splunk.
The dataset contains the following:
time
destip
destport
transport
2025-09-17 22:03:09
172.16.5.1
53
UDP
2025-09-17 22:03:10
172.16.5.1
53
UDP
...
- 61
0
votes
1
answer
34
views
two-way table of sums [closed]
I have two categorical variables, Student and CourseType, and one continuous variable, Units. I want a table that sums up the units for each pair of Student/CourseType. Like this:
Required
Elective
...
- 49
0
votes
3
answers
96
views
Replacing default regression table notes on fixest
I want to replace the custom etable default standard error note with one of my own.
I am working with
library(fixest)
model1 <- feols(mpg ~ hp + drat + wt|cyl, data=mtcars)
etable(model1,
...
- 475
-1
votes
1
answer
73
views
How to have a summary-like textbox [closed]
I want to have a textbox with the following logic:
Meaning, some text and the dots until reaching a predetermined width and a number. I am aware that since I am not using a monospaced character the ...
- 2,623
2
votes
1
answer
84
views
Why are values not correctly displayed in summary()? [duplicate]
I have a vector 10,000 numbers long with a skewed distribution and extreme values. When I call base R's summary() function, certain values display as 0 when they are not actually 0.
From my actual ...
- 23
0
votes
2
answers
55
views
runnig ANOVA for selected variables only with grep() in r [closed]
I am trying to run ANOVA for multiple outcomes selected with grep(). Below is close to what I have, but this doesn't work, of course. It seems like there is an elegant and efficient way of doing this ...
-1
votes
2
answers
124
views
Create a summary() table by date in R [duplicate]
This must be simple, but I can't find guidance how to accomplish it. I've got a very simple (sample below), with a date variable and a temperature variable. The output I want is a data frame by date ...
- 355
1
vote
1
answer
76
views
Summary of numeric variable with missing values
Is there a R package that give me summary statistics of a numeric variable which include the percentage of missing values?
I have tried the built-in summary, Hmisc describe and psych describe, but non ...
- 5,418
0
votes
2
answers
47
views
Need help graphing a time series by category and grand total of all categories in Power BI
I have a data frame with columns year, category, and value. I would like to plot this data in Power BI as follows: For each category separately, plot the sum of "value" by year. In addition, ...
- 43
1
vote
1
answer
69
views
NA values when running summary statistics for NSCH data in R using mitools and survey packages
I am working with NSCH data for the first time in R. I found the following resource, which has been enormously helpful (thank you!).
https://github.com/ajdamico/asdfree/blob/master/nsch.Rmd
I followed ...
1
vote
1
answer
83
views
gtsummary hierarchical summary table for multiple measurements
I have data with vital signs multiple timepoints (0H, 4H, 8H etc) for each measure (SYSBP, DIABP etc). The data is organised in long format as follows
data <- structure(list(SUBJID = c(1, 1, 1, 1, ...
0
votes
2
answers
73
views
Handling placeholder values in numeric columns with tbl_summary()
I'm trying to use the tbl_summary() function from the gtsummary package to summarize survey data.
However, I'm finding it challenging to deal with numeric columns that contain placeholder values.
For ...
0
votes
1
answer
179
views
r summary table for discrete and continuous variables
My apologies if this question is a duplicate or asked somewhere already.
I like to create summary tables with this format.
1) Discrete variables : n/N (%)
2a) Continuous variables : mean (SD); N
2b)...
- 883
0
votes
1
answer
305
views
JQL in a filter is working sometimes, and sometimes not
In our Jira boards, we want to be able to filter FE and BE tickets by using the Quick filters. The tickets have a prefix of: "FE: (title)" or "BE: (title)".
My 2 queries are:
...
jira
0
votes
1
answer
207
views
paired wilcoxon test in gtsummary for multiple observations per subject
I'm trying to compare two paired samples from 4-period crossover bioequivalence study. My target variable is TMAX (but it may be any other which fits for this test). There are no problems with my code ...
1
vote
1
answer
118
views
Export statsmodels summary() to .png
I have trained a glm as follows:
fitGlm = smf.glm( listOfInModelFeatures,
family=sm.families.Binomial(),data=train, freq_weights = train['sampleWeight']).fit()
The results looks good:
...
- 1,762
-1
votes
1
answer
41
views
a summary table of n (%)
I am trying to create a summary table with only N and %s formatted like this.
data("mtcars")
am (N [%])
0 19 [59%]
1 13 [41%]
gear (N [%])
3 15 [46%]
4 ...
- 343
0
votes
1
answer
50
views
Single band multiple raster Exploratory Data Analysis (EDA) in R
I have single band 764 weekly raster files from 2009 to present. Using these files, I want to make seasonal exploratory data analysis (EDA) according to corresponding years. I need to know how I can ...
- 1
1
vote
0
answers
146
views
How to show weights and coefficient p-values for (multiple) estimation(s) using etable
I'm putting together multiple estimations into one etable() table.
When I do a single estimation using summary() , I get the individual coefficient p-value and the weights used.
Yet when I do a single ...
- 13
1
vote
1
answer
36
views
Obtain from a large list (survival) the table from the summary
I have an object called resultados ,a list, which is a result from a cch function. applied to set a model that was run in a loop to iterate for a list of biomarkers (111 elements). I would like to ...
- 410
1
vote
0
answers
89
views
Using two "by" categories in tbl_summary from gtsummary in R
I would like to create summary table using two "by" factor (age category and gender)
i would like to obtain this table. Any ideas?
I tried
data %>% select(Sex, Age, Height, Weight, BMI, ...
1
vote
1
answer
509
views
Adjusting for sampling weights in table1 in R
I would like to write a custom rendering funtcion that shows summary statistics weighted by sampling weights using the table1 package in R.
The problem here is that in addition to the vector with the ...
- 28
0
votes
1
answer
86
views
pseudo element nesting css doesnt apply using `&` for ::marker under <details> but <summary>
trying CSS nesting feature with pseudo element ::marker but found it strange that this nesting does not work
details {
padding: 4px;
& summary {
color: red;
& ::...
- 54.2k
0
votes
1
answer
31
views
Duplicated stat_summary with break y-axis in R
I have data on Percentage Change from Baseline for two groups, and I've encountered an outlier. To visualize the data, I created a boxplot and added the number of observations at the bottom using ...
- 726
0
votes
4
answers
141
views
Excel sum/max-min multiple rows, insert new row and delete added rows
I have the Excel data shown below. Column A has the ID, columns B and C have segments of values associated with the ID, and Columns D and E are general descriptions of the ID (associated with the ID, ...
- 43
1
vote
0
answers
569
views
Update github summary wth action's results
I would like to modify our the GHE workflow summary with some action's results using GITHUB_STEP_SUMMARY
Here is how it is organized:
From the web UI or gh CLI, we launch a generic workflow which ...
- 364
1
vote
1
answer
294
views
How to specify covariates in gtsummary ANCOVA
In a gtsummary table, I want to show the p-value for the difference in several variables between group A and group B, corrected for age and sex. I found here that I can use the ANCOVA test in ...
- 25
0
votes
1
answer
69
views
r convert a wide format to a summary format
If this is my dataframe
Factors Group n Average Max Min
Calcium Above 1599 0.412 42.872 0.017
Calcium Below 1040 0.011 0.017 ...
0
votes
1
answer
62
views
What does (Mb) Ncells 284.8 Vcells 459.9 mean in RStudio
I used the function gc() when the RAM looks like it is going RED and the message that I received is Mb Ncells 284.8 and Vcells 459.9.
What does that mean, especially after I just saved 8GB of memory ...
1
vote
2
answers
50
views
Calculate the mean by group and binding to the data set in R [duplicate]
Consider the following example:
library(dplyr)
df <- data.frame(
Cat = c ("A","B","C","B","C","A",&...
- 643
0
votes
0
answers
97
views
Why am I getting a different value for the percent variation explained by my dbRDA output?
I've run a dbRDA on a large community abundance dataset in Vegan, and have realised I'm getting different values for the total variance explained by my constrained axis.
If I use summary(dbrda) I get ...
- 1
1
vote
1
answer
1k
views
Array arguments to SUMIFS are of different size ERROR CODE
I am using the following code, but am receiving the 'array arguments to sumifs are of different sizes' error code :
=SUMIFS(Expenses!I:I,$A$30,Expenses!B:B,B1,Expenses!H:H)
Any helpful ideas on how ...
0
votes
4
answers
440
views
Looking up Excel values based on sheets and rows
I was wondering if it's possible to look up values based on sheet names and certain columns inside those sheets? I was trying to wrap my head around that idea, but couldn't actually find a solution, ...
- 3
-1
votes
1
answer
388
views
Simple google sheet trade summary from Tradingview .csv file
I have this raw data in this format:
I want to add a column (or more than one if it’s not possible to find a single formula to complete the job) that matches each open trade by instrument and ...
- 25
0
votes
0
answers
669
views
Argument "statistic" in "tbl_summary" function from "gtsummary" package does not work
I am new to gtsummary package, but when I try to change summary statistics in the tbl_summary function, it gives me error messages, I tried to use the code with different data frames, but the same ...
- 55
-2
votes
1
answer
143
views
Gabor Data Analysis: Chapter 1 Stuck in a Code: How to Set Directory
Dear Stackoverflow Community,
I am trying to self-teach myself R and data analysis using the textbook "Békés, Gábor. Data Analysis for Business, Economics, and Policy" (https://gabors-data-...
- 1
-1
votes
2
answers
116
views
Modify the name of factor variables in lm function(summary function)
Sample code:
options(contrasts = c("contr.sum", "contr.poly"))
require(datasets); data(InsectSprays)
model1 <- lm(count ~ spray, data = InsectSprays)
summary(model1)
When I ...
- 71
1
vote
2
answers
124
views
How to return the last two lines of summary output from a linear model in R?
After finding a regression prediction in lm I want to return only last two lines of the summary. What would be the best function to use?
my_model_lm(y ~ x1 + x2 + x3, data = [data])
summary_result <...
- 13
1
vote
1
answer
301
views
Different outputs from same model lmer modelsummary sjPlot
I am running into a small issue that i can't figure my head around.
I developed a model that I test using lmer. Full code:
#importing library
library(tidyverse)
library(lmerTest)
library(car)
library(...
- 25
1
vote
0
answers
131
views
Summary table visualized as a tree chart with R
I'm trying to visualize a summary table as a tree in R.
Actually I saw there are some plots related to decision tree algorithms, but I don't need a machine learning model.
Is it possible to have a &...
-1
votes
1
answer
61
views
In the JMeter Summary report, I would like to display the average of all the repeated requests instead of individual samples
I have a test plan that runs with 100 threads, and many APIs are repeated in the test flow. I want the Summary CSV report to display the average response time, as seen in the UI.
Currently i shows for ...
- 129
-1
votes
2
answers
510
views
How to look at a certain value/category of a variable according to another one (Large dataset)
I'm writing this question according to another problem I have in R studio. I have a very large dataset that consists of movement data (ACC) for birds and I have multiple rows per individuals (each row ...
- 27
1
vote
1
answer
162
views
What is the optimal value of limit_phrases for the summary method in pyTextRank
I am summarizing documents using TextRank pipeline in SpaCy. I need to summarize both long and short documents. Can you suggest a good approach to choose the right parameter of limit_phrases?
this is ...
- 141
0
votes
1
answer
87
views
How to collapse dataset and create new variables?
I have a dataset with multiple rows of data for each subject. This dataset is very long, and each person has dozens of rows of each session they are in. I want to collapse this dataset into a more ...
- 401
4
votes
1
answer
2k
views
R summary of GLM not showing Deviance Residuals
I wish to see the summary of deviance residuals when I run summary on a GLM in R. I believe this should be shown by default, however it doesn't appear for me. I am aware that I can use something like
...
- 43
-1
votes
1
answer
59
views
Group by and Left join
create table test_txn (
ttid bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`PROFILEID` int(11) NOT NULL,
`MERCHANT_TXN_ID` varchar(32) NOT NULL,
`TXN_STATUS` int(4) NOT NULL,
`...
0
votes
1
answer
83
views
is there an R function that allows me us the summarize function on multiple variables within a data set? or get descriptive statistics
i am trying to get the descriptive statistics from multiple variables between two groups. so far the only way i could find out how to use so is using the group by then summarize function. but it is ...
0
votes
2
answers
53
views
Summarize column in multiple files in R
I have multiple files which is formatted like:
> Test1.txt
NameNo Team etc
1: AS001-A. 8 773
2: AS002-S. 7 631
3: AS003-G. 8 970
> Test2.txt
...
- 157
0
votes
2
answers
48
views
Add labels to a bar chart of monthly totals
I built a barplot in R where each bar represents the cummulative rainfall for a given month in a year. However, the bars themselves don't have labels, and my boss is really emphasizing the fact that ...
0
votes
1
answer
280
views
Can´t center text in Syncfusion GridSummaryColumn
I'm trying without sucess to center or position in other ways the text in the summary row of my Syncfusion SfDataGrid in WPF. I have the following structure:
<syncfusion:SfDataGrid
...
...
