csvsmith documentation¶
csvsmith is a toolkit for cleaning, transforming, and managing CSV-oriented workflows.
It provides both a command-line interface (CLI) and a Python API for building reproducible data processing pipelines.
Example¶
csvsmith excel-to-csv input.xlsx -o output.csv
csvsmith dedupe data.csv -o clean.csv
csvsmith concentrate input.csv
csvsmith sample-csv -o sample.csv --rows 16
csvsmith view sample.csv --head 5
csvsmith knapsack sample.csv value 2036 -o marked.csv
csvsmith clean-currency-numeric '$1,234.56'
Getting started¶
Tools¶
Python API¶
- Python API
- csvsmith package
CSVClassifierConcentrateResultDataFrameDropRowsBySubstringKnapsackCSVResultRehydrateResultRelationResultSampleCSVResultStringDistanceStripBomResultadd_row_digest()analyze_pair()build_filter()clean_numeric()concentrate_csv()count_duplicates_sorted()create_sample_csv()dedupe_with_report()excel_to_csv()find_duplicate_rows()find_knapsack_indices()find_matches_in_csv()infer_type()mark_knapsack_csv()move_by_suffix()read_csv_rows()rehydrate_csv()save_csv()strict_concat_rows()strip_utf8_bom()write_csv_rows()
- csvsmith.tools
- csvsmith.utils