I'm working with some xlsx files and need to import them into program. I've written a script that handles everything I need it to do. However, I need to apply filters to the table in excel before importing them in. When I apply filters and prep the table to import into python, python reads the entire table ignoring all the filters. My work around has been filtering what I need then copying that to a new sheet. Then when reading into excel I specify the new sheet of filtered data that I'm looking for. Is there a way to read the filtered table into excel directly? Or Should I just import the entire table and apply those same filters using pandas in my script instead? Continue reading...
