a J5d !@sf dZddlmZddlmZddlmZddlZddlZddlZddl Z ej dkr`ddl m Z n ddlm Z ej ddkrdd l mZdd lmZedZeZeZeZeZeZeZd d ZnPdd l m Zddlm!Z!mZedZeZeZeZeZeZe"ZeZ#ddl$Z$dd Zz ddl%Z%Wne&y0dZ%Yn0zddl'm(Z)Wn e&ybddl*m(Z)Yn0gdZ+dZ,dZ-dZ.dZ/dZ0dZ1e%duZ2edgdZ3edgdZ4edgdZ5ddZ6d d!Z7d"d#Z8d$d%Z9d&d'Z:d(d)Z;dd*d+Ze>fd;d<Z?d=d>Z@e5e3dd?d@de3dd?d@dde3dd?d@de4dd@de4dd@dddAdBgde5dddde4dd@de4dd@dddde5e3dCd?dCdCe3dCdDdCdCe3dCd?dCdCe3dCd?dCdCe4dEdEdEe4dEdEdEdFdde5e3dGdHdIdJe3dKdHdLdMe3dNdOdPdQe3dRdHdSdTe4dUdUdUe4dUdUdUdFdde5e3dGdHdIdJe3dKdHdLdMde3dRdHdSdTe4dUdUdUe4dUdUdUdFdde5e3dEd?dEdEe3dEd?dEdEdde4dEdEdEe4dEdEdEdFdAgde5e7e7dde4dEdEdEe4dEdEdEdFdAgde5de3dEd?dCdEdde4dEdEdEe4dEdEdEdFdde5dddde4dVdVdVe4dEdEdEdFdde5de3dd?dCddde4ddEde4ddEddFdde5e3dCd?dCdCe3dCd?dCdCde3dCd?dCdCe4dEdEdEe4dEdEdEdFdde5e3dCd?dCdCe3dEd?dCdEde3dCd?dCdCe4dEdEdEe4dEdEdEdFdde5e3ddDd@de3ddDd@dde3ddDd@de4dd@de4dd@dddde5e3dWdddXe3dYddde3dYddde3dZdddee8d[ee8dEddde5ddddeez*_pipe_line_with_colons..|)lenzipjoin) colwidths colalignssegmentsr r r_pipe_line_with_colonssrBcs@dddddfddt||D}|d}|||S)Nrzalign="right"| zalign="center"| r2r,r1r-cs(g|] \}}d|d|dqS) rgetr7cr8 alignmentr rr9sz-_mediawiki_row_with_attrs..r)r=r>rstrip) separator cell_valuesr?r@values_with_attrsZcolsepr rIr_mediawiki_row_with_attrss rOcsH|dd7<dddddfddt||D}d d |d S) NrrDz<.z>.z=.rCc3s"|]\}}|d|VqdS)rNrE)r7r8vrIr r r:z*_textile_row_with_attrs..r;r=r>)rMr?r@valuesr rIr_textile_row_with_attrssrTcCsdS)Nzr )Zcolwidths_ignoreZcolaligns_ignorer r r _html_begin_table_without_headersrUcsrddddd|r.fddt||D}nfddt||D}dd|}d krnd |}|S) Nrz style="text-align: right;"z style="text-align: center;"rCc s&g|]\}}d|d|qSz<{0}{1}>{2}rformatrFrGrJcelltagr rr9sz(_html_row_with_attrs..c s*g|]"\}}d|dt|qSrV)rXrF htmlescaperGrYr rr9sz {}thz#
{} )r=rXr>rK)rZunsaferMr?r@rNZrowhtmlr rYr_html_row_with_attrss    r^cs8dddddfddt||D}d|dS)NrzzrCc s.g|]&\}}d|d|qS)z {0}{1} {2} rrWrGrJrZheaderr rr9sz(_moin_row_with_attrs..||rR)rZrMr?r@r`rNr r_r_moin_row_with_attrssrbcsLddddddfdd|D}d|s2d nd |d |rDd nd gS)NlrrHrCrcsg|]}|dqS)rcrE)r7r8rIr rr9r:z-_latex_line_begin_tabular.. z\begin{tabular}{z\begin{longtable}{}z\toprule\hline)r>)r?r@booktabs longtableZtabular_columns_fmtr rIr_latex_line_begin_tabulars  rjz\&z\%z\$z\#z\_z\^{}z\{z\}z\textasciitilde{}z\textbackslash{}z\ensuremath{<}z\ensuremath{>}) &%$#_^{rf~\<>cs4fddfdd|D}tddd}t||S)Ncs ||SrrE)rHescrulesr r escape_charsz_latex_row..escape_charcsg|]}dt|qS)r)r>mapr7cell)rxr rr9r:z_latex_row..rrkz\\)r"_build_simple_row)rMr?r@rwZescaped_valuesrowfmtr )rxrwr _latex_rows  r~cCs`dd}t|}g}|r(||d|d<|D]*}t|}|rL||d|d<||q,||fS)NcSs"t|ttfr|sdS|SdS)Nz..)r _text_type _binary_typestripvalr r r escape_emptysz._rst_escape_first_column..escape_emptyr)listappend)rowsheadersr new_headersZnew_rowsrownew_rowr r r_rst_escape_first_columns rr.z r$r'+=r;r/u╒u═u╤u╕u╞u╪u╡u├u─u┼u┤u╘u╧u╛u│raz.{| class="wikitable" style="text-align: left;"z |+ |-z|-z|}!z''')r`z|| z || z| z | z |z
r\tdTrgz\hline \end{tabular}rv)rhz\midrulez\bottomrule \end{tabular})riz\hline \endheadz\hline \end{longtable} z|_. z|_.)simpleplaingrid fancy_gridZ fancy_outlineZgithubpipeorgtbljiraprestoprettypsqlrstZ mediawikiZmoinmoinZyoutrackhtmlZ unsafehtmllatexZ latex_rawZlatex_booktabsZlatex_longtableZtsvZtextilerrrrrrrrrrr) rrrrrrrrrrrz \r|\n|\r\ns | | z:\x1b\[\d+[;\d]*m|\x1b\[\d*\;\d*\;\d*m|\x1b\]8;;(.*?)\x1b\\s3\[\d+\[;\d]*m|\[\d*;\d*;\d*m|\x1b\]8;;(.*?)\x1b\\z;\x1B]8;[a-zA-Z0-9:]*;[^\x1B]+\x1B\\([^\x1b]+)\x1B]8;;\x1B\\zz>^(([+-]?[0-9]{1,3})(?:,([0-9]{3}))*)?(?(1)\.[0-9]*|\.[0-9]+)?$c Cs(tddddtd|dtd|ddddS)zConstruct a simple TableFormat with columns separated by a separator. >>> tsv = simple_separated_format("\t") ; tabulate([["foo", 1], ["spam", 23]], tablefmt=tsv) == 'foo \t 1\nspam\t23' True Nrr)r(r)r*r+)r#r")rLr r rrCs  rc Cs4z |}Wnttfy"Yn0ttt|S)a >>> _isnumber_with_thousands_separator(".") False >>> _isnumber_with_thousands_separator("1") True >>> _isnumber_with_thousands_separator("1.") True >>> _isnumber_with_thousands_separator(".1") True >>> _isnumber_with_thousands_separator("1000") False >>> _isnumber_with_thousands_separator("1,000") True >>> _isnumber_with_thousands_separator("1,0000") False >>> _isnumber_with_thousands_separator("1,000.1234") True >>> _isnumber_with_thousands_separator(b"1,000.1234") True >>> _isnumber_with_thousands_separator("+1,000.1234") True >>> _isnumber_with_thousands_separator("-1,000.1234") True )decodeUnicodeDecodeErrorAttributeErrorboolrematch _float_with_thousands_separatorsstringr r r"_isnumber_with_thousands_separatorWs  rc Cs,z||WdSttfy&YdS0dS)NTF) ValueError TypeError)convrr r r_isconvertiblexs rcCsHtt|sdSt|ttfrDtt|s8tt|rD|dvSdS)z >>> _isnumber("123.45") True >>> _isnumber("123") True >>> _isnumber("spam") False >>> _isnumber("123e45678") False >>> _isnumber("inf") True F)infz-infnanT) rfloatrrrmathisinfisnanlowerrr r r _isnumbers    rcCs*t||up(t|ts t|to(t||S)zG >>> _isint("123") True >>> _isint("123.45") False )typerrrr)rZinttyper r r_isints rcCs"t|tup t|ttfo |dvS)zc >>> _isbool(True) True >>> _isbool("False") True >>> _isbool(1) False )TrueFalse)r _bool_typerrrrr r r_isbools rcCs|r t|tst|tr t|}|dur,tSt|dr:tSt|rFtSt|rV|rVt St|t rh|rht St |rx|rxt St|trtStSdS)a%The least generic type (type(None), int, float, str, unicode). >>> _type(None) is type(None) True >>> _type("foo") is type("") True >>> _type("1") is type(1) True >>> _type('42') is type(42) True >>> _type('42') is type(42) True N isoformat) rrr_strip_invisible _none_typer rrrint _long_typerr)r has_invisiblenumparser r r_types*    rcCsft|st|r^t|rdS|d}|dkr<|dn|}|dkrXt||dSdSndSdS)aSymbols after a decimal point, -1 if the string lacks the decimal point. >>> _afterpoint("123.45") 2 >>> _afterpoint("1001") -1 >>> _afterpoint("eggs") -1 >>> _afterpoint("123e45") 2 >>> _afterpoint("123,456.78") 2 .rer/N)rrrrfindrr<)rposr r r _afterpoints rcCsd|}||S)uLFlush right. >>> _padleft(6, 'яйца') == ' яйца' True z{0:>%ds}rXwidthsfmtr r r_padleftsrcCsd|}||S)uLFlush left. >>> _padright(6, 'яйца') == 'яйца ' True z{0:<%ds}rrr r r _padrightsrcCsd|}||S)uNCenter string. >>> _padboth(6, 'яйца') == ' яйца ' True z{0:^%ds}rrr r r_padboth srcCs|Srr )Z ignore_widthrr r r_padnonesrcCs8t|tr&ttd|}ttd|Sttd|SdS)zRemove invisible ANSI color codes. >>> str(_strip_invisible('\x1B]8;;https://example.com\x1B\\This is a link\x1B]8;;\x1B\\')) 'This is a link' z\1rN)rrrsub_invisible_codes_link_invisible_codes_invisible_codes_bytes)rZ links_removedr r rrs rcCsHtdurtrtj}nt}t|ts,t|tr8|t|S|t|SdS)zVisible width of a printed string. ANSI color codes are removed. >>> _visible_width('hello'), _visible_width("world") (5, 5) N)wcwidthWIDE_CHARS_MODEwcswidthr<rrrr)rZlen_fnr r r_visible_width)s   rcCs.t|trttt|Sttt|SdSr)rrrrsearch_multiline_codes_multiline_codes_bytesrr r r _is_multiline;s rcCstt|td|Sz1Visible width of a potentially multiline content.[ ])maxryrsplitZ multiline_s line_width_fnr r r_multiline_widthBsrcs4|r tn|rtjnt|r,fdd}n}|S)z2Return a function to calculate visible cell width.cs t|Sr)rrrr rPr:z"_choose_width_fn..rrrr<renable_widechars is_multilinewidth_fnr rr_choose_width_fnGsrcs|dkr tsdd|D}t}n|dkr@ts:dd|D}t}np|dkr|r\dd|D}ndd|D}t|fd dt||D}t}n |st}ntsd d|D}t}||fS) Nr,cSsg|] }|qSr rr7rr r rr9Yr:z._align_column_choose_padfn..r1cSsg|] }|qSr rrr r rr9]r:r-cSsg|]}tt|qSr )rrrr r rr9ar:cSsg|] }t|qSr )rrr r rr9cr:cs g|]\}}||dqSrDr )r7rZdecsZ maxdecimalsr rr9er:cSsg|] }|qSr rrr r rr9kr:)PRESERVE_WHITESPACErrrr=rr)stringsrJrpadfnZdecimalsr rr_align_column_choose_padfnVs*rcs4|r tn|rtjnt|r,fdd}n}|S)Ncs t|Sr)_align_column_multiline_widthrrr rrxr:z/_align_column_choose_width_fn..rrr rr_align_column_choose_width_fnpsrcCstt|td|Sr)rryrrrr r rr~srcCs<g}|D].}t|tr,|D]}||qq||q|Sr)rrr)Z nested_listretitemsubitemr r r _flat_lists  rc st|||\}t|||}tt||}ttt|||r|s^|s^fdd|D}qdd|D} fddt|| D} fddt|| D}n\|s|sfdd|D}n>ttt|} fddt|| D} fddt|| D}|S) ztring] -> [padded_string]cs*g|]"}dfdd|DqS)recsg|]}|qSr r rmaxwidthrr rr9r:,_align_column...)r> splitlinesr7msrr rr9sz!_align_column..cSs"g|]}ddtd|DqS)cSsg|] }t|qSr r<rr r rr9r:rr)rrrr r rr9r:cs(g|] \}}fddt||DqS)csg|]\}}||qSr r r7r5rcrr rr9r:r)r=)r7mwmlrr rr9scs6g|].\}}dfddt|p&||DqS)recsg|]\}}||qSr r r7rr5rr rr9r:r)r>r=r)r7rrrr rr9scsg|]}|qSr r rrr rr9r:csg|]\}}||qSr r rrr rr9r:csg|]\}}||qSr r rrr rr9r:)rrrryrrr=r<) rrJZminwidthrrrrZs_widthsZpadded_stringsZs_lensZvisible_widthsr rr _align_columns0    r c CsPtdtdtdtdtdtdi}ttttttd}t||d||d}||S)Nrr/rr)r r rrr/r)rrrrrrrrF)Ztype1Ztype2typesZinvtypesZ moregenericr r r _more_generics  r cs fdd|D}tt|tS)u]The least generic type all column values are convertible to. >>> _column_type([True, False]) is _bool_type True >>> _column_type(["1", "2"]) is _int_type True >>> _column_type(["1", "2.3"]) is _float_type True >>> _column_type(["1", "2.3", "four"]) is _text_type True >>> _column_type(["four", 'пять']) is _text_type True >>> _column_type([None, "brux"]) is _text_type True >>> _column_type([1, 2, None]) is _int_type True >>> import datetime as dt >>> _column_type([dt.datetime(1991,2,19), dt.time(17,35)]) is _text_type True csg|]}t|qSr )rrrrr rr9r:z _column_type..)rr r)rrrr r rr _column_typesrcCs|dur |S|ttfvr"d|S|turTz t|dWStyPt|YS0nZ|tur|olt|ttf}|rt|}tt||}|||Stt||Sn d|SdS)uFormat a value according to its type. Unicode is supported: >>> hrow = ['буква', 'цифра'] ; tbl = [['аз', 2], ['буки', 4]] ; good_result = '\u0431\u0443\u043a\u0432\u0430 \u0446\u0438\u0444\u0440\u0430\n------- -------\n\u0430\u0437 2\n\u0431\u0443\u043a\u0438 4' ; tabulate(tbl, headers=hrow) == good_result True N{0}ascii) rrrXrrrrrreplace)rZvaltypefloatfmt missingvalrZis_a_colored_numberZraw_valZ formatted_valr r r_formats&      rc s|r0tt|}fdd|D}d|St||}|7dkrVt|Sdkrht|Ssvd|St|SdS)zIPad string header to width chars given known visible_width of the header.csg|]}t||qSr  _align_headerr7hrJrrr rr9sz!_align_header..rer2r1rN) rrrr>r<rrrXr) r`rJrZ visible_widthrrZ header_linesZ padded_linesZ ninvisibler rrrs      rcCsX|dus|dur|St|t|kr@td|td|tdddt||D}|S)zAdd a left-most index column.NFzindex=zrows=z0index must be as long as the number of data rowscSsg|]\}}|gt|qSr r)r7rPrr r rr91r:z&_prepend_row_index..)r<printrr=)rindexr r r_prepend_row_index)s  rcCs$z t|WStyYdS0dS)zDA wrapper around standard bool() which doesn't throw on NumPy arraysFN)rrrr r r_bool5s  rc sztd}Wnty.d}tYn0d}t|drt|drt|jdrr|tt|}nt|drt||dvr|jjdurt |jjtr|jjdd <n|jjgdd <|j}t|j}d d |D}ntd dkrztt t nlt|}dkr.|s.gnLdkr^t|d r^t |j dr^|j jndkrt|d krt |d trt|d drtt t |d jnt|d krt|d drt|d drt}gdkr.t|d kr|d ni||dd}|D]4}|D]$} | |vr>| || q>q2dkrxn|t trfdd Dtt t nNdkrt|d krfdd Dtt t ngnrtdfdd |D}nrdkrHt|drHt|drHt|drHdd |jDn2dkrzt|d krztt t tt|d dkrt|d kr|dur|d gt|d |dd}n|d tt t |dd}tt t tt t|}t|t tfv} |dkr.|dur.t||}n|t |trP| sPt|t|}nZ|dksjt|r| s|durttt|}t||}n|dkst|s| srt|d krt} t|d } | | krdg| | |fS)aTransform a supported data type to a list of lists, and a list of headers. Supported tabular data types: * list-of-lists or another iterable of iterables * list of named tuples (usually used with headers="keys") * list of dicts (usually used with headers="keys") * list of OrderedDicts (usually used with headers="keys") * 2D NumPy arrays * NumPy record arrays (usually used with headers="keys") * dict of iterables (usually used with headers="keys") * pandas.DataFrame (usually used with headers="keys") The first row can be used as headers if headers="firstrow", column indices can be used as headers if headers="keys". If showindex="default", show row indices of the pandas.DataFrame. If showindex="always", show row indices for all types of data. If showindex="never", don't show row indices for all types of data. If showindex is an iterable, show its values as row indices. FTNkeysrS__call__r)ralwaysTrcSsg|] }t|qSr rr7rr r rr9zr:z+_normalize_tabular_data..z7tabular data doesn't appear to be a dict or a DataFramedtypenames_fieldsfirstrowr/csg|]}||qSr rEr7k)rr rr9r:csg|]}||qSr rEr() firstdictr rr9r:z6headers for a list of dicts is not a dict or a keywordcsg|]fddDqS)csg|]}|qSr rEr(rr rr9r:z6_normalize_tabular_data...r r7)r r+rr9r: descriptionZfetchoneZrowcountcSsg|] }|dqS)rr )r7columnr r rr9r:rr"neverr)rrrr rSr rrnamerryrgetattrr$r%r<tupler&setextendupdateradddictr-rangerrrrr) tabular_datar showindexZis_headers2bool_brokenrrvalsZ uniq_keysrr)Zshowindex_is_a_strZnhsZncolsr )r*rr r_normalize_tabular_data=s            .                r<c Cst|t|dd}g}|D]z}g}t|||D]Z\}}}t|rR|rR||q0|durt|d} | |} |d| q0||q0||q|S)NrT)rre)_expand_iterabler<r=rr_CustomTextWrapwrapr>) list_of_listsr? numparsesresultrrr{rrwrapperwrappedr r r_wrap_text_to_colwidthss      rEr c s|dur g}t|||d\} }| durnt| d} t| trJt| | | } n t| | d} t|| } t| | | d} |dkrt| |\} }t|dkrdd}t krdnt krdnn t krd nt krd nd d t t |gd d | D}t t|st t|tduo*tt|ts^|tvr^t|r^t||}dndttt| }t|t|} dd t|| D}t|trt||g}n6t|}t|t|kr|t|t|tgt|tr t||g}n6t|}t|t|kr@|t|t|tgfdd t||||D}fdd |D}| durt| tsJt | D]\}}|||<q|rfdd |Dn dgt|}fdd t|||D}|r^|pdggt|}|pgt|}fdd t||D}fdd t|||D}tt|}nfdd |D}tt|}t|tst!|t!d}t"|||||S)u,Format a fixed width table for pretty printing. >>> print(tabulate([[1, 2.34], [-56, "8.999"], ["2", "10001"]])) --- --------- 1 2.34 -56 8.999 2 10001 --- --------- The first required argument (`tabular_data`) can be a list-of-lists (or another iterable of iterables), a list of named tuples, a dictionary of iterables, an iterable of dictionaries, a two-dimensional NumPy array, NumPy record array, or a Pandas' dataframe. Table headers ------------- To print nice column headers, supply the second argument (`headers`): - `headers` can be an explicit list of column headers - if `headers="firstrow"`, then the first row of data is used - if `headers="keys"`, then dictionary keys or column indices are used Otherwise a headerless table is produced. If the number of headers is less than the number of columns, they are supposed to be names of the last columns. This is consistent with the plain-text format of R and Pandas' dataframes. >>> print(tabulate([["sex","age"],["Alice","F",24],["Bob","M",19]], ... headers="firstrow")) sex age ----- ----- ----- Alice F 24 Bob M 19 By default, pandas.DataFrame data have an additional column called row index. To add a similar column to all other types of data, use `showindex="always"` or `showindex=True`. To suppress row indices for all types of data, pass `showindex="never" or `showindex=False`. To add a custom row index column, pass `showindex=some_iterable`. >>> print(tabulate([["F",24],["M",19]], showindex="always")) - - -- 0 F 24 1 M 19 - - -- Column alignment ---------------- `tabulate` tries to detect column types automatically, and aligns the values properly. By default it aligns decimal points of the numbers (or flushes integer numbers to the right), and flushes everything else to the left. Possible column alignments (`numalign`, `stralign`) are: "right", "center", "left", "decimal" (only for `numalign`), and None (to disable alignment). Table formats ------------- `floatfmt` is a format specification used for columns which contain numeric data with a decimal point. This can also be a list or tuple of format strings, one per column. `None` values are replaced with a `missingval` string (like `floatfmt`, this can also be a list of values for different columns): >>> print(tabulate([["spam", 1, None], ... ["eggs", 42, 3.14], ... ["other", None, 2.7]], missingval="?")) ----- -- ---- spam 1 ? eggs 42 3.14 other ? 2.7 ----- -- ---- Various plain-text table formats (`tablefmt`) are supported: 'plain', 'simple', 'grid', 'pipe', 'orgtbl', 'rst', 'mediawiki', 'latex', 'latex_raw', 'latex_booktabs', 'latex_longtable' and tsv. Variable `tabulate_formats`contains the list of currently supported formats. "plain" format doesn't use any pseudographics to draw tables, it separates columns with a double space: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], ... ["strings", "numbers"], "plain")) strings numbers spam 41.9999 eggs 451 >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], tablefmt="plain")) spam 41.9999 eggs 451 "simple" format is like Pandoc simple_tables: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], ... ["strings", "numbers"], "simple")) strings numbers --------- --------- spam 41.9999 eggs 451 >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], tablefmt="simple")) ---- -------- spam 41.9999 eggs 451 ---- -------- "grid" is similar to tables produced by Emacs table.el package or Pandoc grid_tables: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], ... ["strings", "numbers"], "grid")) +-----------+-----------+ | strings | numbers | +===========+===========+ | spam | 41.9999 | +-----------+-----------+ | eggs | 451 | +-----------+-----------+ >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], tablefmt="grid")) +------+----------+ | spam | 41.9999 | +------+----------+ | eggs | 451 | +------+----------+ "fancy_grid" draws a grid using box-drawing characters: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], ... ["strings", "numbers"], "fancy_grid")) ╒═══════════╤═══════════╕ │ strings │ numbers │ ╞═══════════╪═══════════╡ │ spam │ 41.9999 │ ├───────────┼───────────┤ │ eggs │ 451 │ ╘═══════════╧═══════════╛ "pipe" is like tables in PHP Markdown Extra extension or Pandoc pipe_tables: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], ... ["strings", "numbers"], "pipe")) | strings | numbers | |:----------|----------:| | spam | 41.9999 | | eggs | 451 | "presto" is like tables produce by the Presto CLI: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], ... ["strings", "numbers"], "presto")) strings | numbers -----------+----------- spam | 41.9999 eggs | 451 >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], tablefmt="pipe")) |:-----|---------:| | spam | 41.9999 | | eggs | 451 | "orgtbl" is like tables in Emacs org-mode and orgtbl-mode. They are slightly different from "pipe" format by not using colons to define column alignment, and using a "+" sign to indicate line intersections: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], ... ["strings", "numbers"], "orgtbl")) | strings | numbers | |-----------+-----------| | spam | 41.9999 | | eggs | 451 | >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], tablefmt="orgtbl")) | spam | 41.9999 | | eggs | 451 | "rst" is like a simple table format from reStructuredText; please note that reStructuredText accepts also "grid" tables: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], ... ["strings", "numbers"], "rst")) ========= ========= strings numbers ========= ========= spam 41.9999 eggs 451 ========= ========= >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], tablefmt="rst")) ==== ======== spam 41.9999 eggs 451 ==== ======== "mediawiki" produces a table markup used in Wikipedia and on other MediaWiki-based sites: >>> print(tabulate([["strings", "numbers"], ["spam", 41.9999], ["eggs", "451.0"]], ... headers="firstrow", tablefmt="mediawiki")) {| class="wikitable" style="text-align: left;" |+ |- ! strings !! align="right"| numbers |- | spam || align="right"| 41.9999 |- | eggs || align="right"| 451 |} "html" produces HTML markup as an html.escape'd str with a ._repr_html_ method so that Jupyter Lab and Notebook display the HTML and a .str property so that the raw HTML remains accessible the unsafehtml table format can be used if an unescaped HTML format is required: >>> print(tabulate([["strings", "numbers"], ["spam", 41.9999], ["eggs", "451.0"]], ... headers="firstrow", tablefmt="html"))
strings numbers
spam 41.9999
eggs 451
"latex" produces a tabular environment of LaTeX document markup: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], tablefmt="latex")) \begin{tabular}{lr} \hline spam & 41.9999 \\ eggs & 451 \\ \hline \end{tabular} "latex_raw" is similar to "latex", but doesn't escape special characters, such as backslash and underscore, so LaTeX commands may embedded into cells' values: >>> print(tabulate([["spam$_9$", 41.9999], ["\\emph{eggs}", "451.0"]], tablefmt="latex_raw")) \begin{tabular}{lr} \hline spam$_9$ & 41.9999 \\ \emph{eggs} & 451 \\ \hline \end{tabular} "latex_booktabs" produces a tabular environment of LaTeX document markup using the booktabs.sty package: >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], tablefmt="latex_booktabs")) \begin{tabular}{lr} \toprule spam & 41.9999 \\ eggs & 451 \\ \bottomrule \end{tabular} "latex_longtable" produces a tabular environment that can stretch along multiple pages, using the longtable package for LaTeX. >>> print(tabulate([["spam", 41.9999], ["eggs", "451.0"]], tablefmt="latex_longtable")) \begin{longtable}{lr} \hline spam & 41.9999 \\ eggs & 451 \\ \hline \end{longtable} Number parsing -------------- By default, anything which can be parsed as a number is a number. This ensures numbers represented as strings are aligned properly. This can lead to weird results for particular strings such as specific git SHAs e.g. "42992e1" will be parsed into the number 429920 and aligned as such. To completely disable number parsing (and alignment), use `disable_numparse=True`. For more fine grained control, a list column indices is used to disable number parsing only on those columns e.g. `disable_numparse=[0, 2]` would disable number parsing only on the first and third columns. Column Widths and Auto Line Wrapping ------------------------------------ Tabulate will, by default, set the width of each column to the length of the longest element in that column. However, in situations where fields are expected to reasonably be too long to look good as a single line, tabulate can help automate word wrapping long fields for you. Use the parameter `maxcolwidth` to provide a list of maximal column widths >>> print(tabulate( [('1', 'John Smith', 'This is a rather long description that might look better if it is wrapped a bit')], headers=("Issue Id", "Author", "Description"), maxcolwidths=[None, None, 30], tablefmt="grid" )) +------------+------------+-------------------------------+ | Issue Id | Author | Description | +============+============+===============================+ | 1 | John Smith | This is a rather long | | | | description that might look | | | | better if it is wrapped a bit | +------------+------------+-------------------------------+ N)r:r)rArrTr1r-r2rcSsg|]}dtt|qS)r)r>ryrr#r r rr9yr:ztabulate..FcSsg|]\}}t||dqS))r)r)r7colnpr r rr9r:cs,g|]$\}fdd|DqS)csg|]}t|qSr )r)r7rP)ctfl_fmtrmiss_vr rr9r:z'tabulate...r r7rH)r)rHrIrJrr9s cs g|]}|ttfvrnqSr )rr)r7rH)numalignstralignr rr9r:csg|]}|qSr r r) min_paddingrr rr9r:c s$g|]\}}}t|||qSr )r )r7rHr8minw)rrrr rr9srcs,g|]$\}}t|tfdd|DqS)c3s|]}|VqdSrr r7clrr rrQr:&tabulate...r)r7rOrHrRr rr9sc s(g|] \}}}t||||qSr r)r7rr8rO)rrr rr9scs"g|]}tfdd|DqS)c3s|]}|VqdSrr rPrRr rrQr:rSrTrKrRr rr9r:r)#r<r<rrr=_expand_numparserEr MIN_PADDING_DEFAULT_ALIGNr>ryrrrrrrrr#multiline_formatsrrFrrrr= basestringr4_DEFAULT_FLOATFMT_DEFAULT_MISSINGVALr enumerate_table_formats _format_table)r9rtablefmtrrLrMrr:disable_numparsecolalignZ maxcolwidthsr@Znum_colsrA plain_textcolsZcoltypesZ float_formatsZ missing_valsZalignsidxr3Z minwidthsZt_colsZt_alignsrr )rrrrNrLrMrrrsR                 &      rcCs:t|tr*dg|}|D] }d||<q|S| g|SdS)aB Return a list of bools of length `column_count` which indicates whether number parsing should be used on each column. If `disable_numparse` is a list of indices, each of those indices are False, and everything else is True. If `disable_numparse` is a bool, then the returned list is all the same. TFN)rr)r` column_countrArr r rrUs    rUcCs.t|tr ||g|t|S|g|SdS)aY Expands the `original` argument to return a return a list of length `num_desired`. If `original` is shorter than `num_desired`, it will be padded with the value in `default`. If `original` is not a list to begin with (i.e. scalar value) a list of length `num_desired` completely populated with `default will be returned N)rrr<)originalZ num_desiredrr r rr=s r=cs*|r"d|fdd|D}|S|SdS)NrDcsg|]}|qSr r rzpadr rr9r:z_pad_row..r )cellsr* padded_cellsr rgr_pad_rows rkcCs |\}}}||||S)z7Format row according to DataRow format without padding.)r>rK)rjr}rr r!r r rr|s r|cCs,|sdSt|dr||||St||SdS)z5Return a string which represents a row of data cells.Nr!r r|)rjr?r@r}r r r _build_rows   rmcCs|t|||||Sr)rrm)linesrjr?r@r}r r r_append_basic_rowsroc sfdd|D}dd|Dtttfddt|DfddtD}|D]}t|} t|| |||q`|S)Ncsg|]}|dqSrr r7r5rgr rr9r:z)_append_multiline_row..cSsg|] }|qSr )rrKr r rr9r:cs*g|]"\}}|d|gt|qSrr)r7rQr5)nlinesr rr9 scsg|]fddDqS)csg|] }|qSr r rPir rr9r:z4_append_multiline_row...r r,) cells_linesrsrr9r:)rryr<r=r8rkro) rnZpadded_multiline_cells padded_widthsr@r}rhr?Z lines_cellslnZ padded_lnr )rurrrhr_append_multiline_rows  rxcsN|sdSt|dr|||S|\}}}fdd|D}t||||fSdS)z3Return a string which represents a horizontal line.Nr!csg|] }|qSr r rqfillr rr9r:z_build_line..rl)r?r@linefmtrr r!rir ryr _build_lines   r|cCs|t||||Sr)rr|)rnr?r@r{r r r _append_line!sr}c@s$eZdZdZddZeddZdS)JupyterHTMLStrzUWrap the string with a _repr_html_ method so that Jupyter displays the HTML tablecCs|Srr selfr r r _repr_html_*szJupyterHTMLStr._repr_html_cCs|S)z>add a .str property so that the raw string is still accessibler rr r rstr-szJupyterHTMLStr.strN)__name__ __module__ __qualname____doc__rpropertyrr r r rr~&sr~csg}|r|jr|jng}|j|j}fdd|D} |rPddttd} ntt} |} fdd|D} |jrd|vrt|| ||j| r| || | |||j rd|vrt|| ||j | r*|j r*d |vr*| d d D]&} | || | ||j t|| ||j q| || d | ||j n| D]} | || | ||j q.|j rjd |vrjt|| ||j |sv|rd |}|jtkrt|S|SndSd S)z1Produce a plain-text representation of the table.csg|]}|dqSrpr rqrgr rr9:r:z!_format_table..cSs|Srr )rror r rr<r:z_format_table..rgcsg|]}|qSr r r#rhZpad_rowr rr9Cr:r$r%r&Nrr'rer)r+r*r(rrxrkror$r}r%r&r)r'r>rUr~)rrrr?r@rrnZhiddenr(rvZ append_rowZpadded_headersZ padded_rowsroutputr rrr^3sB    r^c@s<eZdZdZddZeddZddZdd Zd d Z d S) r>a[A custom implementation of CPython's textwrap.TextWrapper. This supports both wide characters (Korea, Japanese, Chinese) - including mixed string. For the most part, the `_handle_long_word` and `_wrap_chunks` functions were copy pasted out of the CPython baseline, and updated with our custom length and line appending logic. cOs*g|_d|_tjj|g|Ri|dSr) _active_codes max_linestextwrap TextWrapper__init__)rargskwargsr r rrmsz_CustomTextWrap.__init__cCs"t|}trt|St|SdS)zqCustom len that gets console column width for wide and non-wide characters as well as ignores color codesN)rrrr<)rstrippedr r r_lenrs z_CustomTextWrap._lencCs~ddtt|D}dd|D}d|j|}|D] }|tkrR|j|q8g|_q8t|jdkrp|t}||dS)aAdds a new line to the list of lines the text is being wrapped into This function will also track any ANSI color codes in this string as well as add any colors from previous lines order to preserve the same formatting as a single unwrapped string. cSsg|]}|qSr r )r7xr r rr9r:z1_CustomTextWrap._update_lines..cSs*g|]"}|j|d|dqS)rr/)rspan)r7coder r rr9srrN)rfinditerrr>r_ansi_color_reset_coderr<)rrnnew_lineZ code_matchesZ color_codesrr r r _update_lines|sz_CustomTextWrap._update_linescCs|dkrd}n||}|jrt|d}d}||d||krH|d}q(||d|d||dd|d<n|s||dS)a _handle_long_word(chunks : [string], cur_line : [string], cur_len : int, width : int) Handle a chunk of text (most likely a word, not whitespace) that is too long to fit in any line. r/rN)break_long_wordsrrpop)rreversed_chunkscur_linecur_lenr space_leftchunkrtr r r_handle_long_words  z!_CustomTextWrap._handle_long_wordc Csg}|jdkrtd|j|jdurf|jdkr8|j}n|j}||||j|jkrftd||rg}d}|r|j}n|j}|j||}|j r|d dkr|r|d=|r||d}|||kr| | ||7}qqq|r2||d|kr2| ||||tt|j|}|j rj|rj|d dkrj|||d8}|d=|rn|jdust|d|jks|r|j rt|dkr|d s||kr|||d|qn|rF|d r*|||j|kr*| |j|||d|q|||d8}|d=q|r|d}||||j|jkr||j|d<q||||jqqn|S)a_wrap_chunks(chunks : [string]) -> [string] Wrap a sequence of text chunks and return a list of lines of length 'self.width' or less. (If 'break_long_words' is false, some lines may be longer than this.) Chunks correspond roughly to words and the whitespace between them: each chunk is indivisible (modulo 'break_long_words'), but a line break can come between any two chunks. Chunks should not have internal whitespace; ie. a chunk is either all whitespace or a "word". Whitespace chunks will be removed from the beginning and end of lines, but apart from that whitespace is preserved. rzinvalid width %r (must be > 0)Nr/z#placeholder too large for max widthrr)rrrsubsequent_indentinitial_indentr placeholderlstripreversedrop_whitespacerrrrsumryr<rr>rK) rchunksrnindentrrrZ chunk_len prev_liner r r _wrap_chunkss                z_CustomTextWrap._wrap_chunksN) rrrrr staticmethodrrrrr r r rr>es &r>c Csddl}ddl}ddl}|tj}z$||jdddgd\}}Wn@|jy}z&t|t|| dWYd}~n d}~00g}t }d} d} d} d } |D]\} }| d vrd }q| d vr|} q| d vr|}q| dvr| } q| dvr"|t vrtd|t|| d|} q| dvr2|} q| dvrt|| dq|s\|j gn|}| d krp|jnt| d}|D]x}|d kr|j }t|rt||| | ||| dn@t|&}t||| | ||| dWdn1s0YqWdn1s0YdS)a Usage: tabulate [options] [FILE ...] Pretty-print tabular data. See also https://github.com/astanin/python-tabulate FILE a filename of the file with tabular data; if "-" or missing, read data from stdin. Options: -h, --help show this message -1, --header use the first row of data as a table header -o FILE, --output FILE print table to FILE (default: stdout) -s REGEXP, --sep REGEXP use a custom column separator (default: whitespace) -F FPFMT, --float FPFMT floating point number format (default: g) -f FMT, --format FMT set output table format; supported formats: plain, simple, grid, fancy_grid, pipe, orgtbl, rst, mediawiki, html, latex, latex_raw, latex_booktabs, latex_longtable, tsv (default: simple) rNr/z h1o:s:F:A:f:)helpr`rzsep=zfloat=zalign=zformat=rrz\s+r.)z-1z--headerr')z-oz--output)z-Fz--float)z-Cz --colalign)z-fz--formatz"%s is not a supported table formatr)z-sz--sep)z-hz--helpr5)rr_r rfilera)getoptsysrdedent_mainrargv GetoptErrorrexitrZrrstdinstdoutopenr _pprint_file)rrrusageoptsrrrrrar_r outfileoptvaluefilesoutr Zfobjr r rr-s               rc s8|}fdd|D}tt|||||d|ddS)Ncs$g|]}|rt|qSr )rrrrK)r7rdr r rr9r:z _pprint_file..)rra)r) readlinesrr) Zfobjectrr_r rrrartabler rrrs r__main__)r)FF)TT)rTFF)TT)rT)FN)r)T)r __future__rr collectionsrrrrr version_infocollections.abcr itertoolsr functoolsrrrrrrZ _int_typelongrrZ _float_typeunicoderrrrrrbytesrYrr ImportErrorrrr[cgi__all__ __version__rVrrZr[rWrrr"r#r6rBrOrTrUr^rbrjZLATEX_ESCAPE_RULESr~rr]rsortedr rrXcompilerrrrrrrrrrrrrrrrrrrrrrr<rrrrrrr r rrrrrr<rErrUr=rkr|rmrorxr|r}r~r^rr>rrrr r r rsJ           "                                                                                                          z  !  '      1  %   -  J    2I\