Module Import alias ImportFrom alias Import alias ImportFrom alias Assign NameStore Call NameLoad NameLoad Assign NameStore TupleLoad Str Str Str Str Str Assign NameStore TupleLoad Str Str Str Str Assign NameStore TupleLoad Str Str Str Str Assign NameStore Call AttributeLoad NameLoad attr Num Num Num Num Num Num Assign NameStore Call AttributeLoad NameLoad attr Num Num Num Assign NameStore Call AttributeLoad NameLoad attr Num Num Num FunctionDef arguments args NameParam NameParam NameParam defaults NameLoad NameLoad body Expr Str Assign NameStore AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore AttributeLoad AttributeLoad NameLoad attr attr For TupleStore NameStore NameStore Call NameLoad NameLoad body If BoolOpAnd CompareIsNot NameLoad NameLoad CompareIn Call NameLoad NameLoad NameLoad body Assign SubscriptStore NameLoad Index NameLoad Str If BoolOpOr UnaryOpNot NameLoad CompareEq NameLoad NameLoad body TryExcept body For TupleStore NameStore NameStore Call NameLoad NameLoad body If BoolOpAnd CompareNotEq NameLoad Str CompareIsNot NameLoad NameLoad body Raise Call NameLoad Str Return TupleLoad NameLoad BinOpMult ListLoad NameLoad Call NameLoad NameLoad handlers ExceptHandler type NameLoad body If NameLoad body Raise Call NameLoad NameLoad NameLoad NameLoad If BoolOpOr UnaryOpNot NameLoad CompareEq NameLoad NameLoad body TryExcept body Assign NameStore ListLoad Assign NameStore AttributeLoad NameLoad attr For TupleStore NameStore NameStore Call NameLoad NameLoad body If BoolOpOr CompareEq NameLoad Str CompareIs NameLoad NameLoad body Expr Call NameLoad NameLoad orelse If CompareIn Call AttributeLoad NameLoad attr NameLoad body Expr Call NameLoad NameLoad orelse If CompareIn Call AttributeLoad NameLoad attr NameLoad body Expr Call NameLoad NameLoad orelse Raise Call NameLoad Str Return TupleLoad NameLoad NameLoad handlers ExceptHandler type NameLoad body If NameLoad body Raise Call NameLoad NameLoad NameLoad NameLoad If BoolOpOr UnaryOpNot NameLoad CompareEq NameLoad NameLoad body TryExcept body Assign NameStore ListLoad Assign NameStore AttributeLoad NameLoad attr For TupleStore NameStore NameStore Call NameLoad NameLoad body If BoolOpOr CompareEq NameLoad Str CompareIs NameLoad NameLoad body Expr Call NameLoad NameLoad Continue Assign NameStore Call NameLoad Call NameLoad NameLoad Str Str If BoolOpAnd CompareEq SubscriptLoad NameLoad Index Num Str CompareNotEq Call NameLoad NameLoad Num body Raise Call NameLoad Str Expr Call NameLoad NameLoad Return TupleLoad NameLoad NameLoad handlers ExceptHandler type NameLoad body If CompareEq NameLoad NameLoad body Raise Call NameLoad NameLoad NameLoad NameLoad If NameLoad body Return TupleLoad AttributeLoad NameLoad attr ListComp IfExp CompareNotEq NameLoad Str NameLoad NameLoad comprehension NameStore NameLoad orelse Return TupleLoad AttributeLoad NameLoad attr NameLoad ExceptHandler type NameLoad body If NameLoad body Raise Call NameLoad NameLoad NameLoad NameLoad If BoolOpOr UnaryOpNot NameLoad CompareEq NameLoad NameLoad body TryExcept body Assign NameStore ListLoad Assign NameStore AttributeLoad NameLoad attr For TupleStore NameStore NameStore Call NameLoad NameLoad body If BoolOpOr CompareEq NameLoad Str CompareIs NameLoad NameLoad body Expr Call NameLoad NameLoad Continue Assign NameStore Call NameLoad Call NameLoad NameLoad Str Str Expr Call NameLoad NameLoad Return TupleLoad NameLoad NameLoad handlers ExceptHandler type NameLoad body If NameLoad body Raise Call NameLoad NameLoad NameLoad NameLoad If BoolOpOr UnaryOpNot NameLoad CompareIn NameLoad ListLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr body TryExcept body Assign NameStore ListLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call NameLoad Assign NameStore AttributeLoad NameLoad attr For TupleStore NameStore NameStore Call NameLoad NameLoad body If BoolOpOr CompareEq NameLoad Str CompareIs NameLoad NameLoad body Expr Call NameLoad NameLoad Expr Call NameLoad NameLoad Continue Assign NameStore Call NameLoad NameLoad keyword NameLoad If CompareEq Call AttributeLoad NameLoad attr NameLoad body If BoolOpAnd NameLoad CompareNotEq NameLoad AttributeLoad NameLoad attr body Raise Call NameLoad NameLoad NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr Expr Call NameLoad AttributeLoad NameLoad attr orelse If CompareEq Call AttributeLoad NameLoad attr NameLoad body If BoolOpAnd NameLoad CompareNotIn NameLoad ListLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Raise Call NameLoad NameLoad NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr Expr Call NameLoad AttributeLoad NameLoad attr orelse If BoolOpAnd NameLoad CompareNotEq NameLoad AttributeLoad NameLoad attr body Raise Call NameLoad NameLoad NameLoad NameLoad Expr Call NameLoad AttributeLoad NameLoad attr Expr Call NameLoad NameLoad If BoolOpAnd NameLoad CompareEq NameLoad Call NameLoad ListLoad NameLoad body Return TupleLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad If BoolOpOr CompareEq NameLoad Call NameLoad ListLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr BoolOpAnd CompareEq NameLoad Call NameLoad ListLoad AttributeLoad NameLoad attr CompareIs NameLoad AttributeLoad NameLoad attr body For TupleStore NameStore NameStore Call NameLoad NameLoad body If CompareEq AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Assign SubscriptStore NameLoad Index NameLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad If CompareIn AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr orelse If BoolOpOr CompareEq NameLoad Call NameLoad ListLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr BoolOpAnd CompareEq NameLoad Call NameLoad ListLoad AttributeLoad NameLoad attr CompareIs NameLoad AttributeLoad NameLoad attr body Raise Call NameLoad Str orelse If BoolOpOr CompareEq NameLoad Call NameLoad ListLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr BoolOpAnd CompareEq NameLoad Call NameLoad ListLoad AttributeLoad NameLoad attr CompareIs NameLoad AttributeLoad NameLoad attr BoolOpAnd CompareEq NameLoad Call NameLoad ListLoad AttributeLoad NameLoad attr CompareIs NameLoad AttributeLoad NameLoad attr body Raise Call NameLoad Str Return TupleLoad Call AttributeLoad NameLoad attr NameLoad handlers ExceptHandler type NameLoad body If NameLoad body Raise Call NameLoad NameLoad NameLoad NameLoad ExceptHandler type NameLoad body If NameLoad body Raise Call NameLoad NameLoad NameLoad NameLoad ExceptHandler type NameLoad body If NameLoad body Raise Call NameLoad NameLoad NameLoad NameLoad If NameLoad body Return TupleLoad AttributeLoad NameLoad attr ListComp IfExp CompareNotEq NameLoad Str NameLoad NameLoad comprehension NameStore NameLoad orelse Return TupleLoad AttributeLoad NameLoad attr NameLoad decorator_list
N/A N/A datetime dateutil.parser parse N/A six csvkit.exceptions InvalidValueForTypeException N/A NoneType N/A type None N/A NULL_VALUES N/A na n/a none null . N/A TRUE_VALUES N/A yes y true t N/A FALSE_VALUES N/A no n false f N/A DEFAULT_DATETIME N/A N/A datetime datetime 9999 12 31 0 0 0 N/A NULL_DATE N/A N/A datetime date 9999 12 31 N/A NULL_TIME N/A N/A datetime time 0 0 0 normalize_column_type N/A N/A l normal_type blanks_as_nulls N/A None True N/A N/A 
    Attempts to normalize a list (column) of string values to booleans, integers,
    floats, dates, times, datetimes, or strings. NAs and missing values are converted
    to empty strings. Empty strings are converted to nulls in the case of non-string
    types. For string types (unicode), empty strings are converted to nulls unless
    blanks_as_nulls is false.

    Optional accepts a "normal_type" argument which specifies a type that the values
    must conform to (rather than inferring). Will raise InvalidValueForTypeException
    if a value is not coercable.

    Returns a tuple of (type, normal_values).
     N/A lower N/A N/A six text_type lower N/A replace N/A N/A six text_type replace N/A N/A i x N/A enumerate l N/A N/A N/A N/A x None N/A N/A lower x NULL_VALUES N/A N/A N/A l N/A i N/A N/A N/A normal_type N/A normal_type NoneType N/A N/A N/A N/A N/A i x N/A enumerate l N/A N/A N/A N/A x N/A x None N/A N/A N/A ValueError Not null N/A N/A NoneType N/A N/A None N/A len l N/A N/A N/A ValueError N/A N/A normal_type N/A N/A N/A InvalidValueForTypeException i x normal_type N/A N/A N/A normal_type N/A normal_type bool N/A N/A N/A N/A normal_values N/A N/A append N/A normal_values append N/A N/A i x N/A enumerate l N/A N/A N/A N/A x N/A x None N/A N/A N/A append None N/A N/A N/A N/A N/A x lower TRUE_VALUES N/A N/A N/A append True N/A N/A N/A N/A N/A x lower FALSE_VALUES N/A N/A N/A append False N/A N/A N/A ValueError Not boolean N/A N/A bool normal_values N/A N/A N/A ValueError N/A N/A normal_type N/A N/A N/A InvalidValueForTypeException i x normal_type N/A N/A N/A normal_type N/A normal_type int N/A N/A N/A N/A normal_values N/A N/A append N/A normal_values append N/A N/A i x N/A enumerate l N/A N/A N/A N/A x N/A x None N/A N/A N/A append None N/A N/A int_x N/A int N/A replace x , N/A N/A N/A N/A x N/A 0 0 N/A N/A int x 0 N/A N/A N/A TypeError Integer is padded with 0s, so treat it as a string instead. N/A N/A append int_x N/A N/A int normal_values N/A N/A N/A TypeError N/A N/A N/A normal_type int N/A N/A N/A InvalidValueForTypeException i x int N/A blanks_as_nulls N/A N/A N/A N/A six text_type N/A N/A N/A x x None N/A x l N/A N/A N/A N/A six text_type l N/A N/A ValueError N/A N/A normal_type N/A N/A N/A InvalidValueForTypeException i x normal_type N/A N/A N/A normal_type N/A normal_type float N/A N/A N/A N/A normal_values N/A N/A append N/A normal_values append N/A N/A i x N/A enumerate l N/A N/A N/A N/A x N/A x None N/A N/A N/A append None N/A N/A float_x N/A float N/A replace x , N/A N/A append float_x N/A N/A float normal_values N/A N/A N/A ValueError N/A N/A normal_type N/A N/A N/A InvalidValueForTypeException i x normal_type N/A N/A N/A normal_type N/A normal_type N/A N/A datetime time N/A datetime date N/A datetime datetime N/A N/A N/A N/A normal_values N/A N/A append N/A normal_values append N/A normal_types_set N/A set N/A add N/A normal_types_set add N/A N/A i x N/A enumerate l N/A N/A N/A N/A x N/A x None N/A N/A N/A append None N/A N/A add NoneType N/A N/A d N/A parse x default DEFAULT_DATETIME N/A N/A N/A N/A d date NULL_DATE N/A N/A N/A normal_type N/A normal_type N/A datetime time N/A N/A N/A InvalidValueForTypeException i x normal_type N/A d N/A N/A d time N/A N/A add N/A datetime time N/A N/A N/A N/A N/A d time NULL_TIME N/A N/A N/A normal_type N/A normal_type N/A N/A datetime date N/A datetime datetime N/A N/A N/A InvalidValueForTypeException i x normal_type N/A d N/A N/A d date N/A N/A add N/A datetime date N/A N/A N/A normal_type N/A normal_type N/A datetime datetime N/A N/A N/A InvalidValueForTypeException i x normal_type N/A N/A add N/A datetime datetime N/A N/A append d N/A N/A normal_type N/A normal_types_set N/A set N/A NoneType N/A N/A N/A normal_type normal_values N/A N/A N/A normal_types_set discard NoneType N/A N/A N/A normal_types_set N/A set N/A N/A datetime datetime N/A datetime date N/A N/A normal_types_set N/A set N/A N/A datetime date N/A normal_type N/A datetime datetime N/A N/A N/A i v N/A enumerate normal_values N/A N/A N/A N/A v __class__ N/A datetime date N/A N/A N/A normal_values N/A i N/A N/A N/A datetime datetime combine v NULL_TIME N/A N/A N/A datetime datetime normal_types_set N/A N/A N/A N/A normal_types_set discard N/A datetime date N/A N/A N/A N/A normal_types_set N/A set N/A N/A datetime datetime N/A datetime time N/A N/A normal_types_set N/A set N/A N/A datetime time N/A normal_type N/A datetime datetime N/A N/A N/A ValueError Cant't coherently mix datetimes and times in a single column. N/A N/A N/A N/A normal_types_set N/A set N/A N/A datetime date N/A datetime time N/A N/A normal_types_set N/A set N/A N/A datetime time N/A normal_type N/A datetime date N/A N/A normal_types_set N/A set N/A N/A datetime date N/A normal_type N/A datetime time N/A N/A N/A ValueError Can't coherently mix dates and times in a single column. N/A N/A N/A N/A normal_types_set pop normal_values N/A N/A N/A ValueError N/A N/A normal_type N/A N/A N/A InvalidValueForTypeException i x normal_type N/A N/A OverflowError N/A N/A normal_type N/A N/A N/A InvalidValueForTypeException i x normal_type N/A N/A TypeError N/A N/A normal_type N/A N/A N/A InvalidValueForTypeException i x normal_type N/A blanks_as_nulls N/A N/A N/A N/A six text_type N/A N/A N/A x x None N/A x l N/A N/A N/A N/A six text_type l N/A