Programming and Analysis
What can one do with some knowledge of these two?
The idea is to show my knowledge about programming and business analysis.
I present any code, that I find interesting (usually C#, VBA, Python or JavaScript) and I comment it. Reviews of IT books can be found as well. I hope you find something interesting here!
- VBA – Cells and Ranges in Excel (A bit more than the standard story)Excel’s ranges and cells are both complicated and very simple. They are simple, because everyone has an idea what is a range and what is a cell, and they are complicated, because these are both: Properties of the worksheet object…Read more ›
- VBA – Benford Analysis (First-Digit Law)Long time ago, an astronomer called Benford was taking a look at logarithm books, noticing that the earlier pages (starting with 1) are pretty much more worn out than the later ones. He thought about the result, and managed to…Read more ›
- VBA – DictionaryVBA has a dictionary structure. Dictionary is an object, and it can be referenced either with early binding or with a late binding, referring to Microsoft Scripting Runtime: What is a dictionary? This is the Microsoft definition of the VBA…Read more ›
- Python – Stand Alone Application with GUIPython has a built-in GUI package, which allows easy building of forms like this: The package used in this example is tkinter. The form above takes the value, entered in the entry field, squares it and displays it back in…Read more ›
- C# – CodeForces – From Hero to ZeroIt was some time ago, since I last took a look at programming challange in CodeForces, thus I have decided to take a look again. So, I chose the lowest problem of the second division just to boost up my…Read more ›
- C# – Look at the Variables’ Values, while Debugging in Visual StudioDebugging is like being the detective in a crime movie where you are also the murderer. In order to debug well, we need to know the value of the current variable. In Visual Studio, this could be acquired through multiple ways.…Read more ›
- Analyzing trends with map and reduce in PythonEditorial (from Vitosh): Lately, I have reviewed the Mastering Large Datasets book by J.T. Wolohan. The book is python based and it explains how to scale a data project, using the map and reduce to scale data projects. Long story…Read more ›
Python Summit in Berlin is coming! With talks mainly in German and some in English! And if you want to explore Machine Learning, you can always change the room and go to the ML Summit, which is literally next door.
Absolutely NOTHING! Open a simple Excel file and start building your own magic there! It is THAT easy! Really, if you become even quite a little aware of VBA in Excel you will be among the best Excel-Table makers in your company 🙂
