Viewing 15 posts - 31 through 45 (of 325 total)
I'm sorry, but your explanation is incorrect. Numpy.info, to which you refer, is a numpy-specific help function that does not give such an output about the data frame that is...
May 6, 2020 at 3:59 am
Thanks for this question, but is the ranking 1, 2, 2, 4, 5 given in the explanation correct? For the default SKIP, I would expect the ranking 1, 2, 2,...
May 2, 2020 at 12:24 am
Write me a question. George 🙂
Sorry, I have no question, I just wanted to point out the 3rd parameter for the ROUND function;-)
April 27, 2020 at 3:49 pm
Thanks Steve for this question. You can also try this:
SELECT ROUND(-7.7, 0, 1) as Round_truncated, CEILING(-7.7) as 'Ceiling';
GO
April 27, 2020 at 2:57 pm
I don't work with memory-optimized tables so I searched the web for the answer. Two sources state that DBCC CHECKTABLE will return: "Msg 5296, Level 16, State 1, Line 86...
March 27, 2020 at 4:39 am
Yesterday I gave up QotD after I couldn't decide which way was best. I wrote DecToHexa (n) function, which may be the answer # 1.
March 26, 2020 at 7:27 am
I had more time on Sunday, but I didn't believe I'd spend nearly half a day with it. I will try to explain this using the examples below, which I...
March 22, 2020 at 10:27 pm
Thanks for this question Steve. Today's Qotd could not be done quickly at breakfast with morning coffee. It was necessary to study DOCS well, you could "slip" in the recently...
March 19, 2020 at 4:25 pm
How about:
name.title();Wouldn't that work for this one-word example?
# Python v2.7.13 code:
str = "this is string example.";
print str
print "str.capitalize() : ", str.capitalize()
print "str.title() : ", str.title()
$python main.py
#...
March 12, 2020 at 3:09 am
Scary but interesting question, thanks Grant. At first I thought that all possible answers could be considered correct. After a moment of despair, I found a hint for the right...
February 11, 2020 at 5:16 pm
Great question, thanks John. Some typo doesn't matter, and the same two answers don't. After all, one correct answer rules out the remaining... Thanks also to Carlo Romagnano for clarifying...
January 30, 2020 at 8:56 pm
Ref. in the QotD explanation refers to the documentation for Built-in Functions and the open() function not to Input and Output. In...
January 29, 2020 at 3:49 pm
Hmmm ... oddly, print (result) in Python v2.7.13 displays the result correctly. No need to add list().
January 15, 2020 at 6:37 pm
Thanks Steve, for an interesting question. I appreciate the perfect explanation of this topic in a recent article in your "Voice of the DBA" blog. Well done!
December 27, 2019 at 1:33 am
In Python Pandas (Python v2.7.13), option #1 works with both { } and [ ].
In addition, option #3 without the Inplace=True parameter will do nothing and the original df will...
December 18, 2019 at 11:22 pm
Viewing 15 posts - 31 through 45 (of 325 total)