o ضY@sdZddlmZddlmZddlmZddlmZmZdZ dZ dZ d Z d Z d Zd ZGd ddeZGdddeZGdddeZddZd$ddZd$ddZGdddeZGdddeZGdddeZGd d!d!eZGd"d#d#eZdS)%z tablib.core ~~~~~~~~~~~ This module implements the central Tablib objects. :copyright: (c) 2016 by Kenneth Reitz. :license: MIT, see LICENSE for more details. )copy) itemgetter)formats) OrderedDictunicodetablibz0.12.1iz Kenneth ReitzMITzCopyright 2017 Kenneth Reitzrestructuredtextc@seZdZdZddgZeefddZddZdd Zd d Z d d Z ddZ ddZ ddZ ddZddZddZddZddZddZd d!Zed"d#Zed$d%Zd&d'Zd(S))Rowz/Internal Row object. Mainly used for filtering._rowtagscCst||_t||_dSN)listr r selfrowr r=/var/www/html/env/lib/python3.10/site-packages/tablib/core.py__init__"s z Row.__init__cCsdd|jDS)Ncss|]}|VqdSr r).0colrrr 'szRow.__iter__..r rrrr__iter__&z Row.__iter__cC t|jSr )lenr rrrr__len__) z Row.__len__cCrr )reprr rrrr__repr__,rz Row.__repr__cCs|j||Sr r)rijrrr __getslice__/zRow.__getslice__cCs |j|Sr rrr"rrr __getitem__2rzRow.__getitem__cCs||j|<dSr r)rr"valuerrr __setitem__5r%zRow.__setitem__cCs |j|=dSr rr&rrr __delitem__8s zRow.__delitem__cCs(t}|jD] }t||}|||<q|Sr )dict __slots__getattr)rslotsslot attributerrr __getstate__;s    zRow.__getstate__cCs&t|D] \}}t|||qdSr )ritemssetattr)rstatekvrrr __setstate__Es&zRow.__setstate__cCs|d|dS)Nrinsertrr(rrrrpushHrz Row.rpushcCs|t||dSr )r9rr:rrrlpushKsz Row.lpushcCs||dSr r;r:rrrappendNr%z Row.appendcCs|j||dSr )r r9)rindexr(rrrr9Qsz Row.insertcCs ||jvSr r)ritemrrr __contains__TrzRow.__contains__cCr)z%Tuple representation of :class:`Row`.)tupler rrrrrBW z Row.tuplecCr)z$List representation of :class:`Row`.)rr rrrrr\rCzRow.listcCs:|dkrdSt|tr||jvSttt|t|j@S)z)Returns true if current row contains tag.NF) isinstancestrr boolrset)rtagrrrhas_tagas   z Row.has_tagN)__name__ __module__ __qualname____doc__r,rrrrr!r$r'r)r*r1r7r;r<r>r9rApropertyrBrIrrrrr s.    r c@sLeZdZdZiZddZddZddZdd Zd d Z d d Z ddZ ddZ e ddZdtddZduddZddZddZeeeZdd Zd!d"ZeeeZd#d$Zed%d&Zed'd(Zdvd)d*Zd+d,Zed-d.Zed/d0Zed1d2Zed3d4Z ed5d6Z!ed7d8Z"ed9d:Z#ed;d<Z$ed=d>Z%ed?d@Z&edAdBZ'e(fdCdDZ)e(fdEdFZ*e(fdGdHZ+e(fdIdJZ,e(fdKdLZ-dMdNZ.dOdPZ/dQdRZ0dwdSdTZ1dvdUdVZ2dvdWdXZ3dxdZd[Z4dxd\d]Z5dvd^d_Z6d`daZ7dbdcZ8dddeZ9dydfdgZ:dhdiZ;djdkZdpdqZ?dwdrdsZ@dS)zDatasetaThe :class:`Dataset` object is the heart of Tablib. It provides all core functionality. Usually you create a :class:`Dataset` instance in your main module, and append rows as you collect data. :: data = tablib.Dataset() data.headers = ('name', 'age') for (name, age) in some_collector(): data.append((name, age)) Setting columns is similar. The column data length must equal the current height of the data and headers must be set :: data = tablib.Dataset() data.headers = ('first_name', 'last_name') data.append(('John', 'Adams')) data.append(('George', 'Washington')) data.append_col((90, 67), header='age') You can also set rows and headers upon instantiation. This is useful if dealing with dozens or hundreds of :class:`Dataset` objects. :: headers = ('first_name', 'last_name') data = [('John', 'Adams'), ('George', 'Washington')] data = tablib.Dataset(*data, headers=headers) :param \*args: (optional) list of rows to populate Dataset :param headers: (optional) list strings for Dataset header row :param title: (optional) string to use as title of the Dataset .. admonition:: Format Attributes Definition If you look at the code, the various output/import formats are not defined within the :class:`Dataset` object. To add support for a new format, see :ref:`Adding New Formats `. cOsJtdd|D|_d|_g|_g|_|d|_|d|_|dS)Ncss|]}t|VqdSr r )rargrrrrz#Dataset.__init__..headerstitle) r_data_Dataset__headers _separators _formattersgetrSrT_register_formats)rargskwargsrrrrs   zDataset.__init__cC|jSr )heightrrrrrzDataset.__len__csjt|ts t|tr!||jvr|j|fdd|jDSt|j|}t|tr.|jSdd|DS)Ncg|]}|qSrrrrposrr z'Dataset.__getitem__..cSsg|]}|jqSr)rB)rresultrrrrds) rDrErrSr?rUKeyErrorr rB)rkey_resultsrrbrr's    zDataset.__getitem__cCs||t||j|<dSr ) _validater rU)rrhr(rrrr)s zDataset.__setitem__cCsjt|ts t|tr/||jvr-|j|}|j|=t|jD] \}}||=||j|<qdSt|j|=dSr )rDrErrSr? enumeraterUrg)rrhrcr"rrrrr*s    zDataset.__delitem__cC&zd|jWStyYdSw)Nz <%s dataset>zrTlowerAttributeErrorrrrrr!  zDataset.__repr__csg}|jr|dd|jD|dd|jDdd|D}tttt|}|jr9|ddd|Dd d dt |Dd fd d|DS) NcSg|]}t|qSr)r)rhrrrrdrez'Dataset.__unicode__..css|] }ttt|VqdSr )rmaprrarrrrz&Dataset.__unicode__..cSsg|] }ttt|qSr)rrsrrarrrrdcSsg|]}d|qS-r)rlengthrrrrdre|css|]}d|VqdS)z{%s:%s}Nr)rr@rrrrrR c3s|]}j|VqdSr )formatra format_stringrrrs) rVr>extendrUrrsmaxzipr9joinrk)rrflens field_lensrr}r __unicode__szDataset.__unicode__cC|Sr )rrrrr__str__szDataset.__str__c CstjD]f}zUz,t||jt|j|jt|d|j|jt|d|j|j|j|jf|j|j<Wn&tyXt||jt|jt|d|j|j|jdf|j|j<YnwWqtyid|j|j<YqwdS)Adds format properties.zget_%szset_%sNNN) r availabler3rTrN export_set import_set_formatsroclsfmtrrrrZs"   zDataset._register_formatsNFcsz|rjr t|jknd}n$|r't|dkrd}njr$t|jknd}n tfddjD}|r7dS|s;tdS)z>Assures size of every row in dataset is of proper proportions.Trvc3s|] }t|jkVqdSr )rwidth)rxrrrrrtz$Dataset._validate..F)rrr^allrUInvalidDimensions)rrrsafetyis_validrrrrjs zDataset._validateTc stj}|r tntjrKt|D]7\}}jD]/\}}z"|dur5t|D] \}} || |||<q'n ||||||<WqtyItwqjrh|r\fdd|D} | Stjgt|} | Sdd|D} | S)z=Packages Dataset into lists of dictionaries for transmission.Ncs g|] }ttj|qSr)rrrS)rdata_row dict_packrrrrd=s z$Dataset._package..cSrqr)rrarrrrdAre) rrUrr+rXrk IndexErrorInvalidDatasetIndexrS) rdictsorderedrUrow_irrcallbackr#cdatarrr_package"s4   zDataset._packagecCr])zAn *optional* list of strings to be used for header rows and attribute names. This must be set manually. The given list length must equal :class:`Dataset.width`. )rVrrrr _get_headersGszDataset._get_headerscCs<|||rzt||_WdStytwd|_dS)zValidating headers setter.N)rjrrV TypeError)r collectionrrr _set_headersPs   zDataset._set_headerscCr)aA native Python representation of the :class:`Dataset` object. If headers have been set, a list of Python dictionaries will be returned. If no headers have been set, a list of tuples (rows) will be returned instead. A dataset object can also be imported by setting the `Dataset.dict` attribute: :: data = tablib.Dataset() data.dict = [{'age': 90, 'first_name': 'Kenneth', 'last_name': 'Reitz'}] )rrrrr _get_dict^s zDataset._get_dictcCst|sdSt|dtr||D] }|t|qdSt|dtrE|t|d|_|D] }|tt| q5dSt )aA native Python representation of the Dataset object. If headers have been set, a list of Python dictionaries will be returned. If no headers have been set, a list of tuples (rows) will be returned instead. A dataset object can also be imported by setting the :class:`Dataset.dict` attribute. :: data = tablib.Dataset() data.dict = [{'age': 90, 'first_name': 'Kenneth', 'last_name': 'Reitz'}] Nr) rrDrwiper>r r+keysrSvaluesUnsupportedFormat)rpicklerrrr _set_dictls zDataset._set_dictcCs^t|}|jr|dg}ng}t|dkr't|ddr'tt|d|j}t||}|S)z,Prepares the given column for insert/append.rrv__call__)rrSpoprhasattrrsrUrBrrheaderrrr _clean_cols zDataset._clean_colcCr)zfThe number of rows currently in the :class:`Dataset`. Cannot be directly modified. )rrUrrrrr^s zDataset.heightc CsHzt|jdWSty#zt|jWYSty"YYdSww)ziThe number of columns currently in the :class:`Dataset`. Cannot be directly modified. r)rrUrrSrrrrrrs  z Dataset.widthcKsF|st|}|j|d\}}|std||||fi||S)z Import `in_stream` to the :class:`Dataset` object using the `format`. :param \*\*kwargs: (optional) custom configuration to the format `import_set`. rzFormat {0} cannot be imported. detect_formatrrYrr|)r in_streamr|r\rrrrrloadz Dataset.loadcK4|j|d\}}|std|||fi|S)z Export :class:`Dataset` object to `format`. :param \*\*kwargs: (optional) custom configuration to the format `export_set`. rFormat {0} cannot be exported.rrYrr|)rr|r\rrrrrexportzDataset.exportcCdS)aA Legacy Excel Spreadsheet representation of the :class:`Dataset` object, with :ref:`separators`. Cannot be set. .. note:: XLS files are limited to a maximum of 65,000 rows. Use :class:`Dataset.xlsx` to avoid this limitation. .. admonition:: Binary Warning :class:`Dataset.xls` contains binary data, so make sure to write in binary mode:: with open('output.xls', 'wb') as f: f.write(data.xls) Nrrrrrxlssz Dataset.xlscCr)a_An Excel '07+ Spreadsheet representation of the :class:`Dataset` object, with :ref:`separators`. Cannot be set. .. admonition:: Binary Warning :class:`Dataset.xlsx` contains binary data, so make sure to write in binary mode:: with open('output.xlsx', 'wb') as f: f.write(data.xlsx) Nrrrrrxlsx z Dataset.xlsxcCr)a^An OpenDocument Spreadsheet representation of the :class:`Dataset` object, with :ref:`separators`. Cannot be set. .. admonition:: Binary Warning :class:`Dataset.ods` contains binary data, so make sure to write in binary mode:: with open('output.ods', 'wb') as f: f.write(data.ods) Nrrrrrodsrz Dataset.odscCr)acA CSV representation of the :class:`Dataset` object. The top row will contain headers, if they have been set. Otherwise, the top row will contain the first row of the dataset. A dataset object can also be imported by setting the :class:`Dataset.csv` attribute. :: data = tablib.Dataset() data.csv = 'age, first_name, last_name\n90, John, Adams' Import assumes (for now) that headers exist. .. admonition:: Binary Warning :class:`Dataset.csv` uses \r\n line endings by default, so make sure to write in binary mode:: with open('output.csv', 'wb') as f: f.write(data.csv) If you do not do this, and you export the file on Windows, your CSV file will open in Excel with a blank line between each row. Nrrrrrcsvsz Dataset.csvcCr)aA TSV representation of the :class:`Dataset` object. The top row will contain headers, if they have been set. Otherwise, the top row will contain the first row of the dataset. A dataset object can also be imported by setting the :class:`Dataset.tsv` attribute. :: data = tablib.Dataset() data.tsv = 'age first_name last_name\n90 John Adams' Import assumes (for now) that headers exist. Nrrrrrtsv z Dataset.tsvcCr)aA YAML representation of the :class:`Dataset` object. If headers have been set, a YAML list of objects will be returned. If no headers have been set, a YAML list of lists (rows) will be returned instead. A dataset object can also be imported by setting the :class:`Dataset.yaml` attribute: :: data = tablib.Dataset() data.yaml = '- {age: 90, first_name: John, last_name: Adams}' Import assumes (for now) that headers exist. Nrrrrryaml.rz Dataset.yamlcCr)a4A DataFrame representation of the :class:`Dataset` object. A dataset object can also be imported by setting the :class:`Dataset.df` attribute: :: data = tablib.Dataset() data.df = DataFrame(np.random.randn(6,4)) Import assumes (for now) that headers exist. Nrrrrrdf=rz Dataset.dfcCr)aA JSON representation of the :class:`Dataset` object. If headers have been set, a JSON list of objects will be returned. If no headers have been set, a JSON list of lists (rows) will be returned instead. A dataset object can also be imported by setting the :class:`Dataset.json` attribute: :: data = tablib.Dataset() data.json = '[{"age": 90, "first_name": "John", "last_name": "Adams"}]' Import assumes (for now) that headers exist. NrrrrrjsonJrz Dataset.jsoncCr)zA HTML table representation of the :class:`Dataset` object. If headers have been set, they will be used as table headers. ..notice:: This method can be used for export only. NrrrrrhtmlYz Dataset.htmlcCr)aA dBASE representation of the :class:`Dataset` object. A dataset object can also be imported by setting the :class:`Dataset.dbf` attribute. :: # To import data from an existing DBF file: data = tablib.Dataset() data.dbf = open('existing_table.dbf').read() # to import data from an ASCII-encoded bytestring: data = tablib.Dataset() data.dbf = '' .. admonition:: Binary Warning :class:`Dataset.dbf` contains binary data, so make sure to write in binary mode:: with open('output.dbf', 'wb') as f: f.write(data.dbf) Nrrrrrdbfbsz Dataset.dbfcCr)zA LaTeX booktabs representation of the :class:`Dataset` object. If a title has been set, it will be exported as the table caption. .. note:: This method can be used for export only. Nrrrrrlatex{rz Dataset.latexcCs$|||j|t||ddS)zInserts a row to the :class:`Dataset` at the given index. Rows inserted must be the correct size (height or width). The default behaviour is to insert the given row to the :class:`Dataset` object at the given index. )r N)rjrUr9r )rr?rr rrrr9s zDataset.insertcC|j|j||ddS)zyAdds a row to the end of the :class:`Dataset`. See :class:`Dataset.insert` for additional documentation. rr N)r9r^rrrrr;z Dataset.rpushcC|jd||ddS)zyAdds a row to the top of the :class:`Dataset`. See :class:`Dataset.insert` for additional documentation. rrNr8rrrrr<z Dataset.lpushcC|||dS)znAdds a row to the :class:`Dataset`. See :class:`Dataset.insert` for additional documentation. Nr=rrrrr>zDataset.appendcCs|D]}|||qdS)zZAdds a list of rows to the :class:`Dataset` using :class:`Dataset.append` N)r>)rrowsr rrrrrszDataset.extendcC|d}|d=|S)z:Removes and returns the first row of the :class:`Dataset`.rrrcacherrrlpopz Dataset.lpopcCr)9Removes and returns the last row of the :class:`Dataset`.rrrrrrpoprz Dataset.rpopcCr)r)rrrrrrsz Dataset.popcCs|durg}t|drtt||j}||}|j|d|jr:|s&t|r3|jdkr3t |r3t |j |||jrY|j rYt |jD]\}}| |||||j|<qEdSdd|D|_dS)aInserts a column to the :class:`Dataset` at the given index. Columns inserted must be the correct height. You can also insert a column of a single callable object, which will add a new column with the return values of the callable each as an item in the column. :: data.append_col(col=random.randint) If inserting a column, and :class:`Dataset.headers` is set, the header attribute must be set, and will be considered the header for that row. See :ref:`dyncols` for an in-depth example. .. versionchanged:: 0.9.0 If inserting a column, and :class:`Dataset.headers` is set, the header attribute must be set, and will be considered the header for that row. .. versionadded:: 0.9.0 If inserting a row, you can add :ref:`tags ` to the row you are inserting. This gives you the ability to :class:`filter ` your :class:`Dataset` later. NrrrcSsg|]}t|gqSrrPrarrrrd sz&Dataset.insert_col..)rrrsrUrrjrS HeadersNeededr^rrr9rrk)rr?rrr"rrrr insert_cols$     zDataset.insert_colcCr)z|Adds a column to the end of the :class:`Dataset`. See :class:`Dataset.insert` for additional documentation. rN)rrrrrr rpush_colrzDataset.rpush_colcCr)z|Adds a column to the top of the :class:`Dataset`. See :class:`Dataset.insert` for additional documentation. rrN)rrrrr lpush_colrzDataset.lpush_colrxcCs||f}|j|dS)z4Adds a separator to :class:`Dataset` at given index.N)rWr>)rr?textseprrrinsert_separator szDataset.insert_separatorcCs<|js |jr |jnd}n |jr|jdnd}|||dS)z=Adds a :ref:`separator ` to the :class:`Dataset`.rrvN)rSr^r)rrr?rrrappend_separator'szDataset.append_separatorcCr)zuAdds a column to the :class:`Dataset`. See :class:`Dataset.insert_col` for additional documentation. N)rrrrr append_col3rzDataset.append_colcsfdd|jDS)z@Returns the column from the :class:`Dataset` at the given index.cr`rrrar?rrrd>rez#Dataset.get_col..)rU)rr?rrrget_col;szDataset.get_colcCsHt|tr||jvr|j|}nt||jks"|j||fdSt)aAdds a :ref:`formatter` to the :class:`Dataset`. .. versionadded:: 0.9.5 :param col: column to. Accepts index int or header str. :param handler: reference to callback function to execute against each cell value. T) rDrErSr?rgrrXr>r)rrhandlerrrr add_formatterEs  zDataset.add_formattercs"t|}fdd|jD|_|S)zReturns a new instance of the :class:`Dataset`, excluding any rows that do not contain the given :ref:`tags `. csg|] }|r|qSr)rIrarHrrrdaruz"Dataset.filter..)rrU)rrH_dsetrrrfilter\szDataset.filtercst|ts t|tr8|jstt|jt||d}t|j|j d}|D]fdd|jD}|j |dq#|S|jr@|j|}t|jt||d}t|j|j d}|D]|jrdfdd|jD}n}|j |dqT|S)aSort a :class:`Dataset` by a specific column, given string (for header) or integer (for column index). The order can be reversed by setting ``reverse`` to ``True``. Returns a new :class:`Dataset` instance where columns have been sorted. )rhreverse)rSrTcg|]}|qSrrrrhr@rrrdxrez Dataset.sort..rcrrrrrrrrdre) rDrErrSrsortedr+rrOrTr>)rrr_sortedrrrrrsortfs&  z Dataset.sortcCsz|sdSt}|jdg||jd}||_t|jD]\}}||jdkr(q|g||}t|}|j|dq|S)zTranspose a :class:`Dataset`, turning rows into columns and vice versa, returning a new ``Dataset`` instance. The first row of the original instance becomes the new header row.Nrr)rOrSrkrr r>)rr new_headersr?columnrow_datarrr transposeszDataset.transposecCsZt|tsdS|j|jkrtt|}dd|jD}dd|jD}||||_|S)zStack two :class:`Dataset` instances together by joining at the row level, and return new combined ``Dataset`` instance.NcSg|]}|qSrrrarrrrdz!Dataset.stack..cSrrrrarrrrdr)rDrOrrrrUr)rotherr rows_to_stack other_rowsrrrstacks   z Dataset.stackcCst|tsdS|js |jr|jr|jst|j|jkrtz|j|j}Wn ty0d}Ynwt}|jD] }|j||dq7|jD] }|j||dqE||_|S)zStack two :class:`Dataset` instances together by joining at the column level, and return a new combined ``Dataset`` instance. If either ``Dataset`` has headers set, than the other must as well.Nr)rDrOrSrr^rrr)rrrrrrrr stack_colss&       zDataset.stack_colscs(tfdd|jD|jdd<dS)ziRemoves all duplicate rows from the :class:`Dataset` object while maintaining the original order.cs*g|]}t|vst|s|qSr)rBaddraseenrrrds*z-Dataset.remove_duplicates..N)rGrUrrrrremove_duplicatess"zDataset.remove_duplicatescCst|_d|_dS)zARemoves all content and headers from the :class:`Dataset` object.N)rrUrVrrrrrs z Dataset.wipec ssdS|durttj}|durtj}fdd|D}fdd|D}t}t||_g|_tjD],\}}g}|jD]}|jvrXj|}|||qCt ||vrf|jt |dq:|S)zkReturns a new instance of the :class:`Dataset`, including only specified rows and columns. Ncsg|] }|tjvr|qSr)ranger^rarrrrdsz"Dataset.subset..csg|] }|jvr|qSr)rS)rrrrrrdrur) rrr^rSrOrUrkr?r>rgr ) rrcolsrrow_norrrhrcrrrsubsets,     zDataset.subset)NNF)TTr rrw)F)ArJrKrLrMrrrr'r)r*r!rr classmethodrZrjrrrrNrSrrr+rr^rrrrrrrrrrrrrrrr9r;r<r>rrrrrrrrrrrrrrrrrrrr rrrrrOns.   %                     >      '"rOc@speZdZdZiZdddZddZddZed d Z d d Z d dZ dddZ e ddZddZddZdS)Databookz(A book of :class:`Dataset` objects. NcCs$|dur t|_n||_|dSr )r _datasetsrZ)rsetsrrrrs  zDatabook.__init__cCrl)Nz <%s databook>zrmrrrrr!(rpzDatabook.__repr__cCs g|_dS)z@Removes all :class:`Dataset` objects from the :class:`Databook`.Nr rrrrr.s z Databook.wipec CstjD]H}z7zt||jt|j|j|j|jf|j|j<Wnty:t||jt|j|jdf|j|j<YnwWqtyKd|j|j<YqwdS)rNr) rrr3rTrN export_book import_bookrrorrrrrZ3s   zDatabook._register_formatscCr]r rrrrrsheetsBr_zDatabook.sheetscCst|tr |j|dSt)z5Adds given :class:`Dataset` to the :class:`Databook`.N)rDrOr r>InvalidDatasetType)rdatasetrrr add_sheetEs zDatabook.add_sheetTcCs>g}|rt}nt}|jD]}|||j|j|ddq |S)z(Packages :class:`Databook` for delivery.)r)rTr)rr+r r>rTr)rr collectorrdsetrrrrMs   zDatabook._packagecCr)zDThe number of the :class:`Dataset` objects within :class:`Databook`.)rr rrrrsize^rCz Databook.sizecKsF|st|}|j|d\}}|std||||fi||S)z Import `in_stream` to the :class:`Databook` object using the `format`. :param \*\*kwargs: (optional) custom configuration to the format `import_book`. rzFormat {0} cannot be loaded.r)rr|rr\rrrrrrcrz Databook.loadcKr)z Export :class:`Databook` object to `format`. :param \*\*kwargs: (optional) custom configuration to the format `export_book`. rrr)rr|r\rrrrrrtrzDatabook.exportr )T)rJrKrLrMrrr!rr rZrrrrNrrrrrrrr s      r c Cs<tjD]}z ||r|jWSWqtyYqwdS)z#Return format name of given stream.N)rrdetectrTro)streamrrrrrs    rNcKtj||fi|SzReturn dataset of given stream.)rOrrr|r\rrrrrcKrr)r rrrrrrrrc@eZdZdZdS)rz(Only Datasets can be added to a DataBookNrJrKrLrMrrrrrrc@r)rz Invalid sizeNrrrrrrr rc@r)rzOutside of Dataset sizeNrrrrrrr rc@r)rzGHeader parameter must be given when appending a column in this Dataset.Nrrrrrrr rc@r)rzFormat is not supportedNrrrrrrr rr )rMroperatorrrr tablib.compatrr __title__ __version__ __build__ __author__ __license__ __copyright__ __docformat__objectr rOr rrr ExceptionrrrrNotImplementedErrorrrrrrs<  Q2h