Expression Basics

Sigilweaver uses Polars expressions for filtering data and creating calculated columns. Don't worry if you've never written code - the editor guides you with autocomplete.

You Don't Need to Memorize Anything

The expression editor has full autocomplete support. Press Tab at any point to see what's available.

Finding Columns

Type pl.col(" and press Tab to see all columns from your input data:

pl.col("  # Press Tab → see your columns

Start typing to filter: pl.col("win → Tab → pl.col("Winning Numbers")

Finding Methods

After a column reference, type . and press Tab to see available methods. The suggestions are context-aware based on data type:

pl.col("email").       # Tab → .str.contains(), .str.to_lowercase(), etc.
pl.col("created_at").  # Tab → .dt.year(), .dt.month(), etc.
pl.col("price").       # Tab → .round(), .abs(), .clip(), etc.

Type a few letters to narrow down: .str.con → Tab → .str.contains()

Complete Example

Building an expression to check if a name contains "Mrs":

1. Type pl.col("Na → Tab → pl.col("Name")
2. Type .str.con → Tab → .str.contains("")
3. Type Mrs inside the quotes

Result: pl.col("Name").str.contains("Mrs")

The entire process uses Tab completion - no memorization required.

Keyboard Shortcuts

• Tab - Show completions / accept suggestion
• Ctrl+Space (Cmd+Space on Mac) - Manually trigger autocomplete
• Arrow keys - Navigate suggestions
• Enter - Accept selected suggestion

Column References

Reference a column by name using pl.col():

pl.col("column_name")
pl.col("age")
pl.col("Total Sales")

Column names with spaces or special characters work the same way - just wrap them in quotes.

Literals

Use pl.lit() to wrap constant values when they need to become column expressions:

pl.lit("active")       # String literal
pl.lit(42)             # Integer literal
pl.lit(3.14)           # Float literal
pl.lit(True)           # Boolean literal

When You Need pl.lit()

You must use pl.lit() when assigning or returning a constant value:

# In Formula tool - assign a constant to a new column
pl.lit("Complete")

# In conditional returns (.then and .otherwise)
pl.when(pl.col("status") == "active").then(pl.lit("Yes")).otherwise(pl.lit("No"))

# Fill null values with a constant
pl.col("value").fill_null(pl.lit(0))

When You Don't Need pl.lit()

You don't need pl.lit() for comparisons - bare values work fine:

# Comparing to constants - no pl.lit() needed
pl.col("status") == "active"        # Works
pl.col("age") > 18                   # Works
pl.col("price") < 100.0              # Works

Rule of Thumb

Comparisons: Use bare values ("active", 18, 100.0)
Assignments/Returns: Use pl.lit() to wrap the value

Comparison Operators

Operation	Operator	Example
Equals	==	pl.col("status") == "active"
Not equals	!=	pl.col("status") != "deleted"
Greater than	>	pl.col("age") > 18
Greater or equal	>=	pl.col("score") >= 70
Less than	<	pl.col("price") < 100
Less or equal	<=	pl.col("quantity") <= 10

Logical Operators

Operation	Operator	Example
And	&	(expr1) & (expr2)
Or	|	(expr1) | (expr2)
Not / Invert	~	~pl.col("is_deleted")

Invert (~)

The ~ operator inverts boolean values:

~pl.col("is_active")           # True becomes False, False becomes True
~(pl.col("status") == "done")  # Rows where status is NOT "done"

caution

The ~ operator only works on boolean columns or expressions that return boolean values.

Arithmetic Operators

Operation	Operator	Example
Addition	+	pl.col("price") + pl.col("tax")
Subtraction	-	pl.col("revenue") - pl.col("cost")
Multiplication	*	pl.col("quantity") * pl.col("unit_price")
Division	/	pl.col("total") / pl.col("count")
Floor division	//	pl.col("seconds") // 60
Modulo	%	pl.col("value") % 2

Chaining Operations

Polars expressions are chainable - you can call multiple methods in sequence:

pl.col("name").str.to_lowercase().str.strip_chars()
pl.col("date").dt.year()
pl.col("price").round(2).cast(pl.Float64)

External Reference

For the complete Polars expression API, see the Polars User Guide.