Sorry to bump in but is there any reason that speaks against or for using either of these options over the other?

print(df.query('Grade >= 73'))
print(df[df['Grade'] >= 73])

To elaborate your question from ZZ, how do you decide the combination of Badge And Conf_Code.

Getting each the latest Date for each Badge is not the issue, but how do...

I have 2 options assuming im understanding correctly what ur trying to achieve:

--##################################################################################
--UNPIVOT: Convert Columns to Rows
--##################################################################################
select Doc,Name_OF,Number_OF
from [dbo].[Operation
UNPIVOT
(Number_OF for Name_OF in (Op1,Op2,Op3,Op4)) up

--Filtered only rows where...

Now wheres the container that allows me to work on a project until its finished without having to deal with 6 other projects on the side.

I've done a few Project Euler items. It's a good test for learning Python.

I think you are also looking only along the upper left to lower right diagonal. The...

Not sure if i am grouping too many columns here but my first thought would have been this.

Joining the table with the grouped version itself, not very efficient maybe? Guess...

would be nice to have something like this i guess, sucks it doesnt work

create table #table
(old_column int)

insert into #table
values(1),(2)

alter table #table
add new_column int default (case when old_column...

oracle? i remember reading here about why i would avoid oracle as a customer

https://news.ycombinator.com/item?id=18442941

Is it me or is all you have to do is change the following:

BETWEEN '' + @year + '-01-01 00:00:00.000' AND '' + @year + '-12-31 23:59:59.000'

to...

Agree, as a new member of the community id love to see what these are like.

Being able to take part online from europe would be awesome

I am close i think but im not sure where my my error is.

I am taking the previous end date and compare it to the current start date. I take...

For future posts plz take a look at this if you want help: https://www.sqlservercentral.com/blogs/how-to-post-a-t-sql-question-on-a-public-forum

To the problem: is this your issue, that these 2 where clauses queries dont produce the...

Always a challenge to learn something new when you're working, though I am surprised you can't do some of this at work. I'd think some of these might be...

That is something that is bothering me ALOT.

I am alone responsible for SSIS, SSAS and query development.

We have more than 500 tables and 7 different Cubes.

I can not even keep...

Correct answer YES! HARD WORK PAYING FINALLY OFF *SARCAS*

On another note i might be terrible at googling but i found the results for using group by and filtering on Dataframes...

• This reply was modified 3 years, 11 months ago by  ktflash.