/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 vote147 views1 answer
How to prepare independent and dependent variables from dataframe
Python
5 votes160 views2 answers
Filter dataframe with list
Python
2 votes151 views3 answers
How to copy items from 1 list to another in python
Python
92 votes156 views5 answers
Make a new environment conda
Python
10 votes141 views3 answers
Python print traceback from exception
Python
2 votes195 views2 answers
Django search
Python Django
21 votes162 views1 answer
Jupyter ignore warnings
Python
0 vote156 views1 answer
How to rinstalll re
Python
9 votes150 views3 answers
A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead
Python
3 votes148 views2 answers
Find location of max value in python list
Python