This is my TestWorkbook.xlsx in same location as my python script:
Data Time Variable Value
08/01/17 06:00:30 Occupancy.1m.15s.mean 497.714
08/01/17 06:00:30 QueueTime.1m.15s.mean 698.999
08/01/17 06:00:30 QueueStatus.1m.15s.mean 42.8639
08/01/17 06:00:30 QueueTime.1m.15s.mean 113.139
import pandas as pd
import numpy as np
import glob
all_data = pd.DataFrame()
res = glob.glob("*.xlsx")
for f in glob.glob("TestWorkbook.xlsx"):
df = pd.read_excel(f, sheetname='Sheet1')
all_data = all_data.append(df, ignore_index=True)
all_data.describe()
Not sure why it is returning error
raise ValueError("Cannot describe a DataFrame without columns")
ValueError: Cannot describe a DataFrame without columns
Comment From: jreback
pls show a reproducible example.
and this is completely non-performant, instead append the frames to a list then use pd.concat.
you are merely seeing this (IOW, there is no data).
In [2]: pd.DataFrame().describe()
---------------------------------------------------------------------------
ValueError Traceback (most recent call last)
<ipython-input-2-e81e6dc1b4a2> in <module>()
----> 1 pd.DataFrame().describe()
/Users/jreback/pandas/pandas/core/generic.py in describe(self, percentiles, include, exclude)
5496 raise NotImplementedError(msg)
5497 elif self.ndim == 2 and self.columns.size == 0:
-> 5498 raise ValueError("Cannot describe a DataFrame without columns")
5499
5500 if percentiles is not None:
ValueError: Cannot describe a DataFrame without columns
Comment From: scheung38
Hi @jreback I am just following the exact example from http://pbpython.com/excel-file-combine.html
Comment From: jreback
@scheung38 and? just because its on the web doesn't meet its a good example!
I would guess that you are simply not reading in any data (e.g. the glob doesn't return any files)