Bacchas: Created page with "

 import glob import os import pandas as pd file = input('File Path: ') pth = os.path.dirname(file) extension = os.path.splitext(file)[1] print(pth) files = glob.glob(os.p..."

2020-09-02T22:16:17Z

Created page with "<pre> import glob import os import pandas as pd file = input('File Path: ') pth = os.path.dirname(file) extension = os.path.splitext(file)[1] print(pth) files = glob.glob(os.p..."

New page

<pre>
import glob
import os
import pandas as pd
file = input('File Path: ')
pth = os.path.dirname(file)
extension = os.path.splitext(file)[1]
print(pth)
files = glob.glob(os.path.join(pth, '*.xls*'))
files

df = pd.DataFrame()

for f in files:
data = pd.read_excel(f)
df = df.append(data)

set(df['PDF Filename'])
df.to_excel("combined_files.xlsx")

df.shape
</pre>

==[[#top|Back To Top]] - [[Python|Main Category]]/[[Python_Excel_Related| Excel Category]]==
[[Category:Python]]

Combine multiple excel files into One - Revision history

Bacchas: Created page with "
import glob import os import pandas as pd file = input('File Path: ') pth = os.path.dirname(file) extension = os.path.splitext(file)[1] print(pth) files = glob.glob(os.p..."