Posts

If you are an aspiring Data Scientist then the Pandas pivot table is one of the primary tools that you must learn. We all know how to use the excel pivot table. In fact, there are many use cases from summarizing data to performing calculations. But as you know excel pivot table is based on a Graphical User Interface (GUI) so it’s relatively easy to learn and apply. On the contrary Pandas pivot table is based on python code so it can be overwhelming for beginners and often your excel pivot table understanding will interfere....

I have been looking for the best Evernote alternative for a very long time. I have tried OneNote, SimpleNote, Notion, Dropbox paper etc. but nothing worked for me. So my search continued, but this time I was looking for open-source alternatives. My main criteria were, there should be an Android app, a Desktop app for Both Windows & Linux and a strong focus on Privacy. So, in my search process, I have come across Joplin....

Yes, the headline is correct, this tutorial is about employee attrition prediction using ML algorithms. A person like me who mostly writes tutorials on Excel and Finance has taken up this challenge to learn Data Science a few months back. (Please note I’m a finance professional with no IT background ) And today I can confidently say I’m somewhere around the intermediate level in terms of my data science/ML skills....

“Oh My God” excel formulas not working in my report. Sounds familiar right? If so, don’t worry, you are just one among many excel users who face this problem very often. Just think about it. You have built an excel model for Sales Forecast using various logics with fairly complicated formulas. [‘IF’ formulas with 64 conditions – just kidding] And when you try to use that model, you see some of your formulas either not working or looks broken....

Almost everyone knows how to use filters in excel but very few know that there is visual filter called ‘slicer in excel’. Without any doubts filters are most commonly used functionality in excel to slice and dice data. Its very useful and easy to use when you have multiple columns. But given that filters work based on dropdowns the selections are hidden and only visible when you click on the dropdown....