Clifford's Portfolio

Deleting rows from a table

Syntax:DELETE FROM table_nameWHERE condition;

Updating a column based on condition on another column

Updating an existing table value based on a certain condition.

Stepping back in time using python

I found that working with dates in python can be quite a hurdle. But pandas always comes through. I discovered the pd.offsets module and it...

Getting the difference between two dates