u/Great-Village-430

Hey all,

So as the title says, I'm looking for the best software or at least most suitable to analyse large amounts of data from excel?

I've tried using VBA which can do what I need but it gets slow and glitchy with large code and data.

I need something that can take the data from excel and filter it using multiple filters so for example, if I have 4 filters then it will look for all the lines that contain the 1st filter then look through the resulting lines for the 2nd filter and forget the ones that don't contain that filter and so on.

Then with the lines that contain all 4 filters, extract them and place them onto another sheet. It'll also need to perform calculations on the results and create graphs for further analysis.

I want to be able to do all this with the click of a button so ideally, the filters will be drop down menus so I'll select the 4 filters then click "analyse" and it should do everything that I need.

Thanks.

Hey all,

So I'm looking for software that will be suitable for what I'm trying to do. Originally, I was using excel vba which works but because of the size of my data, it can get too glitchy. So the things I need it for are listed below;

- Store a large dataset of results that could be 10s of 1000s of lines all in 1 table with 20+ columns

- Use drop down menus to select manual filters that matches the filters to the dataset and pulls any lines that match all the filters and puts them into a new table for viewing.

- Make calculations based on this new spreadsheet and produce graphs for analysis

Ideally I want this to be fully automated and able to be done within a few clicks of a button whilst also running quickly. Is Python capable of this? Thanks.