Questions tagged [range]
A range is an extent of values between its lower and upper bound. It can refer to a DOM Range, the Ruby Range class, the Python range function, Perl 5's `..` operator, Perl 6's Range Class, or PostgreSQL's range types.
range
10,690
questions
0
votes
2
answers
38
views
Check whether a string value is formula or range or constant
I have a very specific use case where I need to read value input in the data validation field for each cell.
If the value is a list, then the value should be stored in the string as it is. However, if ...
0
votes
1
answer
48
views
VBA Union Result Too Small
This is a lot of words to explain a very simple question:
Why is VBA upset about so few areas in a range variable?
When I try to do the union of two range variables, the result only has some of the ...
2
votes
1
answer
57
views
segment tree with range intersection
Recently I came up with a range problem when thinking about a hobby project.
Consider a big binary array indexed from 0 with size A("[0, A)"), I want to support 3 range (the ranges are ...
0
votes
1
answer
27
views
How to change scatter point color in plotly if exceed/ in between horizontal and vertical lines
Is it possible to change the specific scatter point color in a plot when values is in between the horizontal and vertical line in plot?
Example:
Horizonal Line and Vertical Line Code
Here is the ...
0
votes
1
answer
23
views
Setting the y-axis range for Seaborn/Matplotlib countplot to a specified range above/below the max and min data points
I am doing EDA for a machine learning project and am plotting a grid of countplots with Seaborn. In the visualization, the difference in height of the bars in each subplot is almost indiscernible as ...
0
votes
0
answers
68
views
C++ - Questions about bit shift operators (<< and >>)
Consider the below code:
std::string g_CharTable = "stjkloptrew23456mncv891TZUIOPAS";
std::uint32_t value = 123456789
std::string hash;
for (std::size_t i = 0; i < 5; ++i)
{
...
0
votes
1
answer
30
views
How to pull a range of values and add it to a date depending on it meeting a certain condition
Am trying to automatically sum up Dates based on a certain size of a feature and it's estimate and I am wondering if we can do this without if statements?
So If I enter a new feature of a certain size ...
2
votes
1
answer
47
views
copy a range from one worksheet to another without blank rows
I have a range named in a worksheet that is five columns wide and approximately 220 rows long. The rows within that range are primarily formulas that pull data from other locations and concatenate or ...
-1
votes
0
answers
21
views
Hive sql repeating records with amount differing only by +-5%?
How to delete repeating records with amount differing only by 5%? by amount in the range amout-5% to amount+5%?
Here is an example table on hive
[# a.uk b.uk AMOUNT START_DATE FINISHED_DATE source
1 ...
-5
votes
2
answers
96
views
How to decrease the range of the for loop in python?
In this question I wanted to find min(m+k) such that mCk =n, I wrote a code to brute force for my sequence, The problem was that my code isn't fast enough so I want to decrease the length of the for ...
0
votes
0
answers
14
views
Where is the documentation on the extra attribute on a Range? [duplicate]
I just found out about C# ranges, thanks to VSCode Quick Fixes, which looks very nice (especially coming from Python). The one thing that I cannot find any documentation on, though, is the supplying ...
0
votes
1
answer
45
views
Snowflake SQL. Select column value if 1st 5 characters are numeric and within a Numeric Range
I have a column named ProcedureCode VARCHAR(16777216) in a Table named ProcedureCode.
It has values like '12345,46H', 'A4715,12W', '98765', '99200' etc.
From that Table, I need to pull only rows where ...
0
votes
0
answers
29
views
Representing an 8-digit hexadecimal as a long [duplicate]
I am writing a Java program that performs bitwise operations on bites in a data stream.
I have been given test values in the form of 8-digit hexadecimal strings, which I have converted to base 10 and ...
3
votes
3
answers
69
views
Explanation about awk matching a pattern between a range of lines
I have an Awk one-liner that, while I understand what is being accomplished at a high level, I don't fully understand how Awk is accomplishing the task I give it. I'm asking Awk to give me a range of ...
-1
votes
2
answers
111
views
Fastest way to generate numbers up to a range in Python
I want to create a list of numbers that contains three consecutive 1s in its binary representation. To do this, I make set of number up to 2**n, and subtract it with a set of numbers that contains NO ...