# CSV Compare
This is a very basic tool used for plotting and comparing csv data from two separate csv files.
## Usage
A version of the jupyter notebook is hosted at [mybinder.org](https://mybinder.org/v2/gh/mitchute/energyplus-diff-analysis/main)
*How is this used?*
1. Open the binder (https://mybinder.org/v2/gh/mitchute/energyplus-diff-analysis/main). This may take a few minutes to build and load the container images running behind the scenes. Once completed, mybinder.org will launch the jupyter dashboard in your web browser. This looks like a file explorer.
2. Launch the "Make_Plots.ipynb" jupyter notebook by clicking on it from the jupyter dashboard. This will launch a new tab in your browser with this notebook loaded and running.
3. Upload your data by clicking "upload" from the jupyter dashboard. For example, you could upload and name your baseline csv file "base.csv", and your modified version csv "mod.csv".
4. Back over on the "Make_Plots" jupyter notebook, update the names of your baseline and modified csv data files to match what you uploaded.
5. Select how you want your data plotted. See the examples section below for additional information.
6. To execute, you can select Cell >> Run All (or other available options). You can also run individual cells with the "shift+return" command."
## Examples
### Example 1 - Plotting all columns with diffs
As described, this plots all columns
```plot(baseline_path, mod_path, output_path)```
### Example 2 - Plot only one series
If you only want to plot a single column from the csv data, the column name can be passed explicitly to the ```cols``` field.
```plot(baseline_path, mod_path, output_path, cols="Col Name 1")```
### Example 3 - Plot a selected set of columns from the csv data
The ```cols``` field also accepts a list input for when you want to plot more than one column, but not all of them.
```plot(baseline_path, mod_path, output_path, cols=["Col Name 1", "Col Name 2"])```
### Example 4 - Plot one series for a specified number of rows
You may also specify the range of rows you want to plot.
```plot(baseline_path, mod_path, output_path, cols="Col Name 1", low_row_num=10, high_row_num=20)```
### Example 5 - Only plot files with diffs
To plot all files with including files without diffs, you can add the `plot_all_series` flag and set it to `True`.
```plot(baseline_path, mod_path, output_path, plot_all_series=True)```
### Example 6 - Zip plots
You can also zip your plots once plotting is complete for easier downloading.
```plot(baseline_path, mod_path, output_path, create_archive=True)```
## Command Line Interface
There's also a command line interface.
```bash
$ energyplus_diffs --help
Usage: eplus-diff [OPTIONS] BASELINE_CSV MODIFIED_CSV OUTPUT_DIR
Options:
-p, --plot-all-series Plot all series including series without diffs
-a, --create-archive Create archive of plots afterwards
--help Show this message and exit.
```
