numeric Questions
7
Solved
I want to check if a string contains a numeric value. I have this code :
$string = "some string that contains 123456 in the middle"
$substring = $string.substring(27,9).Trim()
I have $substring ...
Rowland asked 4/7, 2018 at 10:23
11
I am trying to locate some problematic records in a very large Oracle table. The column should contain all numeric data even though it is a varchar2 column. I need to find the records which don't c...
6
I have a table:
Account_Code | Desc
503100 | account xxx
503103 | account xxx
503104 | account xxx
503102A | account xxx
503110B | account xxx
Where Account_Code is a varchar.
When I create a q...
Spheroid asked 4/1, 2013 at 8:32
4
Solved
I have a data frame contain 10 columns of data (temperatures, humidity values etc.). R identifies those as strings. I used the following command to convert one of the columns to numeric format:
d...
Yonyona asked 14/11, 2018 at 19:53
4
Solved
I have a convolution integral of the type:
To solve this integral numerically, I would like to use numpy.convolve(). Now, as you can see in the online help, the convolution is formally done from...
1
Solved
In R source code, most (but not all) functions use integer values for constants:
colnames <- function(x, do.NULL = TRUE, prefix = "col")
{
if(is.data.frame(x) && do.NULL)
ret...
Spurn asked 24/9, 2021 at 18:19
5
Solved
I have an error being thrown by SQL Server Management Studio when running this code:
declare @percentage numeric(3,2)
set @percentage = cast(15 as numeric(3,2))
but when I change numeric declara...
Discomfort asked 13/1, 2010 at 18:18
7
Solved
I have a PySpark Dataframe with a column of strings. How can I check which rows in it are Numeric. I could not find any function in PySpark's official documentation.
values = [('25q36',),('75647',)...
Cathodoluminescence asked 12/12, 2018 at 13:10
10
Solved
Is there an open-source alternative to MATLAB's fmincon function for constrained linear optimization? I'm rewriting a MATLAB program to use Python / NumPy / SciPy and this is the only functio...
Deafanddumb asked 8/9, 2008 at 15:19
2
Solved
Need MATLAB/Octave dec2base functionality function with independent bits/digits calculation algorithm (within integer logic, with no divisions, using modular arithmetic).
Would be nice to have as w...
4
Solved
Been scouring the internet trying to figure this out. Tried isnumeric, but that only works for an AbstractChar. I'd prefer not having to use tryparse if possible, but if that's the only solution so...
0
We are fitting a generalized linear model to a set of data using R on Fedora 33. We are 3 people that have the exact same data set, exact same OS (Fedora 33) , exact same R version and package vers...
Bobbitt asked 26/4, 2021 at 22:41
5
Solved
Is it possible to set an element of an array to NaN in Python?
Additionally, is it possible to set a variable to +/- infinity? If so, is there any function to check whether a number is infinity or...
1
Solved
2
Is there a linear algebra library that implements iterative Gauss-Seidel to solve linear systems? Or maybe a preconditioned gradient solver?
Thanks
EDIT: In the end I used a kind of crude but co...
4
Solved
6
Is there a way to key a numeric keypad without punctuations?
<TextInput keyboardType='numeric' ..... />
if I use secureTextEntry={true}, it gets the right keyboard I want, but the values are...
Conventionality asked 15/2, 2018 at 0:28
7
Solved
Recently I was going through an old blog post by Eric Lippert
in which, while writing about associativity he mentions that in C#, (a + b) + c is not equivalent to a + (b + c) for certain values of...
3
The number π can be calculated with the following infinite series sum:
I want to define a Haskell function roughlyPI that, given a natural number k, calculates the series sum from 0 to the k value...
Suttle asked 1/2, 2021 at 0:44
1
Solved
How to optimize the data frame memory footprint and find the most optimal (minimal) data types dtypes for numeric columns. For example:
A B C D
0 1 1000000 1.1 1.111111
1 2 -1000000 2.1 2.111111
...
4
I need to draw a numeric diamond, for example with a height of 9:
1
222
33333
4444444
555555555
4444444
33333
222
1
I wrote the code and I managed to get the same diamond, but with stars. ...
5
Solved
I have a program that reads financial data in JSON and inserts it into an SQLite database. The problem is when I'm inserting it into SQLite numeric column and it doesn't seem to like the decimal ob...
3
Solved
Recently I migrated a DB to PostgreSQL that has some columns defined as numeric(9,3) and numeric(9,4). In testing the app I have found that when data is saved to these columns there are trailing ze...
Otherness asked 13/11, 2014 at 23:6
4
I have a Python function with 64 variables, and I tried to optimise it using L-BFGS-B method in the minimise function, however this method have quite a strong dependence on the initial guess, and f...
Ramachandra asked 10/2, 2014 at 6:0
2
Solved
System.Numerics.BigInteger lets you multiply large integers together, but is there anything of the same type for floating point numbers? If not, is there a free library I can use?
//this but with ...
© 2022 - 2025 — McMap. All rights reserved.