Windows support for Apache Arrow is pretty good. There are Python wheels, Python conda packages and a binary build for R on CRAN. One thing that has been missing though for a long time has been a conda package for R Arrow on Windows. Thanks to a lot of experimentation and some important suggestions by Isuru Fernando (Thanks!), we...
When new members join our team, they usually are already fluent in data analysis with
pandasand know their way around the typical quirks. They know that they should use vectorised functions where possible and avoid using
applywith a slow Python callable. There are two main reasons, I teach them the
BlockManagerquite at the beginning....
It has been now nearly two years since the idea came up to use
ExtensionArrayinterface to provide columns in
pandasthat are backed by Apache Arrow.
fletcherwas started as a prototype project to show how this idea can be brought together. Since then there has been quite a lot of development...
While most databases are accessible via ODBC where we have an efficient way via turbodbc to turn results into a
pandas.DataFrame, there are nowadays a lot of databases that either only come solely with a JDBC driver or the non-JDBC drivers are not part of free or open-source offering. To access these databases, you can use JayDeBeApi...
TL;DR: Recently, DuckDB a database that promises to become the SQLite-of-analytics, was released and I took it for an initial test drive. Install it via
conda install python-duckdbor
pip install duckdb.