Search Results for "plotting csv data"

sqlite-web is a web-based SQLite database browser written in Python. It lets users open existing SQLite databases or create new ones through a browser interface. The tool can browse table data, inspect database structure, and run arbitrary SQL queries from a dedicated query tab. It also supports common editing actions, including inserting, updating, and deleting rows. Users can add or drop tables, columns, and indexes, and they can import or export data in JSON or CSV format. It can run from the command line, through Docker, or with a higher-performance gevent WSGI server, making it useful for quick database inspection, lightweight administration, and local development workflows.

SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing!

Welcome to the project page for pyDaSSQLiteMan (Python Data and SQLite Manager). This application is a Python Tkinter application designed to enable easy SQLite database file manipulation, and an easy method to run SQL styled queries on CSV files. If you're not downloading the pre-compiled executable you will need Python to run this app. You can download it from http://www.python.org/ .

ExcelToDatabase is an automated tool for batch-importing Excel data into a database. It supports 10 popular databases including MySQL, Oracle, SQL Server, PostgreSQL, and so on. Supported file formats include xls, xlsx, xlsm, xlsb, csv, txt, xml, json, and dbf. Its native user interface brings users a comfortable experience for simplified Excel import and export, making it easier than ever before.

API and command line utility, written in Python, for querying Elasticsearch exporting result as documents into a CSV file. The search can be done using logical operators or ranges, in combination or alone. The output can be limited to the desired attributes. Also ToT can insert the querying to a Pandas Dataframe or/and save its in a HDF5 container (under development).

Project has moved to: https://github.com/OptimalBPM/qal QAL is a collection of libraries for mining, transforming and writing data from and to a number of places. Sources and destinations include different SQL and NoSQL backends, file formats like .csv, XML and excel. Even untidy HTML web pages. It has a database abstraction layer that supports connectivity to Postgres, MySQL, DB2, Oracle, MS SQL server. JSON and MongoDB is coming. It uses XML/JSON formats(self-generated SQL schemas) for representing queries, transformation and merging, making it scriptable. ...

Spools data for a given query or table from 14 databases. Windows command-line application.

A python script that uses wxwidgets. View or edit delimited data.

pyMantis is a data-management system for (systems) biology build on the web2py framework. It features: tree based file explorer, relational db table wizzard with automated creation of user interfaces, internal and external access management, wiki, ..

The csvdatamix project aims to randomize CSV input data files in order to conceal the original state of the data. Similar to data masking or data transformation. Also has mapping abilities to translate back to the original state of the data.

A group a subprojects for Data Cleaning projects, mainly as a step of a Data Mining Project. Visit www.datacleaningopensource.com to review our current applications or if you want to add yours. NOTE: PROGRAMMING SKILLS ARE REQUIRED.