cartoframes.utils module

general utility functions

cartoframes.utils.cssify(css_dict)

Function to get CartoCSS from Python dicts

cartoframes.utils.df2pg_schema(dataframe, pgcolnames)

Print column names with PostgreSQL schema for the SELECT statement of a SQL query

cartoframes.utils.dict_items(indict)

function for iterating through dict items compatible with py2 and 3

Parameters:indict (dict) – Dictionary that will be turned into items iterator

cartoframes.utils.dtypes2pg(dtype)

Returns equivalent PostgreSQL type for input dtype

cartoframes.utils.importify_params(param_arg)

Convert parameter arguments to what CARTO’s Import API expects

cartoframes.utils.join_url(*parts)

join parts of URL into complete url

cartoframes.utils.minify_sql(lines)

eliminate whitespace in sql queries

cartoframes.utils.norm_colname(colname)

Given an arbitrary column name, translate to a SQL-normalized column name a la CARTO’s Import API will translate to

Examples

• ‘Field: 2’ -> ‘field_2’
• ‘2 Items’ -> ‘_2_items’

Parameters:colname (str) – Column name that will be SQL normalized Returns:SQL-normalized column name Return type:str

cartoframes.utils.normalize_colnames(columns)

SQL-normalize columns in dataframe to reflect changes made through CARTO’s SQL API.

Parameters:columns (list of str) – List of column names Returns:Normalized column names Return type:list of str

cartoframes.utils.pg2dtypes(pgtype)

Returns equivalent dtype for input pgtype.

cartoframes.utils.pgquote(string)

single-quotes a string if not None, else returns null

cartoframes.utils.safe_quotes(text, escape_single_quotes=False)

htmlify string

cartoframes.utils.temp_ignore_warnings(func)

Temporarily ignores warnings like those emitted by the carto python sdk

cartoframes.utils.unique_colname(suggested, existing)

Given a suggested column name and a list of existing names, returns a name that is not present at existing by prepending _ characters.