/Python/Pandas reading each xlsx file in folder

Pandas reading each xlsx file in folder

Read all excel using glob

import sys
import csv
import glob
import pandas as pd

# get data file names
path =r'C:\DRO\DCL_rawdata_files\excelfiles'
filenames = glob.glob(path + "/*.xlsx")

dfs = []

for df in dfs: 
    xl_file = pd.ExcelFile(filenames)
    df=xl_file.parse('Sheet1')
    dfs.concat(df, ignore_index=True)

Source: stackoverflow.com

Pandas reading each xlsx file in folder

import pandas as pd
import glob

# your path to folder containing excel files
datapath = "\\Users\\path\\to\\your\\file\\"

# set all .xls files in your folder to list
allfiles = glob.glob(datapath + "*.xls")

# for loop to aquire all excel files in folder
for excelfiles in allfiles:
    raw_excel = pd.read_excel(excelfiles)

# place dataframe into list
list1 = [raw_excel]

Source: stackoverflow.com

Pandas reading each xlsx file in folder

import os
import pandas as pd
import openpyxl as excel
import glob



#setting up path

path = 'data_inputs'
extension = 'xlsx'
os.chdir(path)
files = [i for i in glob.glob('*.{}'.format(extension))]

#Grouping files - brings multiple files of same type together in a list 

wild_groups = ([s for s in files if "wild" in s])
domestic_groups = ([s for s in files if "domestic" in s])

#Sets up a dictionary associated with the file groupings to be called in another module 
file_names = {"WILD":wild_groups, "DOMESTIC":domestic_groups}
...

Source: stackoverflow.com

Similar codes

1 vote245 views1 answer
Import "django.core.urlresolvers" could not be resolved
Python Django
1 vote210 views1 answer
Pyhton built in sort
Python
1 vote225 views1 answer
Django queryset average of unique values
Python Django
113 votes172 views10 answers
Python choose random element from list
Python
30 votes232 views4 answers
Python generate list of random numbers
Python
0 vote223 views1 answer
Python not equal to operation
Python
0 vote201 views1 answer
Import matplotlib submodule 'style'
Python
4 votes199 views3 answers
Python os
Python
-2 votes199 views1 answer
No connection could be made because the target machine actively refused it python
Python
-1 vote215 views1 answer
Map numpy array
Python