Welcome to the Data-eyes repository! This project is part of a learning journey in Python, designed to help you master data manipulation while creating a practical tool for handling tabular data. Here, you’ll build a web interface to work with structured data files and generate SQL queries, all while keeping things simple and useful.
Data-eyes empowers you to:
- Load and explore tabular data from CSV and JSON files.
- Filter, sort, and analyze data through an intuitive web interface.
- Generate SQL queries based on your actions, exportable for real-world use.
This is a hands-on project to strengthen your Python skills and provide a lightweight alternative to costly business intelligence tools, especially valuable in resource-constrained environments.
-
Data Handling:
- Processes CSV and JSON files using Python’s built-in modules.
- Displays data in a tabular format with basic filtering and sorting capabilities.
-
Web Interface:
- Built with FastAPI for the backend and Jinja2 templates for rendering HTML.
- Markdown descriptions rendered with Markdown-it on the frontend.
-
SQL Generation:
- Translates user actions into SQL queries, stored for export or reuse.
-
Backend:
- Python 3.10+
- FastAPI for the web framework
- Built-in Python modules (
csv,json) for data processing
-
Frontend:
- HTML/CSS for layout and styling
- Jinja2 for templating
- Markdown-it for rendering Markdown content
-
Development Tools:
- Poetry for dependency management
- Ruff for linting
- MyPy for type checking
- Data Loading: Effortlessly import CSV and JSON files to start working with your data.
- Interactive Interface: View your data in a table, apply filters, and sort columns with a few clicks.
- SQL Export: Turn your actions into SQL queries, perfect for use in databases or sharing with others.
Your ideas and efforts are warmly welcomed! Take a look at our Contributing Guide to see how you can:
- Set up the project on your own system
- Follow our development workflow
- Stick to our code style guidelines
- Add new features or improve what’s already there
Here are some ways you could help:
- Add more filtering options to make data exploration even richer.
- Enhance the SQL generator for more complex queries.
- Support additional file formats if you’re feeling inspired.
- Polish the interface to make it even more user-friendly.
This project is brought to you by Hugues Dtankouo, a Senior Full Stack Developer who believes in the power of Python to solve real problems and inspire growth.
📧 Contact: huguesdtankouo@gmail.com
🔗 LinkedIn: Hugues Dtankouo
🔗 GitHub: Hugues-DTANKOUO
- License: MIT License – feel free to use, adapt, and share this work.
- Change Log: CHANGELOG.md – a record of our progress together.
Data-eyes is in its early stages, with the core pieces already in place. Looking ahead, we might:
- Add tools for summarizing data (like totals or averages).
- Improve how we export queries and results.
- Make the interface even smoother and more inviting.
Your thoughts will help guide where we take it next!
Right now, we’re concentrating on:
- Making sure data loading and display work flawlessly.
- Perfecting the SQL generation so it’s accurate and helpful.
- Writing clear documentation to support your learning.
- Testing with real data to ensure it meets your needs.
Thank you for being part of this journey! Let’s build a tool that makes data work for everyone – I can’t wait to see what we create together.