missing columns by read_excel

Question

I have to read an Excel file with multiple sheets, all sheets have the same structure, all have 152 columns, but pandas doesn't read the full structure of a sheet, read only 97 columns of 152, any ideas?

I use this simple code

    def read_excel(self, header=0):
        self._excel = pd.read_excel(io=self.path_read,
                                    sheet_name=self.sheets,
                                    header=header
                                    )

How do you specify the name of the 'sheet' you want to read? — LoukasPap, Feb 03 '21 at 15:45
Does this answer your question? [Using Pandas to pd.read\_excel() for multiple worksheets of the same workbook](https://stackoverflow.com/questions/26521266/using-pandas-to-pd-read-excel-for-multiple-worksheets-of-the-same-workbook) — LoukasPap, Feb 03 '21 at 16:18
Are you sure it does not read the whole excel? Does any error come out? Have you tried `df.shape` to see the exact number of rows & columns? — LoukasPap, Feb 05 '21 at 13:40
And another question. Do you store each sheet to a different dataframe? And please, provide the `header` variable in your post. — LoukasPap, Feb 05 '21 at 13:42
Thanks for all, I've solved this, the problem was Windows Security config — Sebastián Martínez, Feb 08 '21 at 20:21
Nice. Now that you solve it, you can post your solution as the answer, so others can be helped, if they stuck at the same problem. — LoukasPap, Feb 08 '21 at 20:55

score 0 · Answer 1 · answered Feb 09 '21 at 21:23

0

I've solved this horrible problem; the problem was Windows Security config that makes impossible to read the full Excel. A simple solution is to run the code as administrator.

answered Feb 09 '21 at 21:23

Sebastián Martínez

23
1
6

missing columns by read_excel

1 Answers1