Tooling - Revision history

DRW: /* Data tools */ Add "Modern CSV" and tips for safely editing CSVs in Excel

2023-07-20T19:07:11Z

Data tools: Add "Modern CSV" and tips for safely editing CSVs in Excel

← Older revision		Revision as of 19:07, 20 July 2023
Line 1:		Line 1:
	== Data tools ==		== Data tools ==
	* [https://www.visidata.org/ VisiData] - Terminal user interface for a data exploration/manipulation tool that can handle large datasets.		* [https://www.visidata.org/ VisiData] - Terminal user interface for a data exploration/manipulation tool that can handle large datasets.
			** If you REALLY don't want to use VisiData because you don't want to use the terminal, [https://www.moderncsv.com/ Modern CSV] looks like a decent CSV editor that can handle large files and won't mangle your CSV file (unlike Excel).
			*** If, in a pinch, you absolutely have to use Excel to edit a CSV file (which you really shouldn't), 1) make a copy of your CSV file, saving it as a text file (with the "txt" extension), 2) open it in Excel using the text import function, and 3) make all of the fields text fields. 4) Edit the file in Excel. 5) When finished "Save as..." a CSV file.
	* [https://github.com/jqnatividad/qsv qsv] - "command line program for indexing, slicing, analyzing, splitting, enriching, validating & joining CSV files. Commands are simple, fast and composable." Forked from xsv by CKAN Joel, so it's got some CKAN-specific features in the works.		* [https://github.com/jqnatividad/qsv qsv] - "command line program for indexing, slicing, analyzing, splitting, enriching, validating & joining CSV files. Commands are simple, fast and composable." Forked from xsv by CKAN Joel, so it's got some CKAN-specific features in the works.

DRW: /* Data tools */

2022-03-22T20:19:57Z

Data tools

← Older revision		Revision as of 20:19, 22 March 2022
Line 1:		Line 1:
	== Data tools ==		== Data tools ==
	* [https://www.visidata.org/ VisiData] - Terminal user interface for a data exploration/manipulation tool that can handle large datasets.		* [https://www.visidata.org/ VisiData] - Terminal user interface for a data exploration/manipulation tool that can handle large datasets.
	* [https://github.com/jqnatividad/qsv qsv] - "command line program for indexing, slicing, analyzing, splitting, enriching, validating & joining CSV files. Commands are simple, fast and composable."		* [https://github.com/jqnatividad/qsv qsv] - "command line program for indexing, slicing, analyzing, splitting, enriching, validating & joining CSV files. Commands are simple, fast and composable." Forked from xsv by CKAN Joel, so it's got some CKAN-specific features in the works.

	=== Anonymization ===		=== Anonymization ===

DRW: Add Tooling page

2022-03-22T20:16:44Z

Add Tooling page

New page

== Data tools ==
* [https://www.visidata.org/ VisiData] - Terminal user interface for a data exploration/manipulation tool that can handle large datasets.
* [https://github.com/jqnatividad/qsv qsv] - "command line program for indexing, slicing, analyzing, splitting, enriching, validating & joining CSV files. Commands are simple, fast and composable."

=== Anonymization ===
* [https://www.open-diffix.org/ Open Diffix] - Free, open-source desktop tool (and eventually Postgres extension) for anonymizing data.

[[Category:Onboarding]]