Python and Excel by using openpyxl
This post will show a very interesting thing that can be done by using Python and Excel together with a GUI that creates an application. At my workplace we often must extract or clean data, one example is shown below:
In the third column which is named “target” we can see text but also numbers, the meaning of this post is to create a fast way to extract these numbers.
Using Excel VBA with advanced filter At my workplace I often investigate a lot of different aspects of the data. One important moment is when I need to filter out and examine lots of different unique factors that corresponds to a specific event (I won’t go into detail regarding the actual real data due to secrecy in the workplace).
I noticed that my colleagues used Excels table and filter function and simply copy and pasted the results into a new sheet with the filtered data.
Using Excel at the workplace
At my current workplace I have been known as one of the “go to college” when it comes to tips and tricks in Excel but also more advance topics like new formulas or macros. One of my colleagues in another department asked over lunch if I knew something that could help him with updating names in a column in Excel. The problem was that another program outside of Excel automatically updates the names but just once a day, and new data can be imported with several thousand rows hours before which therefore have no name for a long time.