News for hackers. Stuff that matters.
Re:DuckDB – in-process SQL OLAP database management system by brahbrah on Monday February 13, 2023 @09:35AM (#34773853)
Sometimes yes and sometimes no. For example if you had price data and you wanted to bump prices up a dollar in 2020 how would you do that in sql?

In pandas it’s:

    prices_df.loc['2020'] += 1
If you had a temperature forecast and you wanted to add the expected temperature miss to them, how would you do that on sql?

In pandas it’s:

    temps_df + expected_miss_df

There are no comments on this comment yet.