li 0ddlmZddlmZddlmZddZy))utils)Row) TypeTesterNc ddlm}g}tj|s|g}tj|s|g}|||gz}g} |jD]t fd|D} t | } t| dk(r| j| dn| j| |D]%} |jt| | | gz|'|D cgc]*} |j|jj| ,}} |t|trX| tn|}tt!||}|j#|j$||_|j'||}n|t |z}||||Scc} w)a. Create a new table with columns converted into rows values. For example: +---------+----------+--------+-------+ | name | gender | race | age | +=========+==========+========+=======+ | Jane | female | black | 24 | +---------+----------+--------+-------+ | Jack | male | white | 35 | +---------+----------+--------+-------+ | Joe | male | black | 28 | +---------+----------+--------+-------+ can be normalized on columns 'gender', 'race' and 'age': +---------+-----------+---------+ | name | property | value | +=========+===========+=========+ | Jane | gender | female | +---------+-----------+---------+ | Jane | race | black | +---------+-----------+---------+ | Jane | age | 24 | +---------+-----------+---------+ | ... | ... | ... | +---------+-----------+---------+ This is the opposite of :meth:`.Table.denormalize`. :param key: A column name or a sequence of column names that should be maintained as they are in the normalized self. Typically these are the tables unique identifiers and any metadata about them. :param properties: A column name or a sequence of column names that should be converted to properties in the new self. :param property_column: The name to use for the column containing the property names. :param value_column: The name to use for the column containing the property values. :param column_types: A sequence of two column types for the property and value column in that order or an instance of :class:`.TypeTester`. Defaults to a generic :class:`.TypeTester`. :returns: A new :class:`.Table`. r)Tablec3(K|] }| yw)N).0nrows Z/var/www/html/strategist-ai/venv_dbt/lib/python3.12/site-packages/agate/table/normalize.py znormalize..Gs&Q#a&&s) agate.tablerr issequence_rowstuplelistlenappendr _column_types _column_namesindex isinstancerdictzipupdate_forcerun)selfkey propertiesproperty_column value_column column_typesrnew_rowsnew_column_names row_nameskleft_rowfnamekey_column_typestester force_updatenew_column_typesr s @r normalizer1sd"H   C e   J ' \ o|<<Izz M &#& &7 q6Q;   QqT "   Q  MA OOCQAK!7:JK L M MX[[t**4+=+=+C+CD+IJ[[z, C!-!5<C%567 FMM*$ !::h0@A+d<.@@ +-= >>\s/F)propertyvalueN)agater agate.rowsragate.type_testerrr1r r r8s(X?r7