CODEWITHSUNDEEP
pythonexcelpandasmerging-data
jordan23
jordan23

Reputation: 73

Merging iqy files with python

currently I extracted data from sharepoint and have .iqy files that I can open with excel. There are about 30 files and I am trying to merge all the information into one .iqy file or excel file with python.

import os, glob
import pandas as pd

files = []
for file in os.listdir("C:\\Users\\CHI86786\\Downloads"):
    files.append(file)

excels = [pd.ExcelFile(name) for name in files]
frames = [x.parse(x.sheet_names[0], header=None, index_col=None) for x in excels]

frames[1:] = [df[1:] for df in frames[1:]]

combined = pd.concat(frames)
combined.to_excel("SPmerged.iqy", header=False, index=False)

took a same approach as if I would merge excel files. but I keep getting an error that reads FileNotFoundError: [Errno 2] No such file or directory: 'desktop.ini'

EDIT

more of the error message

File "C:\Users\CHI\source\repos\MergingExcel\MergingExcel\MergingExcel.py", line 8, in <module>
    excels = [pd.ExcelFile(name) for name in files] #reads names in
  File "C:\Users\CHI86786\source\repos\MergingExcel\MergingExcel\MergingExcel.py", line 8, in <listcomp>
    excels = [pd.ExcelFile(name) for name in files] #reads names in
  File "C:\Users\CHI\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\excel.py", line 394, in __init__
    self.book = xlrd.open_workbook(self._io)
  File "C:\Users\CHI\AppData\Local\Programs\Python\Python37-32\lib\site-packages\xlrd\__init__.py", line 116, in open_workbook
    with open(filename, "rb") as f:
FileNotFoundError: [Errno 2] No such file or directory: 'desktop.ini'

Upvotes: 2

Views: 2385

Answers (1)

miken32
miken32

Reputation: 42716

Your code is trying to act on every file in C:\Users\CHI86786\Downloads, including system files like "desktop.ini".

Instead, try restricting it to the files you're interested in using glob:

for file in glob.glob("C:\\Users\\CHI86786\\Downloads\\*.iqy")

Upvotes: 1

Related Questions