Data Converter

Open-Source project that provides simple helpers for data management – provided by AppSeed.

Features

  • CSV Files:
    • Print
    • Columns: Remove, Update
    • Add New Column with random values:
      • timestamp, random_int and random string (via Faker)
    • csv_to_json Helper
  • Support via Github (issues tracker) and Discord.

The project is bundled with a simple Flask app that loads the information from samples/data.csv and presents the information using data tables.

✨ Quick Start

  • Clone the project
  • Install Python modules:
    • pip install -r requirements.txt
  • Start the Flask app
    • The http://localhost:5000/datatables/ route will display the contents of samples/data.csv using data tables.
  • Save your CSV content using the same file
    • samples/data.csv
  • Refresh the http://localhost:5000/datatables/ page

At this point, you should see your data nicely paginated.

Data Converter - Provided by AppSeed.

✨ Complete Set UP

Clone Sources (this repo)

$ git clone https://github.com/app-generator/devtool-data-converter.git
$ cd devtool-data-converter

Install Modules using a Virtual Environment

$ virtualenv env
$ source env/bin/activate
$ pip install -r requirements.txt

Or for Windows-based Systems

$ virtualenv env
$ .\env\Scripts\activate
$
$ # Install modules - SQLite Database
$ pip3 install -r requirements.txt

Set up the environment

$ export FLASK_APP=run.py
$ export FLASK_ENV=development

Or for Windows-based Systems

$ # CMD terminal
$ set FLASK_APP=run.py
$ set FLASK_ENV=development
$
$ # Powershell
$ $env:FLASK_APP = ".\run.py"
$ $env:FLASK_ENV = "development"

Edit sample/data.csv manually or using a Python console:

Open a new terminal, activate the VENV and update the CSV sample using provided helpers:

$ python
>>> 
>>> from util import *
>>> input = 'samples/data.csv'
>>> csv_print( input )

Print only 2 lines

>>> from util import *
>>> input = 'samples/data.csv'
>>> 
>>> csv_print( input ) # print all file
>>> 
csv_print( input, 2 )  # print header and first 2 lines
... 
product_code,product_info,value,currency,type
Nike_Air,Nike Air More Uptempo,105,usd,transaction
Nike_Club,Nike Club Joggers BB,55,usd,transaction

Remove a column from the the CSV file

>>> csv_col_remove( input, 'value' ) # `vaue` is the column name

Add a column to the CSV file

>>> csv_col_add( input, 'value' ) # `vaue` is the column name   


Data Converter – Provided by AppSeed App Generator.

GitHub

View Github