data-analysis-guidelines

data-analysis-guidelines copied to clipboard

Add basic setup for database-backed analysis

1

`pip` install `sqlalchemy` and `psycopg2`. Then, in your Pweave markdown (`.pmd`) or Pweave TeX (`.ptexw`) file: Import pandas and sqlalchemy, and connect to your database. ```python = import pandas as...

hancush

we have instructions for pweave with atom. @fgregg, care to add your emacs setup to the setup guide, too?

hancush

Pick best DataFrame to X format table option

1

Some ideas: - [tabulate](https://pypi.python.org/pypi/tabulate) - [pytablewriter](http://pytablewriter.readthedocs.io/en/latest/) Requirements: - Must support Markdown and LaTeX table formats

hancush

for multi-part analyses, figure out a pattern to set up an environment once, and import it to all pweave files

1

i've tried a `setup.py` file in the `analyses/` dir, as well as an `environment` module. both led to weird import problems when compiling the analysis versus developing in atom.

hancush

[lfs](https://git-lfs.github.com/) is a cool open-source tool from atlassian that's been adopted by git clients like github and makes dealing with big ol' files a breeze. add some language about it.

hancush

Research indicates 1.5.3

hancush

To use pweave, first write an input file (Pweave markdown, Pweave LaTeX, etc.) with code enclosed in `noweb` syntax (that's `=` on a new line at the top and `@`...

hancush