Hello everyone. Assume I have a big spreadsheet file and I'm using the pandas package to process it. Like, I need data from two tabs in that big file. In those tabs, one tab will be having a ton of data and the other tab is just a few square cells.
If I use pd.read_excel(), it looks like the whole file is loaded. But, When I tried to use the method twice (once for each sheet), then I effectively need to suffer the whole workbook being read twice (even if we are using the specified sheet).
Anyone suggest to me, whether I'm using it wrong? If so, please help me
Thank you in advance :)