Contents

### Contents

  * [Introduction](./_introduction.md)
  * [The Basic API](./basic_api.md)
  * [Batch Processing](././batch_processing.md)
  * [Configuration Options](./options.md)
  * [Row and Column Separators](./row_col_sep.md)
  * [Header Transformations](./header_transformations.md)
  * [Header Validations](./header_validations.md)
  * [**Data Transformations**](./data_transformations.md)
  * [Value Converters](./value_converters.md)
    
--------------    

# Data Transformations

SmarterCSV automatically transforms the values in each colum in order to normalize the data.
This behavior can be customized or disabled.

## Remove Empty Values
`remove_empty_values` is enabled by default
It removes any values which are `nil` or would be empty strings.

## Convert Values to Numeric
`convert_values_to_numeric` is enabled by default. 
SmarterCSV will convert strings containing Integers or Floats to the appropriate class.

## Remove Zero Values
`remove_zero_values` is disabled by default.
When enabled, it removes key/value pairs which have a numeric value equal to zero.

## Remove Values Matching
`remove_values_matching` is disabled by default. 
When enabled, this can help removing key/value pairs from result hashes which would cause problems. 

e.g.
 * `remove_values_matching: /^\$0\.0+$/` would remove $0.00 
 * `remove_values_matching: /^#VALUE!$/` would remove errors from Excel spreadsheets 

## Empty Hashes

It can happen that after all transformations, a row of the CSV file would produce a completely empty hash.

By default SmarterCSV uses `remove_empty_hashes: true` to remove these empty hashes from the result.

This can be set to `true`, to keep these empty hashes in the results.

-------------------
PREVIOUS: [Header Validations](./header_validations.md) | NEXT: [Value Converters](./value_converters.md)

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
smarter_csv-1.12.1	docs/data_transformations.md
smarter_csv-1.12.0	docs/data_transformations.md