Скачать или смотреть How to combine multiple Excel files into one using Microsoft Copilot

Hi guys, welcome back :-)
In this video I will cover the following:
How to combine multiple excel files using ChatGPT and/or Copilot
How to generate the Python script and run it on your computer
How to use the Python dev tool - Thonny

You will not have to upload any Excel data to ChatGPT,
You will not have to upload any Excel files to ChatGPT or Copilot

Here are the steps:
Run the prompt on ChatGPT or Copilot (Note Copilot and ChatGPT use the same AI engine)
Paste the generated script in your Python Tool - Thonny
Run the Python Script.

The Prompt i used in the video:
I have multiple Excel files in a folder named "excel_files". Each excel file contains two columns, a "branch" column and a "monthly revenue" column. I want to merge all the excel files into one file called "merged". Write me a Python script for that.

Here are the sample Excel files I used:
https://drive.google.com/drive/folder...

If you like the video please hit the Link button and subscribe
If you have any questions please leave them in the comments.