lirddlmZddlmZddlmZddlmZddlm Z ddl m Z ddd ejdfd Z y) ) OrderedDict)Decimal)utils)Number)Row) TypeTesterNpropertyvaluecddlm}|g}ntj|s|g}g}t }|j D]Wt fd|D} | |vr t || <t|} |} | |vr|j| | || | <Y|tjk(r5t|j|jtr td}nd}||z} g} g}|jD]\}} t!|t#|dk(r|j|dn|j||D],} | | vrj| | j|.| jt%| |Dcgc]*}|j&|j(j+|,}}|t|t,rX| t-n|}t/t1||}|j3|j4||_|j7| | }n|t!|z}|| | ||Scc}w)a Create a new table with row values converted into columns. For example: +---------+-----------+---------+ | name | property | value | +=========+===========+=========+ | Jane | gender | female | +---------+-----------+---------+ | Jane | race | black | +---------+-----------+---------+ | Jane | age | 24 | +---------+-----------+---------+ | ... | ... | ... | +---------+-----------+---------+ Can be denormalized so that each unique value in `field` becomes a column with `value` used for its values. +---------+----------+--------+-------+ | name | gender | race | age | +=========+==========+========+=======+ | Jane | female | black | 24 | +---------+----------+--------+-------+ | Jack | male | white | 35 | +---------+----------+--------+-------+ | Joe | male | black | 28 | +---------+----------+--------+-------+ If one or more keys are specified then the resulting table will automatically have :code:`row_names` set to those keys. This is the opposite of :meth:`.Table.normalize`. :param key: A column name or a sequence of column names that should be maintained as they are in the normalized table. Typically these are the tables unique identifiers and any metadata about them. Or, :code:`None` if there are no key columns. :param field_column: The column whose values should become column names in the new table. :param property_column: The column whose values should become the values of the property columns in the new table. :param default_value: Value to be used for missing values in the pivot table. If not specified :code:`Decimal(0)` will be used for aggregations that return :class:`.Number` data and :code:`None` will be used for all others. :param column_types: A sequence of column types with length equal to number of unique values in field_column or an instance of :class:`.TypeTester`. Defaults to a generic :class:`.TypeTester`. :returns: A new :class:`.Table`. r)TableNc3(K|] }| yw)N).0krows \/var/www/html/strategist-ai/venv_dbt/lib/python3.12/site-packages/agate/table/denormalize.py zdenormalize..Ps,1A,s) row_names) agate.tabler r issequencerrowstuplestrappenddefault isinstancecolumns data_typerritemslistlenr column_types column_namesindexrdictzipupdate_forcerun)selfkeyproperty_column value_column default_valuer#r field_namesrow_datarow_keyfvnew_column_namesnew_rowsrrnamekey_column_typestester force_updatenew_column_typesrs @r denormalizer< s@v" {   c "eK}Hyy !,,, ( " + HW  O$ %   K    q ! ! ! % dll<0::F C#AJM M[(HI 411g q6Q;   QqT "   Q  *AAv 1Q4  =)  * C!1234 VYYT))$*;*;*A*A$*GHYYz, C!-!5<C%567 FMM*$ !::h0@A+d<.@@ +-= SSZs/I) collectionsrdecimalragateragate.data_typesr agate.rowsragate.type_testerrrr<rrrDs3##( `e`m`m!zTrC