Breaking News: Grepper is joining You.com. Read the official announcement!

pandas reading each xlsx file in folder

Vast Vole answered on October 2, 2020 Popularity 3/10 Helpfulness 1/10

answer pandas reading each xlsx file in folder

related pandas reading each xlsx file in folder

pandas reading each xlsx file in folder

Comment

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}
...

Popularity 3/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: each file pandas python xlsx

Link to this answer
Share Copy Link

Contributed on Oct 02 2020

Vast Vole

0 Answers Avg Quality 2/10

Closely Related Answers

pandas reading each xlsx file in folder

Comment

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]

Popularity 4/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: each pandas python file xlsx

Link to this answer
Share Copy Link

Contributed on Oct 02 2020

Vast Vole

0 Answers Avg Quality 2/10

pandas reading each xlsx file in folder

Contents

More Related Answers

pandas reading each xlsx file in folder

Closely Related Answers

pandas reading each xlsx file in folder

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.