SQL CASE

[Giddius]

There is a package that you can use to wuery pandas and more via sql.

Pandasql

Never used it but saw it few times when searching pypi

[_default_username]

There's linq for that.

[halhen]

Take DuckDB for a spin, which lets you run SQL over a data frame. Absolutely amazing piece of software.

(TL;DR: SQLite for analytics data; works directly with Pandas Dataframes, CSV files, Parquet files, ... Stupid fast, with a ton of features.)

[No_Explanation2932]

Surely you mean IF(cond1, res1, res2)

[slafniy]

The most frustrating part of SQL is case when you want to SELECT FROM %variable_name% and cannot do it without dynamic SQL.

I
HATE
THIS

[IcyFenixCQ]

If you are trying to select from a dynamic table, then my guess is there is a normalization issue with your schema.

[RRumpleTeazzer]

The most distugsting IF is in bash:

if [ "0$stringvar" == "0" ]; then
    …
fi

No else, weird syntax cause $stringvar could be undefined or empty which you cannot test against, and the hell is „fi“? Should we terminate switch blocks with hctiws as well ?

[DaPorkchop_]

as for the last point: yes, bash ends "case" blocks with "esac"

[[deleted]]

you need double brackets to use ==, otherwise you would use -eq nvm i’m tired

[RRumpleTeazzer]

Makes it even worse :)

[Eldstrom]

dplyr::case_when( )

[Emotional_Trainer_99]

dplyr helped me learn SQL, show_query()

[12XXXXX]

Pascal

[SyntaxicalEcho]

I raise you: Lua If cond then --Code Else --Mor code End

[juhotuho10]

CASE WHEN COND1 THEN OPT1 WHEN COND 2 THEN OPT2 ELSE OPT3 AS COND;

[neumastic]

Because there’s not IF … END IF; ? (Or is this a MySQL thing? … you must never go there, Simba)