Python-Excel Visualization Automation
Краткое
Freelancer Client is hiring: Python-Excel Visualization Automation.
Location: Remote
I need a repeatable Python workflow that connects to my external databases, gathers the required tables, and pushes the refreshed data into Excel while immediately producing data visualisation sheets. The script must:
Open a secure connection to the databases using supplied credentials
Query the specific tables I outline and perform any light cleaning with pandas
Write the results to a new or existing workbook through openpyxl / xlsxwriter
Generate the visualisations right inside the file—charts and graphs that update every time the script is run
Skills: Python, Data Processing, Excel, Data Analysis
Budget: $250–$750 USD
Source: Freelancer Client via Remote / Online. Apply on the source website.
Оригинал
I need a repeatable Python workflow that connects to my external databases, gathers the required tables, and pushes the refreshed data into Excel while immediately producing data visualisation sheets. The script must:
• Open a secure connection to the databases using supplied credentials
• Query the specific tables I outline and perform any light cleaning with pandas
• Write the results to a new or existing workbook through openpyxl / xlsxwriter
• Generate the visualisations right inside the file—charts and graphs that update every time the script is run
I will supply a small sample of the database structure and an Excel template so you can mirror my formatting. The end-to-end run should complete with a single command or scheduled task, with all libraries clearly documented in a requirements.txt file.
Acceptance is straightforward: if I can point the script at my database, run it without manual edits, and receive an updated Excel workbook containing the refreshed data plus the visualisations in their assigned sheets, the job is done.
Локация & Details
Перейти к источнику →About this listing
This remote opportunity was imported from Freelancer and is shown here for discovery. To apply, follow the link to the original posting.