Excel and CSV interfaces¶
effectus comes with program line binaries to work directly with:
- CSV files
- an Excel selection
CSV Files¶
Run the program make_summary on the program line directly on a CSV file:
$ curl -O https://bitbucket.org/hyllos/effectus-python/raw/default/effectus/data/missing_teeth.csv
$ make_summary missing_teeth.csv
Pareto True
Ratio 0.917
Causes 1/5
Effects 2/3
Variability 0.04
If there is only one column, it will consider each value as such.
If there is more than one column, it will consider the second as the frequency of the values in the first (the last example).
If the third column carries the frequencies, use --frequencies 3
. The option --observations
works accordingly.
If you use --frequencies -1
, no frequencies will be considered at all (each observation is counted once).
Note
Use write_reduced_values()
to reduce values to value frequency mappings and write them to a CSV file.
Excel Selection¶
If you have one column with values or one with values and another with frequencies, select them and execute on the program line
$ make_summary_xl
Pareto True
Ratio 0.917
Causes 1/5
Effects 2/3
Variability 0.04
Watch a video tutorial.