SQLArgument[arg1, arg2, ...] holds a sequence of arguments to an SQL query.
SQLDateTime[datetime] represents date and time information that can be stored in a database.
SQLDelete[conn, table] deletes the data in a table in an SQL connection.SQLDelete[conn, table, cond] deletes data that matches cond.
SQLInsert[conn, table, cols, data] inserts data into a table in an SQL connection.
SQLMemberQ[data, column] specifies a condition in an SQL query used to test whether an element of a list matches the value of a column.
SQLStringMatchQ[col, patt] specifies a condition in an SQL query used to test whether the value of a column matches a pattern. The actual format for the pattern varies from ...
RectangleChart[{{x_1, y_1}, {x_2, y_2}, ...}] makes a rectangle chart with bars of width x_i and height y_i. RectangleChart[{..., w_i[{x_i, y_i}, ...], ..., w_j[{x_i, y_j}, ...
s_1 ~~ s_2 ~~ ... or StringExpression[s_1, s_2, ...] represents a sequence of strings and symbolic string objects s_i.
When summarizing data, it is often useful to analyze it by subgroup. For example, crop yields could be categorized by seed variety, or average patient recovery time by ...
In data analysis, it is often necessary to clean a dataset before analyzing it. Data points with missing entries or that contain invalid values must be removed or replaced by ...