Open and read multiple xml files from the folder

Question

the below holder have 100+ XML files. I have to open and read all those files.

F:\Process\Process_files\xmls

So far, I did the below code to open single XML file from the folder. What I need to change to open/read all the XML files from the folder.

from bs4 import BeautifulSoup
import lxml
import pandas as pd

infile = open("F:\\Process\\Process_files\\xmls\\ABC123.xml","r")
contents = infile.read()
soup = BeautifulSoup(contents,'html.parser')

score 3 · Answer 1 · answered Sep 13 '18 at 09:23

Use the glob and the os module to iterate over every file in a given path with a given file extension:

import glob
import os

path = "F:/Process/Process_files/xmls/"

for filename in glob.glob(os.path.join(path, "*.xml")):
    with open(filename) as open_file:
        content = open_file.read()

    soup = BeautifulSoup(content, "html.parser")

Tip: Use the with statement so the file gets automatically closed at the end.

Source: Open Every File In A Folder

score 0 · Answer 2 · answered Sep 13 '18 at 09:23

So you need to iterate over files in the folder? You can try something like this:

for file in os.listdir(path):
    filepath = os.path.join(path, file)
    with open(filepath) as fp:
        contents = fp.read()
        soup = BeautifulSoup(contents, 'html.parser')

Open and read multiple xml files from the folder

2 Answers2