Jan-17-2020, 05:20 PM
Dear, selected, I am not a programmer, but I need to learn VBA to get what I need today. I have some spreadsheets in Excel and its total sum is 8 million and 200 thousand rows with more than 60 columns, that is a very large data volume. I need to process this data, perform backtests, and learn VBA in order to do that, but with the advancement of analytics I am in need of more performance and functionality than VBA does not provide me.
There are processes that perform in Excel that last 7, 8, 9 hours and meanwhile remain "arms crossed" waiting or ending.
Given this is it possible to learn Python to process this data? It's analyzes, processes, possibility tests ... I saw about R too but it didn't seem like one of the best options, correct me if I'm wrong.
Thanks !!!
There are processes that perform in Excel that last 7, 8, 9 hours and meanwhile remain "arms crossed" waiting or ending.
Given this is it possible to learn Python to process this data? It's analyzes, processes, possibility tests ... I saw about R too but it didn't seem like one of the best options, correct me if I'm wrong.
Thanks !!!