Operating columns
To understand column operations, first, we'll look at some of the most common operations, which are for selecting columns. In Optimus, you have the powerful select function, which provides multiple options for managing most selection cases.
Selecting columns
The simplest use case for selecting a column is using its name:
df.cols.select("job").print()
You will get the job column data in response:
job (object) ---------- Leader Espionage 1 3
If you want to select multiple columns by their whole names, you can use a Python list, like so:
df.cols.select(["name", "job"]).print()
This will return the name and job column data:
name job (object) (object) ---------- ---------- optimus Leader bumblebee Espionage eject 1 2 ...
