1,994 questions
Advice
1
vote
1
replies
57
views
How to switch between ADB and ADBD
How to switch between the the two (adb and adbd) I'm trying to get to adb but it keeps kicking me into ADBD. And I'm not sure why could someone please explain. Thank you.
I'm not sure if this is a not ...
Best practices
0
votes
1
replies
146
views
PrimeNG vs NG-ZORRO comparison
PrimeNG and NG-ZORRO as UI Library, which is better for large enterprise grade Angular application? Where customization will be easy, less pain and all features will be available.
I feel PrimeNG ...
- 1
0
votes
0
answers
45
views
Creating a Line graph & Matrix showing % Difference from Previous Year, allowing for a filter on "Country"
I have raw data with columns "Year", "Period", "Country", "Sales Amount". Please note there are 13 periods in a year, (and not 12). The dates also differ ...
- 1
1
vote
1
answer
112
views
What is the appropriate terra-based method to summarize the difference between rasters with different spatial extents?
The terra code I'm using to summarize the difference between two rasters, each with a unique spatial extent, is producing unexpected results. In short, the output matches the spatial extent of the ...
3
votes
1
answer
96
views
R. Contrasting predicted means in R survey package with splines
In the R "survey" package the svyglm() function can be used with svypredmeans() and svycontrast() in order to compare predictive marginal means for a generalised linear model. This works ...
- 101
1
vote
3
answers
109
views
How to get difference value (delta) between to rows after query in Mariadb
Helo,
this is my query:
MariaDB [PV_Anlage]>
SELECT created_at, verbrauch_ges
FROM pv_metrics
group by DATE(created_at)
ORDER BY ID DESC limit 20;
+---------------------+---------------+
| ...
- 23
4
votes
3
answers
163
views
How to tell if two arrays contain the same elements [duplicate]
Following are two arrays of strings
arr1=("aa" "bb" "cc" "dd" "ee")
echo ${#arr1[@]} //output => 5
arr2=("cc" "dd" "ee&...
- 2,113
3
votes
0
answers
73
views
Monthly/quaterly data when using did_imputation in R
I am using the did_imputation package in R for the Imputation Estimator from Borusyak, Jaravel, and Spiess (2021). I suspect to have some issues regarding the formatting of my variables, especially ...
- 66
0
votes
1
answer
149
views
The results of using Eigen to calculate matrix in C++ are different on Linux and Windows platforms
I use Eigen to calculate the rotation matrix and run the same C++code on both Linux and Windows platforms as follows:
void testEigen()
{
Eigen::AngleAxisd xRot(0.0, Eigen::Vector3d::UnitX());
...
- 1
0
votes
0
answers
62
views
Comparing hash of a file in git index versus git working directory is inconsistent
I have a git repo with the same file called fileA in two different paths : locationX and location Y.
I am trying to ensure that these two files are identical and if they do/do not match what's been ...
1
vote
1
answer
102
views
Calculate the difference between successive observations rowwise in a dataframe
I have this hypothetical dataframe
df<- data.frame(a_13=c(NA, 1, 2),
a_12=c(NA, 4, 3),
a_11=c(NA, 2,NA))
df
a_13 a_12 a_11
1 NA NA NA
2 1 4 2
3 ...
- 215
0
votes
1
answer
155
views
How to calculate difference between 2 columns in power bi table visualization
I have a table visualization created in power BI dashboard and it has 3 columns. I want to find the difference between col1 and col2 and display as diff. I have written a measure but it is giving me ...
- 67
0
votes
0
answers
54
views
The difference between math.trunc() and int() in python [duplicate]
what is the difference between math.trunc() in math module and the int function in python both of them return remove the fractional part of a number and I think it has some reasons that python let ...
- 33
0
votes
1
answer
126
views
Calculation of the current month value from the running total column (reset every year)
I have a table like this:
I want to calculate the current value of a single month in another column as the difference between this month and previous (grouping by "group"), except January ...
- 1
1
vote
1
answer
230
views
Delphi EncodeDateTime and EncodeTime Time portions are different
Here is an example which demonstrates the problem:
var
fdt, fndt : Double;
dt, dt2 : TDateTime;
begin
dt := EncodeDateTime(2023, 12, 31, //
20, 10, 5, 100);
dt2 := EncodeTime(20, ...
- 3,483
2
votes
1
answer
94
views
Compare strings from a very large text file (over 100 GB) with a small text file (about 30 lines) and print all the strings contained in both files
I have two text files. One contains a very long list of strings (100 GB), the other contains about 30 strings. I need to find which lines in the second file are also in the first file and write them ...
- 23
0
votes
1
answer
126
views
SQL max function leetcode 626
In Leetcode 626. Exchange Seats
I write
Select
(case
when id%2 != 0 and id = (select max(id) from Seat) then id
when id%2 =0 then id-1
else id+1 end) as id,
student
...
-2
votes
2
answers
70
views
Python script to print only the difference between two text files [closed]
I was looking for some help to write a Python script to print only the difference and not anything extra in the output.
For example:
Contents of File1 :-
['Tom','Joe','Kim']
Contents of File2 :-
['...
0
votes
1
answer
67
views
compare 2 arrays with different sets of elements and get the difference
I have 2 arrays similar to below structure. I want to compare each field and then store the array item which has a difference into a third array.
Arr1= [{ state:CA, id:1, name:aaa, product:car, color: ...
0
votes
0
answers
159
views
Correct way of using cross-correlation to find time difference between 2 sine waves
I'm not a software engineer nor a hardware engineer, but I've been trying to learn some signal processing algorithms to apply to my project.
I want to use cross-correlation to find time difference ...
- 11
0
votes
0
answers
55
views
Compare bit bucket branches and see differences that should not be seen
I have the following branches
uat
prep
prod
I have same code in all 3 branches.
When I compare UAT as Source and PREP as Destination, bitbucket shows no differences.
however, If I compare UAT as ...
- 13
-3
votes
1
answer
71
views
How do i calculate difference between counts for each value in Excel
I counted the total number of each product in table1. Then, I need to differentiate Delivered and Pending products in the total count.
For Total count of each product i used:
=COUNTIF($B5:$B17,E5)
...
0
votes
1
answer
70
views
How to find the percentage change of two graphs
I have two graphs and would like to find the difference between them in percentage.
First I converted them into lists:
Graph_1=[3843.788185, 3734.256494, 3572.574207, 3420.958554, 3254.79344, 3008....
- 31
1
vote
1
answer
67
views
How to calculate the percentage of change on rows with NA
How do I find and calculate the percentage of change of an indicator throughout time when there are several NAs spread throughout the data?
Let's assume that this is my dataframe:
a b c d ...
- 25
0
votes
1
answer
380
views
Problems with add_difference() in gtsummary
I have this df
df
# A tibble: 248 × 2
asignado mxsitam
<chr> <chr>
1 Control No
2 Control No
3 Intervencion No
4 Intervencion Si
5 ...
- 33
0
votes
2
answers
170
views
Find some better algorithm for finding the smallest difference between the elements of an array
Input: Array of integers A[0..n – 1]
Output: Smallest difference between two elements of a dmin array
dmin = ∞
for i = 0 to n − 1 do
for j = 0 to n − 1 do
if i != j &&|A[i] − A[j]| &...
- 11
0
votes
0
answers
60
views
Extract difference between slightly misaligned images with ImageMagick
I have 2 screenshots from a video game, of a person's gloves and a knife. The knife and the background are identical, while the gloves are different. I want to get the different part between the ...
- 736
0
votes
0
answers
38
views
Dropping rows that do not match values from another column
I've got two dataframes that I am comparing however they are different in length. I want to compare the values from the reference column that exist in both dataframe and drop the rows that do not ...
0
votes
2
answers
71
views
how to difference values within several panels
Suppose the data is:
data <- structure(list(country = c("Poland", "Poland", "Poland", "Poland",
"Poland", "...
- 187
0
votes
3
answers
73
views
How to select result which calculates difference between two tables then display it along a third table?
Regarding db fiddle
Table: items
id
name
1
bolt
2
wrench
3
hammer
Table: inwards
id
item_id
quantity
1
1
10.00
2
2
8.00
Table outwards
id
item_id
quantity
1
1
5.00
I want to SELECT table items with a ...
- 321
0
votes
1
answer
66
views
Python Pandas: Find the difference of two dataframe
import pandas as pd
a = [0.0, 0.6900000000000001, 1.3800000000000001, 1.3800000000000001, 2.0700000000000003, 2.7600000000000002, 2.7600000000000002, 3.45, 4.1262, 4.140000000000001, 4....
- 1,723
-1
votes
2
answers
125
views
MySQL Query for Spread/Difference of Energy Counter and missing Value interpolation
I have an energy counter (kWh) recorded in a MySQL database every 15 minutes.
Sometimes the recording fails for several reasons (power outage, computer reboot for updates...) and values are missing.
...
- 187
0
votes
2
answers
106
views
removeAll function removes more than expected
I have the following functionality that I’ve seen people use in order to get
the differences between two lists.
Note: this is not the actual code but a representation of what I have, in actuality each ...
-1
votes
2
answers
77
views
What are the differences between these two function? They look the same [duplicate]
I am a newbie of Rust. There are two function here. When I compile, foo1 compiles pass and foo2 displays an error. But they only add an irrelevant parameter to foo1 compared to foo2, what is the ...
-1
votes
1
answer
39
views
Difference between class component and function component in reactjs
Difference between class and function components in reactions?
Working and use of both components and when to use them. And also explains when to use which component that completes our programming ...
-3
votes
2
answers
645
views
How to identify changed property values when comparing two nested data structures? [closed]
I'm working on a TypeScript project where I need to compare two objects with potentially nested structures and identify the fields that have changed between them. For instance, consider an old object ...
0
votes
1
answer
101
views
Find cases of abrupt changes (value differences) within a certain time span with R
I have a multi-annual temperature time-series with a datetime column (with irregular time steps) as such :
daytime Temperature
<dttm> <dbl>
1981-10-01 ...
- 11
1
vote
2
answers
96
views
Dataframe - difference of rows by some style
I want the difference of column 'position' by the column 'Seg' with 'x' adjacent.
import numpy as np
import pandas as pd
mydict = {'position':['0.0', '0.433', '2.013', '3.593', '5.173', '6.753', '6.9']...
- 1,723
0
votes
2
answers
91
views
Count then calculate differences from first and previous rows after grouping, but ignoring text/character values in r
From the following data grouped by id and visit, which include a mix of numeric and text/character values, how to create these 3 new columns:
count_wotxt: count by id and visit but without ...
- 1,248
2
votes
1
answer
49
views
first Quarter current Quarter difference
Iam fairly new to DAX and for that reason studying to catch more routine. Having problem trying to resolve. Am trying to count difference between first and the current Quarter.
start Q current Q diff =...
- 45
-1
votes
1
answer
197
views
About making animation by VMD(Visual Molecular Dynamics)
~Details~
I have a file.pdb that contains 10 frames but each frame don’t have same data size(ex. frame1 has 10 atoms, frame2 has 20 atoms….).
I need a way to make animation of this file, but VMD ...
- 1
0
votes
0
answers
47
views
Calculating all possible differences of observations in R
I have the following data frame and
# Create a dummy dataframe
dummy_df <- data.frame(
observation = as.factor(rep(1:4, each = 3)), # Factor from 1 to 4, repeated for each species
species = rep(...
- 51
1
vote
2
answers
900
views
what difference of hashSetOf() and mutableSetOf() method in kotlin
when or where use hashSetOf() or mutableSetOf() method in kotlin or what difference of these?
I know the hashSetOf() or mutableSetOf() are the mutable but in programming when or where we use them.
val ...
- 13
0
votes
0
answers
95
views
How do I calculate the time difference between two datetimes in excel and then get the average time?
I have a dataset that I download from an application (no movement in changing the format of data)
**Created Date | Reviewed Date**
2023-10-25T09:55:47 | 2023-10-28T10:23:56
2023-10-25T09:55:47 ...
- 15
0
votes
1
answer
74
views
CLS tool is failing? data does not match
I am trying to improve the website that I am in charge of, but using the Page Speed tool https://pagespeed.web.dev/ shows me that the CLS for desktop is already 0 (zero) and in the Above it shows me ...
- 1
0
votes
1
answer
114
views
Quantify confidence on a difference between two groups [duplicate]
I am looking to quantify certainty/confidence on a difference between two groups (see toy dataset):
# Create dataframe
df<-data.frame(
Age=c(40,40,40,40,41,41,41,41),
Strength=c(50,49,46,46,...
- 81
0
votes
1
answer
83
views
Getting difference for variable per year
I would like to get the difference for consecutive years in a data frame like this:
group year value
------------------
1 2017 10
1 2018 20
1 2019 25
2 ...
- 489
0
votes
2
answers
79
views
Difference between two row values within the same column based on value in third column in R
[Expected Table][1]Thanks for looking into this post.
Trying to find difference between the "Record" value based on baseline visit in R(for spotfire)
For RecordId(10001), Change in Record ...
- 15
-1
votes
1
answer
659
views
Gap and Island Grouping
For my source table I have all the “Contact history for customers” in the correct order (ascending starting from earliest date at the top). What I need to do is group rows where the contacts are ...
- 1
0
votes
1
answer
432
views
BACI design: How to account for the difference in Before-After Control?
I ran a BACI experiment looking at the effect of artificial light at night on fish reproduction, and one of our response variable is the yolk area in their eggs. My raw data looks like the attached ...
