Scribd
Upload
2 views13 pages

Day-30-Python-Data Analysis Project Using AI

The document outlines a project to create a professional desktop software using Python, Tkinter, and Pandas for corporate users to analyze Excel or CSV data without coding. It details functional requirements including file selection, dynamic column detection, report building, chart generation, and usability features. The project emphasizes clean code, error handling, and the ability to export reports and charts, ensuring a user-friendly interface for non-technical users.

Uploaded by

mechanicair909
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views13 pages

Day-30-Python-Data Analysis Project Using AI

The document outlines a project to create a professional desktop software using Python, Tkinter, and Pandas for corporate users to analyze Excel or CSV data without coding. It details functional requirements including file selection, dynamic column detection, report building, chart generation, and usability features. The project emphasizes clean code, error handling, and the ability to export reports and charts, ensuring a user-friendly interface for non-technical users.

Uploaded by

mechanicair909
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Day - 30

Data Analysis Project


Using AI

A.I. Powered 30 Days Python Micro Course By Satish Dhawale ( Microsoft Certified Trainer )
ROLE SETTING (Very Important)

• You are an expert Python software developer and data analyst.


• You have strong experience in:
• - Pandas for data analysis
• - Tkinter for GUI applications
• - Matplotlib for charts
• - Building corporate-ready desktop automation tools
PROJECT CONTEXT

• I want to build a professional desktop software (GUI-based) for corporate users.


• The software should allow non-technical users to analyze Excel or CSV data
• without writing any Python code.
FUNCTIONAL REQUIREMENTS
Write a complete Python program using Tkinter and Pandas that does the following:
1️⃣ File Selection & Reading
• - Allow the user to browse and select a CSV or Excel file.
• - Add a separate "Read" button.
• - When the Read button is clicked:
• - Read the full dataset
• - Display:
• - Total number of rows
• - Total number of columns
• - All column headings
2️⃣ Dynamic Column Detection
• - Automatically detect:
• - Text columns (object/string dtype)
• - Numeric columns (int/float or numeric-looking text)
3️⃣ Report Builder (Interactive
Analysis)
• - Provide dropdowns for:
• 1. Group By Column (only text columns)
• 2. Aggregation Method (sum, mean, average, max, min, count, median)
• 3. Value Column (only numeric columns)

• - When user clicks "Preview Report":


• - Apply GroupBy + selected aggregation
• - Sort results in descending order
• - Display the result table inside the GUI (not Excel)
4️⃣ Export Report
• - Add an Export button.
• - Allow export format selection:
• - Excel (.xlsx)
• - CSV (.csv)
• - Export the report automatically into the same folder
• where the input file is located.
- Provide a dropdown to select chart type:
- Bar chart
- Column chart
- Line chart

5️⃣ Chart - Pie chart


- When user clicks "Preview Chart":
Builder (GUI- - Generate the selected chart using the report
Based data
- Display the chart inside the GUI window
Visualization)
- Add "Export Chart" option:
- Export chart as PNG image
- Save it in the same folder as the input file
6️⃣ Usability & Error Handling
• - Show proper error messages if:
• - File is not selected
• - Read button is not clicked
• - Dropdowns are not selected
• - Reset previous outputs when a new report is generated
• - Keep the GUI clean, professional, and easy to use
TECHNICAL CONSTRAINTS
• - Use Tkinter for GUI
• - Use Pandas for data processing
• - Use Matplotlib for charts
• - Write clean, readable, well-commented code
• - Structure the code so it can be converted into a .EXE using PyInstaller
• - Do not require the end user to install Python
DELIVERABLE FORMAT
• - Provide the full Python code in one single block
• - Ensure the program is production-ready
• - Do not omit any required functionality
Clear role definition

Clear problem statement

WHY THIS Step-by-step requirements

PROMPT IS
PERFECT Forces AI to think structurally

Produces enterprise-level code

Teaches real-world AI usage

You might also like