Search Results for "excel database"

AI Data Science Team is a Python library and agent ecosystem designed to accelerate and automate common data science workflows by modeling them as specialized AI “agents” that can be orchestrated to perform tasks like data cleaning, transformation, analysis, visualization, and machine learning. It provides a modular agent framework where each agent focuses on a step in the typical data science pipeline — for example, loading data from CSV/Excel files, cleaning and wrangling messy datasets, engineering predictive features, building models with AutoML, connecting to SQL databases, and producing visual outputs — all driven by natural language or programmatic instructions. The project includes ready-to-use applications that showcase these agents in action, such as an exploratory data analysis copilot that generates reports, a pandas data analyst that combines wrangling and plotting, and SQL database agents that can query business databases and output results directly.

Data Preprocessing Automation is a Python-based GUI application designed to simplify and automate data preprocessing tasks. It allows users to upload Excel files, automatically handle missing values, remove duplicates, and detect and remove outliers using statistical methods. The application provides data visualization tools, including box plots for distribution analysis and scatter plots for exploring relationships between variables. Users can download the processed data for further...

A user-friendly application to efficiently sort all types of files from a source folder into a destination folder based on a list of filenames provided in an Excel or CSV file.

csv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. ...

LibreOffice is a free and powerful office suite, and a successor to OpenOffice. Its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. LibreOffice is Free and Open Source Software (FOSS) – development is open to new talent and new ideas, and our software is tested and used daily by a large and devoted user community. Your documents will look professional and clean, regardless of their purpose: a letter, a master thesis, a brochure,...

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. This means that QAL can be backend agnostic about a subset of SQL features and data types. ...

You assemble *blocks* in your django template, with each block wired to a tastypie resource, which in turn is mapped to a django model. Each *block* will reside in a dijit ContentPane which you must define in your template. You have a choice of 2 layouts for each *block*, Form or Grid based. Form displays a single record in either a 1, 2 or 3 column layout while Grid displays many rows in a spreadsheet like grid. You can perform edits in place on fields in both layouts. You can...

This application allows bulk import and exports between Banner EPAFs and Excel spreadsheets. Despite what your sales rep told you, doing EPAFs in Excel and then importing them into Banner is no easy task. Each EPAF can have a variable number of rows in variable number of tables and transaction numbers must be carefully kept in sync among all of these rows and records. WindEPAF takes this difficult and error-prone process and makes it easy.

Excel Spy is GUI application which is intended for office use . It features searching in multiple excel files (.xls format) and save search results instantly . Files containing results can immediately be accessed directly for editing.

Generating Excel 97+ files with Python 2.4+ (need decorators), importing Excel 95+ files, support for UNICODE in Excel files, using variety of formatting features and printing options, Excel files and OLE2 compound files dumper. No need in Windows/COM

PythonOffice is a Python API for the Ms XML (Excel) Spreadsheet format. It allows you to read and write Excel XML documents from within the Python programming language. In future, support for other formats is planned, including OOo, Ms Open Xml.

pyXLWriter is a Python library for generating Excel compatible spreadsheets. It's a port of John McNamara's Perl Spreadsheet::WriteExcel 1.0 module (see http://www.cpan.org) to Python. Requires Python 2.1+. [Project was stopped]