Menu
Installations methods include:
These instructions document the installation of Python 3. The version of Python that ships with OS X is great for learning, but it’s not good for development. The version shipped with OS X may be out of date from the official current Python release, which is considered the stable production version.
Methods differ in ease of use, coverage, maintenance of old versions,system-wide versus local environment use, and control. With pip or Anaconda’sconda, you can control the package versions for a specific project to preventconflicts. Conda also controls non-Python packages, like MKL or HDF5. Systempackage managers, like
apt-get
, install across the entire computer, oftenhave older versions, and don’t have as many available versions. Sourcecompilation is much more difficult but is necessary for debugging and development.If you don’t know which installation method you need or prefer, we recommendthe Scientific Python Distribution Anaconda .Jul 03, 2017 Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby) - Duration: 1:00:27. Keith Galli 368,730 views. When using python in IDLE on Mac, each python installation has it’s own /lib/site-packages for 3rd party modules. Depending on your installation method (using the regular pip install package-name ) terminal won’t allow you to import them when using IDLE. Xlwings comes pre-installed with Anaconda.If you are new to Python or have troubles installing xlwings, Anaconda is highly recommended. Otherwise you can also install it manually with pip. Pandas is a Python package that provides fast, flexible, and expressive data structures designed to make working with structured (tabular, multidimensional, potentially heterogeneous) and time series data both easy and intuitive. It aims to be the fundamental high-level building block for doing practical, real world data analysis in Python. Additionally, it has the broader goal of becoming.
Scientific Python Distributions (recommended)¶
Python distributions provide the language itself, along with the most commonlyused packages and tools. These downloadable files require little configuration,work on almost all setups, and provide all the commonly used scientific python tools.
Pycharm
Anaconda works on Windows, Mac, andLinux, provides over 1,500 Python/R packages, and is used by over 15 millionpeople. Anaconda is best suited to beginning users; it provides a largecollection of libraries all in one.
For more advanced users who will need to install or upgrade regularly,Miniconda is a moresuitable way to install the conda package manager.
Other options include:
- WinPython: Another free distributionincluding scientific packages and the Spyder IDE; Windows only, but moreactively maintained and supports the latest Python 3 versions.
- Pyzo: A free distribution based on Anaconda andthe IEP interactive development environment; Supports Linux, Windows, and Mac.
Installing via pip¶
Python comes with an inbuilt package management system,pip. Pip can install, update, or deleteany official package.
You can install packages via the command line by entering:
We recommend using an user install, sending the
--user
flag to pip.pip
installs packages for the local user and does not write to the systemdirectories. Preferably, do not use sudopip
, as this combination can cause problems.Pip accesses the Python Package Index, PyPI , whichstores almost 200,000 projects and all previous releases of said projects.Because the repository keeps previous versions, you can pin to a version andnot worry about updates causing conflicts. Pip can also install packages inlocal virtualenv, or virtual environment.
Install system-wide via a package manager¶
System package managers can install the most common Python packages.They install packages for the entire computer, often use older versions,and don’t have as many available versions.
Ubuntu and Debian¶
using apt-get:
Fedora 22 and later¶
using dnf:
Mac¶
Mac doesn’t have a preinstalled package manager, but there are a couple ofpopular package managers you can install.
For Python 3.5 with Macports , execute thiscommand in a terminal:
Homebrew has an incomplete coverage of the SciPy ecosystem,but does install these packages:
Source packages¶
You can build any of the packages from source. Those involved in developmentmay take this route to get developmental versions or alter source code.Refer to individual projects for more details.
Binaries¶
Binary files can directly install the packages. These can either come from thedirect source, like GitHub or PyPI ,or third-party repositories. Linux operating systems, like Ubuntu ,have package repositories where you can search for and download individual binaries.For Windows, Christoph Gohlke provides pre-built Windows installersfor many packages.
Prerequisites¶
- xlwings requires an installation of Excel and therefore only works on Windows and macOS. Note that macOS currently does not support UDFs.
- xlwings requires at least Python 3.6.
Last version of xlwings to support
- Python 3.5: 0.19.5
- Python 2.7: 0.16.6
Installation¶
xlwings comes pre-installed with Anaconda. If you are new to Python or have troubles installing xlwings, Anaconda is highly recommended. Otherwise you can also install it manually with pip:
or conda: Microsoft windows server 2008 r2 x64 torrent.
Note that the official
conda
Civ 6 dlc mac torrent. package might be few releases behind. You can, however,use the conda-forge
channel (replace install
with upgrade
if xlwings is already installed):Note
When you are on macOS and are installing xlwings with
conda
(or use the version that comes with Anaconda),you’ll need to run $xlwingsrunpythoninstall
once to enable the RunPython
calls from VBA. This is done automatically if you install the addin via $xlwingsaddininstall
.Add-in¶
To install the add-in, run the following command:
To call Excel from Python, you don’t need an add-in. Also, you can use a single file VBA module instead of the add-in. For more details, see Add-in & Settings.
Garageband 6.0.5 mac. Note
The add-in needs to be the same version as the Python package. Make sure to re-install the add-in after upgrading the xlwings package.
Dependencies¶
- Windows:
pywin32
,comtypes
- Mac:
psutil
,appscript
The dependencies are automatically installed via
conda
or pip
.How to activate xlwings PRO¶
xlwings PRO offers access to additional functionality. All PRO features are marked with xlwings PRO in the docs.
Python Download Mac
Note
To get access to the additional functionality of xlwings PRO, you need a license key and at least xlwings v0.19.0. Everything under the
xlwings.pro
subpackage is distributed under a commercial license. See xlwings PRO for more details.To activate the license key, run the following command:
This will store the license key under your
xlwings.conf
file in your home folder. Alternatively, you can also store the license key under an environment variable with the name XLWINGS_LICENSE_KEY
.xlwings PRO requires additionally the
cryptography
and Jinja2
packages which come pre-installed with Anaconda. Otherwise, install them via pip or conda.With pip, you can also run
pipinstall'xlwings[pro]'
which will take care of the extra dependencies for xlwings PRO.Optional Dependencies¶
- NumPy
- Pandas
- Matplotlib
- Pillow/PIL
- Flask (for REST API)
- cryptography (for xlwings PRO)
- Jinja2 (for xlwings PRO)
These packages are not required but highly recommended as they play very nicely with xlwings. They are all pre-installed with Anaconda. With pip, you can install xlwings with all optional dependencies as follows:
Update¶
To update to the latest xlwings version, run the following in a command prompt:
or:
Make sure to keep your version of the Excel add-in in sync with your Python package by running the following (make sure to close Excel first):
Uninstall¶
To uninstall xlwings completely, first uninstall the add-in, then uninstall the xlwings package using the same method (pip or conda) that you used for installing it:
Then
or:
Finally, manually remove the .xlwings directory in your home folder if it exists.