Simple Data Converter - Flask & Simple-DataTables

A simple open-source tool for CSV files: loader, viewer and updater using Flask and Simple-DataTables JS library.

Simple Data Converter - Powered by Flask and Simple-Datatables
Simple Data Converter - Powered by Flask and Simple-Datatables

Hello! This article presents a simple Data Converter codebase powered by Flask and Simple-DataTables JS Library. This experimental project can be used to visualize CSV files using data tables, export in different formats, and edit the information using the console. The source code, published on Github under the MIT license, will be updated to support charts and other conversions (to PDF, to data frames.. etc). Thanks for reading!


✨ Project Features

  • πŸ‘‰ Minimal set up
  • πŸ‘‰ CSV files upload / Visualisation
  • πŸ‘‰ Search, Pagination, Export to JSON, SQL, and Text
  • πŸ‘‰ Edit (via console): Update/Remove/Add columns

New columns can be provisioned using data with different formats: Random Strings, Integers, and Timestamps (UNIX format). Β 

Data Converter - CSV Load in Data Tables.
Data Converter - CSV Load in Data Tables

✨How to start the project

This tool can be compiled and started in any environment that has Python3 and GIT installed.

Step #1 - Clone the sources
$ git clone https://github.com/app-generator/devtool-data-converter.git
$ devtool-data-converter
Data Converter - Clone Sources
Step #2 - Install the dependencies
$ virtualenv env
$ source env/bin/activate
$ pip install -r requirements.txt
Data Converter - Install Dependencies
Step #3 - Start the app
$ flask run
Data Converter - Start the APP

If all goes well, we should be able to visit the app in the browser and visualize the default CSV files shipped with the code (samples directory).


✨Helpers

The project comes with a few basic helpers for CSV data format:

  • csv_print() - print a CSV file to the console
  • csv_col_remove() - remove a column (by name)
  • csv_col_update() - update a column with generated data
  • csv_col_add() - add a new column (generated data)
  • csv_to_json() - CSV to JSON converter

Generated data is generated in different formats: random strings, random integers, and UNIX timestamps.

Print a CVS file
Data Converter - CSV Print
Delete Columns from a CSV file
Data Converter - CSV Delete Columns
CSV Add Content - New column provisioned with random integers
Data Converter - CSV Add Data

Thanks for reading! For more resources, feel free to access: