why this error? The system cannot find message text for message number 0x2331 in the message file for Application
Date : March 29 2020, 07:55 AM
|
I have a column of text and text-formatted-numbers. If number;convert. If text;return text
Tag : excel , By : mediafarm
Date : March 29 2020, 07:55 AM
like below fixes the issue As I mentioned in the comments use the error checking to do a mass conversion but if you still insist on a formula then here it is. =IFERROR(INT(A1),A1)
|
How can I find the amount of decimal places of a number from a list of numbers in a text file
Tag : python , By : Robin Buitenhuis
Date : March 29 2020, 07:55 AM
wish help you to fix your issue A text file has the following numbers: 1,2,3.02, 3.234,2.52 , Suppose the input file is something like below. input.txt 1,2,3.02,3.234,2.52
res = []
with open('input.txt') as file:
number_list = file.readline().strip().split(',')
for num in number_list:
sig_fig = 0
if '.' in number:
sig_fig = len(number.split('.')[-1])
res.append(sig_fig)
print(res)
def get_sig_fig(num):
return len(num.split('.')[-1]) if '.' in num else 0
with open('input.txt') as file:
number_list = file.readline().strip().split(',')
res = list(map(get_sig_fig, number_list))
print(res)
|
Generate a list of unique random numbers where the number should not be same as index of number in list using kdb
Date : March 29 2020, 07:55 AM
will be helpful for those in need There are probably a few ways to do go about this. I came up with this: q){$[any (r:neg[x]?x)=til x;.z.s x;r]}5
3 2 4 0 1
q){$[any (r:neg[x]?x)=til x;.z.s x;r]}5
2 0 4 1 3
|
Use a while loop to read in the entire text file and output a message a list with only the even numbers from the file to
Tag : chash , By : ganok_tor
Date : March 29 2020, 07:55 AM
|