Hey i wanna create an automation in python. I have some images with datas near 5000 and i want that datas enter to the ecxal file
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 25/100
Research direction
Start by reviewing the provided image, blank Excel template, and the listed column structure and formatting rules. Done means extracting all records accurately, applying the required numbering, date and amount transformations, and populating the structured Excel output.
Written by the indexing model from the issue text.
Description
Help Needed: Extract Data from Image to Excel Format
Description
I have an image containing tabular data with various fields such as sales dates, customer names, dealer names, amounts, phone numbers, and more. I need help extracting this data accurately and populating it into a structured Excel file.
Requirements
Extract all data entries from the provided image.
Use a fixed Form Number (e.g., 12428_000001) for all records on the same page.
Increment Record Numbers starting from 1 for each entry.
Format the Sales Date as MM/DD/YYYY.
Convert Basic Amount values from millions to full numbers (multiply by 1,000).
Calculate Net Amount as the sum of Basic Amount and Insurance Amount.
Fill all other fields exactly as shown in the image.
Maintain data accuracy and formatting.
Column Structure for Excel
FORM NO.
RECORD NO.
SALES DATE
CUSTOMER NAME
INITIALS
E-MAIL ADDRESS
DEALER NAME
CUSTOMER ADDRESS
CITY
STATE
CUSTOMER PHONE
DEALER PHONE
DELIVERY TIME
INVOICE NO.
INSURANCE POLICY NO.
CHESIS NO.
BASIC AMOUNT
INSURANCE AMOUNT
TOTAL AMOUNT (if applicable)
DISCOUNT
NET AMOUNT
Files Provided
Image file containing raw data.
Blank Excel template to fill in.
Additional Notes
Page or form changes should have unique Form Numbers to distinguish data.
Assistance requested for manual extraction or automated process suggestions.
- Dominant language
- Python
- Stars
- 35.4k
- Forks
- 12.9k
- Avg merge
- 2h 37m
- Merged PRs (30d)
- 1
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from geekcomputers/Python
-
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
geekcomputers/Python#3205 · 3 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
geekcomputers/Python#3188 · 3 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
geekcomputers/Python#3060 · 1 comment ·
-
[BUG] shapchat Open
Difficulty 5/5 Over a week Newbie friendliness 10/100
geekcomputers/Python#3214 · 5 comments ·
-
Test of an Issue Open
Difficulty 5/5 Over a week Newbie friendliness 10/100
geekcomputers/Python#3209 · 5 comments ·
All issues in geekcomputers/Python
Similar issues
-
Add: hunch Open
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
AbdelStark/awesome-typesafe#104 ·
-
enhancement
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
DiamondLightSource/dodal#2211 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
openml/openml-python#1749 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
sipyourdrink-ltd/bernstein#6191 ·