Скачать или смотреть "Combine Multiple Excel Files into One | Python Excel Automation PART-2

#Python #Excel #Automation #DataAnalysis #Pandas #ExcelTips #PythonForBeginners
Want to combine multiple Excel files into one? 🚀
In this tutorial, I’ll show you step by step how to merge all Excel workbooks into a single file using Python and Pandas.

✅ No manual copy-paste
✅ Works for any number of files
✅ Beginner-friendly explanation
✅ Perfect for Data Analysts, Students, and Business Users

By the end of this video, you’ll be able to automate Excel tasks easily with Python.
PYTHON CODE:
import pandas as pd
import glob
import os

📂 Folder where your split files are saved
folder_path = r"C:\Users\Ramesh\Documents\SplitFiles"

🔍 Get all Excel files in the folder
all_files = glob.glob(os.path.join(folder_path, "*.xlsx"))

Empty list to hold data
dataframes = []

Loop through each file and read into pandas
for file in all_files:
df = pd.read_excel(file) # Read each file
df["Source_File"] = os.path.basename(file) # Optional: add filename column
dataframes.append(df)

Combine all data into one dataframe
combined_df = pd.concat(dataframes, ignore_index=True)

Save to a single Excel file
output_file = os.path.join(folder_path, "Combined_All_Files.xlsx")
combined_df.to_excel(output_file, index=False)

print(f"✅ All files combined into: {output_file}")