Code Monkey home page Code Monkey logo

qtpandas's Introduction

QtPandas

Utilities to use pandas (the data analysis/manipulation library for Python) with Qt.

Project Information

Latest Release latest release
Package Status status
Build Status travis build status
PyPI pypi downloads

Codacy Badge Join the chat at https://gitter.im/qtpandas/Lobby# open issues closed issues

Requirements;

Python 3.4 or greater
Pthon 2.7 or greater
PyQt4

Install

To install run the following in the command prompt;

pip install qtpandas

If that doesn't work try installing the lastest version of easy gui;

pip install --upgrade git+https://github.com/robertlugg/easygui.git

If that doesn't work then please report an issue

To use, create a new Python script containing the following:

from PyQt4.QtCore import *
from PyQt4.QtGui import *

from qtpandas.views.CSVDialogs import CSVImportDialog

if __name__ == "__main__":
    from sys import argv, exit

    app = QApplication(argv)
    dialog = CSVImportDialog()
    dialog.show()
    app.exec_()

Examples

These can be found in QtPandas/examples.

  • BasicExmple.py

basic

  • Here is TestApp.py

testapp

Development

Wanna contribute?

Any feedback is apprecaited.

  • Report an issue
  • Check out the wiki for development info (coming soon!)
  • Fork us.

Forked from @datalyze-solutions's master.

qtpandas's People

Contributors

kaotika avatar mherrmann avatar quiqua avatar westurner avatar zbarge avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

qtpandas's Issues

Failing or broken pytests

In PR #22 running pytest on the tests directory has been yielding weird results ever since I started messing around with the decorators. Mostly I have been converting methods to functions using @classmethod and changing self to cls. I did all that b/c codacy suggested but as far as I can tell this is mostly just making things more difficult. If we need to lose all that bullshit we def can. I can just tell codacity to ignore that problem pattern and the score should improve, but I don't wanna cheat if I don't have too ๐Ÿ˜‰.

  • Create a standard SOP in the wiki of how to run pytest on the tests directory
    • Create one for Atom
    • Create one for PyCharm
      (Add a few screen shots if possible)
      After merger of PR #30
  • Run pytest tests from travis.ci
    • Create new issue to diagnose travis.ci issues if any.

General enhancements (this will probably be broken up into several different issues)

Wish-list

  • Break this list up into several different issues
  • Add documentation.
  • Reach out to people that fork/starred pandasqt
  • Add this as a solution to stackoverflow problems
    • Add links to those problems on this thread
  • Add Windows, Apple, and Linux tests.
  • Consider adding functions seen in Spyder IDE's dataframeeditor
    • Sort
    • Color coding
  • Create specific Python version tests.
  • Make verison agnostic.
  • Add screen shots
  • Create Wiki
  • Revise the pandas faq to reflect that there is python3 compatible of pandasqt

qtpandas requires installation of visual studio (tools) on host pc?

On windows 10:

pip install qtpandas

results in :

error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": https://visualstudio.microsoft.com/downloads/

Is it really necessary to have visual c++ (tools) installed to use qtpandas? Would be nice if everything would be installable into virtual env and just as cleanly uninstallable without having to globally install other stuff on the host pc

Collecting qtpandas
  Using cached https://files.pythonhosted.org/packages/9c/96/4d1782c3ca98228f93fae14d7be7bcc202bb520d2162d7ef6ff8a9a7473d/qtpandas-1.0.3-py3-none-any.whl
Requirement already satisfied: pytest in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from qtpandas) (3.7.2)
Requirement already satisfied: pytest-qt==1.2.2 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from qtpandas) (1.2.2)
Requirement already satisfied: easygui in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from qtpandas) (0.98.1)
Requirement already satisfied: pytest-cov in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from qtpandas) (2.5.1)
Requirement already satisfied: python-magic==0.4.6 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from qtpandas) (0.4.6)
Collecting pandas==0.17.1 (from qtpandas)
  Using cached https://files.pythonhosted.org/packages/a9/8e/034d108c2b2834ad4cc5bf7fb2b4d96bacf135034a2e2d946f7b4661d461/pandas-0.17.1.tar.gz
Requirement already satisfied: setuptools in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pytest->qtpandas) (40.2.0)
Requirement already satisfied: atomicwrites>=1.0 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pytest->qtpandas) (1.1.5)
Requirement already satisfied: attrs>=17.4.0 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pytest->qtpandas) (18.1.0)
Requirement already satisfied: py>=1.5.0 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pytest->qtpandas) (1.5.4)
Requirement already satisfied: six>=1.10.0 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pytest->qtpandas) (1.11.0)
Requirement already satisfied: more-itertools>=4.0.0 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pytest->qtpandas) (4.3.0)
Requirement already satisfied: colorama; sys_platform == "win32" in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pytest->qtpandas) (0.3.9)
Requirement already satisfied: pluggy>=0.7 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pytest->qtpandas) (0.7.1)
Requirement already satisfied: coverage>=3.7.1 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pytest-cov->qtpandas) (4.5.1)
Requirement already satisfied: python-dateutil>=2 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pandas==0.17.1->qtpandas) (2.7.3)
Requirement already satisfied: pytz>=2011k in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pandas==0.17.1->qtpandas) (2018.5)
Requirement already satisfied: numpy>=1.7.0 in d:\zone\mid\lib\python\virtual_env\data_vis\lib\site-packages (from pandas==0.17.1->qtpandas) (1.15.1)
Installing collected packages: pandas, qtpandas
  Found existing installation: pandas 0.23.4
    Uninstalling pandas-0.23.4:
      Successfully uninstalled pandas-0.23.4
  Running setup.py install for pandas ... error
    Complete output from command d:\zone\mid\lib\python\virtual_env\data_vis\scripts\python.exe -u -c "import setuptools, tokenize;__file__='C:\\Users\\DBE4A~1.MOR\\AppData\\Local\\Temp\\pip-install-_k7iu0t9\\pandas\\setup.py';f=getattr(tokenize, 'open', open)(
__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\DBE4A~1.MOR\AppData\Local\Temp\pip-record-6oyqzxa5\install-record.txt --single-version-externally-managed --compile --install-headers d:\zon
e\mid\lib\python\virtual_env\data_vis\include\site\python3.6\pandas:
    running install
    running build
    running build_py
    creating build
    creating build\lib.win32-3.6
    creating build\lib.win32-3.6\pandas
    copying pandas\info.py -> build\lib.win32-3.6\pandas
    copying pandas\_version.py -> build\lib.win32-3.6\pandas
    copying pandas\__init__.py -> build\lib.win32-3.6\pandas
    creating build\lib.win32-3.6\pandas\compat
    copying pandas\compat\chainmap.py -> build\lib.win32-3.6\pandas\compat
    copying pandas\compat\chainmap_impl.py -> build\lib.win32-3.6\pandas\compat
    copying pandas\compat\openpyxl_compat.py -> build\lib.win32-3.6\pandas\compat
    copying pandas\compat\pickle_compat.py -> build\lib.win32-3.6\pandas\compat
    copying pandas\compat\__init__.py -> build\lib.win32-3.6\pandas\compat
    creating build\lib.win32-3.6\pandas\computation
    copying pandas\computation\align.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\api.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\common.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\engines.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\eval.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\expr.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\expressions.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\ops.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\pytables.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\scope.py -> build\lib.win32-3.6\pandas\computation
    copying pandas\computation\__init__.py -> build\lib.win32-3.6\pandas\computation
    creating build\lib.win32-3.6\pandas\computation\tests
    copying pandas\computation\tests\test_eval.py -> build\lib.win32-3.6\pandas\computation\tests
    copying pandas\computation\tests\__init__.py -> build\lib.win32-3.6\pandas\computation\tests
    creating build\lib.win32-3.6\pandas\core
    copying pandas\core\algorithms.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\api.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\base.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\categorical.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\common.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\config.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\config_init.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\convert.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\datetools.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\dtypes.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\format.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\frame.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\generic.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\groupby.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\index.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\indexing.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\internals.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\matrix.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\missing.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\nanops.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\ops.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\panel.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\panel4d.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\panelnd.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\reshape.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\series.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\sparse.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\strings.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\style.py -> build\lib.win32-3.6\pandas\core
    copying pandas\core\__init__.py -> build\lib.win32-3.6\pandas\core
    creating build\lib.win32-3.6\pandas\io
    copying pandas\io\api.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\auth.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\clipboard.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\common.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\data.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\date_converters.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\excel.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\ga.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\gbq.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\html.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\json.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\packers.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\parsers.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\pickle.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\pytables.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\sas.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\sql.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\stata.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\wb.py -> build\lib.win32-3.6\pandas\io
    copying pandas\io\__init__.py -> build\lib.win32-3.6\pandas\io
    creating build\lib.win32-3.6\pandas\rpy
    copying pandas\rpy\base.py -> build\lib.win32-3.6\pandas\rpy
    copying pandas\rpy\common.py -> build\lib.win32-3.6\pandas\rpy
    copying pandas\rpy\mass.py -> build\lib.win32-3.6\pandas\rpy
    copying pandas\rpy\vars.py -> build\lib.win32-3.6\pandas\rpy
    copying pandas\rpy\__init__.py -> build\lib.win32-3.6\pandas\rpy
    creating build\lib.win32-3.6\pandas\sandbox
    copying pandas\sandbox\qtpandas.py -> build\lib.win32-3.6\pandas\sandbox
    copying pandas\sandbox\__init__.py -> build\lib.win32-3.6\pandas\sandbox
    creating build\lib.win32-3.6\pandas\sparse
    copying pandas\sparse\api.py -> build\lib.win32-3.6\pandas\sparse
    copying pandas\sparse\array.py -> build\lib.win32-3.6\pandas\sparse
    copying pandas\sparse\frame.py -> build\lib.win32-3.6\pandas\sparse
    copying pandas\sparse\list.py -> build\lib.win32-3.6\pandas\sparse
    copying pandas\sparse\panel.py -> build\lib.win32-3.6\pandas\sparse
    copying pandas\sparse\scipy_sparse.py -> build\lib.win32-3.6\pandas\sparse
    copying pandas\sparse\series.py -> build\lib.win32-3.6\pandas\sparse
    copying pandas\sparse\__init__.py -> build\lib.win32-3.6\pandas\sparse
    creating build\lib.win32-3.6\pandas\sparse\tests
    copying pandas\sparse\tests\test_array.py -> build\lib.win32-3.6\pandas\sparse\tests
    copying pandas\sparse\tests\test_libsparse.py -> build\lib.win32-3.6\pandas\sparse\tests
    copying pandas\sparse\tests\test_list.py -> build\lib.win32-3.6\pandas\sparse\tests
    copying pandas\sparse\tests\test_sparse.py -> build\lib.win32-3.6\pandas\sparse\tests
    copying pandas\sparse\tests\__init__.py -> build\lib.win32-3.6\pandas\sparse\tests
    creating build\lib.win32-3.6\pandas\stats
    copying pandas\stats\api.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\common.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\fama_macbeth.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\interface.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\math.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\misc.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\moments.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\ols.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\plm.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\var.py -> build\lib.win32-3.6\pandas\stats
    copying pandas\stats\__init__.py -> build\lib.win32-3.6\pandas\stats
    creating build\lib.win32-3.6\pandas\util
    copying pandas\util\clipboard.py -> build\lib.win32-3.6\pandas\util
    copying pandas\util\decorators.py -> build\lib.win32-3.6\pandas\util
    copying pandas\util\doctools.py -> build\lib.win32-3.6\pandas\util
    copying pandas\util\misc.py -> build\lib.win32-3.6\pandas\util
    copying pandas\util\print_versions.py -> build\lib.win32-3.6\pandas\util
    copying pandas\util\terminal.py -> build\lib.win32-3.6\pandas\util
    copying pandas\util\testing.py -> build\lib.win32-3.6\pandas\util
    copying pandas\util\__init__.py -> build\lib.win32-3.6\pandas\util
    creating build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_algos.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_base.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_categorical.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_common.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_compat.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_config.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_dtypes.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_expressions.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_format.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_frame.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_generic.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_graphics.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_graphics_others.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_groupby.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_index.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_indexing.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_internals.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_lib.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_multilevel.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_nanops.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_panel.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_panel4d.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_panelnd.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_reshape.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_rplot.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_series.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_stats.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_strings.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_style.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_testing.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_tseries.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\test_util.py -> build\lib.win32-3.6\pandas\tests
    copying pandas\tests\__init__.py -> build\lib.win32-3.6\pandas\tests
    creating build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_buffer.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_case.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_except.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_extension.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_format.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_limits.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_newspec.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_obj.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_pack.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_read_size.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_seq.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_sequnpack.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_subtype.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_unpack.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\test_unpack_raw.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    copying pandas\tests\test_msgpack\__init__.py -> build\lib.win32-3.6\pandas\tests\test_msgpack
    creating build\lib.win32-3.6\pandas\tools
    copying pandas\tools\merge.py -> build\lib.win32-3.6\pandas\tools
    copying pandas\tools\pivot.py -> build\lib.win32-3.6\pandas\tools
    copying pandas\tools\plotting.py -> build\lib.win32-3.6\pandas\tools
    copying pandas\tools\rplot.py -> build\lib.win32-3.6\pandas\tools
    copying pandas\tools\tile.py -> build\lib.win32-3.6\pandas\tools
    copying pandas\tools\util.py -> build\lib.win32-3.6\pandas\tools
    copying pandas\tools\__init__.py -> build\lib.win32-3.6\pandas\tools
    creating build\lib.win32-3.6\pandas\tools\tests
    copying pandas\tools\tests\test_merge.py -> build\lib.win32-3.6\pandas\tools\tests
    copying pandas\tools\tests\test_pivot.py -> build\lib.win32-3.6\pandas\tools\tests
    copying pandas\tools\tests\test_tile.py -> build\lib.win32-3.6\pandas\tools\tests
    copying pandas\tools\tests\test_util.py -> build\lib.win32-3.6\pandas\tools\tests
    copying pandas\tools\tests\__init__.py -> build\lib.win32-3.6\pandas\tools\tests
    creating build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\api.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\base.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\common.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\converter.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\frequencies.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\holiday.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\index.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\interval.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\offsets.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\period.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\plotting.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\resample.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\tdi.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\timedeltas.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\tools.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\util.py -> build\lib.win32-3.6\pandas\tseries
    copying pandas\tseries\__init__.py -> build\lib.win32-3.6\pandas\tseries
    creating build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_base.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_converter.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_daterange.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_frequencies.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_holiday.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_offsets.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_period.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_plotting.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_resample.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_timedeltas.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_timeseries.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_timeseries_legacy.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_timezones.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_tslib.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\test_util.py -> build\lib.win32-3.6\pandas\tseries\tests
    copying pandas\tseries\tests\__init__.py -> build\lib.win32-3.6\pandas\tseries\tests
    creating build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\generate_legacy_storage_files.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_clipboard.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_common.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_cparser.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_data.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_date_converters.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_excel.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_ga.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_gbq.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_html.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_json_norm.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_packers.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_parsers.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_pickle.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_pytables.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_sas.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_sql.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_stata.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\test_wb.py -> build\lib.win32-3.6\pandas\io\tests
    copying pandas\io\tests\__init__.py -> build\lib.win32-3.6\pandas\io\tests
    creating build\lib.win32-3.6\pandas\io\tests\test_json
    copying pandas\io\tests\test_json\test_pandas.py -> build\lib.win32-3.6\pandas\io\tests\test_json
    copying pandas\io\tests\test_json\test_ujson.py -> build\lib.win32-3.6\pandas\io\tests\test_json
    copying pandas\io\tests\test_json\__init__.py -> build\lib.win32-3.6\pandas\io\tests\test_json
    creating build\lib.win32-3.6\pandas\stats\tests
    copying pandas\stats\tests\common.py -> build\lib.win32-3.6\pandas\stats\tests
    copying pandas\stats\tests\test_fama_macbeth.py -> build\lib.win32-3.6\pandas\stats\tests
    copying pandas\stats\tests\test_math.py -> build\lib.win32-3.6\pandas\stats\tests
    copying pandas\stats\tests\test_moments.py -> build\lib.win32-3.6\pandas\stats\tests
    copying pandas\stats\tests\test_ols.py -> build\lib.win32-3.6\pandas\stats\tests
    copying pandas\stats\tests\test_var.py -> build\lib.win32-3.6\pandas\stats\tests
    copying pandas\stats\tests\__init__.py -> build\lib.win32-3.6\pandas\stats\tests
    creating build\lib.win32-3.6\pandas\msgpack
    copying pandas\msgpack\exceptions.py -> build\lib.win32-3.6\pandas\msgpack
    copying pandas\msgpack\_version.py -> build\lib.win32-3.6\pandas\msgpack
    copying pandas\msgpack\__init__.py -> build\lib.win32-3.6\pandas\msgpack
    creating build\lib.win32-3.6\pandas\io\tests\data
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_hdf
    copying pandas\io\tests\data\legacy_hdf\datetimetz_object.h5 -> build\lib.win32-3.6\pandas\io\tests\data\legacy_hdf
    copying pandas\io\tests\data\legacy_hdf\legacy.h5 -> build\lib.win32-3.6\pandas\io\tests\data\legacy_hdf
    copying pandas\io\tests\data\legacy_hdf\legacy_0.10.h5 -> build\lib.win32-3.6\pandas\io\tests\data\legacy_hdf
    copying pandas\io\tests\data\legacy_hdf\legacy_table.h5 -> build\lib.win32-3.6\pandas\io\tests\data\legacy_hdf
    copying pandas\io\tests\data\legacy_hdf\legacy_table_0.11.h5 -> build\lib.win32-3.6\pandas\io\tests\data\legacy_hdf
    copying pandas\io\tests\data\legacy_hdf\pytables_native.h5 -> build\lib.win32-3.6\pandas\io\tests\data\legacy_hdf
    copying pandas\io\tests\data\legacy_hdf\pytables_native2.h5 -> build\lib.win32-3.6\pandas\io\tests\data\legacy_hdf
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.10.1
    copying pandas\io\tests\data\legacy_pickle\0.10.1\AMD64_windows_2.7.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.10.1
    copying pandas\io\tests\data\legacy_pickle\0.10.1\x86_64_linux_2.7.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.10.1
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.11.0
    copying pandas\io\tests\data\legacy_pickle\0.11.0\0.11.0_x86_64_linux_3.3.0.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.11.0
    copying pandas\io\tests\data\legacy_pickle\0.11.0\x86_64_linux_2.7.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.11.0
    copying pandas\io\tests\data\legacy_pickle\0.11.0\x86_64_linux_3.3.0.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.11.0
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.12.0
    copying pandas\io\tests\data\legacy_pickle\0.12.0\0.12.0_AMD64_windows_2.7.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.12.0
    copying pandas\io\tests\data\legacy_pickle\0.12.0\0.12.0_x86_64_linux_2.7.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.12.0
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    copying pandas\io\tests\data\legacy_pickle\0.13.0\0.13.0_AMD64_windows_2.7.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    copying pandas\io\tests\data\legacy_pickle\0.13.0\0.13.0_i686_linux_2.6.5.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    copying pandas\io\tests\data\legacy_pickle\0.13.0\0.13.0_i686_linux_2.7.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    copying pandas\io\tests\data\legacy_pickle\0.13.0\0.13.0_i686_linux_3.2.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    copying pandas\io\tests\data\legacy_pickle\0.13.0\0.13.0_x86_64_darwin_2.7.5.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    copying pandas\io\tests\data\legacy_pickle\0.13.0\0.13.0_x86_64_darwin_2.7.6.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    copying pandas\io\tests\data\legacy_pickle\0.13.0\0.13.0_x86_64_linux_2.7.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    copying pandas\io\tests\data\legacy_pickle\0.13.0\0.13.0_x86_64_linux_2.7.8.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    copying pandas\io\tests\data\legacy_pickle\0.13.0\0.13.0_x86_64_linux_3.3.0.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.13.0
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.14.0
    copying pandas\io\tests\data\legacy_pickle\0.14.0\0.14.0_x86_64_darwin_2.7.6.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.14.0
    copying pandas\io\tests\data\legacy_pickle\0.14.0\0.14.0_x86_64_linux_2.7.8.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.14.0
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.14.1
    copying pandas\io\tests\data\legacy_pickle\0.14.1\0.14.1_x86_64_linux_2.7.8.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.14.1
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.15.0
    copying pandas\io\tests\data\legacy_pickle\0.15.0\0.15.0_x86_64_linux_2.7.8.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.15.0
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.15.2
    copying pandas\io\tests\data\legacy_pickle\0.15.2\0.15.2_x86_64_darwin_2.7.9.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.15.2
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.0
    copying pandas\io\tests\data\legacy_pickle\0.16.0\0.16.0_x86_64_darwin_2.7.9.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.0
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.2
    copying pandas\io\tests\data\legacy_pickle\0.16.2\0.16.2_AMD64_windows_2.7.10.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.2
    copying pandas\io\tests\data\legacy_pickle\0.16.2\0.16.2_AMD64_windows_3.4.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.2
    copying pandas\io\tests\data\legacy_pickle\0.16.2\0.16.2_x86_64_darwin_2.7.10.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.2
    copying pandas\io\tests\data\legacy_pickle\0.16.2\0.16.2_x86_64_darwin_2.7.9.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.2
    copying pandas\io\tests\data\legacy_pickle\0.16.2\0.16.2_x86_64_darwin_3.4.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.2
    copying pandas\io\tests\data\legacy_pickle\0.16.2\0.16.2_x86_64_linux_2.7.10.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.2
    copying pandas\io\tests\data\legacy_pickle\0.16.2\0.16.2_x86_64_linux_3.4.3.pickle -> build\lib.win32-3.6\pandas\io\tests\data\legacy_pickle\0.16.2
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.0
    copying pandas\io\tests\data\legacy_msgpack\0.16.0\0.16.0_x86_64_darwin_2.7.9.msgpack -> build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.0
    creating build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.2
    copying pandas\io\tests\data\legacy_msgpack\0.16.2\0.16.2_AMD64_windows_2.7.10.msgpack -> build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.2
    copying pandas\io\tests\data\legacy_msgpack\0.16.2\0.16.2_AMD64_windows_3.4.3.msgpack -> build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.2
    copying pandas\io\tests\data\legacy_msgpack\0.16.2\0.16.2_x86_64_darwin_2.7.10.msgpack -> build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.2
    copying pandas\io\tests\data\legacy_msgpack\0.16.2\0.16.2_x86_64_darwin_2.7.9.msgpack -> build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.2
    copying pandas\io\tests\data\legacy_msgpack\0.16.2\0.16.2_x86_64_darwin_3.4.3.msgpack -> build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.2
    copying pandas\io\tests\data\legacy_msgpack\0.16.2\0.16.2_x86_64_linux_2.7.10.msgpack -> build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.2
    copying pandas\io\tests\data\legacy_msgpack\0.16.2\0.16.2_x86_64_linux_3.4.3.msgpack -> build\lib.win32-3.6\pandas\io\tests\data\legacy_msgpack\0.16.2
    copying pandas\io\tests\data\banklist.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\DEMO_G.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\DRXFCD_G.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\iris.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\SSHSV1_A.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata3.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata5.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata6.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test1.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test1.csv.bz2 -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test1.csv.gz -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test2.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\tips.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\unicode_series.csv -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\DEMO_G.XPT -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\DRXFCD_G.XPT -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\SSHSV1_A.XPT -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata10_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata10_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata11_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata11_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata12_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata14_118.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata1_114.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata1_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata1_encoding.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata2_113.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata2_114.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata2_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata2_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata3_113.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata3_114.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata3_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata3_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata4_113.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata4_114.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata4_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata4_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata5_113.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata5_114.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata5_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata5_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata6_113.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata6_114.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata6_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata6_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata7_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata7_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata8_113.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata8_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata8_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata9_115.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\stata9_117.dta -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\gbq_fake_job.txt -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\utf16_ex.txt -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\blank.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\blank_with_header.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test1.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test2.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test3.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test4.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\testmultiindex.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\testskiprows.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_converters.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_index_name_pre17.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_multisheet.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_types.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\times_1900.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\times_1904.xls -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\blank.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\blank_with_header.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test1.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test2.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test3.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test4.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\testmultiindex.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\testskiprows.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_converters.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_index_name_pre17.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_multisheet.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_types.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\times_1900.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\times_1904.xlsx -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\blank.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\blank_with_header.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test1.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test2.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test3.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test4.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\testmultiindex.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\testskiprows.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_converters.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_index_name_pre17.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_multisheet.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\test_types.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\times_1900.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\times_1904.xlsm -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\salary.table -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\banklist.html -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\computer_sales_page.html -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\macau.html -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\nyse_wsj.html -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\spam.html -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\valid_markup.html -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\wikipedia_states.html -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\yahoo_options1.html -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\yahoo_options2.html -> build\lib.win32-3.6\pandas\io\tests\data
    copying pandas\io\tests\data\yahoo_options3.html -> build\lib.win32-3.6\pandas\io\tests\data
    creating build\lib.win32-3.6\pandas\io\tests\data\html_encoding
    copying pandas\io\tests\data\html_encoding\chinese_utf-16.html -> build\lib.win32-3.6\pandas\io\tests\data\html_encoding
    copying pandas\io\tests\data\html_encoding\chinese_utf-32.html -> build\lib.win32-3.6\pandas\io\tests\data\html_encoding
    copying pandas\io\tests\data\html_encoding\chinese_utf-8.html -> build\lib.win32-3.6\pandas\io\tests\data\html_encoding
    copying pandas\io\tests\data\html_encoding\letz_latin1.html -> build\lib.win32-3.6\pandas\io\tests\data\html_encoding
    creating build\lib.win32-3.6\pandas\io\tests\test_json\data
    copying pandas\io\tests\test_json\data\tsframe_iso_v012.json -> build\lib.win32-3.6\pandas\io\tests\test_json\data
    copying pandas\io\tests\test_json\data\tsframe_v012.json -> build\lib.win32-3.6\pandas\io\tests\test_json\data
    creating build\lib.win32-3.6\pandas\tests\data
    copying pandas\tests\data\categorical_0_14_1.pickle -> build\lib.win32-3.6\pandas\tests\data
    copying pandas\tests\data\categorical_0_15_2.pickle -> build\lib.win32-3.6\pandas\tests\data
    copying pandas\tests\data\mindex_073.pickle -> build\lib.win32-3.6\pandas\tests\data
    copying pandas\tests\data\multiindex_v1.pickle -> build\lib.win32-3.6\pandas\tests\data
    copying pandas\tests\data\s1-0.12.0.pickle -> build\lib.win32-3.6\pandas\tests\data
    copying pandas\tests\data\s2-0.12.0.pickle -> build\lib.win32-3.6\pandas\tests\data
    copying pandas\tests\data\iris.csv -> build\lib.win32-3.6\pandas\tests\data
    copying pandas\tests\data\tips.csv -> build\lib.win32-3.6\pandas\tests\data
    copying pandas\tests\data\unicode_series.csv -> build\lib.win32-3.6\pandas\tests\data
    copying pandas\tools\tests\cut_data.csv -> build\lib.win32-3.6\pandas\tools\tests
    creating build\lib.win32-3.6\pandas\tseries\tests\data
    copying pandas\tseries\tests\data\cday-0.14.1.pickle -> build\lib.win32-3.6\pandas\tseries\tests\data
    copying pandas\tseries\tests\data\dateoffset_0_15_2.pickle -> build\lib.win32-3.6\pandas\tseries\tests\data
    copying pandas\tseries\tests\data\daterange_073.pickle -> build\lib.win32-3.6\pandas\tseries\tests\data
    copying pandas\tseries\tests\data\frame.pickle -> build\lib.win32-3.6\pandas\tseries\tests\data
    copying pandas\tseries\tests\data\series.pickle -> build\lib.win32-3.6\pandas\tseries\tests\data
    copying pandas\tseries\tests\data\series_daterange0.pickle -> build\lib.win32-3.6\pandas\tseries\tests\data
    UPDATING build\lib.win32-3.6\pandas/_version.py
    set build\lib.win32-3.6\pandas/_version.py to '0.17.1'
    running build_ext
    building 'pandas.lib' extension
    error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": https://visualstudio.microsoft.com/downloads/

    ----------------------------------------
  Rolling back uninstall of pandas
Command "d:\zone\mid\lib\python\virtual_env\data_vis\scripts\python.exe -u -c "import setuptools, tokenize;__file__='C:\\Users\\DBE4A~1.MOR\\AppData\\Local\\Temp\\pip-install-_k7iu0t9\\pandas\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().
replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\DBE4A~1.MOR\AppData\Local\Temp\pip-record-6oyqzxa5\install-record.txt --single-version-externally-managed --compile --install-headers d:\zone\mid\lib\python\virtual
_env\data_vis\include\site\python3.6\pandas" failed with error code 1 in C:\Users\DBE4A~1.MOR\AppData\Local\Temp\pip-install-_k7iu0t9\pandas\

Move ui files into qtpandas directory

Suggested by @zbarge in #7

This will probably have to wait until after we get #23 sorted out.

  • Move files
  • Rewire all files that use ui to reflect that change
  • Compare pytest results to results before move.
    • If stuff breaks fix it.

Qt5 Support?

Has anyone tried to update this to pyQt5? Would anyone else be interested in using it with Qt5?

Set up build testing

Complete build testing setup

In general I have been using Spyder-ide testing rig-out as an template for testing in this repo which is probably why travis.ci says the build is failing.

Travis.ci

  • Create .travis.yml file.
  • integrate into README.md
  • Wire travis.ci to this repo
  • Figure out why it says the build is failing but installs fine from pip.

General

  • Look to Spyder-ide's wiki for information on build testing.
    • Make similar entries in this wiki

Make Python2 friendly

Right now qtpandas is capable of installing in a py27 env but it breaks when run.
python-future is a great resource on making code Py2/3 compatible.

  • any file with a print statement needs the following line in imports
from __future__ import print_function

Delete old branches

There are a handful of old branches that need to get cut. They should be scanned before anything useful. I'll comment on this issue with a list and small summary of the purpose of the branch.

Update for PyQt5

More like a suggestion, than an issue. In short, a lot of QtGui references need to point to QtWidgets in PyQt5. If refactoring is too much of a burden, maybe make PyQt4 a required/bundled module.

Set up appveyor

  • Add appveyor file
  • Integrate into README.md
  • Make sure config is correct and first build passes.

There's wrong in qtpanas.models.DataFrameModel.py

line 557๏ผšself._dataFrame.sort(column, ascending=not bool(order), inplace=True) is wong

when you click the columns name in gui, it will course a misktake which leads to stop working.

in latest pandas verson ,df.sort() has relplaced by df.sort_values,

so, in line 557, it shoud witer like this:
self._dataFrame.sort_values(column, ascending=not bool(order), inplace=True)

Error while installing

python version : Anaconda3 32bit 4.3.1 python 3.6.0
pyqt5 version : 5.9, sip-4.19.3

install failed. I used "pip install qtpandas"
error message includes "failed building wheels for pandas"

Working on Anaconda Python 2.7, Mac OS X 10.11.6 with a little help

Dear James Draper,

Thank you! I had to do two things to get this to work on my machine.
[1] I put the statement
from future import print_function
at the top of the file utils.py.
[2] I inserted the statements
import sys
reload(sys)
sys.setdefaultencoding('latin-1')
near the top of icons_rc.py.

TestApp.py now looks like it runs fine. Again, thanks!

Yours,

m-bob

example not compatible with current pandas

I've suceeded by installing current version by

pip3 install git+https://github.com/draperjames/qtpandas.git

instead of an old version from 2016 by

pip3 install qtpandas

However, running https://github.com/draperjames/qtpandas/blob/master/examples/BasicExample.py failed with

$ python3 BasicExample.py 
Traceback (most recent call last):
  File "BasicExample.py", line 15, in <module>
    from qtpandas.views.DataTableView import DataTableWidget
  File "/home/.../.local/lib/python3.8/site-packages/qtpandas/views/DataTableView.py", line 13, in <module>
    from qtpandas.views.EditDialogs import AddAttributesDialog, RemoveAttributesDialog
  File "/home/.../.local/lib/python3.8/site-packages/qtpandas/views/EditDialogs.py", line 17, in <module>
    from pandas.tslib import NaTType
ModuleNotFoundError: No module named 'pandas.tslib'

My versions:

$ pip3 show pandas qtpandas
Name: pandas
Version: 1.3.4
Summary: Powerful data structures for data analysis, time series, and statistics
Home-page: https://pandas.pydata.org
Author: The Pandas Development Team
Author-email: [email protected]
License: BSD-3-Clause
Location: /home/.../.local/lib/python3.8/site-packages
Requires: python-dateutil, numpy, pytz
Required-by: tabula-py, seaborn, qtpandas
---
Name: qtpandas
Version: 1.0.4
Summary: Utilities to use pandas (the data analysis / manipulation
Home-page: None
Author: None
Author-email: None
License: None
Location: /home/.../.local/lib/python3.8/site-packages
Requires: pytest-cov, pytest, easygui, qtpy, pandas, future, pytest-qt
Required-by: 

model architecture diagram

Excuse me,could you tell me the model architecture diagram of the "qtpandas" modules. I want to transplant it to PyQt5 with Python 3.6.x or greator. With the diagram I could do these work more easily. My Gmail is [email protected]

TestApp is throwing attribute error

When I run TestApp.py I recieve the following error;

C:\Anaconda3\lib\site-packages\qtpandas\encoding.py:21: UserWarning: Detector.Issues importing libmagic - got an error: [WinError 193] %1 is not a valid Win32 application
  warnings.warn("Detector.Issues importing libmagic - got an error: {}".format(e))
Error in sys.excepthook:
Traceback (most recent call last):
  File "C:\Anaconda3\lib\site-packages\qtpandas\excepthook.py", line 32, in excepthook
    tbinfo = tbinfo.decode('utf-8')
AttributeError: 'str' object has no attribute 'decode'

Original exception was:
Traceback (most recent call last):
  File "C:\Users\Lenovo\Documents\GitHub\QtPandas\examples\TestApp.py", line 244, in <module>
    widget.setDataFrame( getCsvData() )
  File "C:\Users\Lenovo\Documents\GitHub\QtPandas\examples\util.py", line 37, in getCsvData
    parse_dates=parse_dates
  File "C:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 498, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "C:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 275, in _read
    parser = TextFileReader(filepath_or_buffer, **kwds)
  File "C:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 590, in __init__
    self._make_engine(self.engine)
  File "C:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 731, in _make_engine
    self._engine = CParserWrapper(self.f, **self.options)
  File "C:\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1103, in __init__
    self._reader = _parser.TextReader(src, **kwds)
  File "pandas\parser.pyx", line 353, in pandas.parser.TextReader.__cinit__ (pandas\parser.c:3246)
  File "pandas\parser.pyx", line 591, in pandas.parser.TextReader._setup_parser_source (pandas\parser.c:6111)
OSError: File b'C:\\Users\\Lenovo\\AppData\\Local\\atom\\app-1.12.6\\testData/test1.csv' does not exist

I think we need to change decode to encode. It should be compatible with py2/3

sip import raises compatibility problems

This is issue link to PR #30

Test current qtpy fix in the following;

- [x] Py35 PyQt4
- [ ] Py35 PyQt5
- [ ] Py34 PySide
    -[ ] without zeex
    -[ ] with zeex
- [ ] Py27 PyQt4
- [ ] Py27 PyQt5

We could also configure travis.ci to do all of this but that is easier said than done. I'm thinking about rigging out a virtual box with some standard parameters so I can actually understand how linux works.
I'll add in more stuff on all this later.

PyQt4/PySide importing

I'm using qtpandas as a module in a PySide project, so I want all the calls from the compat imports to be from PySide.
I also have PyQt4 installed system-wide as well, but it is not going to be imported anywhere in the project. Unfortunately, following the default order, compat tries to import PyQt4 first, it finds it, so classes like QtGui are overwritten by the ones from PyQt4. This makes trouble when later I create objects that are, for instance, a subclass of QtGui.QWidget et similia.
The easy patch for my case is to switch the try cases, but one is simply re-phrasing the problem in this way...
There should be a way to look if one of the modules is already imported, like is done in pyqtgraph:
https://github.com/pyqtgraph/pyqtgraph/blob/develop/pyqtgraph/Qt.py
AFAIU, their Qt module should do the same job as the compat one...

Upgrade pandas dependency to 0.19.1

Many people use the latest version of pandas including myself.

  • Make new branch
  • Try updating the dependency
  • Make list of things that break (if stuff breaks)
  • Fix the broken stuff

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.