What do you want to save?
Add Code snippet
New code examples
-
Python 2021-11-14 23:17:13
how to combine number of excel files into a single file using python or pandas
import os import pandas as pd cwd = os.path.abspath('') files = os.listdir(cwd) df = pd.DataFrame() for file in files: if file.endswith('.xlsx'): df = df.append(pd.read_excel(file), ignore_index=True) df.head() df.to_excel('total_sales.xl... Add solution
Best helpers
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5
+5