3,057 questions
0
votes
1
answer
69
views
pandas get min and max value for multiple rows
i have these cols "Price", "functions", & "cat" as df.
Price functions cat
51272.85 8 3-8
51134.15 3 3-8
51150 8 3-8
51161.3 1 1-6
51165.45 1 ...
- 99
0
votes
1
answer
161
views
How to use the sorted() and min() function with OR-Tools in python?
I'm building a Python Sudoku Solver to solve the classic and non-classic sudokus using the cp_model from Google's ortools library. Specifically, I'm trying to write a method that solves a Sudoku ...
- 295
1
vote
1
answer
41
views
How to create DataFrame that is the minimal values based on 2 other DataFrame's in pandas (python)?
Let's say I have DataFrames df1 and df2:
>>> df1 = pd.DataFrame({'A': [0, 2, 4], 'B': [2, 17, 7], 'C': [4, 9, 11]})
>>> df1
A B C
0 0 2 4
1 2 17 9
2 4 7 11
>&...
- 787
-2
votes
1
answer
83
views
How to generate an annual return (performance) table of several securities accounts in Excel
I have a data set which consists of the following structure and would like to generate an annual return table. Data can be for only first day of each year, or sometimes monthly intervals as well. For ...
- 25
4
votes
3
answers
100
views
Having trouble with which.min inside dplyr pipe
I have some trouble with which.min function inside a dplyr pipe
I have a cumbersome solution (*) and I'm looking form more compact and elegant way to do this
reproducible example
library(dplyr)
...
- 1,810
-2
votes
1
answer
102
views
Detect and ignore anomalous number in MySQL MIN/MAX query [closed]
I am trying to find the MIN and MAX of a simple data set....
Score
15
12
8
28
5
Simply doing this would work.
SELECT MIN(Score) AS minScore, MAX(Score) AS maxScore FROM Scores;
Which should return 5 ...
- 17
0
votes
1
answer
47
views
Max and Rank not returning expected results
I have what I thought was a simple solution to return the earliest date in each group for a large number of records.
WITH FEES
AS
(
SELECT
IT_NO AS ITEM_NO,
MAX(FEE_TRAN_DT) ...
- 702
0
votes
0
answers
66
views
Is there a way to numerically find multiple minima of a function?
So I have a function f(θ) that I can calculate numerically on a range 0 to 2pi. (specifically the minimum distance between the point on one keplerian orbit and another keplerian orbit).
I know from ...
1
vote
2
answers
107
views
How do I find the min and max of a value of one column in postgresSQL and have it return only 2 rows?
I'm using postgresSQL and would like to find the minimum value and the maximum value in one column. I have to have a column titled Order ID, Minimum Order, Maximum Order in the query. See the below ...
- 57
-3
votes
1
answer
54
views
I am trying to figure out how to incorporate a date range restriction while using the MIN function in SQL [closed]
I have a list of order dates for various vendors on specific items. I want to be able to pull the MIN orderdate but also have the min order date be within a specific date range (i.e. first day of last ...
- 5
-1
votes
1
answer
48
views
Excel =MIN(INDEX(( returning wrong value
I'm trying to return earliest date from a range by using the following formula:
=MIN(INDEX((donations_tracker!$A$2:$A$15 = A4)\*(donations_tracker!$D$2:$D$15),,,))
The formula returns 1899-12-30 for ...
0
votes
1
answer
114
views
Max() and Min() have different behaviours?
Why is the behaviour of min() different from max()?
Select
max(My_Date) over (order by My_Date) as Max_Datum
, min(My_Date) over (order by My_Date) as Min_Datum
From
(
Select dateadd(m,-1,...
- 448
2
votes
2
answers
80
views
Teradata Windows analytical function to select the correct records from partition
I have just 2 columns for partition and on basis of those two columns, need to select the appropriate dates.
Input Data:
strt_dt
end_dt
ID
Amt
2023-09-29
2023-10-01
ID1
100
2023-10-02
2023-10-02
ID1
...
- 105
0
votes
2
answers
211
views
Eliminating #N/A errors in =MIN STOCKHISTORY results
I am using the STOCKHISTORY function to find the minimum value during a set period. On occasion and for some stocks, there may be errors or missing data on a given day. This returns #N/A value, I ...
- 3
0
votes
0
answers
13
views
how do we test published data on mqtt uisng nodered as a tester, is there any way to test it by postman with valid and invalid scenarios
I am getting this data on mqtt
{"header":{"gatewayId":"460d39e0-44c6-11ef-a75e-ff9073d46daf","assetId":"8cd3b8d8-a5db-45ef-9a1c-e812de7e5ef0","...
