Viewing 15 posts - 76 through 90 (of 230 total)
Option 1 works only if you replace the {} with [] as follows:
df.columns = ['BillMonth', 'InvoiceAmount']
True, dat! So, we're down to the missing alternative of "None", I suppose...
December 18, 2019 at 9:06 pm
Option 1 may well work, but in this instance, it's renaming the wrong field so is wrong for the question posted.
(I know, I'm being really picky now).
I really don't...
December 18, 2019 at 11:56 am
Option one won't work as it's renaming the wrong field.
Option one should work, shouldn't it, since it sets the name of all the columns, but uses the old name...
December 18, 2019 at 11:37 am
I thought I wouldn't touch this question until it's been reviewed, but I couldn't resist.
Clearly, option 3 wouldn't work, since the original column name is "BillingAmount", and not "BillAmount". In...
December 18, 2019 at 8:30 am
I'll defer answering until Steve has sorted this one out.
November 27, 2019 at 10:43 am
Well, unfortunately, the documentation is a bit off. The bit about the session settings is correct, which matches what I wrote.
The bit about the database settings is incorrect. The correct...
November 25, 2019 at 9:34 am
Not to nit-pick, but the option is actually called ANSI_NULL_DFLT_OFF, so technically, all the answers are incorrect.
However, the database option is called ANSI_NULL_DEFAULT, which can be set to OFF or...
November 25, 2019 at 8:54 am
Looking at the available answers, the only logical response would be that it would fail, since all the other answers have both date and time that doesn't match the input...
September 27, 2019 at 8:28 am
Interesting that arguments are optional until the're used in the function.
June 19, 2019 at 7:13 am
Evidently, I wrote much the same thing 4 years ago. 😛
June 17, 2019 at 7:18 am
I'm gonna go all "Four Yorkshire-men" on this and comment that back in my day, we'd been glad for ISQL/W. We would use SAF in character mode and be happy!...
June 17, 2019 at 7:16 am
Good question!
This is the main reason I avoid ISNULL, if possible.
Another aspect is the nullability of the result. ISNULL will infer that from the nullability of the second argument, whereas...
May 16, 2019 at 7:24 am
Well, then. Eventually, your answer might be re-flagged.
May 8, 2019 at 5:00 pm
And when did you answer the question? I have the same on, but I know I answered before Steve corrected the answers.
May 8, 2019 at 4:18 pm
Viewing 15 posts - 76 through 90 (of 230 total)