Theres so many python books out there for data analysis.

After i fortified my basics of python im planning to continue with a handbook/introduction book to numpy und scipy.

Can anyone suggest...

So something like this?

This gets the value from the previous week, if you want the Date you would have to replace the LAG(DATE)

select Date,Value,Previous=LAG(VALUE)OVER (ORDER BY DATE)
from...

• This reply was modified 4 years, 6 months ago by  ktflash.

Something like this?

create table #TEMP (Date int, Value int)

insert into #TEMP (Date,Value) VALUES
(201901,201901)
,(201902,201902)
,(201903,201903)
,(201904,201904)
,(201905,201905)
,(202001,202001)
,(202002,202002)
,(202003,202003)
,(202004,202004)
,(202005,202005)
,(202101,202101) 
,(202102,202102)
,(202103,202103)
,(202104,202104)
,(202105,202105)


select a.Date,a.Value,b.Value
from #TEMP A
     inner join #TEMP B on b.Date...

• This reply was modified 4 years, 6 months ago by  ktflash.

The first thing i could think of seems to work but its not pretty i guess and im sure someone has a better solution, so lets see:

My Approach:

• get the...

i started to juggle

Still terrible at it but apparently it has decent amount of things it does for you:

• improving hand eye connection
• muscle training (holy shit, once you start...

Damn i should get into R

One of the many versions of: i know that only because i made that mistake already

Even if you use case when it will still produce duplicates, because ur join condition is what produces the duplicates: the not unique IDs

You have to filter them instead of...

If you edit the Taskflow, isnt there a 3rd option other than success/fail?

Sorry for the german version but there should be something called completeance or something.

What else...

One of the internet forum classics:

• Link to deleted File/Image
• Or simply: Thanks i found a different solution that works THE END

with
range_cte(EMployeeID, TranDate, NewStatus, dt_diff) as (
    select
      EMployeeID, TranDate, NewStatus,
      isnull(datediff(day, TranDate, lead(TranDate,1)...

• This reply was modified 4 years, 9 months ago by  ktflash.

How is it in other countries?

Here in germany it is like a third world country when it comes to home office, it is barely a thing.

Possibly dumb question, but i don't understand why and i am curious.

What is the reasoning behind creating these posts before it is actually available?

• Are they some sort of reminder...

While I don't know that I want AI/ML systems making decisions for me,

I wonder how much this is already happening without us knowing.

I am assuming the solution is a correlated subquery.

Like this example, with the difference that you need to use sum and group by instead of AVG.

This must be...