I receive information in Telegram with the client ID and the purchase amount. If a client makes purchases multiple times, a new message arrives each time, but the ID remains the same. As a result, there are several purchases for each client. I need the resulting bot to place the ID in the first column, and all other columns to the right should be filled with their amounts. So that in the end, all IDs are on the left, and their purchase amounts go to the right, allowing me to easily track the total purchases for each user.

The file is exported from Telegram in JSON format. The data needs to be imported into an Excel table.

Proposals 10 Discussions 1

Svyatoslav Galygin

1 0

Projects -
Rating -
Rating 149

Budget: 10000 UAH Deadline: 3 days

Hello!

I am ready to develop a script/parser for processing data from Telegram and distributing it into an Excel spreadsheet in the specified format. I have experience working with JSON files, integrating with Telegram, and automating data processing for output to Excel.

What will be done:
1. **Processing JSON files**: the script will extract data (client ID and purchase amounts) from Telegram JSON.
2. **Data grouping**: for each unique ID, the sums of all their purchases will be collected.
3. **Generating Excel spreadsheet**:
- First column: unique client IDs.
- Subsequent columns: purchase amounts arranged in chronological order.
- Calculation of the total amount for each client (upon request).
4. **Automation**: the script will be ready for regular processing of new files.
5. **Ease of execution**: the solution will work through an interface (if needed) or can be executed with a single command.

Tools:
- Python (pandas for working with tables, openpyxl for Excel, json for data processing).
- Ready to set it up on your device.

I guarantee high-quality execution of the task in the shortest possible time. I am ready to discuss additional details and requests.

Best regards, Svyatoslav

Ihor Pavlenko

4 0

Projects 4
Rating -
Rating 687

Budget: 800 UAH Deadline: 1 day

Hello, I can implement it in Python, the output will be an Excel file with the data in the required format. I have already done a similar task.

Oleh Ovchynnykov

52 1

Budget: 1000 UAH Deadline: 1 day

Good day
I am ready to complete this work
Write to me
I will be happy to help

Dmitro A.

5 0

Projects 5
Rating -
Rating 224

Budget: 500 UAH Deadline: 1 day

Good afternoon. I can develop such a script for you in Python. We can discuss all the details in private messages.

Olksandr Kazarov

3 1

Projects 3
Rating -
Rating 449

Budget: 8800 UAH Deadline: 5 days

Hello! I am ready to complete your project for creating a script to process data from Telegram and distribute it into Excel. Here’s how I propose to organize the process:

What will be done:
Processing the JSON file from Telegram:

The script will automatically extract the client ID and purchase amounts from the JSON.
It will handle duplicate IDs so that for each client, the purchase amounts are displayed in separate columns.
Creating an Excel table:

Table format: the first column will be the client ID, and the subsequent columns will be the purchase amounts.
All data will be neatly structured for convenient analysis.
Advantages of my solution:

Automation: you just need to upload the JSON file, and the script will do everything by itself.
Flexibility: the ability to easily adapt to other data formats or additional requirements.
Accuracy: I will take into account all the nuances of working with duplicate IDs and empty values.
Technical implementation:
Language: Python.
Libraries: pandas for data processing and openpyxl for working with Excel.
Optimization of the script for fast execution even with large volumes of data.

I would be happy to collaborate! If there are any additional requests, I am ready to consider them in my work.