Module Expr Str ImportFrom alias ImportFrom alias alias alias ImportFrom alias ImportFrom alias ImportFrom alias alias alias alias ImportFrom alias alias alias alias ImportFrom alias alias ImportFrom alias alias alias alias ImportFrom alias alias alias FunctionDef arguments args NameParam NameParam defaults body If Call NameLoad NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr NameLoad orelse If BoolOpAnd Call NameLoad NameLoad NameLoad Call NameLoad SubscriptLoad NameLoad Index Num NameLoad body Assign NameStore ListComp Call AttributeLoad NameLoad attr NameLoad comprehension NameStore NameLoad orelse Return NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Dict Assign NameStore ListLoad For NameStore NameLoad body If CompareIn NameLoad NameLoad body Assign SubscriptStore NameLoad Index NameLoad BinOpAdd SubscriptLoad NameLoad Index NameLoad Num Expr Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad NameLoad SubscriptLoad NameLoad Index NameLoad orelse Assign SubscriptStore NameLoad Index NameLoad Num Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Return NameLoad decorator_list ClassDef bases NameLoad body Expr Str FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad NameLoad NameLoad body Assign NameStore Call NameLoad NameLoad AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad Call NameLoad NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse If BoolOpAnd Call NameLoad NameLoad NameLoad Call NameLoad Call NameLoad NameLoad NameLoad body Assign NameStore Call NameLoad Call NameLoad NameLoad AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body If Call NameLoad Call NameLoad NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body If Call NameLoad Call NameLoad NameLoad body Return Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse Return Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad NameLoad NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad Return AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad body Expr Str FunctionDef arguments args NameParam NameParam NameParam defaults body Assign NameStore NameLoad If CompareGt Call NameLoad AttributeLoad AttributeLoad NameLoad attr attr Num body Assign NameStore Call NameLoad NameLoad AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore Call NameLoad NameLoad NameLoad If NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad decorator_list If CompareIsNot NameLoad NameLoad body Expr Call NameLoad NameLoad NameLoad NameLoad orelse If NameLoad body For NameStore NameLoad body If CompareEq Call NameLoad NameLoad Num body Expr Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num NameLoad orelse Expr Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num NameLoad decorator_list decorator_list ClassDef bases NameLoad body Expr Str FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad NameLoad NameLoad body Assign NameStore Call NameLoad NameLoad AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad Call NameLoad NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse If BoolOpAnd Call NameLoad NameLoad NameLoad Call NameLoad Call NameLoad NameLoad NameLoad body Assign NameStore Call NameLoad Call NameLoad NameLoad AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body If Call NameLoad Call NameLoad NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body If Call NameLoad Call NameLoad NameLoad body Return Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse Return Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad NameLoad NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad Return AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad body Expr Str FunctionDef arguments args NameParam NameParam NameParam defaults body Assign NameStore NameLoad If CompareGt Call NameLoad AttributeLoad AttributeLoad NameLoad attr attr Num body Assign NameStore Call NameLoad NameLoad AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore Call NameLoad NameLoad NameLoad If NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad decorator_list If CompareIsNot NameLoad NameLoad body Expr Call NameLoad NameLoad NameLoad NameLoad orelse If NameLoad body For NameStore NameLoad body If CompareEq Call NameLoad NameLoad Num body Expr Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num NameLoad orelse Expr Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num NameLoad decorator_list decorator_list Assign NameStore ListLoad Str Str Str Str Str Str ClassDef bases NameLoad body Expr Str FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad Num Num NameLoad NameLoad NameLoad NameLoad body Expr Str If CompareIs NameLoad NameLoad body Assign NameStore ListLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad If NameLoad body Expr Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr ListLoad Assign AttributeStore NameLoad attr ListLoad Assign AttributeStore NameLoad attr Call NameLoad NameLoad Assign AttributeStore NameLoad attr Call NameLoad NameLoad If CompareNotEq NameLoad Num body If NameLoad body Raise Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad orelse If NameLoad body Assign AttributeStore NameLoad attr NameLoad If CompareNotEq NameLoad Num body If NameLoad body Raise Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad orelse If NameLoad body Assign AttributeStore NameLoad attr NameLoad If NameLoad body Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Return AttributeLoad NameLoad attr decorator_list NameLoad FunctionDef arguments args NameParam NameParam defaults body Pass decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam defaults body Expr Str Return AttributeLoad NameLoad attr decorator_list NameLoad FunctionDef arguments args NameParam NameParam defaults body Pass decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Call NameLoad Call AttributeLoad NameLoad attr NameLoad Delete SubscriptDel AttributeLoad NameLoad attr Index NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Call NameLoad Call AttributeLoad NameLoad attr NameLoad Delete SubscriptDel AttributeLoad NameLoad attr Index NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str If CompareNotEq Call NameLoad AttributeLoad NameLoad attr Num body Assign NameStore ListComp NameLoad comprehension NameStore AttributeLoad NameLoad attr Call NameLoad NameLoad NameLoad If CompareNotEq Call NameLoad NameLoad Num body Assign NameStore Call NameLoad Num Call NameLoad AttributeLoad NameLoad attr For NameStore NameLoad body Assign NameStore ListComp NameLoad comprehension NameStore NameLoad CompareNotIn NameLoad AttributeLoad NameLoad attr Return ListComp SubscriptLoad AttributeLoad NameLoad attr Index NameLoad comprehension NameStore NameLoad orelse Return AttributeLoad NameLoad attr orelse Return AttributeLoad NameLoad attr decorator_list NameLoad FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign AttributeStore NameLoad attr Call NameLoad NameLoad decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam defaults body Expr Str If CompareNotEq Call NameLoad AttributeLoad NameLoad attr Num body Assign NameStore ListComp NameLoad comprehension NameStore AttributeLoad NameLoad attr Call NameLoad NameLoad NameLoad If CompareNotEq Call NameLoad NameLoad Num body Assign NameStore Call NameLoad Num Call NameLoad AttributeLoad NameLoad attr For NameStore NameLoad body Assign NameStore ListComp NameLoad comprehension NameStore NameLoad CompareNotIn NameLoad AttributeLoad NameLoad attr Return ListComp SubscriptLoad AttributeLoad NameLoad attr Index NameLoad comprehension NameStore NameLoad orelse Return AttributeLoad NameLoad attr orelse Return AttributeLoad NameLoad attr decorator_list NameLoad FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign AttributeStore NameLoad attr Call NameLoad NameLoad decorator_list AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore NameLoad If Call NameLoad Call NameLoad NameLoad body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Assign NameStore NameLoad If Call NameLoad Call NameLoad NameLoad body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Assign NameStore ListComp SubscriptLoad AttributeLoad NameLoad attr Index NameLoad comprehension NameStore Call NameLoad Num Call NameLoad AttributeLoad NameLoad attr CompareNotIn NameLoad NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Assign NameStore ListComp SubscriptLoad AttributeLoad NameLoad attr Index NameLoad comprehension NameStore Call NameLoad Num Call NameLoad AttributeLoad NameLoad attr CompareNotIn NameLoad NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad NameLoad NameLoad body If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr ListLoad NameLoad orelse Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad ListLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Assign NameStore NameLoad If Call NameLoad Call NameLoad NameLoad body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad NameLoad NameLoad body If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr ListLoad NameLoad orelse Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad ListLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body If Call NameLoad NameLoad NameLoad body Assign NameStore AttributeLoad NameLoad attr orelse If Call NameLoad NameLoad NameLoad body Assign NameStore AttributeLoad NameLoad attr orelse Assign NameStore NameLoad If NameLoad body Assign NameStore Call NameLoad AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore ListLoad If Call NameLoad NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr For NameStore NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad orelse If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Raise Call NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Assign NameStore Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr AugAssignAdd AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore ListLoad If Call NameLoad NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr For NameStore NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Expr Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index NameLoad Expr Call AttributeLoad NameLoad attr NameLoad NameLoad orelse If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Raise Call NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Return Call NameLoad NameLoad orelse If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Return Call NameLoad NameLoad orelse Return Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str ImportFrom alias Assign NameStore ListLoad AugAssignAdd NameStore Call NameLoad Call AttributeLoad NameLoad attr If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Assign NameStore Call NameLoad Lambda arguments args NameParam defaults BinOpAdd ListLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num Call NameLoad AttributeLoad NameLoad attr NameLoad If UnaryOpNot NameLoad body Assign NameStore Call NameLoad NameLoad If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Expr Call AttributeLoad NameLoad attr Num BinOpAdd ListLoad Str AttributeLoad NameLoad attr orelse Expr Call AttributeLoad NameLoad attr Num AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body Expr Str ImportFrom alias Return Call NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body Expr Str ImportFrom alias If NameLoad body Return Call NameLoad Call NameLoad NameLoad orelse Return Call NameLoad Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body If Call NameLoad NameLoad NameLoad body If Call NameLoad SubscriptLoad NameLoad Index Num NameLoad body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad NameLoad Index Num orelse Assign NameStore SubscriptLoad NameLoad Index Num If Call NameLoad SubscriptLoad NameLoad Index Num NameLoad body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad NameLoad Index Num orelse Assign NameStore SubscriptLoad NameLoad Index Num Return Call AttributeLoad NameLoad attr NameLoad NameLoad orelse Return Call AttributeLoad NameLoad attr NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Return ListLoad Str Str Str Str orelse Return ListLoad Str Str Str Str decorator_list FunctionDef arguments args NameParam defaults body ImportFrom alias Assign NameStore BinOpMod Str AttributeLoad NameLoad attr If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Assign NameStore Call NameLoad keyword Num Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr BinOpMult ListLoad Str Call NameLoad SubscriptLoad NameLoad Index Num Assign NameStore ListLoad For NameStore NameLoad body Assign NameStore ListLoad For NameStore NameLoad body If CompareEq NameLoad Str body Expr Call AttributeLoad NameLoad attr Str orelse Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Return BinOpAdd NameLoad Call AttributeLoad NameLoad attr orelse Return BinOpAdd NameLoad Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return Call NameLoad NameLoad decorator_list decorator_list
N/A N/A 
    pyexcel.sheets.nominablesheet
    ~~~~~~~~~~~~~~~~~~~

    Building on top of filterablesheet, adding named columns and rows support

    :copyright: (c) 2014-2015 by Onni Software Ltd.
    :license: New BSD License, see LICENSE for more details
 texttable Texttable matrix Row Column Matrix formattablesheet FormattableSheet filterablesheet FilterableSheet formatters ColumnFormatter RowFormatter NamedColumnFormatter NamedRowFormatter _compact is_string OrderedDict PY2 is_array_type filters ColumnIndexFilter RowIndexFilter iterators ColumnIndexIterator RowIndexIterator NamedRowIterator NamedColumnIterator constants MESSAGE_NOT_IMPLEMENTED_02 MESSAGE_DATA_ERROR_ORDEREDDICT_IS_EXPECTED DEFAULT_NAME names_to_indices N/A N/A names series N/A N/A N/A N/A isinstance names str N/A N/A indices N/A N/A series index names N/A N/A N/A N/A isinstance names list N/A isinstance N/A names N/A 0 str N/A N/A indices N/A N/A N/A series index astr N/A astr names N/A N/A names N/A indices N/A make_names_unique N/A N/A alist N/A N/A N/A duplicates N/A N/A new_names N/A N/A item alist N/A N/A N/A item duplicates N/A N/A N/A duplicates N/A item N/A N/A duplicates N/A item 1 N/A N/A N/A new_names append N/A %s-%d N/A item N/A duplicates N/A item N/A N/A N/A duplicates N/A item 0 N/A N/A N/A new_names append N/A str item N/A new_names N/A NamedRow N/A Row N/A N/A Series Sheet would have Named Row instead of Row

    Here is an example to merge sheets. Suppose we have the
    following three files::

        >>> import pyexcel as pe
        >>> data = [[1,2,3],[4,5,6],[7,8,9]]
        >>> s = pe.Sheet(data)
        >>> s.save_as("1.csv")
        >>> data2 = [['a','b','c'],['d','e','f'],['g','h','i']]
        >>> s2 = pe.Sheet(data2)
        >>> s2.save_as("2.csv")
        >>> data3=[[1.1, 2.2, 3.3],[4.4, 5.5, 6.6],[7.7, 8.8, 9.9]]
        >>> s3=pe.Sheet(data3)
        >>> s3.save_as("3.csv")


        >>> merged = pe.Sheet()
        >>> for file in ["1.csv", "2.csv", "3.csv"]:
        ...     r = pe.get_sheet(file_name=file)
        ...     merged.row += r
        >>> merged.save_as("merged.csv")

    Now let's verify what we had::

        >>> r=pe.get_sheet(file_name="merged.csv")

    this is added to overcome doctest's inability to handle
    python 3's unicode::

        >>> r.format(lambda v: str(v))
        >>> print(pe.to_array(r))
        [['1', '2', '3'], ['4', '5', '6'], ['7', '8', '9'], ['a', 'b', 'c'], ['d', 'e', 'f'], ['g', 'h', 'i'], ['1.1', '2.2', '3.3'], ['4.4', '5.5', '6.6'], ['7.7', '8.8', '9.9']]

    .. testcleanup::
        >>> import os
        >>> os.unlink("1.csv")
        >>> os.unlink("2.csv")
        >>> os.unlink("3.csv")
        >>> os.unlink("merged.csv")

     select N/A N/A self names N/A N/A N/A Delete row indices other than specified

        Examples:

            >>> import pyexcel as pe
            >>> data = [[1],[2],[3],[4],[5],[6],[7],[9]]
            >>> sheet = pe.Sheet(data)
            >>> sheet
            Sheet Name: pyexcel
            +---+
            | 1 |
            +---+
            | 2 |
            +---+
            | 3 |
            +---+
            | 4 |
            +---+
            | 5 |
            +---+
            | 6 |
            +---+
            | 7 |
            +---+
            | 9 |
            +---+
            >>> sheet.row.select([1,2,3,5])
            >>> sheet
            Sheet Name: pyexcel
            +---+
            | 2 |
            +---+
            | 3 |
            +---+
            | 4 |
            +---+
            | 6 |
            +---+
            >>> data = [
            ...     ['a', 1],
            ...     ['b', 1],
            ...     ['c', 1]
            ... ]
            >>> sheet = pe.Sheet(data, name_rows_by_column=0)
            >>> sheet.row.select(['a', 'b'])
            >>> sheet
            Sheet Name: pyexcel
            +---+---+
            | a | 1 |
            +---+---+
            | b | 1 |
            +---+---+

         N/A N/A is_array_type names str N/A N/A indices N/A names_to_indices names N/A N/A self ref rownames N/A N/A N/A Row select self indices N/A N/A N/A N/A Row select self names N/A __delitem__ N/A N/A self column_name N/A N/A N/A 

        Examples::

            >>> import pyexcel as pe
            >>> data = [
            ...     ['a', 1],
            ...     ['b', 1],
            ...     ['c', 1]
            ... ]
            >>> sheet = pe.Sheet(data, name_rows_by_column=0)
            >>> del sheet.row['a', 'b']
            >>> sheet
            Sheet Name: pyexcel
            +---+---+
            | c | 1 |
            +---+---+

         N/A N/A is_string N/A type column_name N/A N/A N/A N/A N/A self ref delete_named_row_at column_name N/A N/A N/A N/A isinstance column_name tuple N/A is_array_type N/A list column_name str N/A N/A indices N/A names_to_indices N/A list column_name N/A N/A self ref rownames N/A N/A N/A Row __delitem__ self indices N/A N/A N/A N/A Row __delitem__ self column_name N/A __setitem__ N/A N/A self str_or_aslice c N/A N/A N/A N/A is_string N/A type str_or_aslice N/A N/A N/A N/A N/A self ref set_named_row_at str_or_aslice c N/A N/A N/A N/A Row __setitem__ self str_or_aslice c N/A __getitem__ N/A N/A self str_or_aslice N/A N/A N/A N/A is_string N/A type str_or_aslice N/A N/A N/A N/A N/A self ref named_row_at str_or_aslice N/A N/A N/A N/A Row __getitem__ self str_or_aslice N/A __iadd__ N/A N/A self other N/A N/A N/A Overload += sign

        :param list other: the row header must be the first element.
        :return: self
         N/A N/A isinstance other OrderedDict N/A N/A N/A N/A N/A self ref extend_rows other N/A N/A N/A N/A Row __iadd__ self other N/A self N/A __add__ N/A N/A self other N/A N/A N/A Overload += sign

        :return: self
         N/A N/A N/A self __iadd__ other N/A N/A self ref N/A format N/A N/A self row_index formatter format_specs on_demand N/A None None None False N/A N/A Format a row
         handle_one_formatter N/A N/A rows theformatter on_demand N/A N/A N/A new_indices rows N/A N/A N/A len N/A N/A self ref rownames 0 N/A N/A new_indices N/A names_to_indices rows N/A N/A self ref rownames N/A aformatter N/A RowFormatter new_indices theformatter N/A on_demand N/A N/A N/A N/A N/A self ref add_formatter aformatter N/A N/A N/A N/A N/A self ref apply_formatter aformatter N/A N/A N/A row_index None N/A N/A N/A handle_one_formatter row_index formatter on_demand N/A N/A format_specs N/A N/A spec format_specs N/A N/A N/A N/A len spec 3 N/A N/A N/A handle_one_formatter N/A spec N/A 0 N/A spec N/A 1 on_demand N/A N/A N/A handle_one_formatter N/A spec N/A 0 N/A spec N/A 1 on_demand N/A N/A NamedColumn N/A Column N/A N/A Series Sheet would have Named Column instead of Column

    example::

        import pyexcel as pe

        r = pe.SeriesReader("example.csv")
        print(r.column["column 1"])

     select N/A N/A self names N/A N/A N/A Delete columns other than specified

        Examples:

            >>> import pyexcel as pe
            >>> data = [[1,2,3,4,5,6,7,9]]
            >>> sheet = pe.Sheet(data)
            >>> sheet
            Sheet Name: pyexcel
            +---+---+---+---+---+---+---+---+
            | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 9 |
            +---+---+---+---+---+---+---+---+
            >>> sheet.column.select([1,2,3,5])
            >>> sheet
            Sheet Name: pyexcel
            +---+---+---+---+
            | 2 | 3 | 4 | 6 |
            +---+---+---+---+
            >>> data = [
            ...     ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'],
            ...     [1,2,3,4,5,6,7,9],
            ... ]
            >>> sheet = pe.Sheet(data, name_columns_by_row=0)
            >>> sheet
            Sheet Name: pyexcel
            +---+---+---+---+---+---+---+---+
            | a | b | c | d | e | f | g | h |
            +===+===+===+===+===+===+===+===+
            | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 9 |
            +---+---+---+---+---+---+---+---+
            >>> del sheet.column['a', 'b', 'i', 'f'] # doctest:+ELLIPSIS
            Traceback (most recent call last):
                ...
            ValueError: ...
            >>> sheet.column.select(['a', 'c', 'e', 'h'])
            >>> sheet
            Sheet Name: pyexcel
            +---+---+---+---+
            | a | c | e | h |
            +===+===+===+===+
            | 1 | 3 | 5 | 9 |
            +---+---+---+---+

         N/A N/A is_array_type names str N/A N/A indices N/A names_to_indices names N/A N/A self ref colnames N/A N/A N/A Column select self indices N/A N/A N/A N/A Column select self names N/A __delitem__ N/A N/A self str_or_aslice N/A N/A N/A 

        Example::

            >>> import pyexcel as pe
            >>> data = [
            ...     ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'],
            ...     [1,2,3,4,5,6,7,9],
            ... ]
            >>> sheet = pe.Sheet(data, name_columns_by_row=0)
            >>> sheet
            Sheet Name: pyexcel
            +---+---+---+---+---+---+---+---+
            | a | b | c | d | e | f | g | h |
            +===+===+===+===+===+===+===+===+
            | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 9 |
            +---+---+---+---+---+---+---+---+
            >>> del sheet.column['a', 'b', 'i', 'f'] # doctest:+ELLIPSIS
            Traceback (most recent call last):
                ...
            ValueError: ...
            >>> del sheet.column['a', 'c', 'e', 'h']
            >>> sheet
            Sheet Name: pyexcel
            +---+---+---+---+
            | b | d | f | g |
            +===+===+===+===+
            | 2 | 4 | 6 | 7 |
            +---+---+---+---+

         N/A N/A is_string N/A type str_or_aslice N/A N/A N/A N/A N/A self ref delete_named_column_at str_or_aslice N/A N/A N/A N/A isinstance str_or_aslice tuple N/A is_array_type N/A list str_or_aslice str N/A N/A indices N/A names_to_indices N/A list str_or_aslice N/A N/A self ref colnames N/A N/A N/A Column __delitem__ self indices N/A N/A N/A N/A Column __delitem__ self str_or_aslice N/A __setitem__ N/A N/A self str_or_aslice c N/A N/A N/A N/A is_string N/A type str_or_aslice N/A N/A N/A N/A N/A self ref set_named_column_at str_or_aslice c N/A N/A N/A N/A Column __setitem__ self str_or_aslice c N/A __getitem__ N/A N/A self str_or_aslice N/A N/A N/A N/A is_string N/A type str_or_aslice N/A N/A N/A N/A N/A self ref named_column_at str_or_aslice N/A N/A N/A N/A Column __getitem__ self str_or_aslice N/A __iadd__ N/A N/A self other N/A N/A N/A Overload += sign

        :param list other: the column header must be the first element.
        :return: self
         N/A N/A isinstance other OrderedDict N/A N/A N/A N/A N/A self ref extend_columns other N/A N/A N/A N/A Column __iadd__ self other N/A self N/A __add__ N/A N/A self other N/A N/A N/A Overload += sign

        :return: self
         N/A N/A N/A self __iadd__ other N/A N/A self ref N/A format N/A N/A self column_index formatter format_specs on_demand N/A None None None False N/A N/A Format a column
         handle_one_formatter N/A N/A columns aformatter on_demand N/A N/A N/A new_indices columns N/A N/A N/A len N/A N/A self ref colnames 0 N/A N/A new_indices N/A names_to_indices columns N/A N/A self ref colnames N/A theformatter N/A ColumnFormatter new_indices aformatter N/A on_demand N/A N/A N/A N/A N/A self ref add_formatter theformatter N/A N/A N/A N/A N/A self ref apply_formatter theformatter N/A N/A N/A column_index None N/A N/A N/A handle_one_formatter column_index formatter on_demand N/A N/A format_specs N/A N/A spec format_specs N/A N/A N/A N/A len spec 3 N/A N/A N/A handle_one_formatter N/A spec N/A 0 N/A spec N/A 1 on_demand N/A N/A N/A handle_one_formatter N/A spec N/A 0 N/A spec N/A 1 on_demand N/A N/A N/A VALID_SHEET_PARAMETERS N/A name_columns_by_row name_rows_by_column colnames rownames transpose_before transpose_after NominableSheet N/A FilterableSheet N/A N/A Allow dictionary group of the content
     __init__ N/A N/A self sheet name name_columns_by_row name_rows_by_column colnames rownames transpose_before transpose_after N/A None DEFAULT_NAME -1 -1 None None False False N/A N/A Constructor

        :param sheet: two dimensional array
        :param name: this becomes the sheet name.
        :param name_columns_by_row: use a row to name all columns
        :param name_rows_by_column: use a column to name all rows
        :param colnames: use an external list of strings to name the columns
        :param rownames: use an external list of strings to name the rows
         N/A N/A sheet None N/A N/A sheet N/A N/A N/A N/A FilterableSheet __init__ self sheet N/A transpose_before N/A N/A N/A N/A self transpose N/A N/A self name name N/A N/A self _column_names N/A N/A N/A self _row_names N/A N/A N/A self named_row N/A NamedRow self N/A N/A self named_column N/A NamedColumn self N/A N/A name_columns_by_row -1 N/A N/A colnames N/A N/A N/A NotImplementedError MESSAGE_NOT_IMPLEMENTED_02 N/A N/A N/A self name_columns_by_row name_columns_by_row N/A N/A colnames N/A N/A N/A self _column_names colnames N/A N/A name_rows_by_column -1 N/A N/A rownames N/A N/A N/A NotImplementedError MESSAGE_NOT_IMPLEMENTED_02 N/A N/A N/A self name_rows_by_column name_rows_by_column N/A N/A rownames N/A N/A N/A self _row_names rownames N/A transpose_after N/A N/A N/A N/A self transpose N/A row N/A N/A self N/A N/A N/A Row representation. see :class:`NamedRow`

        examples::

            >>> import pyexcel as pe
            >>> data = [[1, 2, 3], [4, 5, 6], [7, 8, 9]]
            >>> sheet = pe.Sheet(data)
            >>> sheet.row[1]
            [4, 5, 6]
            >>> sheet.row[0:3]
            [[1, 2, 3], [4, 5, 6], [7, 8, 9]]
            >>> sheet.row += [11, 12, 13]
            >>> sheet.row[3]
            [11, 12, 13]
            >>> sheet.row[0:4] = [0, 0, 0] # set all to zero
            >>> sheet.row[3]
            [0, 0, 0]
            >>> sheet.row[0] = ['a', 'b', 'c'] # set one row
            >>> sheet.row[0]
            ['a', 'b', 'c']
            >>> del sheet.row[0] # delete first row
            >>> sheet.row[0] # now, second row becomes the first
            [0, 0, 0]
            >>> del sheet.row[0:]
            >>> sheet.row[0]  # nothing left
            Traceback (most recent call last):
                ...
            IndexError
         N/A N/A self named_row N/A property row N/A N/A self value N/A N/A N/A N/A N/A row setter column N/A N/A self N/A N/A N/A Column representation. see :class:`NamedColumn` N/A N/A self named_column N/A property column N/A N/A self value N/A N/A N/A N/A N/A column setter name_columns_by_row N/A N/A self row_index N/A N/A N/A Use the elements of a specified row to represent individual columns

        The specified row will be deleted from the data
        :param int row_index: the index of the row that has the column names
         N/A N/A self row_index row_index N/A N/A self _column_names N/A make_names_unique N/A N/A self row_at row_index N/A N/A N/A self row N/A row_index N/A name_rows_by_column N/A N/A self column_index N/A N/A N/A Use the elements of a specified column to represent individual rows

        The specified column will be deleted from the data
        :param int column_index: the index of the column that has the row names
         N/A N/A self column_index column_index N/A N/A self _row_names N/A make_names_unique N/A N/A self column_at column_index N/A N/A N/A self column N/A column_index N/A colnames N/A N/A self N/A N/A N/A Return column names N/A N/A N/A len N/A self _filters 0 N/A N/A column_filters N/A f N/A f N/A self _filters N/A isinstance f ColumnIndexFilter N/A N/A N/A len column_filters 0 N/A N/A indices N/A range 0 N/A len N/A self _column_names N/A f column_filters N/A N/A indices N/A i N/A i indices N/A i N/A f indices N/A N/A N/A N/A self _column_names N/A i N/A i indices N/A N/A N/A self _column_names N/A N/A N/A self _column_names N/A property colnames N/A N/A self value N/A N/A N/A Set column names N/A N/A self _column_names N/A make_names_unique value N/A N/A colnames setter rownames N/A N/A self N/A N/A N/A Return row names N/A N/A N/A len N/A self _filters 0 N/A N/A row_filters N/A f N/A f N/A self _filters N/A isinstance f RowIndexFilter N/A N/A N/A len row_filters 0 N/A N/A indices N/A range 0 N/A len N/A self _row_names N/A f row_filters N/A N/A indices N/A i N/A i indices N/A i N/A f indices N/A N/A N/A N/A self _row_names N/A i N/A i indices N/A N/A N/A self _row_names N/A N/A N/A self _row_names N/A property rownames N/A N/A self value N/A N/A N/A Set row names N/A N/A self _row_names N/A make_names_unique value N/A N/A rownames setter named_column_at N/A N/A self name N/A N/A N/A Get a column by its name  N/A index name N/A N/A is_string N/A type index N/A N/A index N/A N/A N/A self colnames index name N/A column_array N/A N/A self column_at index N/A column_array N/A set_named_column_at N/A N/A self name column_array N/A N/A N/A 
        Take the first row as column names

        Given name to identify the column index, set the column to
        the given array except the column name.
         N/A index name N/A N/A is_string N/A type index N/A N/A index N/A N/A N/A self colnames index name N/A N/A N/A self set_column_at index column_array N/A delete_columns N/A N/A self column_indices N/A N/A N/A Delete one or more columns

        :param list column_indices: a list of column indices
         N/A N/A N/A FilterableSheet delete_columns self column_indices N/A N/A N/A len N/A self _column_names 0 N/A N/A new_series N/A N/A N/A self _column_names N/A i N/A i N/A range 0 N/A len N/A self _column_names N/A i column_indices N/A N/A self _column_names new_series N/A delete_rows N/A N/A self row_indices N/A N/A N/A Delete one or more rows

        :param list row_indices: a list of row indices
         N/A N/A N/A FilterableSheet delete_rows self row_indices N/A N/A N/A len N/A self _row_names 0 N/A N/A new_series N/A N/A N/A self _row_names N/A i N/A i N/A range 0 N/A len N/A self _row_names N/A i row_indices N/A N/A self _row_names new_series N/A delete_named_column_at N/A N/A self name N/A N/A N/A Works only after you named columns by a row

        Given name to identify the column index, set the column to
        the given array except the column name.
        :param str name: a column name
         N/A N/A isinstance name int N/A N/A N/A N/A len N/A self rownames 0 N/A N/A N/A N/A N/A self rownames pop name N/A N/A N/A self delete_columns N/A name N/A N/A index N/A N/A N/A self colnames index name N/A N/A N/A N/A self colnames pop index N/A N/A N/A FilterableSheet delete_columns self N/A index N/A named_row_at N/A N/A self name N/A N/A N/A Get a row by its name  N/A index name N/A index N/A N/A N/A self rownames index name N/A row_array N/A N/A self row_at index N/A row_array N/A set_named_row_at N/A N/A self name row_array N/A N/A N/A 
        Take the first column as row names

        Given name to identify the row index, set the row to
        the given array except the row name.
         N/A index name N/A N/A is_string N/A type index N/A N/A index N/A N/A N/A self rownames index name N/A N/A N/A self set_row_at index row_array N/A delete_named_row_at N/A N/A self name N/A N/A N/A Take the first column as row names

        Given name to identify the row index, set the row to
        the given array except the row name.
         N/A N/A isinstance name int N/A N/A N/A N/A len N/A self rownames 0 N/A N/A N/A N/A N/A self rownames pop name N/A N/A N/A self delete_rows N/A name N/A N/A index N/A N/A N/A self rownames index name N/A N/A N/A N/A self rownames pop index N/A N/A N/A FilterableSheet delete_rows self N/A index N/A apply_formatter N/A N/A self aformatter N/A N/A N/A Apply the formatter immediately.

        :param Formatter aformatter: a custom formatter
         N/A aformatter N/A N/A self _translate_named_formatter aformatter N/A N/A N/A FormattableSheet apply_formatter self aformatter N/A _translate_named_formatter N/A N/A self aformatter N/A N/A N/A N/A isinstance aformatter NamedColumnFormatter N/A N/A series N/A self colnames N/A N/A N/A isinstance aformatter NamedRowFormatter N/A N/A series N/A self rownames N/A N/A series None N/A series N/A N/A indices N/A names_to_indices N/A aformatter indices series N/A N/A N/A aformatter update_index indices N/A aformatter N/A add_formatter N/A N/A self aformatter N/A N/A N/A Add a lazy formatter.

        The formatter takes effect on the fly when a cell value is read
        This is cost effective when you have a big data table
        and you use only a few rows or columns. If you have farily modest
        data table, you can choose apply_formatter() too.

        :param Formatter aformatter: a custom formatter
         N/A aformatter N/A N/A self _translate_named_formatter aformatter N/A N/A N/A FormattableSheet add_formatter self aformatter N/A extend_rows N/A N/A self rows N/A N/A N/A Take ordereddict to extend named rows

        :param ordereddist/list rows: a list of rows.
         N/A incoming_data N/A N/A N/A isinstance rows OrderedDict N/A N/A keys N/A N/A rows keys N/A k keys N/A N/A N/A N/A N/A self rownames append k N/A N/A N/A incoming_data append N/A rows N/A k N/A N/A N/A FilterableSheet extend_rows self incoming_data N/A N/A N/A N/A len N/A self rownames 0 N/A N/A N/A TypeError MESSAGE_DATA_ERROR_ORDEREDDICT_IS_EXPECTED N/A N/A N/A N/A FilterableSheet extend_rows self rows N/A extend_columns_with_rows N/A N/A self rows N/A N/A N/A Put rows on the right most side of the data N/A N/A N/A len N/A self colnames 0 N/A N/A headers N/A N/A rows pop N/A self row_index N/A N/A self _column_names headers N/A N/A N/A FilterableSheet extend_columns_with_rows self rows N/A extend_columns N/A N/A self columns N/A N/A N/A Take ordereddict to extend named columns

        :param ordereddist/list columns: a list of columns
         N/A incoming_data N/A N/A N/A isinstance columns OrderedDict N/A N/A keys N/A N/A columns keys N/A k keys N/A N/A N/A N/A N/A self colnames append k N/A N/A N/A incoming_data append N/A columns N/A k N/A N/A N/A FilterableSheet extend_columns self incoming_data N/A N/A N/A N/A len N/A self colnames 0 N/A N/A N/A TypeError MESSAGE_DATA_ERROR_ORDEREDDICT_IS_EXPECTED N/A N/A N/A N/A FilterableSheet extend_columns self columns N/A __iter__ N/A N/A self N/A N/A N/A N/A N/A len N/A self _column_names 0 N/A N/A N/A ColumnIndexIterator self N/A N/A N/A N/A len N/A self _row_names 0 N/A N/A N/A RowIndexIterator self N/A N/A N/A N/A FilterableSheet __iter__ self N/A to_array N/A N/A self N/A N/A N/A Returns an array after filtering utils to_array N/A ret N/A N/A ret N/A to_array N/A N/A self rows N/A N/A N/A len N/A self rownames 0 N/A N/A ret N/A map N/A N/A N/A value N/A N/A N/A N/A value N/A 0 N/A value N/A 1 N/A zip N/A self rownames ret N/A N/A PY2 N/A N/A ret N/A list ret N/A N/A N/A len N/A self colnames 0 N/A N/A N/A N/A len N/A self rownames 0 N/A N/A N/A N/A ret insert 0 N/A N/A N/A self colnames N/A N/A N/A N/A ret insert 0 N/A self colnames N/A ret N/A to_records N/A N/A self custom_headers N/A None N/A N/A Returns the content as an array of dictionaries

         utils to_records N/A N/A to_records self custom_headers N/A to_dict N/A N/A self row N/A False N/A N/A Returns a dictionary utils to_dict N/A row N/A N/A N/A to_dict N/A RowIndexIterator self N/A N/A N/A to_dict N/A ColumnIndexIterator self N/A __getitem__ N/A N/A self aset N/A N/A N/A N/A isinstance aset tuple N/A N/A N/A isinstance N/A aset N/A 0 str N/A N/A row N/A N/A N/A self rownames index N/A aset N/A 0 N/A N/A row N/A aset N/A 0 N/A N/A isinstance N/A aset N/A 1 str N/A N/A column N/A N/A N/A self colnames index N/A aset N/A 1 N/A N/A column N/A aset N/A 1 N/A N/A N/A self cell_value row column N/A N/A N/A N/A Matrix __getitem__ self aset N/A __border__ N/A N/A self N/A N/A N/A N/A N/A len N/A self colnames 0 N/A N/A N/A - | + = N/A N/A N/A - | + - N/A __str__ N/A N/A self N/A N/A formatters to_format N/A ret N/A Sheet Name: %s
 N/A self name N/A N/A N/A len N/A self colnames 0 N/A N/A table N/A Texttable max_width 0 N/A N/A N/A table set_chars N/A N/A self __border__ N/A data N/A N/A self to_array N/A N/A N/A table set_cols_dtype N/A N/A t N/A len N/A data N/A 0 N/A new_data N/A N/A sub_array data N/A N/A new_array N/A N/A item sub_array N/A N/A N/A item N/A N/A N/A N/A new_array append N/A N/A N/A N/A new_array append N/A to_format str item N/A N/A N/A new_data append new_array N/A N/A N/A table add_rows new_data N/A N/A ret N/A N/A table draw N/A N/A N/A ret N/A N/A FilterableSheet __str__ self N/A named_rows N/A N/A self N/A N/A N/A N/A NamedRowIterator self N/A named_columns N/A N/A self N/A N/A N/A N/A NamedColumnIterator self N/A N/A